ATTACH LEAF ALL
On this page
Attaches all leaves in a cluster that are currently in the
ATTACH LEAF ALL [FORCE] [NO REBALANCE]
ATTACH LEAF ALLis equivalent to running
ATTACH LEAFon every leaf in a cluster that is currently in the
If you want the leaves to fully rebalance after reattaching, you must run
This will rebalance and synchronize all partitions in one operation.
To avoid the partial rebalance that is run automatically (after
rebalance_ delay_ seconds
ATTACH LEAF ALL NO REBALANCE.
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
For more information see SET GLOBAL .
This command must be run on the master aggregator node (see Node Requirements for SingleStoreDB Commands ).
This command causes implicit commits.
See COMMIT for more information.
Refer to the Permission Matrix for the required permission.
ATTACH LEAF ALL;
Query OK, 1 row affected (0.99 sec)
Last modified: July 31, 2023