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 the online state to the detached 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 can be run on the master aggregator node, or a child aggregator node (see Node Requirements for SingleStore DB Commands ).

Example

DETACH LEAF '192.168.1.110':3306;

Related Topics

• REMOVE LEAF
• ATTACH LEAF

Was this Article Helpful?

Thanks For Your Feedback!