                        課程
                    
                        /數(shù)據(jù)庫
                        
                            /MySQL
                        
                        /MySQL集群（PXC）入門

怎樣創(chuàng)建這樣的數(shù)據(jù)庫

QINGCA

2018-07-26

源自：MySQL集群（PXC）入門 4-2

關注問題我要回答

1132

操作

收起

2 回答

神思者
2018-07-31

同學你好，可以收看這門實戰(zhàn)課。https://coding.imooc.com/class/219.html#Prchor

0 回復有任何疑惑可以回復我~

收起回答

?？?/span>
2019-08-15

用docker來搞

docker?pull?percona/percona-xtradb-cluster:5.7

docker?network?create?pxc-network

docker?volume?create?v1?
docker?volume?create?v2?
docker?volume?create?v3?
docker?volume?create?v4?
docker?volume?create?v5

docker?run?-d?-p?3306:3306??\
??-e?MYSQL_ROOT_PASSWORD=root?\
??-e?CLUSTER_NAME=cluster1?\
??-v?v1:/var/lib/mysql?\
??--name=node1?\
??--net=pxc-network?\
??percona/percona-xtradb-cluster:5.7
??
docker?run?-d?-p?3307:3306???\
??-e?MYSQL_ROOT_PASSWORD=root?\
??-e?CLUSTER_NAME=cluster1?\
??-e?CLUSTER_JOIN=node1?\
??-v?v2:/var/lib/mysql??\
??--name=node2?\
??--net=pxc-network?\
??percona/percona-xtradb-cluster:5.7
??
docker?run?-d??-p?3308:3306??\
??-e?MYSQL_ROOT_PASSWORD=root?\
??-e?CLUSTER_NAME=cluster1?\
??-e?CLUSTER_JOIN=node1?\
??-v?v3:/var/lib/mysql??\
??--name=node3?\
??--net=pxc-network?\
??percona/percona-xtradb-cluster:5.7
??
docker?run?-d??-p?3309:3306??\
??-e?MYSQL_ROOT_PASSWORD=root?\
??-e?CLUSTER_NAME=cluster1?\
??-e?CLUSTER_JOIN=node1?\
??-v?v4:/var/lib/mysql??\
??--name=node4?\
??--net=pxc-network?\
??percona/percona-xtradb-cluster:5.7
??
docker?run?-d??-p?3310:3306?\
??-e?MYSQL_ROOT_PASSWORD=root?\
??-e?CLUSTER_NAME=cluster1?\
??-e?CLUSTER_JOIN=node1?\
??-v?v5:/var/lib/mysql??\
??--name=node5?\
??--net=pxc-network?\
??percona/percona-xtradb-cluster:5.7