Outdated Version

You are viewing an older version of this section. View current production version.



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.


DETACH LEAF 'host':port


  • 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 must be run on the master aggregator node (see Node Requirements for SingleStore DB Commands ).


DETACH LEAF '':3306;

Related Topics