You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.



MemSQL Helios 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 MemSQL Commands ).


memsql> DETACH LEAF '':3306;

Related Topics