# 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 Lists](https://docs.singlestore.com/db/v9.1/reference/configuration-reference/engine-variables/list-of-engine-variables/#sync-variables-lists.md) 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](https://docs.singlestore.com/db/v9.1/reference/sql-reference/operational-commands/set-leaf.md).

## 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](https://docs.singlestore.com/db/v9.1/reference/configuration-reference/engine-variables/list-of-engine-variables/#sync-variables-lists-2.md).

```sql

SET CLUSTER regexp_format = "extended";

```

Retrieve the variable’s value:

```sql

SELECT @@regexp_format;

```

```output

+-----------------+
| @@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](https://docs.singlestore.com/db/v9.1/reference/configuration-reference/engine-variables/list-of-engine-variables/#sync-variables-lists-3.md).

```sql

SET CLUSTER default_autostats_enabled = true;

```

Retrieve the variable’s value:

```sql

SELECT @@default_autostats_enabled;

```

```output

+-----------------------------+
| @@default_autostats_enabled |
+-----------------------------+
|                           1 |
+-----------------------------+

```

## Related Topics

* See the [Engine Variables Overview](https://docs.singlestore.com/db/v9.1/reference/configuration-reference/engine-variables.md) for information about other ways to set variables.

***

Modified at: June 22, 2022

Source: [/db/v9.1/reference/sql-reference/operational-commands/set-cluster/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/operational-commands/set-cluster/)

(An index of the documentation is available at /llms.txt)