Outdated Version

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

COPY PARTITION

Copies the target partition from the master partition to the specified leaf, and sets up replication from the master partition.

COPY PARTITION partition_id TO 'leaf_host':leaf_port

Notes

  • partition_id has the form db_name:partition_ordinal.
  • The master partition for the partition_id must exist and be in an ONLINE state.
  • This command must be run on the master aggregator node (see Node Requirements for MemSQL Commands ).

Example

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