SET CLUSTER
On this page
Sets a sync variable.
Syntax
SET CLUSTER variable_name = valueArguments
-
variable_: name of the sync variable.name -
value: value to be assigned to the sync variable.
Remarks
-
The last two columns in the Sync Variables Lists 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 CLUSTERsyncs the variables to all nodes.If a variable can be synced to all aggregators, only, SET CLUSTERsyncs 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_.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_.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 |
+-----------------------------+Related Topics
-
See the Engine Variables Overview for information about other ways to set variables.
Last modified: June 22, 2022