Outdated Version
You are viewing an older version of this section. View current production version.
DETACH LEAF
Detaches a leaf. Similar to REMOVE LEAF except that it keeps the leaf in the detached state instead of removing it entirely.
DETACH LEAF 'host':port
Notes
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 attached a leaf that is currently in adetached
state. - This command must be run on the master aggregator node (see Node Requirements for MemSQL Commands ).
Example
memsql> DETACH LEAF '192.168.1.110':3306;