mysql主从复制

mysql主从复制

1.主服务器配置一个用户名，并且分配权限（非必要）

create user `starsky`@`%` identified by "root";
grant all on *.* to `starsky`@`%` with grant option;

2.主服务器开启binlog

log-bin=mysql-bin
binlog_format=mixed
server-id = 1

2.配置主与从的my_docker.cnf，设置不同的server-id

3.查看主mysql的binlog节点

show master logs;

4.查看pos

show master status;

5.配置主从

stop slave;

CHANGE MASTER TO 
MASTER_HOST="192.168.238.111",
MASTER_PORT=3309,
MASTER_USER='root',
MASTER_PASSWORD='root',
MASTER_LOG_FILE="mysql-bin.000036",
MASTER_LOG_POS=0;

start slave;

show slave status\G

6.如果出现Slave_IO_Running: NO Slave_SQL_Running: NO

SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE;

7.清除主从复制关系

reset slave all;