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 LEAF
transitions the leaf from theonline
state to thedetached
state.DETACH LEAF
is 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
detached
state.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 LEAVES
transitions the leaves from anonline
state to adetached
state.Use ATTACH LEAF ALL to attach leaves that are in a
detached
state.All leaves must be in the same availability group to
DETACH LEAVES
.DETACH LEAVES
is 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);