MySQL 中文网

5. 管理

在管理节点上，运行客户端工具 ndb_mgm：

/usr/local/mysql/bin/ndb_mgm
-- NDB Cluster -- Management Client --

#查看集群状态

ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=3    @192.168.0.3  (mysql-6.0.3 ndb-6.2.6, Nodegroup: 0, Master)
id=4    @192.168.0.4  (mysql-6.0.3 ndb-6.2.6, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @192.168.0.1  (mysql-6.0.3 ndb-6.2.6)

[mysqld(API)]   2 node(s)
id=2    @192.168.0.2  (mysql-6.0.3 ndb-6.2.6)
id=5 (not connected, accepting connect from any host)

#查看全部数据节点状态

ndb_mgm> all status
Node 3: started (mysql-6.0.3 ndb-6.2.6)
Node 4: started (mysql-6.0.3 ndb-6.2.6)

#报告数据节点的内存使用情况

ndb_mgm> 3 report memoryusage
Node 3: Data usage is 6%(2154 32K pages of total 32768)
Node 3: Index usage is 2%(3009 8K pages of total 131104)

#重启第3个节点

ndb_mgm> 3 restart
Node 3: Node shutdown initiated
Node 3: Node shutdown completed, restarting, no start.
Node 3 is being restarted

Node 3: Started (version 6.2.6)