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)

Was this Article Helpful?

Thanks For Your Feedback!