具體安裝與配置:
1)
準備工作:
6台機器,IP地址分別為
192.168.0.(231-236)
MGM節點:192.168.0.231(232)
SQL 節點:192.168.0.233-234
NDBD 節點:192.168.0.235-236
系統都是RedHat AS 5.0
裝了基本的組件,具有連網功能,而且關閉了防火牆。
軟體,版本是:
mysql-5.1.21-beta-linux-i686-glibc23.tar.gz
2)管理節點的安裝:(232和231的機器)
shell> cd /var/tmp
shell> tar -zxvf mysql-5.1.21-beta-linux-i686-glibc23.tar.gz
shell> cd /var/tmp/mysql-5.1.21-beta-linux-i686-glibc23
shell> mkdir /usr/local/mysql
shell> cp bin/ndb_mgm* /usr/local/mysql
shell> cd /usr/local/mysql
shell> chmod a+x ndb_mgm*
shell> mkdir data(用來存放管理節點的資料)
3)SQL節點和NDBD 節點的安裝:(233-236 四台機器)
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /var/tmp
shell> tar -C /usr/local -xzvf mysql-5.1.21-beta-linux-i686-glibc23.tar.gz
shell> mv /usr/local/mysql-5.1.21-beta-linux-i686-glibc23 /usr/local/mysql
shell> cd mysql
shell> scripts/mysql_install_db --user=mysql
shell> chown -R mysql:mysql /usr/local/mysql
SQL節點還要增加下面的步驟才可以:
shell> cp support-files/mysql.server /etc/rc.d/init.d/mysqld
shell> chmod a+x /etc/rc.d/init.d/mysqld
shell> chkconfig --add mysqld
shell> chkconfig mysqld on (註冊MYSQL為系統的服務)
4)配置NDBD節點:
[root@localhost mysql]# cat /etc/my.cnf
[mysqld]
ndbcluster
#ndb-connectstring=192.168.0.231
#ndb-connectstring=192.168.0.232
這樣寫是可以串連成功。不過我今天來的時候發現全部DOWN掉了。
ndb-connectstring=192.168.0.231,192.168.0.232
[mysql_cluster]
#ndb-connectstring=192.168.0.231
#ndb-connectstring=192.168.0.232
ndb-connectstring=192.168.0.231,192.168.0.232
[root@localhost mysql]#
5)配置SQL 節點:
[root@localhost mysql]# cat /etc/my.cnf
[mysqld]
basedir=/usr/local/mysql/
datadir=/usr/local/mysql/data/
port=3306
user=nobody
socket=/tmp/mysql.sock
ndbcluster
#ndb-connectstring=192.168.0.231
#ndb-connectstring=192.168.0.232
ndb-connectstring=192.168.0.231,192.168.0.232
[ndbd]
connect-string=192.168.0.235
[ndbd]
connect-string=192.168.0.236
[ndbd_mgm]
connect-string=192.168.0.231
[ndbd_mgm]
connect-string=192.168.0.232
[ndbd_mgmd]
config-file=/etc/config.ini
[mysql_cluster]
#ndb-connectstring=192.168.0.231
#ndb-connectstring=192.168.0.232
ndb-connectstring=192.168.0.231,192.168.0.232
[root@localhost mysql]#