CREATE PARTITION

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.

Syntax

CREATE PARTITION partition_id ON 'leaf_host':leaf_port

Remarks

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

Example

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