> 部署 MySQL 5.7 集群 master & slave （僅測(cè)試用）
鏡像版本 5.7
1、創(chuàng)建 overlay 網(wǎng)絡(luò)
|
1
|
docker network create --driver overlay common-network --attachable |
2、編輯兩個(gè)配置文件 master.cnf 與 slave.cnf
|
1
2
3
4
5
6
7
8
|
!includedir /etc/mysql/conf.d/!includedir /etc/mysql/mysql.conf.d/[mysqld]log-bin=mysql-binserver-id=1gtid-mode=ONenforce-gtid-consistency=ON |
|
1
2
3
4
5
6
7
|
!includedir /etc/mysql/conf.d/!includedir /etc/mysql/mysql.conf.d/[mysqld]server-id=2gtid-mode=ONenforce-gtid-consistency=ON |
3、啟動(dòng) 2 個(gè) MYSQL：mysql-master 、mysql-slave
|
1
2
3
4
5
6
7
|
docker run -d \--name mysql-master \--network common-network \-e MYSQL_ROOT_PASSWORD=Passw0rd \-v `pwd`/master.cnf:/etc/mysql/my.cnf \-p 3306:3306 \-d mysql:5.7 |
|
1
2
3
4
5
6
7
|
docker run -d \--name mysql-slave \--network common-network \-e MYSQL_ROOT_PASSWORD=Passw0rd \-v `pwd`/slave.cnf:/etc/mysql/my.cnf \-p 3307:3306 \-d mysql:5.7 |
4、添加從庫用于復(fù)制的用戶
|
1
2
3
|
docker run -it --rm --network common-network mysql mysql -hmysql-master -uroot -pPassw0rd \-e "CREATE USER 'repl'@'%' IDENTIFIED BY 'password' REQUIRE SSL; " \-e "GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%';" |
5、連接 master & slave
|
1
2
3
|
docker run -it --rm --network common-network mysql mysql -hmysql-slave -uroot -pPassw0rd \-e "CHANGE MASTER TO MASTER_HOST='mysql-master', MASTER_PORT=3306, MASTER_USER='repl', MASTER_PASSWORD='password', MASTER_AUTO_POSITION=1, MASTER_SSL=1;" \-e "START SLAVE;" |
6、驗(yàn)證 slave 狀態(tài)
|
1
|
docker run -it --rm --network common-network mysql mysql -hmysql-slave -uroot -pPassw0rd -e "show slave status\G" |
如下狀態(tài)為正常：
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
> 部署 MySQL 8.0 集群 master & slave（僅測(cè)試用）
鏡像版本 mysql:8.0
1、創(chuàng)建 overlay 網(wǎng)絡(luò)
|
1
|
docker network create --driver overlay common-network --attachable |
2、啟動(dòng) 2 個(gè) MYSQL：mysql-master 、mysql-slave
|
1
2
3
4
5
6
|
docker run -d \--name mysql-master \--network common-network \-e MYSQL_ROOT_PASSWORD=Passw0rd \-p 3306:3306 \-d mysql --default-authentication-plugin=mysql_native_password |
|
1
2
3
4
5
6
|
docker run -d \--name mysql-slave \--network common-network \-e MYSQL_ROOT_PASSWORD=Passw0rd \-p 3307:3306 \-d mysql --default-authentication-plugin=mysql_native_password |
3、配置 master & slave
|
1
2
3
4
5
6
|
docker run -it --rm --network common-network mysql mysql -hmysql-master -uroot -pPassw0rd \-e "SET PERSIST server_id=1;" \-e "SET PERSIST_ONLY gtid_mode=ON;" \-e "SET PERSIST_ONLY enforce_gtid_consistency=true; " \-e "CREATE USER 'repl'@'%' IDENTIFIED BY 'password' REQUIRE SSL; " \-e "GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%';" |
|
1
2
3
4
|
docker run -it --rm --network common-network mysql mysql -hmysql-slave -uroot -pPassw0rd \-e "SET PERSIST server_id=2;" \-e "SET PERSIST_ONLY gtid_mode=ON;" \-e "SET PERSIST_ONLY enforce_gtid_consistency=true; " |
4、重啟 master & slave
|
1
|
docker restart mysql-master mysql-slave |
5、連接 master & slave
|
1
2
3
|
docker run -it --rm --network common-network mysql mysql -hmysql-slave -uroot -pPassw0rd \-e "CHANGE MASTER TO MASTER_HOST='mysql-master', MASTER_PORT=3306, MASTER_USER='repl', MASTER_PASSWORD='password', MASTER_AUTO_POSITION=1, MASTER_SSL=1;" \-e "START SLAVE;" |
6、驗(yàn)證 slave 狀態(tài)
|
1
|
docker run -it --rm --network common-network mysql mysql -hmysql-slave -uroot -pPassw0rd -e "show slave status\G" |
如下狀態(tài)為正常：
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
> 驗(yàn)證數(shù)據(jù)同步
在 master 創(chuàng)建數(shù)據(jù)庫 anoyi
|
1
2
|
docker run -it --rm --network common-network mysql mysql -hmysql-master -uroot -pPassw0rd \ -e "create database anoyi default character set utf8mb4 collate utf8mb4_general_ci;" |
在 slave 查看數(shù)據(jù)庫列表
|
1
2
3
4
5
6
7
8
9
10
11
12
|
docker run -it --rm --network common-network mysql mysql -hmysql-slave -uroot -pPassw0rd \ -e "show databases;"mysql: [Warning] Using a password on the command line interface can be insecure.+--------------------+| Database |+--------------------+| anoyi || information_schema || mysql || performance_schema || sys |+--------------------+ |
相關(guān)資料：
mysql 5.7： https://dev.mysql.com/doc/refman/5.7/en/replication.html
mysql 8.0： https://dev.mysql.com/doc/refman/8.0/en/replication.html
以上就是本文的全部?jī)?nèi)容，希望對(duì)大家的學(xué)習(xí)有所幫助，也希望大家多多支持服務(wù)器之家。
原文鏈接：https://www.jianshu.com/p/6194106cdd05
