Attaches all leaves in a cluster that are currently in the detached state. ATTACH LEAF ALL is equivalent to running ATTACH LEAF ... NO REBALANCE on every leaf in a cluster that is currently in a detached state. If you want the leaves to rebalance after reattaching, you must run REBALANCE PARTITIONS afterward.

ATTACH LEAF ALL

Notes

• ATTACH LEAF ALL is equivalent to running ATTACH LEAF ... NO REBALANCE 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.
• In redundancy 1, 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 MemSQL Commands ).

Example

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

Was this Article Helpful?

Thanks For Your Feedback!