Outdated Version

You are viewing an older version of this section. View current production version.

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 ).

PROMOTE PARTITION partition_id ON 'leaf_host':leaf_port

Notes

  • 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)