MySQL的集群的安装与配置(6台机器)
MySQL的集群的安装与配置(6台机器)
具体安装与配置: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]#
|
评论暂时关闭