Outdated Version

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


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


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


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