Outdated Version
You are viewing an older version of this section. View current production version.
DETACH PARTITION
De-register a physical partition on the specified leaf with the master aggregator. The physical partition will not be removed, and its replication status will not be changed. The partition can be re-attached with ATTACH PARTITION.
DETACH PARTITION partition_id ON 'leaf_host':leaf_port
Notes
partition_id
has the formdb_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> DETACH PARTITION memsql_demo:63 ON 'ip-10-0-3-82.ec2.internal':3306;
Query OK, 1 row affected (0.09 sec)