PROMOTE PARTITION

Promotes the specified leaf to the master partition for the target partition id. If there is already a master partition for the same partition ordinal, the existing master is dropped (see DROP PARTITION ).

Syntax

PROMOTE PARTITION partition_id ON 'leaf_host':leaf_port

Remarks

  • The specified leaf must contain a replica physical partition for the target partition id.
  • partition_id has the form db_name:partition_ordinal.
  • This command must be run on the master aggregator node (see Node Requirements for MemSQL Commands ).

Example

memsql> PROMOTE PARTITION memsql_demo:63 ON 'ip-10-0-1-25.ec2.internal':3306;
Query OK, 1 row affected (4.19 sec)