DETACH LEAF
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
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.Use ATTACH LEAF to attach a leaf that is currently in a
detachedstate.This command causes implicit commits. See 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);