SET_SPREAD_OPTION
Changing spread settings using SET_SPREAD_OPTION will have a minor impact on your cluster as it pauses while the change propagates to the entire cluster.
Syntax
SET_SPREAD_OPTION( setting, value )
Parameters
setting |
String containing the spread daemon setting to change. Currently, the only setting you can set with this function is TokenTimeout. This setting controls how long spread waits for a node to respond to a message before assuming it is lost. See Adjusting Spread Daemon Timeouts For Virtual Environments for more information. |
value |
String containing the new value for the setting. |
Example
=> SELECT SET_SPREAD_OPTION( 'TokenTimeout', '35000'); NOTICE 9003: Spread has been notified about the change SET_SPREAD_OPTION -------------------------------------------------------- Spread option 'TokenTimeout' has been set to '35000'. (1 row) => SELECT * FROM V_MONITOR.SPREAD_STATE; node_name | token_timeout ------------------+--------------- v_vmart_node0001 | 35000 v_vmart_node0002 | 35000 v_vmart_node0003 | 35000 (3 rows);