You are viewing an older version of this section. View current production version.
ATTACH LEAF ALL
MemSQL Helios does not support this command.
Attaches all leaves in a cluster that are currently in the
ATTACH LEAF ALL [FORCE]
ATTACH LEAF ALLis equivalent to running
ATTACH LEAFon every leaf in a cluster that is currently in the
detachedstate. If you want the leaves to rebalance after reattaching, you must run
REBALANCE PARTITIONSafterward. This will rebalance and synchronize all partitions in one operation.
FORCEis optional. Using
FORCEoverrides any conflicts that would prevent
ATTACH LEAF ALLfrom 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
false. For more information see SET GLOBAL .
- This command must be run on the master aggregator node (see Node Requirements for MemSQL Commands ).
memsql> ATTACH LEAF ALL; Query OK, 1 row affected (0.99 sec)