Mysql Cluster概述与部署(三)
212992 | 26 | 19136512 | 2336 |
7
| 3 | Data memory | 851968 | 26 | 83886080 | 2560 |
8
| 3 | Index memory | 212992 | 26 | 19136512 | 2336 |
注意:使用量写满会访问不了,这时需要调整配置DataMemory,IndexMemory参数.各配置文件都需调整重启生效.
7.关闭cluster
1
root@10.1.6.205:/usr/local/mysql/bin# /usr/local/mysql/bin/ndb_mgm -e shutdown
2
Connected to Management Server at: 10.1.6.205:1186
3
3 NDB Cluster node(s) have shutdown.
4
Disconnecting to allow management server to shutdown.
再关闭SQL节点mysqld服务
1
root@10.1.6.203:/usr/local/mysql/bin# /usr/local/mysql/bin/mysqladmin -uroot -p shutdown
2
Enter password:
3
130829 02:19:57 mysqld_safe mysqld from pid file /usr/local/mysql/data//debian.pid ended
4
[1]+ Done /usr/local/mysql/bin/mysqld_safe /etc/my.cnf
以上就是mysql cluster初步部署, 之后会写haproxy+keepalive 双机高可用.