Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Steps to restore master - master replication:
- 1. Stop traffic to db2 on the load balancer
- 2. (db1) stop slave;
- 3. (db2) stop slave;
- 4. (db1) show master status;
- 5. (db2) CHANGE MASTER TO master_host='db1', master_user='*****', master_password='*****', master_log_file='mysql-bin.000001', master_log_pos=106;
- 6. (db2) start slave;
- 7. (db2) show slave status\G
- 8. (db2) show master status;
- 9. (db1) CHANGE MASTER TO master_host='db2', master_user='*****', master_password='*****', master_log_file='mysql-bin.xxxxxx', master_log_pos=xxxxxx;
- 10. (db1) start slave;
- 11. (db1) show slave status\G
- 12. Start traffic to db2 on the load balancer
Add Comment
Please, Sign In to add comment