Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

AGGREGATOR SET AS MASTER

Info

SingleStore Managed Service does not support this command.

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