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

Superuser

Example

Update the cluster with changes to control messaging:

=> SELECT reload_spread(true);
 reload_spread
---------------
 reloaded
(1 row)

See Also

REBALANCE_CLUSTER