# ADD AGGREGATOR

The `ADD AGGREGATOR` command adds a new child aggregator to a cluster.

## 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](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands.md) ).
* 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](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md).
* Always use stable addresses for optimal function with this command.
* This command causes implicit commits. Refer to [COMMIT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/commit.md) for more information.
* See the [Permission Matrix](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) 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;

```

```output

+-----------+------+--------+--------------------+------------------------------+-------------------+
| 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;

```

```output

+-----------+------+--------+--------------------+------------------------------+-------------------+
| 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)
```

***

Modified at: June 11, 2026

Source: [/db/v9.1/reference/sql-reference/cluster-management-commands/add-aggregator/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/add-aggregator/)

(An index of the documentation is available at /llms.txt)