Outdated Version

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


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


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


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