SingleStore DB

Setting the Redundancy Level

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. Information on high availability is here.

Setting the Engine Variable

Use the SET GLOBAL command to change redundancy_level 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 DB cluster.

Adding and Removing Child Aggregators

Use ADD AGGREGATOR and REMOVE AGGREGATOR to add and remove child aggregators from a SingleStore DB cluster.


These commands must be run against the Master Aggregator.