mysql cluster 簡單配置

selectshen發表於2015-07-02
MySql
----主機資訊
os:cent os 6.5
host: ct6505/192.108.56.115  管理節點,SQL節點,NDB儲存節點
      ct6506/192.108.56.116  SQL節點,NDB儲存節點
MySQL-Cluster:7.4.6

----安裝MySQL-Cluster
--ct6505,ct6506
[root@ct6505/6 ~]# yum remove mysql-libs-5.1.71-1.el6.x86_64
[root@ct6505/6 ~]# yum install libaio
[root@ct6505/6 ~]# yum  install perl
[root@ct6505/6 ~]# ls MySQL-Cluster-*
MySQL-Cluster-client-advanced-7.4.6-1.el6.x86_64.rpm
MySQL-Cluster-server-advanced-7.4.6-1.el6.x86_64.rpm
[root@ct6505/6 ~]# rpm -ivh MySQL-Cluster-*

----配置MySQL-Cluster
--管理節點
--ct6505
[root@ct6505 mysql-cluster]# mkdir -p /var/lib/mysql-cluster
[root@ct6505 mysql-cluster]# cat /var/lib/mysql-cluster/config.ini

[computer]
 Id=mgr-server-01
 HostName=192.108.56.115

 [mgm default]
 datadir=/var/lib/mysql-cluster

 [mgm]
 HostName=192.108.56.115
 NodeId=60
 ExecuteOnComputer=mgr-server-01
 PortNumber=1186
 ArbitrationRank=2

 [ndbd default]
 NoOfReplicas=2
 DataMemory=512M
 IndexMemory=512M

 [ndbd]
 HostName=192.108.56.115
 DataDir=/var/lib/mysql
 NodeId=1

 [ndbd]
 HostName=192.108.56.116
 DataDir=/var/lib/mysql
 NodeId=2

 [mysqld]
 HostName=192.108.56.115
 NodeId=81

 [mysqld]
 HostName=192.108.56.116
 NodeId=82
 
--NDB儲存節點
--ct6505,ct6506
[root@ct6505/6 mysql-cluster]# cat /etc/my.cnf
 [mysql_cluster]
 ndb-connectstring=192.108.56.115

 
--SQL節點
--ct6505,ct6506
[root@ct6505/6 mysql-cluster]# cat /usr/my.cnf

[client]
 socket=/var/lib/mysql/mysql.sock

 [mysqld]
 datadir=/var/lib/mysql
 ndbcluster

[mysql_cluster]
 ndb-connectstring=192.108.56.115
 
----啟動
--ct6505
[root@ct6505 ~]# ndb_mgmd -f /var/lib/mysql-cluster/config.ini
--ct6505,ct6506
[root@ct6505/6 ~]# ndbd --initial    /* --initial只在第一次啟動使用 */
[root@ct6505/6 ~]# mysqld_safe &

----修改密碼
--ct6505,ct6506
[root@ct6505/6 ~]# cat /root/.mysql_secret
# The random password set for the root user at Fri Jun 19 13:25:21 2015 (local time): Igi1I1PJxfzOdRLq

[root@ct6505/6 mysql]# mysql -uroot -p
mysql> SET PASSWORD = PASSWORD('system');
mysql>  use mysql;
mysql> update user set host='%' where host='localhost';
mysql> flush privileges;

----關閉
[root@ct6505/6 ~]# mysqladmin -uroot -p shutdown
[root@ct6505 ~]# ndb_mgm -e shutdown

----管理工具
[root@ct6505/6 ~]# ndb_mgm
 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/28539951/viewspace-1720636/，如需轉載，請註明出處，否則將追究法律責任。

相關文章