双主互备:
登录mysql:
1. m1给m2授权
grant replication slave on *.* to 'user'@'172.17.0.8' identified by '123456';
2. m2给m1授权
grant replication slave on *.* to 'user'@'172.17.0.5' identified by '123456';
3. 重启m1,m2
quit;
重启mysql
service mysqld restart
4. 登录m1, m2的mysql, 分别查看master状态
show master status;
5. 在m1, m2的配置文件中添加如下内容:
#将复制事件写入binlog,一台服务器既做主库又做从库此选项必须要开启
log-slave-updates=1
6. 在m1, m2中各自停止slave
stop slave;
7. 在m1, m2中各自修改master信息
m1连接m2:
change master to master_host='172.17.0.8',master_port=3306,master_user='user',master_password='123456',master_log_file='master-bin.000011',master_log_pos=120;
m2连接m1:
change master to master_host='172.17.0.5',master_port=3306,master_user='user',master_password='123456',master_log_file='master-bin.000013',master_log_pos=120;
8. 在m1, m2中各自启动Slave
start slave;
9. 在m1, m2中各自查询slave状态
show slave status\G;
双主数据库互备步骤
最新推荐文章于 2024-07-25 17:06:50 发布