基于容器搭建percona-xtradb-cluster集群

    xiaoxiao2025-02-05  54

    作者:【吴业亮】

    博客: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)
    最新回复(0)