ADD AGGREGATOR
On this page
Adds a new child aggregator to a cluster.
Syntax
ADD AGGREGATOR user[:'password']@'host':port;
Remarks
-
This command can be run on the master aggregator node, or a child aggregator node (see Node Requirements for SingleStore Commands ).
-
The specified user account must have full permissions on the node to execute this command, namely the
clusterprivilege.For more information, see Permissions Matrix. -
Always use stable addresses for optimal function with this command.
-
This command causes implicit commits.
Refer to COMMIT for more information. -
See the Permission Matrix for the required permission.
Example
The following example demonstrates how to add a child aggregator to a cluster.
SHOW AGGREGATORS;
+-----------+------+--------+--------------------+------------------------------+-------------------+
| Host | Port | State | Opened_Connections | Average_Roundtrip_Latency_ms | Master_Aggregator |
+-----------+------+--------+--------------------+------------------------------+-------------------+
| 10.0.2.15 | 3306 | online | 1 | NULL | 1 |
+-----------+------+--------+--------------------+------------------------------+-------------------+
1 row in set (0.00 sec)ADD AGGREGATOR root@'10.0.2.16':3306;SHOW AGGREGATORS;
+-----------+------+--------+--------------------+------------------------------+-------------------+
| Host | Port | State | Opened_Connections | Average_Roundtrip_Latency_ms | Master_Aggregator |
+-----------+------+--------+--------------------+------------------------------+-------------------+
| 10.0.2.15 | 3306 | online | 1 | NULL | 1 |
| 10.0.2.16 | 3306 | online | 0 | 0.218 | 0 |
+-----------+------+--------+--------------------+------------------------------+-------------------+
2 rows in set (0.00 sec)Last modified: August 3, 2023