SingleStore DB

Identifying Orphaned Partitions

To easily determine if your cluster has any orphaned partitions, run:

EXPLAIN REBALANCE PARTITIONS ON <database name>;

If there are any unbalanced partitions, a non-empty result set will be returned. If this is the case, run SHOW CLUSTER STATUS and SHOW PARTITIONS to see the details of your partitions:

Example:

SHOW CLUSTER STATUS;
| Host      | Port  | Database | Role      | State       | Position | Details |
+-----------+-------+----------+-----------+-------------+----------+---------+
| 127.0.0.1 | 10001 | x_test   | Reference | replicating | 0:57     |         |
| 127.0.0.1 | 10001 | x_test_0 | Master    | online      | 0:10     |         |
| 127.0.0.1 | 10001 | x_test_1 | Slave     | replicating | 0:10     |         |
| 127.0.0.1 | 10002 | x_test   | Reference | replicating | 0:57     |         |
| 127.0.0.1 | 10002 | x_test_0 | Slave     | replicating | 0:10     |         |
| 127.0.0.1 | 10002 | x_test_1 | Orphan    | online      | 0:10     |         |
SHOW PARTITIONS;
+---------+-----------+-------+--------+--------+
| Ordinal | Host      | Port  | Role   | Locked |
+---------+-----------+-------+--------+--------+
| 0       | 127.0.0.1 | 10001 | Master | 0      |
| 0       | 127.0.0.1 | 10002 | Slave  | 0      |
| 1       | 127.0.0.1 | 10001 | Slave  | 0      |
+---------+-----------+-------+--------+--------+