SingleStore DB

SET CLUSTER

Sets a sync variable. Depending on the variable, the updated value is propagated to all nodes in the cluster or all aggregators in the cluster.

Syntax
SET CLUSTER variable_name = value
Arguments
  • variable_name: name of the sync variable.

  • value: value to be assigned to the sync variable.

Remarks
  • The last two columns in the Sync Variables List specify whether a variable can be synced to all aggregators, all leaves, or both. If a variable can be synced to all aggregators and all leaves, SET CLUSTER syncs the variables to all nodes. If a variable can be synced to all aggregators, only, SET CLUSTER syncs the variable to all aggregators.

  • This command must be run on the master aggregator.

  • To sync a variable to all leaves, only, run SET LEAF.

Examples
Example 1: Syncing a Variable to all Nodes

The following example sets the variable regexp_format. SET CLUSTER syncs the variable to all nodes, because this specific variable can be synced to all aggregators and all leaves, as indicated in the last sentence of the Description column for the variable.

SET CLUSTER regexp_format = "extended";

Retrieve the variable’s value:

SELECT @@regexp_format;
****
+-----------------+
| @@regexp_format |
+-----------------+
| extended        |
+-----------------+
Example 2: Syncing a Variable to All Aggregators

The following example sets the variable default_autostats_enabled. SET CLUSTER syncs the variable to all aggregators, because this specific variable can be synced to all aggregators, only, as indicated in the last sentence of the Description column for the variable.

SET CLUSTER default_autostats_enabled = true;

Retrieve the variable’s value:

SELECT @@default_autostats_enabled;
****
+-----------------------------+
| @@default_autostats_enabled |
+-----------------------------+
|                           1 |
+-----------------------------+