docker部署mysql8之PXC8.0分布式集群
部署集群依赖一个overlay网络，实现PXC服务之间跨节点通过主机名通讯，这里直接部署docker swarm，使用docker swarm自带的overlay网络来完成部署。
三台主机都需要安装一下
yum <span class="token function">install</span> -y yum-utils device-mapper-persistent-data lvm2 yum-config-manager --add-repo http://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo yum makecache <span class="token function">rpm</span> --import https://mirrors.aliyun.com/docker-ce/linux/centos/gpg yum -y <span class="token function">install</span> docker-ce systemctl <span class="token builtin class-name">enable</span> <span class="token function">docker</span> <span class="token operator">&&</span> systemctl start <span class="token function">docker</span>yum <span class="token function">install</span> -y yum-utils device-mapper-persistent-data lvm2 yum-config-manager --add-repo http://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo yum makecache <span class="token function">rpm</span> --import https://mirrors.aliyun.com/docker-ce/linux/centos/gpg yum -y <span class="token function">install</span> docker-ce systemctl <span class="token builtin class-name">enable</span> <span class="token function">docker</span> <span class="token operator">&&</span> systemctl start <span class="token function">docker</span>yum install -y yum-utils device-mapper-persistent-data lvm2 yum-config-manager --add-repo http://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo yum makecache rpm --import https://mirrors.aliyun.com/docker-ce/linux/centos/gpg yum -y install docker-ce systemctl enable docker && systemctl start docker
1.swarm-master上执行如命令创建 swarm：docker swarm init –advertise-addr {master主机IP}
<span class="token punctuation">[</span>root@host1 ~<span class="token punctuation">]</span> Swarm initialized: current <span class="token function">node</span> <span class="token punctuation">(</span>l2wbku2vxecmbz8cz94ewjw6d<span class="token punctuation">)</span> is now a manager. To <span class="token function">add</span> a worker to this swarm, run the following command: <span class="token function">docker</span> swarm <span class="token function">join</span> --token SWMTKN-1-27aqwb4w55kfkcjhwwt1dv0tdf106twja2gu92g6rr9j22bz74-2ld61yjb69uokj3kiwvpfo2il <span class="token number">192.168</span>.1.1:2377 To <span class="token function">add</span> a manager to this swarm, run <span class="token string">'docker swarm join-token manager'</span> and follow the instructions. <span class="token punctuation">[</span>root@host1 ~<span class="token punctuation">]</span> ID <span class="token environment constant">HOSTNAME</span> STATUS AVAILABILITY MANAGER STATUS ENGINE VERSION l2wbku2vxecmbz8cz94ewjw6d * host1 Ready Active Leader <span class="token number">19.03</span>.3 注:如果当时没有记录下 <span class="token function">docker</span> swarm init 提示的添加 worker 的完整命令，可以通过 <span class="token function">docker</span> swarm join-token worker 查看。<span class="token punctuation">[</span>root@host1 ~<span class="token punctuation">]</span> Swarm initialized: current <span class="token function">node</span> <span class="token punctuation">(</span>l2wbku2vxecmbz8cz94ewjw6d<span class="token punctuation">)</span> is now a manager. To <span class="token function">add</span> a worker to this swarm, run the following command: <span class="token function">docker</span> swarm <span class="token function">join</span> --token SWMTKN-1-27aqwb4w55kfkcjhwwt1dv0tdf106twja2gu92g6rr9j22bz74-2ld61yjb69uokj3kiwvpfo2il <span class="token number">192.168</span>.1.1:2377 To <span class="token function">add</span> a manager to this swarm, run <span class="token string">'docker swarm join-token manager'</span> and follow the instructions. <span class="token punctuation">[</span>root@host1 ~<span class="token punctuation">]</span> ID <span class="token environment constant">HOSTNAME</span> STATUS AVAILABILITY MANAGER STATUS ENGINE VERSION l2wbku2vxecmbz8cz94ewjw6d * host1 Ready Active Leader <span class="token number">19.03</span>.3 注:如果当时没有记录下 <span class="token function">docker</span> swarm init 提示的添加 worker 的完整命令，可以通过 <span class="token function">docker</span> swarm join-token worker 查看。[root@host1 ~] Swarm initialized: current node (l2wbku2vxecmbz8cz94ewjw6d) is now a manager. To add a worker to this swarm, run the following command: docker swarm join --token SWMTKN-1-27aqwb4w55kfkcjhwwt1dv0tdf106twja2gu92g6rr9j22bz74-2ld61yjb69uokj3kiwvpfo2il 192.168.1.1:2377 To add a manager to this swarm, run 'docker swarm join-token manager' and follow the instructions. [root@host1 ~] ID HOSTNAME STATUS AVAILABILITY MANAGER STATUS ENGINE VERSION l2wbku2vxecmbz8cz94ewjw6d * host1 Ready Active Leader 19.03.3 注:如果当时没有记录下 docker swarm init 提示的添加 worker 的完整命令，可以通过 docker swarm join-token worker 查看。
2.复制前面的 docker swarm join 命令，在 swarm-worker1 和 swarm-worker2 上执行，将它们添加到 swarm 中。命令输出如下：
<span class="token punctuation">[</span>root@host2 ~<span class="token punctuation">]</span> This <span class="token function">node</span> joined a swarm as a worker. <span class="token punctuation">[</span>root@host3 ~<span class="token punctuation">]</span> This <span class="token function">node</span> joined a swarm as a worker.<span class="token punctuation">[</span>root@host2 ~<span class="token punctuation">]</span> This <span class="token function">node</span> joined a swarm as a worker. <span class="token punctuation">[</span>root@host3 ~<span class="token punctuation">]</span> This <span class="token function">node</span> joined a swarm as a worker.[root@host2 ~] This node joined a swarm as a worker. [root@host3 ~] This node joined a swarm as a worker.
3.swarm-master上docker node ls 可以看到两个 worker node 已经添加进来了。
<span class="token punctuation">[</span>root@host1 ~<span class="token punctuation">]</span> ID <span class="token environment constant">HOSTNAME</span> STATUS AVAILABILITY MANAGER STATUS ENGINE VERSION ju6g4tkd8vxgnrw5zvmwmlevw host2 Ready Active <span class="token number">19.03</span>.3 asrqc03tcl4bvxzdxgfs5h60q host3 Ready Active <span class="token number">19.03</span>.3 l2wbku2vxecmbz8cz94ewjw6d * host1 Ready Active Leader <span class="token number">19.03</span>.3<span class="token punctuation">[</span>root@host1 ~<span class="token punctuation">]</span> ID <span class="token environment constant">HOSTNAME</span> STATUS AVAILABILITY MANAGER STATUS ENGINE VERSION ju6g4tkd8vxgnrw5zvmwmlevw host2 Ready Active <span class="token number">19.03</span>.3 asrqc03tcl4bvxzdxgfs5h60q host3 Ready Active <span class="token number">19.03</span>.3 l2wbku2vxecmbz8cz94ewjw6d * host1 Ready Active Leader <span class="token number">19.03</span>.3[root@host1 ~] ID HOSTNAME STATUS AVAILABILITY MANAGER STATUS ENGINE VERSION ju6g4tkd8vxgnrw5zvmwmlevw host2 Ready Active 19.03.3 asrqc03tcl4bvxzdxgfs5h60q host3 Ready Active 19.03.3 l2wbku2vxecmbz8cz94ewjw6d * host1 Ready Active Leader 19.03.3
swarm-master上执行以下命令:
<span class="token number">1</span>. <span class="token function">mkdir</span> -p /data/ssl <span class="token operator">&&</span> <span class="token builtin class-name">cd</span> /data/ssl <span class="token operator">&&</span> openssl genrsa <span class="token number">2048</span> <span class="token operator">></span> ca-key.pem <span class="token number">2</span>. openssl req -new -x509 -nodes -days <span class="token number">3600</span> <span class="token punctuation">\</span> -key ca-key.pem -out ca.pem <span class="token number">3</span>. openssl req -newkey rsa:2048 -days <span class="token number">3600</span> <span class="token punctuation">\</span> -nodes -keyout server-key.pem -out server-req.pem <span class="token number">4</span>. openssl rsa -in server-key.pem -out server-key.pem <span class="token number">5</span>. openssl x509 -req -in server-req.pem -days <span class="token number">3600</span> <span class="token punctuation">\</span> -CA ca.pem -CAkey ca-key.pem -set_serial 01 <span class="token punctuation">\</span> -out server-cert.pem <span class="token number">6</span>. openssl req -newkey rsa:2048 -days <span class="token number">3600</span> <span class="token punctuation">\</span> -nodes -keyout client-key.pem -out client-req.pem <span class="token number">7</span>. openssl rsa -in client-key.pem -out client-key.pem <span class="token number">8</span>. openssl x509 -req -in client-req.pem -days <span class="token number">3600</span> <span class="token punctuation">\</span> -CA ca.pem -CAkey ca-key.pem -set_serial 01 <span class="token punctuation">\</span> -out client-cert.pem <span class="token number">9</span>. openssl verify -CAfile ca.pem server-cert.pem client-cert.pem <span class="token punctuation">(</span>出现两个OK即可<span class="token punctuation">)</span> server-cert.pem: OK client-cert.pem: OK<span class="token number">1</span>. <span class="token function">mkdir</span> -p /data/ssl <span class="token operator">&&</span> <span class="token builtin class-name">cd</span> /data/ssl <span class="token operator">&&</span> openssl genrsa <span class="token number">2048</span> <span class="token operator">></span> ca-key.pem <span class="token number">2</span>. openssl req -new -x509 -nodes -days <span class="token number">3600</span> <span class="token punctuation">\</span> -key ca-key.pem -out ca.pem <span class="token number">3</span>. openssl req -newkey rsa:2048 -days <span class="token number">3600</span> <span class="token punctuation">\</span> -nodes -keyout server-key.pem -out server-req.pem <span class="token number">4</span>. openssl rsa -in server-key.pem -out server-key.pem <span class="token number">5</span>. openssl x509 -req -in server-req.pem -days <span class="token number">3600</span> <span class="token punctuation">\</span> -CA ca.pem -CAkey ca-key.pem -set_serial 01 <span class="token punctuation">\</span> -out server-cert.pem <span class="token number">6</span>. openssl req -newkey rsa:2048 -days <span class="token number">3600</span> <span class="token punctuation">\</span> -nodes -keyout client-key.pem -out client-req.pem <span class="token number">7</span>. openssl rsa -in client-key.pem -out client-key.pem <span class="token number">8</span>. openssl x509 -req -in client-req.pem -days <span class="token number">3600</span> <span class="token punctuation">\</span> -CA ca.pem -CAkey ca-key.pem -set_serial 01 <span class="token punctuation">\</span> -out client-cert.pem <span class="token number">9</span>. openssl verify -CAfile ca.pem server-cert.pem client-cert.pem <span class="token punctuation">(</span>出现两个OK即可<span class="token punctuation">)</span> server-cert.pem: OK client-cert.pem: OK1. mkdir -p /data/ssl && cd /data/ssl && openssl genrsa 2048 > ca-key.pem 2. openssl req -new -x509 -nodes -days 3600 \ -key ca-key.pem -out ca.pem 3. openssl req -newkey rsa:2048 -days 3600 \ -nodes -keyout server-key.pem -out server-req.pem 4. openssl rsa -in server-key.pem -out server-key.pem 5. openssl x509 -req -in server-req.pem -days 3600 \ -CA ca.pem -CAkey ca-key.pem -set_serial 01 \ -out server-cert.pem 6. openssl req -newkey rsa:2048 -days 3600 \ -nodes -keyout client-key.pem -out client-req.pem 7. openssl rsa -in client-key.pem -out client-key.pem 8. openssl x509 -req -in client-req.pem -days 3600 \ -CA ca.pem -CAkey ca-key.pem -set_serial 01 \ -out client-cert.pem 9. openssl verify -CAfile ca.pem server-cert.pem client-cert.pem (出现两个OK即可) server-cert.pem: OK client-cert.pem: OK
问题：第9步报错为error 18 at 0 depth lookup:self signed certificate
解决方案：当你在创建ca.csr, server.csr, client.csr时 要求你填写的 Common Name。
ca.csr 的common name 不能和server.csr, client.csr填的相同
将目录/data/ssl下所有东西拷贝至 swarm-worker1 和 swarm-worker2的相同目录下
<span class="token function">scp</span> * <span class="token number">192.168</span>.1.2:<span class="token variable"><span class="token variable">`</span><span class="token builtin class-name">pwd</span><span class="token variable">`</span></span>/ <span class="token function">scp</span> * <span class="token number">192.168</span>.1.3:<span class="token variable"><span class="token variable">`</span><span class="token builtin class-name">pwd</span><span class="token variable">`</span></span>/<span class="token function">scp</span> * <span class="token number">192.168</span>.1.2:<span class="token variable"><span class="token variable">`</span><span class="token builtin class-name">pwd</span><span class="token variable">`</span></span>/ <span class="token function">scp</span> * <span class="token number">192.168</span>.1.3:<span class="token variable"><span class="token variable">`</span><span class="token builtin class-name">pwd</span><span class="token variable">`</span></span>/scp * 192.168.1.2:`pwd`/ scp * 192.168.1.3:`pwd`/
三台机器同时操作:
<span class="token function">mkdir</span> -p /data/ssl/cert <span class="token operator">&&</span> <span class="token function">vi</span> /data/ssl/cert/cert.cnf <span class="token punctuation">[</span>mysqld<span class="token punctuation">]</span> skip-name-resolve ssl-ca <span class="token operator">=</span> /cert/ca.pem ssl-cert <span class="token operator">=</span> /cert/server-cert.pem ssl-key <span class="token operator">=</span> /cert/server-key.pem <span class="token punctuation">[</span>client<span class="token punctuation">]</span> ssl-ca <span class="token operator">=</span> /cert/ca.pem ssl-cert <span class="token operator">=</span> /cert/client-cert.pem ssl-key <span class="token operator">=</span> /cert/client-key.pem <span class="token punctuation">[</span>sst<span class="token punctuation">]</span> encrypt <span class="token operator">=</span> <span class="token number">4</span> ssl-ca <span class="token operator">=</span> /cert/ca.pem ssl-cert <span class="token operator">=</span> /cert/server-cert.pem ssl-key <span class="token operator">=</span> /cert/server-key.pem<span class="token function">mkdir</span> -p /data/ssl/cert <span class="token operator">&&</span> <span class="token function">vi</span> /data/ssl/cert/cert.cnf <span class="token punctuation">[</span>mysqld<span class="token punctuation">]</span> skip-name-resolve ssl-ca <span class="token operator">=</span> /cert/ca.pem ssl-cert <span class="token operator">=</span> /cert/server-cert.pem ssl-key <span class="token operator">=</span> /cert/server-key.pem <span class="token punctuation">[</span>client<span class="token punctuation">]</span> ssl-ca <span class="token operator">=</span> /cert/ca.pem ssl-cert <span class="token operator">=</span> /cert/client-cert.pem ssl-key <span class="token operator">=</span> /cert/client-key.pem <span class="token punctuation">[</span>sst<span class="token punctuation">]</span> encrypt <span class="token operator">=</span> <span class="token number">4</span> ssl-ca <span class="token operator">=</span> /cert/ca.pem ssl-cert <span class="token operator">=</span> /cert/server-cert.pem ssl-key <span class="token operator">=</span> /cert/server-key.pemmkdir -p /data/ssl/cert && vi /data/ssl/cert/cert.cnf [mysqld] skip-name-resolve ssl-ca = /cert/ca.pem ssl-cert = /cert/server-cert.pem ssl-key = /cert/server-key.pem [client] ssl-ca = /cert/ca.pem ssl-cert = /cert/client-cert.pem ssl-key = /cert/client-key.pem [sst] encrypt = 4 ssl-ca = /cert/ca.pem ssl-cert = /cert/server-cert.pem ssl-key = /cert/server-key.pem
swarm-master上执行以下命令:
docker network create -d overlay --attachable swarm_mysqldocker network create -d overlay --attachable swarm_mysqldocker network create -d overlay --attachable swarm_mysql
swarm-master上执行以下命令:
<span class="token function">docker</span> network create -d overlay --attachable swarm_mysql <span class="token function">docker</span> run -d --name<span class="token operator">=</span>pn1 <span class="token punctuation">\</span> --net<span class="token operator">=</span>swarm_mysql <span class="token punctuation">\</span> --restart<span class="token operator">=</span>always <span class="token punctuation">\</span> -p <span class="token number">9001</span>:3306 <span class="token punctuation">\</span> --privileged <span class="token punctuation">\</span> -e <span class="token assign-left variable">TZ</span><span class="token operator">=</span>Asia/Shanghai <span class="token punctuation">\</span> -e <span class="token assign-left variable">MYSQL_ROOT_PASSWORD</span><span class="token operator">=</span>mT123456 <span class="token punctuation">\</span> -e <span class="token assign-left variable">CLUSTER_NAME</span><span class="token operator">=</span>PXC1 <span class="token punctuation">\</span> -v /data/ssl:/cert <span class="token punctuation">\</span> -v mysql:/var/lib/mysql/ <span class="token punctuation">\</span> -v /data/ssl/cert:/etc/percona-xtradb-cluster.conf.d <span class="token punctuation">\</span> percona/percona-xtradb-cluster:8.0<span class="token function">docker</span> network create -d overlay --attachable swarm_mysql <span class="token function">docker</span> run -d --name<span class="token operator">=</span>pn1 <span class="token punctuation">\</span> --net<span class="token operator">=</span>swarm_mysql <span class="token punctuation">\</span> --restart<span class="token operator">=</span>always <span class="token punctuation">\</span> -p <span class="token number">9001</span>:3306 <span class="token punctuation">\</span> --privileged <span class="token punctuation">\</span> -e <span class="token assign-left variable">TZ</span><span class="token operator">=</span>Asia/Shanghai <span class="token punctuation">\</span> -e <span class="token assign-left variable">MYSQL_ROOT_PASSWORD</span><span class="token operator">=</span>mT123456 <span class="token punctuation">\</span> -e <span class="token assign-left variable">CLUSTER_NAME</span><span class="token operator">=</span>PXC1 <span class="token punctuation">\</span> -v /data/ssl:/cert <span class="token punctuation">\</span> -v mysql:/var/lib/mysql/ <span class="token punctuation">\</span> -v /data/ssl/cert:/etc/percona-xtradb-cluster.conf.d <span class="token punctuation">\</span> percona/percona-xtradb-cluster:8.0docker network create -d overlay --attachable swarm_mysql docker run -d --name=pn1 \ --net=swarm_mysql \ --restart=always \ -p 9001:3306 \ --privileged \ -e TZ=Asia/Shanghai \ -e MYSQL_ROOT_PASSWORD=mT123456 \ -e CLUSTER_NAME=PXC1 \ -v /data/ssl:/cert \ -v mysql:/var/lib/mysql/ \ -v /data/ssl/cert:/etc/percona-xtradb-cluster.conf.d \ percona/percona-xtradb-cluster:8.0
swarm-worker1 执行一下命令：
<span class="token function">docker</span> run -d --name<span class="token operator">=</span>pn2 <span class="token punctuation">\</span> --net<span class="token operator">=</span>swarm_mysql <span class="token punctuation">\</span> --restart<span class="token operator">=</span>always <span class="token punctuation">\</span> -p <span class="token number">9001</span>:3306 <span class="token punctuation">\</span> --privileged <span class="token punctuation">\</span> -e <span class="token assign-left variable">TZ</span><span class="token operator">=</span>Asia/Shanghai <span class="token punctuation">\</span> -e <span class="token assign-left variable">MYSQL_ROOT_PASSWORD</span><span class="token operator">=</span>mT123456 <span class="token punctuation">\</span> -e <span class="token assign-left variable">CLUSTER_NAME</span><span class="token operator">=</span>PXC1 <span class="token punctuation">\</span> -e <span class="token assign-left variable">CLUSTER_JOIN</span><span class="token operator">=</span>pn1 <span class="token punctuation">\</span> -v /data/ssl:/cert <span class="token punctuation">\</span> -v mysql:/var/lib/mysql/ <span class="token punctuation">\</span> -v /data/ssl/cert:/etc/percona-xtradb-cluster.conf.d <span class="token punctuation">\</span> percona/percona-xtradb-cluster:8.0<span class="token function">docker</span> run -d --name<span class="token operator">=</span>pn2 <span class="token punctuation">\</span> --net<span class="token operator">=</span>swarm_mysql <span class="token punctuation">\</span> --restart<span class="token operator">=</span>always <span class="token punctuation">\</span> -p <span class="token number">9001</span>:3306 <span class="token punctuation">\</span> --privileged <span class="token punctuation">\</span> -e <span class="token assign-left variable">TZ</span><span class="token operator">=</span>Asia/Shanghai <span class="token punctuation">\</span> -e <span class="token assign-left variable">MYSQL_ROOT_PASSWORD</span><span class="token operator">=</span>mT123456 <span class="token punctuation">\</span> -e <span class="token assign-left variable">CLUSTER_NAME</span><span class="token operator">=</span>PXC1 <span class="token punctuation">\</span> -e <span class="token assign-left variable">CLUSTER_JOIN</span><span class="token operator">=</span>pn1 <span class="token punctuation">\</span> -v /data/ssl:/cert <span class="token punctuation">\</span> -v mysql:/var/lib/mysql/ <span class="token punctuation">\</span> -v /data/ssl/cert:/etc/percona-xtradb-cluster.conf.d <span class="token punctuation">\</span> percona/percona-xtradb-cluster:8.0docker run -d --name=pn2 \ --net=swarm_mysql \ --restart=always \ -p 9001:3306 \ --privileged \ -e TZ=Asia/Shanghai \ -e MYSQL_ROOT_PASSWORD=mT123456 \ -e CLUSTER_NAME=PXC1 \ -e CLUSTER_JOIN=pn1 \ -v /data/ssl:/cert \ -v mysql:/var/lib/mysql/ \ -v /data/ssl/cert:/etc/percona-xtradb-cluster.conf.d \ percona/percona-xtradb-cluster:8.0
swarm-worker2执行一下命令：
<span class="token function">docker</span> run -d --name<span class="token operator">=</span>pn3 <span class="token punctuation">\</span> --net<span class="token operator">=</span>swarm_mysql <span class="token punctuation">\</span> --restart<span class="token operator">=</span>always <span class="token punctuation">\</span> -p <span class="token number">9001</span>:3306 <span class="token punctuation">\</span> --privileged <span class="token punctuation">\</span> -e <span class="token assign-left variable">TZ</span><span class="token operator">=</span>Asia/Shanghai <span class="token punctuation">\</span> -e <span class="token assign-left variable">MYSQL_ROOT_PASSWORD</span><span class="token operator">=</span>mT123456 <span class="token punctuation">\</span> -e <span class="token assign-left variable">CLUSTER_NAME</span><span class="token operator">=</span>PXC1 <span class="token punctuation">\</span> -e <span class="token assign-left variable">CLUSTER_JOIN</span><span class="token operator">=</span>pn1 <span class="token punctuation">\</span> -v /data/ssl:/cert <span class="token punctuation">\</span> -v mysql:/var/lib/mysql/ <span class="token punctuation">\</span> -v /data/ssl/cert:/etc/percona-xtradb-cluster.conf.d <span class="token punctuation">\</span> percona/percona-xtradb-cluster:8.0<span class="token function">docker</span> run -d --name<span class="token operator">=</span>pn3 <span class="token punctuation">\</span> --net<span class="token operator">=</span>swarm_mysql <span class="token punctuation">\</span> --restart<span class="token operator">=</span>always <span class="token punctuation">\</span> -p <span class="token number">9001</span>:3306 <span class="token punctuation">\</span> --privileged <span class="token punctuation">\</span> -e <span class="token assign-left variable">TZ</span><span class="token operator">=</span>Asia/Shanghai <span class="token punctuation">\</span> -e <span class="token assign-left variable">MYSQL_ROOT_PASSWORD</span><span class="token operator">=</span>mT123456 <span class="token punctuation">\</span> -e <span class="token assign-left variable">CLUSTER_NAME</span><span class="token operator">=</span>PXC1 <span class="token punctuation">\</span> -e <span class="token assign-left variable">CLUSTER_JOIN</span><span class="token operator">=</span>pn1 <span class="token punctuation">\</span> -v /data/ssl:/cert <span class="token punctuation">\</span> -v mysql:/var/lib/mysql/ <span class="token punctuation">\</span> -v /data/ssl/cert:/etc/percona-xtradb-cluster.conf.d <span class="token punctuation">\</span> percona/percona-xtradb-cluster:8.0docker run -d --name=pn3 \ --net=swarm_mysql \ --restart=always \ -p 9001:3306 \ --privileged \ -e TZ=Asia/Shanghai \ -e MYSQL_ROOT_PASSWORD=mT123456 \ -e CLUSTER_NAME=PXC1 \ -e CLUSTER_JOIN=pn1 \ -v /data/ssl:/cert \ -v mysql:/var/lib/mysql/ \ -v /data/ssl/cert:/etc/percona-xtradb-cluster.conf.d \ percona/percona-xtradb-cluster:8.0
swarm-master上执行一下命令，检查集群的状态 <span class="token function">docker</span> <span class="token builtin class-name">exec</span> -it pn1 /usr/bin/mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with <span class="token punctuation">;</span> or <span class="token punctuation">\</span>g. Your MySQL connection <span class="token function">id</span> is <span class="token number">19</span> Server version: <span class="token number">8.0</span>.25-15.1 Percona XtraDB Cluster <span class="token punctuation">(</span>GPL<span class="token punctuation">)</span>, Release rel15, Revision 8638bb0, WSREP version <span class="token number">26.4</span>.3 Copyright <span class="token punctuation">(</span>c<span class="token punctuation">)</span> <span class="token number">2009</span>-2021 Percona LLC and/or its affiliates Copyright <span class="token punctuation">(</span>c<span class="token punctuation">)</span> <span class="token number">2000</span>, <span class="token number">2021</span>, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type <span class="token string">'help;'</span> or <span class="token string">'\h'</span> <span class="token keyword">for</span> help. Type <span class="token string">'\c'</span> to <span class="token function">clear</span> the current input statement. You are enforcing ssl connection via unix socket. Please consider switching ssl off as it does not <span class="token function">make</span> connection via unix socket any <span class="token function">more</span> secure. mysql<span class="token operator">></span> show status like <span class="token string">'wsrep%'</span><span class="token punctuation">;</span> +------------------------------+-------------------------------------------------+ <span class="token operator">|</span> Variable_name <span class="token operator">|</span> Value <span class="token operator">|</span> +------------------------------+-------------------------------------------------+ <span class="token operator">|</span> wsrep_local_state_uuid <span class="token operator">|</span> 625318e2-9e1c-11e7-9d07-aee70d98d8ac <span class="token operator">|</span> <span class="token punctuation">..</span>. <span class="token operator">|</span> wsrep_local_state_comment为Synced， <span class="token operator">|</span> <span class="token punctuation">..</span>. <span class="token operator">|</span> wsrep_incoming_addresses <span class="token operator">|</span> ce9ffe81e7cb:3306,89ba74cac488:3306,0e35f30ba764:3306 <span class="token operator">|</span> <span class="token punctuation">..</span>. <span class="token operator">|</span> wsrep_cluster_conf_id <span class="token operator">|</span> <span class="token number">3</span> <span class="token operator">|</span> <span class="token operator">|</span> wsrep_cluster_size <span class="token operator">|</span> <span class="token number">3</span> <span class="token operator">|</span> <span class="token operator">|</span> wsrep_cluster_state_uuid <span class="token operator">|</span> 625318e2-9e1c-11e7-9d07-aee70d98d8ac <span class="token operator">|</span> <span class="token operator">|</span> wsrep_cluster_status <span class="token operator">|</span> Primary <span class="token operator">|</span> <span class="token operator">|</span> wsrep_connected <span class="token operator">|</span> ON <span class="token operator">|</span> <span class="token punctuation">..</span>. <span class="token operator">|</span> wsrep_ready <span class="token operator">|</span> ON <span class="token operator">|</span> +------------------------------+-------------------------------------------------+ <span class="token number">59</span> rows <span class="token keyword">in</span> <span class="token builtin class-name">set</span> <span class="token punctuation">(</span><span class="token number">0.02</span> sec<span class="token punctuation">)</span>swarm-master上执行一下命令，检查集群的状态 <span class="token function">docker</span> <span class="token builtin class-name">exec</span> -it pn1 /usr/bin/mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with <span class="token punctuation">;</span> or <span class="token punctuation">\</span>g. Your MySQL connection <span class="token function">id</span> is <span class="token number">19</span> Server version: <span class="token number">8.0</span>.25-15.1 Percona XtraDB Cluster <span class="token punctuation">(</span>GPL<span class="token punctuation">)</span>, Release rel15, Revision 8638bb0, WSREP version <span class="token number">26.4</span>.3 Copyright <span class="token punctuation">(</span>c<span class="token punctuation">)</span> <span class="token number">2009</span>-2021 Percona LLC and/or its affiliates Copyright <span class="token punctuation">(</span>c<span class="token punctuation">)</span> <span class="token number">2000</span>, <span class="token number">2021</span>, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type <span class="token string">'help;'</span> or <span class="token string">'\h'</span> <span class="token keyword">for</span> help. Type <span class="token string">'\c'</span> to <span class="token function">clear</span> the current input statement. You are enforcing ssl connection via unix socket. Please consider switching ssl off as it does not <span class="token function">make</span> connection via unix socket any <span class="token function">more</span> secure. mysql<span class="token operator">></span> show status like <span class="token string">'wsrep%'</span><span class="token punctuation">;</span> +------------------------------+-------------------------------------------------+ <span class="token operator">|</span> Variable_name <span class="token operator">|</span> Value <span class="token operator">|</span> +------------------------------+-------------------------------------------------+ <span class="token operator">|</span> wsrep_local_state_uuid <span class="token operator">|</span> 625318e2-9e1c-11e7-9d07-aee70d98d8ac <span class="token operator">|</span> <span class="token punctuation">..</span>. <span class="token operator">|</span> wsrep_local_state_comment为Synced， <span class="token operator">|</span> <span class="token punctuation">..</span>. <span class="token operator">|</span> wsrep_incoming_addresses <span class="token operator">|</span> ce9ffe81e7cb:3306,89ba74cac488:3306,0e35f30ba764:3306 <span class="token operator">|</span> <span class="token punctuation">..</span>. <span class="token operator">|</span> wsrep_cluster_conf_id <span class="token operator">|</span> <span class="token number">3</span> <span class="token operator">|</span> <span class="token operator">|</span> wsrep_cluster_size <span class="token operator">|</span> <span class="token number">3</span> <span class="token operator">|</span> <span class="token operator">|</span> wsrep_cluster_state_uuid <span class="token operator">|</span> 625318e2-9e1c-11e7-9d07-aee70d98d8ac <span class="token operator">|</span> <span class="token operator">|</span> wsrep_cluster_status <span class="token operator">|</span> Primary <span class="token operator">|</span> <span class="token operator">|</span> wsrep_connected <span class="token operator">|</span> ON <span class="token operator">|</span> <span class="token punctuation">..</span>. <span class="token operator">|</span> wsrep_ready <span class="token operator">|</span> ON <span class="token operator">|</span> +------------------------------+-------------------------------------------------+ <span class="token number">59</span> rows <span class="token keyword">in</span> <span class="token builtin class-name">set</span> <span class="token punctuation">(</span><span class="token number">0.02</span> sec<span class="token punctuation">)</span>swarm-master上执行一下命令，检查集群的状态 docker exec -it pn1 /usr/bin/mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 19 Server version: 8.0.25-15.1 Percona XtraDB Cluster (GPL), Release rel15, Revision 8638bb0, WSREP version 26.4.3 Copyright (c) 2009-2021 Percona LLC and/or its affiliates Copyright (c) 2000, 2021, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. You are enforcing ssl connection via unix socket. Please consider switching ssl off as it does not make connection via unix socket any more secure. mysql> show status like 'wsrep%'; +------------------------------+-------------------------------------------------+ | Variable_name | Value | +------------------------------+-------------------------------------------------+ | wsrep_local_state_uuid | 625318e2-9e1c-11e7-9d07-aee70d98d8ac | ... | wsrep_local_state_comment为Synced， | ... | wsrep_incoming_addresses | ce9ffe81e7cb:3306,89ba74cac488:3306,0e35f30ba764:3306 | ... | wsrep_cluster_conf_id | 3 | | wsrep_cluster_size | 3 | | wsrep_cluster_state_uuid | 625318e2-9e1c-11e7-9d07-aee70d98d8ac | | wsrep_cluster_status | Primary | | wsrep_connected | ON | ... | wsrep_ready | ON | +------------------------------+-------------------------------------------------+ 59 rows in set (0.02 sec)
当pn1(master)正常运行的时候，pn2,pn3模拟重启没问题,测试步骤省略，主要测试重启后所有节点能否正常同步数据
<span class="token function">docker</span> restart pn2 或者 <span class="token function">docker</span> restart pn3<span class="token function">docker</span> restart pn2 或者 <span class="token function">docker</span> restart pn3docker restart pn2 或者 docker restart pn3
<span class="token function">docker</span> restart pn1<span class="token function">docker</span> restart pn1docker restart pn1
重启pn1(master)主节点模拟重启后,无法正常启动，需要以成员方式重加集群，重建命令如下:
<span class="token function">docker</span> run -d --name<span class="token operator">=</span>pn1 <span class="token punctuation">\</span> --net<span class="token operator">=</span>swarm_mysql <span class="token punctuation">\</span> --restart<span class="token operator">=</span>always <span class="token punctuation">\</span> -p <span class="token number">9001</span>:3306 <span class="token punctuation">\</span> --privileged <span class="token punctuation">\</span> -e <span class="token assign-left variable">TZ</span><span class="token operator">=</span>Asia/Shanghai <span class="token punctuation">\</span> -e <span class="token assign-left variable">MYSQL_ROOT_PASSWORD</span><span class="token operator">=</span>mT123456 <span class="token punctuation">\</span> -e <span class="token assign-left variable">CLUSTER_NAME</span><span class="token operator">=</span>PXC1 <span class="token punctuation">\</span> -e <span class="token assign-left variable">CLUSTER_JOIN</span><span class="token operator">=</span>pn2 <span class="token punctuation">\</span> -v /data/ssl:/cert <span class="token punctuation">\</span> -v mysql:/var/lib/mysql/ <span class="token punctuation">\</span> -v /data/ssl/cert:/etc/percona-xtradb-cluster.conf.d <span class="token punctuation">\</span> percona/percona-xtradb-cluster:8.0<span class="token function">docker</span> run -d --name<span class="token operator">=</span>pn1 <span class="token punctuation">\</span> --net<span class="token operator">=</span>swarm_mysql <span class="token punctuation">\</span> --restart<span class="token operator">=</span>always <span class="token punctuation">\</span> -p <span class="token number">9001</span>:3306 <span class="token punctuation">\</span> --privileged <span class="token punctuation">\</span> -e <span class="token assign-left variable">TZ</span><span class="token operator">=</span>Asia/Shanghai <span class="token punctuation">\</span> -e <span class="token assign-left variable">MYSQL_ROOT_PASSWORD</span><span class="token operator">=</span>mT123456 <span class="token punctuation">\</span> -e <span class="token assign-left variable">CLUSTER_NAME</span><span class="token operator">=</span>PXC1 <span class="token punctuation">\</span> -e <span class="token assign-left variable">CLUSTER_JOIN</span><span class="token operator">=</span>pn2 <span class="token punctuation">\</span> -v /data/ssl:/cert <span class="token punctuation">\</span> -v mysql:/var/lib/mysql/ <span class="token punctuation">\</span> -v /data/ssl/cert:/etc/percona-xtradb-cluster.conf.d <span class="token punctuation">\</span> percona/percona-xtradb-cluster:8.0docker run -d --name=pn1 \ --net=swarm_mysql \ --restart=always \ -p 9001:3306 \ --privileged \ -e TZ=Asia/Shanghai \ -e MYSQL_ROOT_PASSWORD=mT123456 \ -e CLUSTER_NAME=PXC1 \ -e CLUSTER_JOIN=pn2 \ -v /data/ssl:/cert \ -v mysql:/var/lib/mysql/ \ -v /data/ssl/cert:/etc/percona-xtradb-cluster.conf.d \ percona/percona-xtradb-cluster:8.0
原文链接：https://blog.csdn.net/weixin_43053507/article/details/126350596?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522171836884016800178552552%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fblog.%2522%257D&request_id=171836884016800178552552&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~blog~first_rank_ecpm_v1~times_rank-17-126350596-null-null.nonecase&utm_term=docker%E9%83%A8%E7%BD%B2
© 版权声明
声明📢本站内容均来自互联网，归原创作者所有，如有侵权必删除。
本站文章皆由CC-4.0协议发布，如无来源则为原创，转载请注明出处。
THE END
