Promote a child aggregator to Master Aggregator.

AGGREGATOR SET AS MASTER [IDENTIFIED BY PASSWORD <password>]

Notes

• See this Knowledge Base article for instructions.
• <password> is a root password valid on all child aggregators.
• Run this command on a child aggregator that you want to promote to be the master aggregator in the cluster.
• This command will run only if the master aggregator fails. It returns an error if the master aggregator is still running.
• To replace an existing master aggregator with a child aggregator, first shut down the existing master aggregator and then use the AGGREGATOR SET AS MASTER syntax on the child aggregator.
• This command must be run on a child aggregator node (see Node Requirements for MemSQL Commands). If this command is run while your cluster has a master aggregator, it will return an error.

Example

memsql> AGGREGATOR SET AS MASTER;
Query OK, 1 row affected (1 min 22.41 sec)

Was this Article Helpful?

Thanks For Your Feedback!