Except for the SHOW ... commands, MemSQL Helios does not support the commands mentioned in this topic.
In a MemSQL cluster, a leaf node functions as a storage and compute node. Leaves are responsible for storing slices of data in the MemSQL cluster.
To optimize performance, the MemSQL system automatically distributes data across leaf nodes into partitions. Each leaf is a MemSQL server consisting of several partitions. Each partition is just a database on that server.
Each leaf is in one of four states:
In this state, a leaf is not part of the cluster. This is the state before you run ADD LEAF to introduce the leaf into the system. A leaf that is unknown will not show up in SHOW LEAVES . The REMOVE LEAF command will transition a leaf into the unknown state.
This is the default, healthy state of a leaf. In the online state, the leaf is an active member of the distributed system and is either currently serving or ready to serve data to the aggregators.
A leaf enters the offline state if the master aggregator cannot reach it. The master aggregator sends a heartbeat to each leaf node and if a leaf fails enough heartbeats it will be moved to the Offline state. If the cluster is in redundancy 2 any partitions on the offline node will be failed over to the leaves pair. The master aggregator continues to ping offline nodes to detect when they should be moved into the attaching state.
A leaf transitions from online to detached when DETACH LEAF is run. You can reintroduce the leaf into the online state with the ATTACH LEAF command. This command will automatically try to reuse the data present on the leaf; this is especially important in redundancy-1. DETACH LEAF is the same as REMOVE LEAF except that after rebalancing away a leaf’s partitions, it transitions it to detached instead of unknown.
A leaf transitions from offline to attaching when it is once again reachable by heartbeats. The master aggregator will automatically run [ATTACH LEAF](/v6.8/reference/sql-reference/cluster-management-commands/attach-leaf/ to attach any partitions on the leaf back into the cluster. While the attach is running the leaf will stay in the attaching state. When the attach is finished the leaf will move to the online state.
The following diagram summarizes the leaf states and the transitions between them: