> 部署 mysql 5.7 集群 master & slave （仅测试用）
镜像版本 5.7
1、创建 overlay 网络
docker network create --driver overlay mon-network --attachable
2、编辑两个配置文件 masterf 与 slavef
!includedir /etc/mysql/conf.d/ !includedir /etc/mysql/mysql.conf.d/ [mysqld] log-bin=mysql-bin server-id=1 gtid-mode=on enforce-gtid-consistency=on
!includedir /etc/mysql/conf.d/ !includedir /etc/mysql/mysql.conf.d/ [mysqld] server-id=2 gtid-mode=on enforce-gtid-consistency=on
3、启动 2 个 mysql：mysql-master 、mysql-slave
docker run -d \ --name mysql-master \ --network mon-network \ -e mysql_root_password=passw0rd \ -v `pwd`/masterf:/etc/mysql/myf \ -p 3306:3306 \ -d mysql:5.7
docker run -d \ --name mysql-slave \ --network mon-network \ -e mysql_root_password=passw0rd \ -v `pwd`/slavef:/etc/mysql/myf \ -p 3307:3306 \ -d mysql:5.7
4、添加从库用于复制的用户
docker run -it --rm --network mon-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
docker run -it --rm --network mon-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、验证 slave 状态
docker run -it --rm --network mon-network mysql mysql -hmysql-slave -uroot -ppassw0rd -e "show slave status\g"
如下状态为正常：
slave_io_running: yes
slave_sql_running: yes
> 部署 mysql 8.0 集群 master & slave（仅测试用）
镜像版本 mysql:8.0
1、创建 overlay 网络
docker network create --driver overlay mon-network --attachable
2、启动 2 个 mysql：mysql-master 、mysql-slave
docker run -d \ --name mysql-master \ --network mon-network \ -e mysql_root_password=passw0rd \ -p 3306:3306 \ -d mysql --default-authentication-plugin=mysql_native_password
docker run -d \ --name mysql-slave \ --network mon-network \ -e mysql_root_password=passw0rd \ -p 3307:3306 \ -d mysql --default-authentication-plugin=mysql_native_password
3、配置 master & slave
docker run -it --rm --network mon-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'@'%';"
docker run -it --rm --network mon-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
docker restart mysql-master mysql-slave
5、连接 master & slave
docker run -it --rm --network mon-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、验证 slave 状态
docker run -it --rm --network mon-network mysql mysql -hmysql-slave -uroot -ppassw0rd -e "show slave status\g"
如下状态为正常：
slave_io_running: yes
slave_sql_running: yes
> 验证数据同步
在 master 创建数据库 anoyi
docker run -it --rm --network mon-network mysql mysql -hmysql-master -uroot -ppassw0rd \ -e "create database anoyi default character set utf8mb4 collate utf8mb4_general_ci;"
在 slave 查看数据库列表
docker run -it --rm --network mon-network mysql mysql -hmysql-slave -uroot -ppassw0rd \ -e "show databases;" mysql: [warning] using a password on the mand line interface can be insecure. +--------------------+ | database | +--------------------+ | anoyi | | information_schema | | mysql | | performance_schema | | sys | +--------------------+
