1、3台机器搭建集群环境1.集群配置如下(3台机器)管理节点:192.168.6.134数据节点1:192.168.6.135数据节点2:192.168.6.136sql节点1:192.168.6.135sql节点2:192.168.6.136我使用3台机器进行配置,其中两台机器上的数据节点与sql节点在一起2.管理节点安装(192.168.6.134)安装1.shell> groupadd mysql 2.shell> useradd mysql -g mysql 3.shell> mv mysql
2、-cluster-gpl-7.2.6-linux2.6-x86_64.tar.gz /usr/local/ 4.shell> cd /usr/local/ 5.shell> tar zxvf mysql-cluster-gpl-7.2.6-linux2.6-x86_64.tar.gz /usr/local/ 6.shell> mv mysql-cluster-gpl-7.2.6-linux2.6-x86_64 mysql 7.shell> chown -R mysql:mysql mysql
3、 8.shell> cd mysql 9.shell> scripts/mysql_install_db --user=mysql 配置管理节点1.shell> mkdir /var/lib/mysql-cluster 2.shell> cd /var/lib/mysql-cluster viconfig.ini添加以下内容1.[ndbd default] 2.NoOfReplicas=2 3.DataMemory=80M 4.IndexMemory=18M 5.[ndb_mgmd]
5、 //数据节点2 11.datadir=/usr/local/mysql/data/ //数据文件位置 12.[MYSQLD] 13.[MYSQLD] 3.数据节点安装(192.168.6.135,192.168.6.136)执行相同的安装操作1.shell> groupadd mysql 2.shell> useradd mysql -g mysql 3.shell> mv mysql-cluster-gpl-7.2.6-linux2.6-x86_64 /usr/loca
6、l/ 4.shell> cd /usr/local/ 5.shell> tar zxvf mysql-cluster-gpl-7.2.6-linux2.6-x86_64.tar.gz 6.shell> mv mysql-cluster-gpl-7.2.6-linux2.6-x86_64 mysql 7.shell> chown -R mysql:mysql mysql 8.shell> cd mysql 9.shell> scripts/mysql_install_db --user=my
7、sql 1.shell> cp support-files/mysql.server /etc/init.d/mysqld 配置数据节点vi/etc/my.cnf添加入如下内容1.[mysqld] 2.ndbcluster # run NDB storage engine 3.ndb-connectstring=192.168.6.134 # location of management server 4. 5.# Options for
8、ndbd process: 6.[mysql_cluster] 7.ndb-connectstring=192.168.6.134 # location of management server 4.启动管理节点服务(192.168.6.134)[plain] viewplain copy print?1.shell> /usr/local/mysql/bin/ndb_mgmd -f /var/lib/mysql-cluster/config.