Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
SET LEAF
On this page
Sets a sync variable to propagate to all leaves in the cluster.
Syntax
SET LEAF variable_name = value
Arguments
-
variable_
: name of the sync variable.name -
value
: value to be assigned to the sync variable.
Remarks
-
variable_
must be a sync variable that can sync to all nodes (aggregators and leaves).name -
You cannot 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 regexp_
to all leaves.SET LEAF
can be run on regexp_
because regexp_
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 LEAF regexp_format = "extended";
Retrieve the variable’s value:
SELECT @@regexp_format;
+-----------------+
| @@regexp_format |
+-----------------+
| extended |
+-----------------+
Example 2
The following example attempts to sync the variable auto_
to all leaves.SET LEAF
fails because auto_
is a variable that can sync to all aggregators, only.
This is indicated in the last sentence of the Description column for the variable.
SET LEAF auto_attach = 1;
ERROR 2324 (HY000): This cluster-wide variable exists only on
aggregators, it's not possible to set a value for leaves
Related Topics
-
See the Engine Variables Overview for information about other ways to set variables.
Last modified: June 22, 2022