MySql节点管理安装步骤

对大家推荐很好使用的MySql节点系统，像让大家对MySql节点系统有所了解，然后对MySql节点系统全面讲解介绍，希望对大家有用在向大家详细介绍MySql节点之前，首先让大家了解下MySql节点，然后全面介绍MySql节点，希望对大家有用。这篇文档旨在介绍如何安装配置基于2台服务器的MySQL集群。并且实现任意一台服务器出现问题或宕机时MySql集群依然能够继续运行。

安装环境及软件包：2台PCmysql-6.0.0-alpha.tar.gzCentos5SerA:192.168.1.50SerB:192.168.1.8

1、在SerA和SerB上安装MySQL以下步骤需要在SerA和SerB上各做一次

1. # mv mysql-6.0.0-alpha.tar.gz /tmp/package

2. # cd /tmp/package

3. # groupadd mysql

4. # useradd -g mysql mysql

5. # tar -zxvf mysql-6.0.0-alpha.tar.gz

6. # rm -f mysql-6.0.0-alpha.tar.gz

7. # mv mysql-6.0.0-alpha mysql

8. # cd mysql

9. # ./configure --prefix=/usr/local --with-extra-charsets=complex --with-plugin-ndbcluster

10. --with-plugin-partition --with-plugin-innobase --with-unix-socket-path=/usr/local/var/mysql.sock

11. # make && make install

12. #ln -s /usr/local/libexec/ndbd /usr/bin

13. #ln -s /usr/local/libexec/ndb_mgmd /usr/bin

14. #ln -s /usr/local/libexec/ndb_cpcd /usr/bin

15. #ln -s /usr/local/libexec/mysqld /usr/bin

16. #ln -s /usr/local/libexec/mysqlmanager /usr/bin

17. #mysql_install_db --user=mysql

我用的是:mysql-5.0.85-linux-i686.tar.gz

二、安装并配置MySql节点

以下步骤需要在SerA和SerB上各做一次

1.配置管理MySql节点配置文件：

1. # mkdir /var/lib/mysql-cluster

2. # cd /var/lib/mysql-cluster

3. # vi config.ini

4. 在config.ini中添加如下内容：

5. [ndbd default]

6. NoOfReplicas= 2

7. MaxNoOfConcurrentOperations= 10000

8. # Amount of memory required=(SizeofDatabase * NumberOfReplicas * 1.1 ) / NumberOfDataNodes

9. DataMemory= 128M

10. IndexMemory= 24M

11. TimeBetweenWatchDogCheck= 30000

12. DataDir=/var/lib/mysql-cluster

13. MaxNoOfOrderedIndexes= 512

14. StartPartialTimeout=100

15. StartPartitionedTimeout=100

16. ArbitrationTimeout=5000

17. TransactionDeadlockDetectionTimeout=5000

18. HeartbeatIntervalDbDb=5000

19. StopOnError=0

20. 
    

21. [ndb_mgmd default]

22. DataDir=/var/lib/mysql-cluster

23. [ndb_mgmd]

24. Id=1

25. HostName= 192.168.1.50

26. [ndb_mgmd]

27. Id=2

28. HostName= 192.168.1.8

29. [ndbd]

30. Id= 3

31. HostName= 192.168.1.50

32. [ndbd]

33. Id= 4

34. HostName= 192.168.1.8

35. [mysqld]

36. ArbitrationRank=2 (非常重要,全靠有它,才可以形成仲裁竞争,从而当另一个机子当了时,此机还可以有知道partion完整的节点)

37. [mysqld]

38. ArbitrationRank=2

39. [mysqld] (多出的这项是留给恢复时使用的.)

40. [mysqld] (多出的这项是留给恢复时使用的.)

41. [tcp default]

42. PortNumber= 63132

43. 
    

44. [separator]

2.配置通用my.cnf文件，mysqld及ndbd,ndb_mgmd均使用此文件.

1. # vi /etc/my.cnf

2. 在my.cnf中添加如下内容：

3. [mysqld]

4. datadir=/usr/local/var

5. socket=/usr/local/var/mysql.sock

6. # Default to using old password format for compatibility with mysql 3.x

7. # clients (those using the mysqlclient10 compatibility package).

8. old_passwords=1

9. default-storage-engine=ndbcluster

10. ndbcluster

11. ndb-connectstring=192.168.1.50,192.168.1.8

12. 
    

13. [ndbd]

14. connect-string=192.168.1.50,192.168.1.8

15. 
    

16. [ndb_mgm]

17. connect-string=192.168.1.50,192.168.1.8

18. 
    

19. [ndb_mgmd]

20. config-file=/var/lib/mysql-cluster/config.ini

21. 
    

22. [mysql_cluster]

23. ndb-connectstring=192.168.1.50,192.168.1.8

24. 
    

25. [mysql.server]

26. user=mysql

27. basedir=/usr/local/

28. 
    

29. [mysqld_safe]

30. log-error=/var/log/mysqld.log

31. #pid-file=/var/run/mysqld/mysqld.pid

32. [mysql]

33. #socket=/usr/local/var/mysql.sock

34. [mysqladmin]

35. #socket=/usr/local/var/mysql.sock

36. [ndb_restore default] 保存退出后.

三.启动管理MySql节点SerA为：

1. [root@SerA ~]# ndb_mgmd --ndb_nodeid=1

2. Cluster configuration warning:

3. arbitrator with id 1 and db node with id 3 on same host 192.168.1.50

4. arbitrator with id 2 and db node with id 4 on same host 192.168.1.8

5. arbitrator with id 5 has no hostname specified

6. arbitrator with id 6 has no hostname specified

7. Running arbitrator on the same host as a database node may

8. cause complete cluster shutdown in case of host failure.

注:在启动时有一个警告提示说MySql节点1和3，2和4的arbitrator一样，可能引起整个集群失败。（可以不用放在心上）启动管理MySql节点SerB为：[root@SerB ~]# ndb_mgmd --ndb_nodeid=2.