RELOAD_SPREAD
Updates cluster changes to the catalog's Spread configuration file. These changes include:
- New or realigned control nodes
- New Spread hosts or fault group
- New or dropped cluster nodes
This function is often used in a multi-step process for large and elastic cluster arrangements. Calling it might require you to restart the database. You must then rebalance the cluster to realize fault tolerance. For details, see Defining and Realigning Control Nodes in the Administrator's Guide.
In an Eon Mode database, using this function could result in the database becoming read-only. Nodes may become disconnected after you call this function. If the database no longer has primary shard coverage without these nodes, it goes into read-only mode to maintain data integrity. Once the nodes rejoin the cluster, the database will resume normal operation. See Maintaining Shard Coverage.
Syntax
RELOAD_SPREAD( true )
Parameters
true |
Updates cluster changes related to control message responsibilities to the Spread configuration file. |
Privileges
Example
Update the cluster with changes to control messaging:
=> SELECT reload_spread(true); reload_spread --------------- reloaded
(1 row)