Sets a sync variable. Depending on the variable, the updated value is propogated 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 list of sync variables 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 |
+-----------------------------+

Related Topics

• See the Engine Variables Overview for information about other ways to set variables.

Was this Article Helpful?

Thanks For Your Feedback!