3.2.7.3 集群扩容
由于MySQL集群属于内存存储模式,所以如果出现存储空间不足时,需要扩容,也就是为集群中增加ndbd数据存储节点,以扩大存储空间。根据官方文档(mysql-cluster-excerpt-5.1-en.pdf的5.12章节Adding MySQL Cluster Data Nodes Online),Mysql集群支持在线扩容,具体步骤如下:
a) 首先必须确保新加入的数据节点作为新的group加入,默认2个node为1个group,Group数量=Node总数/NoOfReplicas数;
b) 修改管理节点的config.ini文件,从
DataMemory = 100M
IndexMemory = 100M
NoOfReplicas = 2
DataDir = /usr/local/mysql/var/mysql-cluster
[ndbd]
Id = 1
HostName = 192.168.0.1
[ndbd]
Id = 2
HostName = 192.168.0.2
[mgm]
HostName = 192.168.0.10
Id = 10
[api]
Id=20
HostName = 192.168.0.20
[api]
Management of MySQL Cluster
308
Id=21
HostName = 192.168.0.21
Note
修改为:
[ndbd default]
DataMemory = 100M
IndexMemory = 100M
NoOfReplicas = 2
DataDir = /usr/local/mysql/var/mysql-cluster
[ndbd]
Id = 1
HostName = 192.168.0.1
[ndbd]
Id = 2
HostName = 192.168.0.2[ndbd]
Id = 3
HostName = 192.168.0.3
[ndbd]
Id = 4
HostName = 192.168.0.4
[mgm]
HostName = 192.168.0.10
Id = 10
[api]
Id=20
HostName = 192.168.0.20
[api]
Id=21
HostName = 192.168.0.21
其中蓝色字体为新增加内容,在1、2两个node的基础上,再增加3、4两个node;需要注意增加的NodeID不能与之前已经存在的NodeID重复,不能是1、2、10、20、21,这里取3和4;修改之前用ndb_mgm客户端的show命令查看集群信息如下:
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: 192.168.0.10:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=1 @192.168.0.1 (5.1.56-ndb-7.1.17, Nodegroup: 0, Master)
id=2 @192.168.0.2 (5.1.56-ndb-7.1.17,