Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

DETACH LEAF

Info

SingleStore Managed Service does not support this command.

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