DETACH LEAF
On this page
Detaches a leaf.
Similar to REMOVE LEAF except that it keeps the leaf in the detached state instead of removing it entirely.
Syntax
DETACH LEAF 'host':port [KILL]
Remarks
-
DETACH LEAFtransitions the leaf from theonlinestate to thedetachedstate. -
DETACH LEAFis useful if you would like to temporarily take down a leaf for repairs without erasing it from metadata. -
KILLprevents persistent long running write queries from blocking a clustering option for an arbitrarily long time (for example, a scale up or scale down or even an upgrade).Auto-rebalances automatically use the KILLmode if the auto-rebalance fails to run after three attempts. -
Use ATTACH LEAF to attach a leaf that is currently in a
detachedstate. -
This command causes implicit commits.
Refer to COMMIT for more information. -
See the Permission Matrix for the required permission.
Example
DETACH LEAF '192.168.1.110':3306;
DETACH LEAVES
Detaches all leaves.
Similar to REMOVE LEAVES, except it detaches all leaves instead of removing them.
Syntax
DETACH LEAVES ('host_1':port_1, ..., 'host_n':port_n)
Remarks
-
DETACH LEAVEStransitions the leaves from anonlinestate to adetachedstate. -
Use ATTACH LEAF ALL to attach leaves that are in a
detachedstate. -
All leaves must be in the same availability group to
DETACH LEAVES. -
DETACH LEAVESis an all-or-nothing command: either all the leaves will be detached, or none of them will.
Example
DETACH LEAVES ('192.168.1.110':8080, '192.168.1.111':8080, '192.168.1.112':8080);
Related Topics
Last modified: January 9, 2025