Skip to main content

SingleStoreDB v8.0

ADD AGGREGATOR

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 SingleStoreDB 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 MatrixADD LEAF

  • Always use stable addresses for optimal function with this command.

  • This command causes implicit commits. See 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:

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;
Query OK, 0 rows affected (1.49 sec)

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)
In this section: