Guest User

Untitled

a guest
Jun 3rd, 2018
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. reset bad side of a mysql master-master
  2.  
  3. 1) On bad side:
  4. stop slave;
  5.  
  6.  
  7. On good side:
  8. stop slave;
  9. flush tables with read lock;
  10. reset master;
  11. show master status;
  12. *dump dbs
  13. unlock tables;
  14.  
  15. On bad side:
  16. *load db dump
  17. /* remove all logging from the loading of the data from the good side */
  18. reset master;
  19. /* forget old slave info and get ready to do change master */
  20. reset slave;
  21. change master to
  22. MASTER_HOST = 'goodside',
  23. MASTER_USER = 'user',
  24. MASTER_PASSWORD = 'pw',
  25. MASTER_LOG_FILE = 'goodmasterfile',
  26. MASTER_LOG_POS = goodmasterpos;
  27. start slave;
  28. /* so we can restart the slave on the good side */
  29. show master status;
  30.  
  31. On good side:
  32. reset slave;
  33. change master to
  34. MASTER_HOST = 'badside',
  35. MASTER_USER = 'user',
  36. MASTER_PASSWORD = 'pw',
  37. MASTER_LOG_FILE = 'badmasterfile',
  38. MASTER_LOG_POS = badmasterpos;
Add Comment
Please, Sign In to add comment