一、管理节点(172.20.10.11):
- 下载:
https://dev.mysql.com/downloads/cluster/(官网:选择linux-generic)
或
https://github.com/dollarphper/soft/blob/master/mysql/mysql-cluster-gpl-7.6.7-linux-glibc2.12-x86_64.tar.gz
- 安装: a. 解压:
tar -xzf mysql-cluster-gpl-7.6.7-linux-glibc2.12-x86_64.tar.gz
b. 移动:
mv mysql-cluster-gpl-7.6.7-linux-glibc2.12-x86_64 /etc/mysql
c. 创建文件夹:
mkdir /etc/mysql/data
d. 创建配置文件: vim /etc/mysql/config.ini
[ndbd default]
NoOfReplicas=2
MaxNoOfTables=1024
MaxNoOfUniqueHashIndexes=1024
MaxNoOfOrderedIndexes=1024
MaxNoOfAttributes=10000
[ndb_mgmd]
HostName=172.20.10.11
DataDir=/etc/mysql/data
[ndbd]
HostName=172.20.10.12
DataDir=/etc/mysql/data
[ndbd]
HostName=172.20.10.13
DataDir=/etc/mysql/data
[mysqld]
HostName=172.20.10.12
[mysqld]
HostName=172.20.10.13
e. 启动:
/etc/mysql/bin/ndb_mgmd --config-file=/etc/mysql/config.ini --configdir=/etc/mysql
f. 查看状态:
/etc/mysql/bin/ndb_mgm -e show
g. 停止:
/etc/mysql/bin/ndb_mgm -e shutdown
二、数据节点/sql节点(172.20.10.12,172.20.10.13):
- 下载:
https://dev.mysql.com/downloads/cluster/(官网:选择linux-generic)
或
https://github.com/dollarphper/soft/blob/master/mysql/mysql-cluster-gpl-7.6.7-linux-glibc2.12-x86_64.tar.gz
- 安装: a. 解压:
tar -xzf mysql-cluster-gpl-7.6.7-linux-glibc2.12-x86_64.tar.gz
b. 移动:
mv mysql-cluster-gpl-7.6.7-linux-glibc2.12-x86_64 /etc/mysql
c. 创建文件夹:
mkdir /etc/mysql/data
- 创建配置文件: vim /etc/mysql/my.cnf
[mysqld]
character_set_server=utf8
basedir=/etc/mysql
datadir=/etc/mysql/data
ndbcluster
ndb-connectstring=172.20.10.11
user=root
socket=/etc/mysql/data/mysql.sock
[mysql_cluster]
ndb-connectstring=172.20.10.11
[client]
socket=/etc/mysql/data/mysql.sock
- 初始化:
/etc/mysql/bin/mysqld --initialize-insecure --basedir=/etc/mysql --datadir=/etc/mysql/data
- 启动数据节点:
/etc/mysql/bin/ndbd --defaults-file=/etc/mysql/my.cnf --initial(仅第一次启动)
或
/etc/mysql/bin/ndbd --defaults-file=/etc/mysql/my.cnf
- 启动sql节点:
/etc/mysql/bin/mysqld --defaults-file=/etc/mysql/my.cnf &
三、测试(172.20.10.11):
- 执行命令:
/etc/mysql/bin/ndb_mgm -e show
- 效果: