Setting the Redundancy Level
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.
On this page
To use availability groups in a cluster, you need to set the redundancy level, which specifies the maximum number (1 or 2) of availability groups.
Setting the Engine Variable
Use the SET GLOBAL
command to change redundancy_
engine variable on the master aggregator at run time:
SET @@GLOBAL.redundancy_level = {1 | 2};
You can inspect the current value with the SELECT GLOBAL
command:
SELECT @@GLOBAL.redundancy_level;
Adding and Removing Leaves
Use ADD LEAF and REMOVE LEAF to add leaves to, and remove leaves from, a SingleStore cluster.
Adding and Removing Child Aggregators
Use ADD AGGREGATOR and REMOVE AGGREGATOR to add and remove child aggregators from a SingleStore cluster.
Note
These commands must be run against the Master Aggregator.
Last modified: April 3, 2023