Mysql数据库集群简单配置
环境：192.168.5.155 mysql-mgm-node
192.168.5.156 mysql-sql-node1 mysql-data-node1
192.168.5.157 mysql-sql-node2 mysql-data-node2
下载cluster软件并上传至各服务器。
1、安装MGM节点：
创建安装目录
mkdir -p /usr/local/mysql/bin
mkdir -p /usr/local/mysql/ndbdata
添加执行文件路径
vi ~/.bash_profile
PATH=$PATH:$HOME/bin:/usr/local/mysql/bin
拷贝执行文件
cp bin/ndb_mgmd /usr/local/mysql/bin
cp bin/ndb_mgm /usr/local/mysql/bin
创建日志文件存储目录
mkdir /var/log/mysql-cluster
创建配置文件目录及文件
mkdir /usr/local/mysql/cluster-conf
vi /usr/local/mysql/cluster-conf/config.ini
编辑配置文件：
NoOfReplicas=2
DataMemory=2048M
IndexMemory=512M
id=1
hostname=192.168.5.155
DataDir=/var/log/mysql-cluster
id=11
HostName=192.168.5.156
DataDir=/usr/local/mysql/ndbdata
id=12
HostName=192.168.5.157
DataDir=/usr/local/mysql/ndbdata
id=21
HostName=192.168.5.156
id=22
HostName=192.168.5.157
id=23
2、安装数据节点及SQL节点：
yum install libaio
#groupadd mysql
#useradd mysql -g mysql
#mv mysql-cluster-gpl-7.2.9-linux2.6-x86_64.tar.gz /usr/local/
#cd /usr/local/
#tar zxvf mysql-cluster-gpl-7.2.9-linux2.6-x86_64.tar.gz
#rm -f mysql-cluster-gpl-7.2.9-linux2.6-x86_64.tar.gz
#mv mysql-cluster-gpl-7.2.9-linux2.6-x86_64 mysql
#chown -R mysql:mysql mysql
#cd mysql
#scripts/mysql_install_db --user=mysql
#cp support-files/my-medium.cnf /etc/my.cnf
#cp support-files/mysql.server /etc/init.d/mysqld
#vi /etc/my.cnf
添加：
datadir=/usr/local/mysql/data/
ndbcluster
ndb-connectstring=192.168.5.155
connect-string=192.168.5.155
ndb-connectstring=192.168.5.155
connect-string=192.168.5.155
config-file=/var/lib/mysql-cluster/config.ini
3、启动相关服务
（1）启动管理节点相关服务:
#/usr/local/mysql/bin/ndb_mgmd -f /var/lib/mysql-cluster/config.ini
#netstat -lntpu
tcp 0 0 0.0.0.0:1186 0.0.0.0:*
LISTEN 22907/ndb_mgmd
（2）启动数据节点相关服务:
#/usr/local/mysql/bin/ndbd --initial（初次启动需要加 --initial参数）
#netstat -lntpu
mkdir /usr/local/mysql/ndbdata
chmod 755 /usr/local/mysql/ndbdata
#service mysqld start
4、功能测试：
# ./ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
2 node(s)
id=11 @192.168.5.156(mysql-5.5.28 ndb-7.2.9, Nodegroup: 0)
id=12 @192.168.5.157(mysql-5.5.28 ndb-7.2.9, Nodegroup: 0, Master)
1 node(s)
id=1 @192.168.5.155(mysql-5.5.28 ndb-7.2.9)
3 node(s)
id=21 @192.168.5.156(mysql-5.5.28 ndb-7.2.9)
id=22 @192.168.5.157(mysql-5.5.28 ndb-7.2.9)
id=23 (not connected, accepting connect from any host)
可关闭master，看master状态是否转移到另外一台；在A关闭状态下，修改B数据库，启动A，看数据是否同步。
页:
[1]