MySQL Cluster Manager
3.3.4 检查Cluster状态
使用MySQL Cluster管理器，你可以检查一下若干层次的状态：
● Cluster整体状态。
● 每个主机状态(特别是主机上的代理是否运行和可访问)
● 组成Cluster的每个节点(进程)的状态。
mcm> show status --cluster mycluster;
+-----------+-------------------+
| Cluster | Status |
+-----------+-------------------+
| mycluster | fully-operational |
+-----------+-------------------+
mcm> list hosts mysite;
+--------------+-----------+---------+
| Host | Status | Version |
+--------------+-----------+---------+
| 192.168.0.10 | Available | 1.0.1 |
| 192.168.0.11 | Available | 1.0.1 |
| 192.168.0.12 | Available | 1.0.1 |
| 192.168.0.13 | Available | 1.0.1 |
+--------------+-----------+---------+
mcm> show status --process mycluster;
+------+----------+--------------+---------+-----------+
| Id | Process | Host | Status | Nodegroup |
+------+----------+--------------+---------+-----------+
| 1 | ndb_mgmd | 192.168.0.10 | running | |
| 2 | ndb_mgmd | 192.168.0.11 | running | |
| 3 | ndbd | 192.168.0.12 | running | 0 |
| 4 | ndbd | 192.168.0.13 | running | 0 |
| 5 | ndbd | 192.168.0.12 | running | 1 |
| 6 | ndbd | 192.168.0.13 | running | 1 |
| 7 | mysqld | 192.168.0.10 | running | |
| 8 | mysqld | 192.168.0.11 | running | |
+------+----------+--------------+---------+-----------+
+-----------+-------------------+
| Cluster | Status |
+-----------+-------------------+
| mycluster | fully-operational |
+-----------+-------------------+
mcm> list hosts mysite;
+--------------+-----------+---------+
| Host | Status | Version |
+--------------+-----------+---------+
| 192.168.0.10 | Available | 1.0.1 |
| 192.168.0.11 | Available | 1.0.1 |
| 192.168.0.12 | Available | 1.0.1 |
| 192.168.0.13 | Available | 1.0.1 |
+--------------+-----------+---------+
mcm> show status --process mycluster;
+------+----------+--------------+---------+-----------+
| Id | Process | Host | Status | Nodegroup |
+------+----------+--------------+---------+-----------+
| 1 | ndb_mgmd | 192.168.0.10 | running | |
| 2 | ndb_mgmd | 192.168.0.11 | running | |
| 3 | ndbd | 192.168.0.12 | running | 0 |
| 4 | ndbd | 192.168.0.13 | running | 0 |
| 5 | ndbd | 192.168.0.12 | running | 1 |
| 6 | ndbd | 192.168.0.13 | running | 1 |
| 7 | mysqld | 192.168.0.10 | running | |
| 8 | mysqld | 192.168.0.11 | running | |
+------+----------+--------------+---------+-----------+
0
第1页：降低复杂性和风险，同时提高管理器效率第2页：MySQL Cluster管理器介绍第3页： MySQL Cluster管理器的高可用操作第4页：MySQL Cluster管理器—架构和用途第5页：改变了以前管理MySQL Cluster方式第6页：MySQL Cluster管理器模式和条件第7页：使用MySQLCluster管理器—一个工作实例第8页：安装、配置、运行MySQLCluster管理器第9页： 创建和开始一个Cluster第10页： 检查Cluster状态第11页： 检查Cluster状态第12页： 升级MySQL Cluster第13页：结论及关于MySQL Cluster数据库
相关文章
关注我们
