一、管理节点(172.20.10.11):

  1. 下载:
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
  1. 安装: 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):

  1. 下载:
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
  1. 安装: 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
  1. 创建配置文件: 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
  1. 初始化:
/etc/mysql/bin/mysqld  --initialize-insecure  --basedir=/etc/mysql  --datadir=/etc/mysql/data
  1. 启动数据节点:
/etc/mysql/bin/ndbd  --defaults-file=/etc/mysql/my.cnf  --initial(仅第一次启动)
或
/etc/mysql/bin/ndbd  --defaults-file=/etc/mysql/my.cnf
  1. 启动sql节点:
/etc/mysql/bin/mysqld  --defaults-file=/etc/mysql/my.cnf  &

三、测试(172.20.10.11):

  1. 执行命令:
/etc/mysql/bin/ndb_mgm  -e  show
  1. 效果: