mysql cluster

SHUTDOWN
1.ndb_mgm>shutdown all the ndb nodes will be shutdon. stop mysql service.

Start
1.ndb_mgmd.exe --reload -f d:\mysql-cluster\config.ini --configdir=d:\mysql-cluster
--reload 重新加载配置文件比如修改内存大小需要这个参数。
--configdir=d:\mysql-cluster 指定客户化目录。
2.ndb nodes start
detail refer:http://blog.csdn.net/zhangking/archive/2010/06/13/5670070.aspx
3.start or restart mysql service.

Configure

1.ndb_config --query=id,type,MaxNoOfOrderedIndexes,IndexMemory,DataMemory 查找配置内存大小（18M，80M）

2.C:\>ndb_mgmd.exe --reload -f d:\mysql-cluster\config.ini --configdir=d:\mysql-cluster(修改内存重新加

载)
refer:http://bugs.mysql.com/bug.php?id=45146
refer:http://blog.csdn.net/zhangking/archive/2010/06/13/5670070.aspx
3.ndb_mgm> ALL REPORT MEMORY(显示所有内存使用情况)

The server has returned this error message:MySQL server has gone away.
solution: change the max_allowed_packet from 1M to 16M.

How to query the max_allowed_packet vaule use below command.
mysql>show variables like '%max_allowed_packet%';

评论

1 楼 liliugen 2010-09-06  

mysql集群哥