以下安装参考mysql 官网和网络博客,经过本人人测试OK 。
mysql cluster rpm 安装
安装软件
[mysql@mynode2 ~]$ ls My*
MySQL-Cluster-client-gpl-7.3.8-1.el6.x86_64.rpm MySQL-Cluster-server-gpl-7.3.8-1.el6.x86_64.rpm
MySQL-Cluster-devel-gpl-7.3.8-1.el6.x86_64.rpm MySQL-Cluster-shared-compat-gpl-7.3.8-1.el6.x86_64.rpm
MySQL-Cluster-embedded-gpl-7.3.8-1.el6.x86_64.rpm MySQL-Cluster-shared-gpl-7.3.8-1.el6.x86_64.rpm
MySQL-Cluster-gpl-7.3.8-1.el6.x86_64.rpm-bundle.tar MySQL-Cluster-test-gpl-7.3.8-1.el6.x86_64.rpm
三台主机
192.168.1.181 管理节点
192.168.1.182 sql 节点 和存储节点
192.168.1.183 sql节点和存储节点
#增加用户:
userdel mysql
groupadd mysql
useradd mysql -g mysql
1, 安装 192.168.1.181
在管理节点安装
rpm -Uhv MySQL-Cluster-server-gpl-7.3.8-1.el6.x86_64.rpm
创建管理目录
mkdir /var/lib/mysql-cluster
chmod -R 777 /var/lib/mysql-cluster
[mysql@mynode1 mysql-cluster]$ cat config.ini
[computer]
Id=mgr-server-01
HostName=192.168.1.181
[mgm default]
datadir=/var/lib/mysql-cluster
[mgm]
HostName=192.168.1.181
NodeId=60
ExecuteOnComputer=mgr-server-01
PortNumber=1186
ArbitrationRank=2
[ndbd default]
NoOfReplicas=2
DataMemory=500M
IndexMemory=500M
[ndbd]
HostName=192.168.1.182
DataDir=/var/lib/mysql
NodeId=1
[ndbd]
HostName=192.168.1.183
DataDir=/var/lib/mysql
NodeId=2
[mysqld]
HostName=192.168.1.182
NodeId=81
[mysqld]
HostName=192.168.1.183
NodeId=82
#启动管理节点
[mysql@mynode1 mysql-cluster]$ ndb_mgmd -f /var/lib/mysql-cluster/config.ini
[mysql@mynode1 mysql-cluster]$ ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=1 @192.168.1.182 (mysql-5.6.22 ndb-7.3.8, Nodegroup: 0, *)
id=2 @192.168.1.183 (mysql-5.6.22 ndb-7.3.8, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=60 @192.168.1.181 (mysql-5.6.22 ndb-7.3.8)
[mysqld(API)] 2 node(s)
id=81 @192.168.1.182 (mysql-5.6.22 ndb-7.3.8)
id=82 @192.168.1.183 (mysql-5.6.22 ndb-7.3.8)
2,数据存储节点 192.168.1.182 / 192.168.1.183
rpm -Uhv MySQL-Cluster-server-gpl-7.3.8-1.el6.x86_64.rpm
rpm -Uhv MySQL-Cluster-client-gpl-7.3.8-1.el6.x86_64.rpm ---可以不装
创建数据节点数据目录
mkdir -p /var/lib/mysql
chown -R 777 /var/lib/mysql
[root@mynode1 mysql]# cd /usr/bin/
[root@mynode1 bin]# ll |grep mysql
-rwxr-xr-x 1 root root 1539 1鏈 9 20:09 msql2mysql
-rwxr-xr-x 1 root root 9852434 1鏈 9 20:11 mysql
-rwxr-xr-x 1 root root 111743 1鏈 9 20:09 mysqlaccess
-rw-r--r-- 1 root root 1702 1鏈 9 20:09 mysqlaccess.conf
-rwxr-xr-x 1 root root 8819481 1鏈 9 20:11 mysqladmin
-rwxr-xr-x 1 root root 9646126 1鏈 9 20:11 mysqlbinlog
-rwxr-xr-x 1 root root 11586 1鏈 9 20:09 mysqlbug
-rwxr-xr-x 1 root root 8807706 1鏈 9 20:11 mysqlcheck
-rwxr-xr-x 1 root root 6806 1鏈 9 20:09 mysql_config
初始化数据库
[root@mynode1 bin]# mysql_install_db --user=mysql --datadir=/var/lib/mysql
创建my.cnf配置文件
chmod 644 /etc/my.cnf
[root@mynode3 ~]$ cat /etc/my.cnf
[CLIENT]
socket=/var/lib/mysql/mysql.sock
[mysqld]
# Options for mysqld process:
datadir=/var/lib/mysql
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
log-bin = /var/lib/mysql/log/mysql-bin.log
max_connections=1000
ndbcluster # run NDB storage engine
ndb-connectstring=192.168.1.181
[mysql_cluster]
# Options for MySQL Cluster processes:
ndb-connectstring=192.168.1.181 # location of management server
#innodb_data_file_path = ibdata1:10M:autoextend
[NDB_MGM]
connect-string=192.168.1.181
[MYSQLD_SAFE]
log-error=/var//lib/mysql/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
启动ndbd服务
ndbd服务第一次启动时需要加上--initial选项,以后不需要
ndbd --initial
3,sql 节点
#安装server包和client包
rpm -Uhv MySQL-Cluster-server-gpl-7.3.8-1.el6.x86_64.rpm
rpm -Uhv MySQL-Cluster-client-gpl-7.3.8-1.el6.x86_64.rpm
mkdir -p /var/run/mysqld/
chmod -R 777 /var/run/mysqld/
#安装数据库
cd /usr/bin
mysql_install_db --user=mysql --datadir=/var/lib/mysql/
启动SQL节点
nohup mysqld_safe --user=mysql &
注意顺序。
1. 启动管理节点:ndb_mgmd -f /var/lib/mysql-cluster/config.ini
2. 启动存储节点:ndbd --initial
初次启动时需要加--initial参数,以后只需要执行ndbd即可;
3. 启动SQL节点:nohup mysqld_safe --explicit_defaults_for_timestamp &
最后结果:失败。
在管理节点上show信息:偶尔出现45连接,偶尔出现46连接,并且45,46上打开数据库时间非常长。
ndb_mgm> show
Connected to Management Server at: localhost:1186
关闭集群
先关闭管理节点,然后关闭SQL节点和数据节点。
/usr/local/mysql/bin/ndb_mgm -e shutdown 管理节点 root 执行
/usr/local/mysql/bin/mysqladmin -uroot shutdown 或者 mysql stop sql 节点 root 执行
/etc/rc.d/init.d/mysqld stop --数据节点 --mysql 用户执行
集群启动操作顺序
要再次启动集群,按照以下顺序执行:
管理节点 -> 数据节点 –> SQL节点注意:此次启动数据节点时不要加”–initial”参数。
usr/local/mysql/bin/ndb_mgmd -f /var/lib/mysql-cluster/config.inibak --管理节点 root 执行
/usr/local/mysql/bin/ndbd 启动数据节点 root 执行
nohup mysqld_safe --user=mysql & sql 节点启动 root 执行 或者 service mysqld start
软件下载链接
http://dev.mysql.com/downloads/cluster/
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15187685/viewspace-1472017/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15187685/viewspace-1472017/