Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
DETACH LEAF
On this page
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 [KILL] [ENSURE_PARTITION_SAFETY]
Remarks
-
DETACH LEAF
transitions the leaf from theonline
state to thedetached
state. -
DETACH LEAF
is useful if you would like to temporarily take down a leaf for repairs without erasing it from metadata. -
KILL
prevents persistent long running write queries from blocking a clustering option for an arbitrarily long time (for example, a scale up or scale down or even an upgrade).Auto-rebalances automatically use the KILL
mode if the auto-rebalance fails to run after three attempts. -
ENSURE_
prevents a leaf (or leaves) from being detached if it contains the last online instance of a partition.PARTITION_ SAFETY -
Use ATTACH LEAF to attach a leaf that is currently in a
detached
state. -
This command causes implicit commits.
Refer to COMMIT for more information. -
See the Permission Matrix for the required permission.
Example
DETACH LEAF '192.168.1.110':3306;
DETACH LEAVES
Detaches all leaves.
Similar to REMOVE LEAVES
, except it detaches all leaves instead of removing them.
Syntax
DETACH LEAVES ('host_1':port_1, ..., 'host_n':port_n) [ENSURE_PARTITION_SAFETY]
Remarks
-
DETACH LEAVES
transitions the leaves from anonline
state to adetached
state. -
Use ATTACH LEAF ALL to attach leaves that are in a
detached
state. -
All leaves must be in the same availability group to
DETACH LEAVES
. -
DETACH LEAVES
is an all-or-nothing command: either all the leaves will be detached, or none of them will. -
ENSURE_
prevents a leaf (or leaves) from being detached if it contains the last online instance of a partition.PARTITION_ SAFETY
Example
DETACH LEAVES ('192.168.1.110':8080, '192.168.1.111':8080, '192.168.1.112':8080);
Related Topics
Last modified: January 9, 2025