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";
Retrieve the variable’s value:
SELECT @@regexp_format; **** +-----------------+ | @@regexp_format | +-----------------+ | extended | +-----------------+