Guest User

Untitled

a guest
Jan 20th, 2019
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. Steps to restore master - master replication:
  2.  
  3. 1. Stop traffic to db2 on the load balancer
  4.  
  5. 2. (db1) stop slave;
  6.  
  7. 3. (db2) stop slave;
  8.  
  9. 4. (db1) show master status;
  10.  
  11. 5. (db2) CHANGE MASTER TO master_host='db1', master_user='*****', master_password='*****', master_log_file='mysql-bin.000001', master_log_pos=106;
  12.  
  13. 6. (db2) start slave;
  14.  
  15. 7. (db2) show slave status\G
  16.  
  17. 8. (db2) show master status;
  18.  
  19. 9. (db1) CHANGE MASTER TO master_host='db2', master_user='*****', master_password='*****', master_log_file='mysql-bin.xxxxxx', master_log_pos=xxxxxx;
  20.  
  21. 10. (db1) start slave;
  22.  
  23. 11. (db1) show slave status\G
  24.  
  25. 12. Start traffic to db2 on the load balancer
Add Comment
Please, Sign In to add comment