Important

The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.

In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.

ADD AGGREGATOR

Syntax

SQL

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 cluster privilege. 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. Note that the client is connected to the master aggregator:

SQL

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)

SQL

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)