Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.
MemSQL Helios 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.
memsql> REMOVE LEAF '192.168.1.110':3306;