SingleStore DB

AGGREGATOR SET AS MASTER

Promote a child aggregator to master aggregator.

Syntax
AGGREGATOR SET AS MASTER;
Remarks
  • This command should only be used in cases where the master aggregator is permanently lost. The command PROMOTE AGGREGATOR … TO MASTER is required for all other use cases that require the promotion of a child aggregator to master.

  • This command must be run on the child aggregator node to be promoted to master (see Node Requirements for SingleStore DB Commands ). If this command is run while your cluster has an online master aggregator, it will return an error.

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

Related Topics