SingleStore DB

ATTACH LEAF ALL

Attaches all leaves in a cluster that are currently in the detached state.

Syntax
ATTACH LEAF ALL [FORCE]
Remarks
  • ATTACH LEAF ALL is equivalent to running ATTACH LEAF on every leaf in a cluster that is currently in the detached state. If you want the leaves to rebalance after reattaching, you must run REBALANCE PARTITIONS afterward. This will rebalance and synchronize all partitions in one operation.

  • FORCE is optional. Using FORCE overrides any conflicts that would prevent ATTACH LEAF ALL from running. In practice, this happens when the data on the leaf has diverged away from the current state of the cluster (for example, a database was recreated while the leaf was down).

  • Detached leaves automatically reattach. To disable this feature, set the global variable auto_attach to false. For more information see SET GLOBAL .

  • This command must be run on the master aggregator node (see Node Requirements for SingleStore DB Commands ).

Example
ATTACH LEAF ALL;
Query OK, 1 row affected (0.99 sec)

Related Topics