Outdated Version
You are viewing an older version of this section. View current production version.
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
- 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)
