测试环境:
管理节点:192.168.0.13
数据节点:192.168.0.14 192.168.0.15
SQL节点:192.168.0.16 192.168.0.17
下载:mysql-5.7.14-linux-glibc2.5-x86_64.tar.gz
1.配置管理节点:
创建目录/usr/local/mysql/mysql-cluster
编辑config.ini文件:
[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=100M
IndexMemory=18M
[TCP DEFAULT]
portnumber=1186
[NDB_MGMD]
NodeId=1
hostname=192.168.0.13
datadir=/usr/local/mysql/mysqlcluster
[NDBD]
NodeId=2
hostname=192.168.0.14
datadir=/usr/local/mysql/data
[NDBD]
NodeId=3
hostname=192.168.0.15
datadir=/usr/local/mysql/data
[MYSQLD]
NodeId=4
hostname=192.168.0.16
[MYSQLD]
NodeId=5
hostname=192.168.0.17
[MYSQLD]
cp mysql-5.7.14-linux-glibc2.5-x86_64/bin/ndb_mgm* /usr/local/mysql/mysql-cluster
2.配置数据节点+sql节点
创建/usr/local/mysql 目录
cp -a mysql-5.7.14-linux-glibc2.5-x86_64/* /usr/local/mysql
安装mysql:
groupadd mysql
useradd -g mysql mysql
chown -R mysql .
chgrp -R mysql .
chown -R mysql.mysql data
cp support-files/my-default.cnf /etc/my.cnf
bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
[mysqld]下加入:
ndbcluster
ndb-connectstring=192.168.0.13
[MYSQL_CLUSTER]
ndb-connectstring=192.168.0.13
启动mysql:
bin/mysqld_safe --user=mysql &
设置mysql密码:
alter user 'root'@'localhost' identified by '123456'
或者
set password=password("000000");
注册mysql服务
cp support-files/mysql.server /etc/rc.d/init.d/mysqld
chmod +x /etc/rc.d/init.d/mysqld
chkconfig --add mysqld
chkconfig --level 1235 mysqld on
3.启动管理节点:
ndb_mgmd -f /usr/local/mysql/mysql-cluster/config.ini
启动数据节点:
/usr/local/mysql/bin/ndbd --initial
首次启动,则需要添加--initial参数,以便进行NDB节点的初始化工作。在以后的启动过程中,则是不能添加该参数的,否则ndbd程序会清除在之前建立的所有用于恢复的数据文件和日志文件。
启动SQL节点:
/usr/local/mysql/bin/mysqld_safe --user=mysql &
查看节点情况:
/usr/local/mysql/mysql-cluster/ndb_mgm -e show