docker版mysql-5.7.35主备搭建记录

一、master配置：

1. 修改配置文件

vim /etc/my.cnf

添加两行

log_bin=mysql-bin

server_id=1

2. 登录添加账号并赋权限

mysql -uroot -p

CREATE USER 'repl'@'192.168.200.20' IDENTIFIED BY 'myRep8%Go';

GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'repl'@'192.168.200.20;

3. 查看master信息

SHOW MASTER STATUS;

将file和position配置给备mysql

二、slave配置：

1. 修改配置文件

vim /etc/my.cnf

添加以下5行

log_bin=mysql-bin

server_id=2

relay_log=/var/lib/mysql/mysql-relay-bin

log_slave_updates=1

read_only=1

2. 重启登录

service mysqld restart

mysql -uroot -p

3. 给slave配置master信息

stop slave;

CHANGE MASTER TO MASTER_HOST='192.168.200.202',
MASTER_USER='repli',MASTER_PORT=3306,MASTER_PASSWORD='myRep8%Go', MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=239100;

4. 启动slave

START SLAVE;

SHOW SLAVE STATUS\G

Slave_IO_Running和Slave_SQL_Running均为yes即可