日期:2014-05-16 浏览次数:20801 次
Mysql版本:mysql-cluster-gpl-7.1.14-linux-i686-glibc23.tar.gz
操作系统:Debian6.0 虚拟机
192.168.225.131 (MGMD)
192.168.225.133 (NDBD)
192.168.225.134 (NDBD)
192.168.225.135 (MySQLD)
192.168.225.136 (MySQLD)
1.每台虚拟机都安装mysql-cluster
root@debian:/home/john# groupadd mysql
root@debian:/home/john# useradd -g mysql mysql
root@debian:/home/john# tar zxf mysql-cluster-gpl-7.1.14-linux-i686-glibc23.tar.gz
root@debian:/home/john# mv zxf mysql-cluster-gpl-7.1.14-linux-i686-glibc23 /usr/local/mysql
root@debian:/home/john# chown mysql:mysql /usr/local/mysql
root@debian:/home/john#
rm mysql-cluster-gpl-7.1.14-linux-i686-glibc23.tar.gz
2.配置MGMD(管理节点192,168.225.131)
创建文件/var/lib/mysql-cluster/config.ini (可以是其他位置或命名)
[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=100M
IndexMemory=100M
[TCP DEFAULT]
portnumber=2202
[NDB_MGMD]
id=1
hostname=192.168.225.131
datadir=/var/lib/mysql-cluster
[NDBD]
id=2
hostname=192.168.225.133
datadir=/usr/local/mysql/ndbdata