Skip to main content

DETACH LEAF

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 causes implicit commits. See COMMIT for more information.

  • Node Requirements for SingleStoreDB Commands

  • See the Permission Matrix for the required permission.

Example

DETACH LEAF '192.168.1.110':3306;

Related Topics

REMOVE LEAF

ATTACH LEAF