作者:【吴业亮】
博客:https://wuyeliang.blog.csdn.net/
相关代码:
https://hub.docker.com/r/percona/percona-xtradb-cluster/
创建网络
创建容器网络
docker network create pxc-network
Bootstrap集群,创建第一个节点
docker run -d \
-e MYSQL_ROOT_PASSWORD=root \
-e CLUSTER_NAME=cluster1 \
--name=node1 \
--net=pxc-network \
percona/percona-xtradb-cluster:5.7
加入第二个节点
docker run -d \
-e MYSQL_ROOT_PASSWORD=root \
-e CLUSTER_NAME=cluster1 \
-e CLUSTER_JOIN=node1 \
--name=node2 \
--net=pxc-network \
percona/percona-xtradb-cluster:5.7
加入第三个节点
docker run -d \
-e MYSQL_ROOT_PASSWORD=root \
-e CLUSTER_NAME=cluster1 \
-e CLUSTER_JOIN=node1 \
--name=node3 \
--net=pxc-network \
percona/percona-xtradb-cluster:5.7
验证
docker exec -it node1 /usr/bin/mysql -uroot -proot
mysql@node1>
View the wsrep status variables:
mysql@node1> show status like 'wsrep%';
+------------------------------+-------------------------------------------------+
| Variable_name | Value |
+------------------------------+-------------------------------------------------+
| wsrep_local_state_uuid | 625318e2-9e1c-11e7-9d07-aee70d98d8ac |
...
| wsrep_local_state_comment | Synced |
...
| wsrep_incoming_addresses | 172.18.0.2:3306,172.18.0.3:3306,172.18.0.4: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)