11

Recover a crashed MySQL master server from the slave

view full story
linux-howto

http://serverfault.com – we are building a simple master/slave MySQL configuration using asynchronous replication, with MySQL enterprise 5.5.17 on both servers and innoDB based tables. In case of a crash of the master server we would like to offer to our users the possibility of recovering the master using the most-up-to date database contents of the slave. On the master server, the database and the binary logs are stored in different disk devices, for better reliability. What would be the best way to do this? I was trying to outline a procedure for this, but I'm not sure this is correct: Ensure that all the statem (HowTos)