AGGREGATOR SET AS MASTER

Promote a child aggregator to master aggregator.

Syntax

AGGREGATOR SET AS MASTER

Remarks

  • See this Knowledge Base article for instructions.
  • Run this command on the child aggregator that you want to promote to be the master aggregator in the cluster.
  • This command will only succeed if the master aggregator is offline. It returns an error if the master aggregator is online.
  • 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 ).

Example

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

Related Topics

Was this article useful?