You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

SHOW CLUSTER STATUS

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

Syntax

SHOW CLUSTER STATUS;

Remarks

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)