【摸鱼】Docker配置主从mysql数据库环境

docker pull mysql拉取docker镜像，国内现在访问不了docker hub，可以去阿里云上镜像加速器地址https://cr.console.aliyun.com/cn-hangzhou/instances/mirrors
启动主库docker run -p 3306:3306 --name master-mysql --privileged=true -v /app/docker/data/master-mysql/log:/var/log/mysql -v /app/docker/data/master-mysql/data/:/var/lib/mysql -v /app/docker/data/master-mysql/conf/:/etc/mysql -v /etc/localtime:/etc/localtime:ro -v /app/docker/data/master-mysql/mysql-files/:/var/lib/mysql-files -e MYSQL_ALLOW_EMPTY_PASSWORD=yes -d mysql
-v后面是卷映射，privileged是获取root权限，MYSQL_ALLOW_EMPTY_PASSWORD=yes是允许数据root无密码登录避免一些奇怪的错误
docker exec -it master-mysql bash进入主库容器内
mysql -uroot登录数据库
use mysql切换到mysql数据库
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456' PASSWORD EXPIRE NEVER;更改密码，123456可以替换为你自己要设定的密码
udpate user set Host='%' where User='root'打开访问地址限制
启动从库docker run -p 3308:3306 --name slave-mysql --privileged=true -v /app/docker/data/slave-mysql/log:/var/log/mysql -v /app/docker/data/slave-mysql/data/:/var/lib/mysql -v /app/docker/data/slave-mysql/conf/:/etc/mysql -v /etc/localtime:/etc/localtime:ro -v /app/docker/data/slave-mysql/mysql-files/:/var/lib/mysql-files -e MYSQL_ALLOW_EMPTY_PASSWORD=yes -d mysql
docker exec -it slave-mysql bash进入从库容器内
mysql -uroot登录数据库
use mysql切换到mysql数据库
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456' PASSWORD EXPIRE NEVER;更改密码，123456可以替换为你自己要设定的密码
udpate user set Host='%' where User='root'打开访问地址限制
在映射卷地址/app/docker/data/master-mysql/conf/中创建文件my.cnf，内容如下

[musqld]
server_id=1

重启主容器docker restart master-mysql
docker exec -it master-mysql bash进入主库容器
mysql -uroot -p
CREATE USER 'replication_user'@'%' IDENTIFIED WITH mysql_native_password BY 'root';配置主库账号
GRANT REPLICATION SLAVE ON *.* TO 'replication_user'@'%';
FLUSH PRIVILEGES;
SHOW MASTER STATUS;查看主服务器状态
退出容器，查看主服务器ip地址docker inspect master-mysql | grep IPAddress
在映射卷地址/app/docker/data/slave-mysql/conf/中创建文件my.cnf，内容如下

[musqld]
server_id=2

重启从库容器docker restart slave-mysql
docker exec -it slave-mysql bash
mysql -u root -p
CHANGE REPLICATION SOURCE TO SOURCE_HOST='172.17.0.2', SOURCE_USER='replication_user', SOURCE_PASSWORD='root', SOURCE_LOG_FILE='binlog.000005', SOURCE_LOG_POS=4566;配置从库服务器，SOURCE_HOST为主服务器Ip 地址，SOURCE_LOG_FILE为主服务器 binlog 文件，SOURCE_LOG_POS为 position,通过在主节点SHOW MASTER STATUS可以获取
启动从服务器复制进程START REPLICA;
查看从服务器状态SHOW REPLICA STATUS;
若要重新搭建STOP REPLICA;RESET REPLICA;