Shows information about partitions within a cluster including replication role, replication state, and replication position, across all databases.

SHOW CLUSTER STATUS;

Notes

• This command must be run on the master aggregator or a child aggregator node (see Node Requirements for MemSQL Commands ).

Example

show cluster status;
****
+----------------------------+------+------------------+-----------+-------------+--------------+---------+
| Host                       | Port | Database         | Role      | State       | Position     | Details |
+----------------------------+------+------------------+-----------+-------------+--------------+---------+
| ip-10-0-1-251.ec2.internal | 3306 | dashboard        | Reference | replicating | 85:140598273 |         |
| ip-10-0-1-251.ec2.internal | 3306 | dashboard_0      | Master    | online      | 5:123919735  |         |
| ip-10-0-1-251.ec2.internal | 3306 | dashboard_16     | Master    | online      | 5:119712270  |         |
| ip-10-0-1-251.ec2.internal | 3306 | dashboard_24     | Master    | online      | 5:120116309  |         |
... snip ...
| ip-10-0-2-184.ec2.internal | 3306 | taxistats_39     | Master    | online      | 0:194908709  |         |
| ip-10-0-2-184.ec2.internal | 3306 | taxistats_47     | Master    | online      | 0:194720042  |         |
| ip-10-0-2-184.ec2.internal | 3306 | taxistats_55     | Master    | online      | 0:195045079  |         |
| ip-10-0-2-184.ec2.internal | 3306 | taxistats_63     | Master    | online      | 0:194714010  |         |
| ip-10-0-2-184.ec2.internal | 3306 | taxistats_7      | Master    | online      | 0:194731867  |         |
+----------------------------+------+------------------+-----------+-------------+--------------+---------+
288 rows in set (1.88 sec)

Was this Article Helpful?

Thanks For Your Feedback!