Attaches a detached leaf into the cluster, re-introducing its data (if possible).
ATTACH LEAF 'host':port [FORCE] [NO REBALANCE]
ATTACH LEAFwill transition the leaf from the
detachedstate to the
ATTACHis used to reintroduce a leaf back into the system. By default,
ATTACH LEAFalso performs any rebalance and resyncing actions needed to bring the leaf up to date with the rest of the cluster. To attach a leaf without rebalancing partitions, use the
NO REBALANCEoption. For more information see REBALANCE PARTITIONS .
ATTACH LEAFcan only be run on leaf nodes that are present in
- This command must be run on the master aggregator node (see Node Requirements for MemSQL Commands ).
FORCEflag overrides any conflicts that would prevent
ATTACH LEAFfrom running. In practice, this happens when the data on the leaf has diverged away from the current state of the cluster (for example, a database was recreated while the leaf was down). You do not need to
ATTACH LEAF ... FORCEby default.
ATTACH LEAFwithout the
FORCEflag collects information about which databases on the leaf are conflicting and the error message indicates directly that you should add the
FORCEflag. By specifying the
FORCEflag, you enable
ATTACH LEAFto ignore the conflicting data on the node you are attaching. The
FORCEflag does not drop the conflicting databases on the node. You can also manually resolve these conflicts by connecting to the leaf directly, examining the conflicting databases, and dropping them if they are no longer relevant.
- If you want to reattach many leaves at one time, after restarting a cluster, for example, you can use ATTACH LEAF ALL.
- Detached leaves automatically reattach. To disable this feature, set the global variable
false. For more information see SET GLOBAL .
memsql> ATTACH LEAF '192.168.1.110':3306; Query OK, 1 row affected (1.11 sec)