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 formdb_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)