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 cluster without using management tools like sdb-admin, memsqlctl, or MemSQL Ops.

  • When installing a SingleStore 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.

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

  • Refer to the Permission Matrix for the required permission.


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)

Last modified: July 31, 2023

Was this article helpful?