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.
SingleStore Managed Service does not support this command.
Removes a leaf node from a cluster and rebalances its partitions into the rest of the cluster.
REMOVE LEAF 'host':port [FORCE]
ADD LEAFcommand if you want to reintroduce the removed leaf into the system.
FORCEflag disables the rebalancing behavior of
REMOVE LEAF. This behavior is designed to keep the database online while you remove a leaf from the system. However, if you are performing maintenance and want to quickly remove a leaf node without keeping the database online, then use the
FORCEflag to disable automatic rebalancing.
REMOVE LEAFcan result in the leaf being added back without user intervention.
REMOVE LEAF '192.168.1.110':3306;