Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.



SingleStore Managed Service does not support this command.

Promotes a node to master aggregator.




BOOTSTRAP AGGREGATOR creates a new cluster with this node as the master aggregator.

This command is required to install a SingleStore DB cluster without using management tools like memsql-admin, memsqlctl, or MemSQL Ops. When installing a SingleStore DB cluster with MemSQL Ops, Ops will perform this operation automatically.

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 command on the master aggregator, and add each child aggregator by running the ADD AGGREGATOR 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 instead of

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.


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

Query OK, 0 rows affected (1.55 sec)

| Host      | Port | State  | Opened_Connections | Average_Roundtrip_Latency_ms | Master_Aggregator |
| | 3306 | online |                  1 |                         NULL |                 1 |
1 row in set (0.00 sec)