SET LEAF
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.
On this page
Sets a sync variable to propagate to all leaves in the cluster.
Syntax
SET LEAF variable_name = valueArguments
-
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 leavesRelated Topics
-
See the Engine Variables Overview for information about other ways to set variables.
Last modified: June 22, 2022