Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [Warning] /usr/sbin/mysqld: Forcing close of thread 24974085 user: 'XXXX'
- SHOW OPEN TABLES;
- [etc...]
- 114 rows in set (0.01 sec)
- Make a full slave backup
- Redirect FQDN for the master to a dead IP so all services are down and master receives no new queries
- When master is receiving no new queries, flush and close all tables individually
- Stop mysql on master
- Ensure OPTIMIZE TABLE does not cause problems for slave if it is replicated out
- Stop mysql on slave
- Copy all blog tables from slave to master
- Restart master
- Restart slave
- Check for any corrupt tables and allow them to be repaired
- Map FQDN back to the master internal IP
- Sanity check of posts on main blog
- Restart replication on slave and masters
- Make sure replication progresses correctly (multi-master)
- Make a full master backup
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement