----主机信息
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博客

mysql cluster 简单配置

最新文章