SET_SPREAD_OPTION

Changes spread daemon settings. This function is mainly used to set the timeout before spread assumes a node has gone down.

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);

See Also