Outdated Version

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


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


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