Outdated Version

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


Creates an empty master partition corresponding to the given partition ordinal on the specified leaf. This command will fail if there are any other partitions with the same partition ordinal.

CREATE PARTITION partition_id ON 'leaf_host':leaf_port


  • This is a dangerous operation. The new partition contains no data, and running CREATE PARTITION cements this new partition state. Any leaves in this partition that were temporarily down cannot have their data reintroduced afterward.
  • partition_id has the form db_name:partition_ordinal.
  • physical partition refers to the database on a leaf that stores the partition’s data.
  • This command must be run on the master aggregator node (see Node Requirements for MemSQL Commands ).


memsql> CREATE PARTITION memsql_demo:63 ON 'ip-10-0-3-82.ec2.internal':3306;
Query OK, 1 row affected (0.52 sec)