日期:2014-05-16 浏览次数:20883 次
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