# BOOTSTRAP AGGREGATOR

The `BOOTSTRAP AGGREGATOR` command promotes a node to Master Aggregator.

## Syntax

```
BOOTSTRAP AGGREGATOR <host>;

```

## Remarks

* `BOOTSTRAP AGGREGATOR` creates a new cluster with this node as the master aggregator.
* This command is required to install a SingleStore cluster without using management tools like sdb-admin, memsqlctl, or MemSQL Ops.
* To set up a new cluster without using management tools, first run this command on one node to configure it as the master aggregator. Then, add each leaf node by running the [ADD LEAF](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/add-aggregator.md) command on the master aggregator, and add each child aggregator by running the [ADD AGGREGATOR](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/add-aggregator.md) command on the master aggregator.
* When specifying the host, provide an address that can be used by other nodes to connect to the current node. The specified host must be accessible by every other node in the cluster. For example, use `192.168.0.1` instead of `127.0.0.1`.
* If `BOOTSTRAP AGGREGATOR` is called on an aggregator that is already joined to a cluster, it will fail with an error informing the caller that the aggregator is already joined to the cluster.
* Always use stable addresses for optimal function with this command.
* Refer to the [Permissions Matrix](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) for the required permissions.

## Examples

The first example demonstrates how to bootstrap the cluster with the node hosted at `10.0.2.15` as the master aggregator. Note that the client is connected to the same node that is being bootstrapped:

```sql
BOOTSTRAP AGGREGATOR '10.0.2.15';

```

```output

Query OK, 0 rows affected (1.55 sec)

```

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

***

Modified at: June 11, 2026

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

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