EXPLAIN REBALANCE PARTITIONS

Syntax

SQL

EXPLAIN REBALANCE PARTITIONS ON db_name

Remarks

db_name - name of a SingleStore database.
Node Requirements for SingleStore Commands
See MV_REBALANCE_STATUS for the column definitions in the result set.

Example

SQL

EXPLAIN REBALANCE PARTITIONS ON memsql_demo;

+-----------------------------+---------+-------------+-------------+-------+
| Action                      | Ordinal | Target_Host | Target_Port | Phase | 
+-----------------------------+---------+-------------+-------------+-------+
| COPY PARTITION              | 13      | 127.0.0.1   | 10002       | 3     |
| COPY PARTITION              | 2       | 127.0.0.1   | 10003       | 4     |
| COPY PARTITION              | 2       | 127.0.0.1   | 10004       | 4     |
| PROMOTE PARTITION WITH DROP | 2       | 127.0.0.1   | 10003       | 5     | 
| DROP PARTITION              | 2       | 127.0.0.1   | 10002       | 6     | 
| DROP PARTITION              | 13      | 127.0.0.1   | 10004       | 6     | 
+-----------------------------+---------+-------------+-------------+-------+

Understanding the Rebalance Actions

Each action occurs on a single partition.

Action	Definition
`COPY PARTITION`	Copies a partition and sets up replication to keep the copy in sync.
`PROMOTE PARTITION [WITH {DROP,REPOINT}]`	Promotes a replica partition into a master partition. The `WITH DROP` clause drops the previous master partition. The `WITH REPOINT` clause converts the previous master partition into a replica partition. There is no default, rebalance chooses one or the other based on the path to get to a balanced set of partitions.
`DROP PARTITION`	Drops a partition.

On this page

Syntax

Remarks

Example

Understanding the Rebalance Actions

Was this article helpful?

On this page

Was this article helpful?