Docker部署mysql ndbcluster8

一，环境说明

1，mysql ndbcluster8集群配置文件mysql-cluster.cnf内容：

[ndbd default]
NoOfReplicas=2
DataMemory=80M
IndexMemory=18M
[ndb_mgmd]
NodeId=1
hostname=192.168.20.2
datadir=/var/lib/mysql
[ndbd]
NodeId=2
NodeGroup=1
hostname=192.168.20.3
datadir=/var/lib/mysql
[ndbd]
NodeId=3
NodeGroup=1
hostname=192.168.20.4
datadir=/var/lib/mysql
[ndbd]
NodeId=4
NodeGroup=2
hostname=192.168.20.5
datadir=/var/lib/mysql
[ndbd]
NodeId=5
NodeGroup=2
hostname=192.168.20.6
datadir=/var/lib/mysql
[mysqld]
NodeId=6
hostname=192.168.20.9
[mysqld]
NodeId=7
hostname=192.168.20.10

2，mysql配置文件my.cnf内容:

[mysqld]
log_timestamps = SYSTEM
max_connections = 5000
max_connect_errors = 10000
ndbcluster
ndb-connectstring=192.168.20.2
user=mysql
default-storage-engine=NDBCLUSTER

[mysql_cluster]
ndb-connectstring=192.168.20.2

二，docker部署命令。

1，创建cluster网络

docker network create cluster --subnet=192.168.20.0/24

2，创建mgmd与ndb,mysql相关节点

docker run -d --net=cluster --name=management1 --ip=192.168.20.2 -e "TZ=Asia/Shanghai" -v /etc/localtime:/etc/localtime:ro   -v /mysqlndb/my.cnf:/etc/my.cnf -v /mysqlndb/mysql-cluster.cnf:/etc/mysql-cluster.cnf container-registry.oracle.com/mysql/community-cluster:8.0 ndb_mgmd


docker run -d --net=cluster --name=ndb1 --ip=192.168.20.3  -e "TZ=Asia/Shanghai" -v /etc/localtime:/etc/localtime:ro -v /mysqlndb/my.cnf:/etc/my.cnf -v /mysqlndb/mysql-cluster.cnf:/etc/mysql-cluster.cnf container-registry.oracle.com/mysql/community-cluster:8.0 ndbd
docker run -d --net=cluster --name=ndb2 --ip=192.168.20.4  -e "TZ=Asia/Shanghai" -v /etc/localtime:/etc/localtime:ro -v /mysqlndb/my.cnf:/etc/my.cnf -v /mysqlndb/mysql-cluster.cnf:/etc/mysql-cluster.cnf container-registry.oracle.com/mysql/community-cluster:8.0 ndbd


docker run -d --net=cluster --name=ndb3 --ip=192.168.20.5 -e "TZ=Asia/Shanghai" -v /etc/localtime:/etc/localtime:ro  -v /mysqlndb/my.cnf:/etc/my.cnf -v /mysqlndb/mysql-cluster.cnf:/etc/mysql-cluster.cnf container-registry.oracle.com/mysql/community-cluster:8.0 ndbd
docker run -d --net=cluster --name=ndb4 --ip=192.168.20.6  -e "TZ=Asia/Shanghai" -v /etc/localtime:/etc/localtime:ro -v /mysqlndb/my.cnf:/etc/my.cnf -v /mysqlndb/mysql-cluster.cnf:/etc/mysql-cluster.cnf container-registry.oracle.com/mysql/community-cluster:8.0 ndbd
 
 


docker run -d --net=cluster --name=mysql1 --ip=192.168.20.9 -e MYSQL_RANDOM_ROOT_PASSWORD=true  -p 3376:3306  -e "TZ=Asia/Shanghai" -v /etc/localtime:/etc/localtime:ro -v /mysqlndb/my.cnf:/etc/my.cnf -v /mysqlndb/mysql-cluster.cnf:/etc/mysql-cluster.cnf container-registry.oracle.com/mysql/community-cluster:8.0 mysqld 


docker run -d --net=cluster --name=mysql2 --ip=192.168.20.10 -e MYSQL_RANDOM_ROOT_PASSWORD=true  -p 3386:3306   -e "TZ=Asia/Shanghai" -v /etc/localtime:/etc/localtime:ro -v /mysqlndb/my.cnf:/etc/my.cnf -v /mysqlndb/mysql-cluster.cnf:/etc/mysql-cluster.cnf container-registry.oracle.com/mysql/community-cluster:8.0 mysqld

3，查看集群节点是否正常。

docker exec -it management1 ndb_mgm -e show

root@os71 ~]# docker exec -it management1 ndb_mgm -e show
Connected to Management Server at: 192.168.20.2:1186
Cluster Configuration

[ndbd(NDB)] 4 node(s)
id=2 @192.168.20.3 (mysql-8.0.34 ndb-8.0.34, Nodegroup: 1, *)
id=3 @192.168.20.4 (mysql-8.0.34 ndb-8.0.34, Nodegroup: 1)
id=4 @192.168.20.5 (mysql-8.0.34 ndb-8.0.34, Nodegroup: 2)
id=5 @192.168.20.6 (mysql-8.0.34 ndb-8.0.34, Nodegroup: 2)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.20.2 (mysql-8.0.34 ndb-8.0.34)

[mysqld(API)] 2 node(s)
id=6 @192.168.20.9 (mysql-8.0.34 ndb-8.0.34)
id=7 @192.168.20.10 (mysql-8.0.34 ndb-8.0.34)

三，修改mysql API节点账号与密码

使用随机密码初始化服务器，该密码 需要改变。从日志中获取密码：

docker logs mysql1 2>&1 | grep PASSWORD
如果命令未返回密码，则服务器没有 尚未完成初始化。请稍等片刻，然后重试。一旦你 获取密码，通过使用客户端登录服务器来更改密码：mysql

docker exec -it mysql1 mysql -uroot -p
进入服务器后，使用 以下声明：

mysql> ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘password’;
开启 root 账号远程访问

flush privileges;

use mysql;

update user set host=’%’ where user=‘root’;