SingleStoreDB v8.1

SET AGGREGATOR

Sets a sync variable to propagate to all aggregators in the cluster.

Syntax

SET AGGREGATOR variable_name = value

Arguments

variable_name: name of the sync variable.
value: value to be assigned to the sync variable.

Remarks

variable_name must be a variable type that can sync to all aggregators or a variable that can sync to all nodes (aggregators and leaves).
You cannot run this command on a non-sync variable.
This command must be run on the master aggregator.

Examples

Example 1

The following example syncs the variable auto_attach to all aggregators. SET AGGREGATOR can be run on auto_attach because auto_attach is a variable that can sync to all aggregators. This is indicated in the last sentence of the “Description” column for the variable.

SET AGGREGATOR auto_attach = 1;

Retrieve the variable’s value:

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

Example 2

The following example syncs the variable regexp_format to all aggregators. SET AGGREGATOR can be run using regexp_format because regexp_format is a variable that can sync to all nodes (leaves and aggregators). This is indicated in the last sentence of the “Description” column for the variable.

SET AGGREGATOR regexp_format = "extended";