You are viewing an older version of this section. View current production version.
In a MemSQL cluster, the
master aggregator is a specialized aggregator aggregator responsible for cluster monitoring and failover. The master aggregator orchestrates basic cluster operations and all DDL operations. Each MemSQL cluster has one master aggregator node.
Commands that Must Run on a Master Aggregator
You must run queries, such the following commands, through the master aggregator:
Master Aggregator Startup
To manually specify a master aggregator in a MemSQL cluster, pick a node in the cluster that will serve as the master aggregator and append the line
master-aggregator (with no arguments) to the end of its
memsql.cnf, then start the server.
If you’re running the MemSQL binary directly, start the master aggregator with following command:
$ ./memsqld --master-aggregator
Recovering from a Master Aggregator Failure
If the master aggregator fails, the cluster remains online and functional. You can continue to run DML operations through any remaining aggregator. Only DDL operations and auto-failover are suspended until you restore the master aggregator. If you haven’t lost the master’s data directory, simply restart it and the aggregators will automatically reconnect to it. Otherwise, MemSQL supports promoting one of remaining aggregators as the new master. To do this, run the AGGREGATOR SET AS MASTER command on the child aggregator you want to promote to master.