Outdated Version
You are viewing an older version of this section. View current production version.
Partitions
A leaf is a MemSQL server consisting of multiple partitions. Each partition is just a database on that server. For example, if you have a database named test and run SHOW DATABASES on a leaf, you will see names resembling test_5 (this would be partition 5 for database test).
Master and replica partitions
A partition is either a master or a replica. Leaves as a whole are not masters or replicas (this distinction is made at the partition level).
Info
MemSQL will create replica partitions only in redundancy-2.
Partition States
If you run SHOW DATABASES EXTENDED on a leaf, you will see that partition databases are in one of two states:
| State | Description |
|---|---|
online |
State for master partitions. |
replicating |
State for replica partitions, which arereplicating from the corresponding master partition over the network. |
Partition Commands
- CREATE PARTITION
- DROP PARTITION
- COPY PARTITION
- ATTACH PARTITION
- DETACH PARTITION
- SHOW PARTITIONS
- PROMOTE PARTITION
- REBALANCE PARTITIONS
- EXPLAIN REBALANCE PARTITIONS
- SHOW REBALANCE STATUS
