Advertisement
Guest User

Untitled

a guest
Apr 18th, 2014
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. [Warning] /usr/sbin/mysqld: Forcing close of thread 24974085 user: 'XXXX'
  2.  
  3. SHOW OPEN TABLES;
  4. [etc...]
  5. 114 rows in set (0.01 sec)
  6.  
  7. Make a full slave backup
  8. Redirect FQDN for the master to a dead IP so all services are down and master receives no new queries
  9. When master is receiving no new queries, flush and close all tables individually
  10. Stop mysql on master
  11. Ensure OPTIMIZE TABLE does not cause problems for slave if it is replicated out
  12. Stop mysql on slave
  13. Copy all blog tables from slave to master
  14. Restart master
  15. Restart slave
  16. Check for any corrupt tables and allow them to be repaired
  17. Map FQDN back to the master internal IP
  18. Sanity check of posts on main blog
  19. Restart replication on slave and masters
  20. Make sure replication progresses correctly (multi-master)
  21. Make a full master backup
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement