High Availability
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.
An availability group is set of leaves which store data redundantly to ensure high availability.redundancy_
variable on the Master Aggregator.
The placement of replica partitions in a cluster can be specified via the leaf_
variable.paired
and load_
.paired
mode, each leaf in an availability group has a corresponding pair node in the other availability group.

In load_
mode, primary partitions are evenly placed on leaves.

For more information, see Managing High Availability.
By default, the ADD LEAF command will add a leaf into the smaller of the two groups.INTO GROUP N
suffix.
SingleStore automatically displays which availability group a leaf belongs to in the SHOW LEAVES command.
Last modified: June 13, 2024