Outdated Version

You are viewing an older version of this section. View current production version.

BOOTSTRAP AGGREGATOR

Info

MemSQL Helios does not support this 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 MemSQL cluster without using management tools like sdb-admin, memsqlctl, or MemSQL Ops. When installing a MemSQL 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 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.

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:

memsql> BOOTSTRAP AGGREGATOR '10.0.2.15';
Query OK, 0 rows affected (1.55 sec)

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