-----Original Message----- From: John Horne [mailto:john.horne@plymouth.ac.uk] Sent: Wednesday, August 13, 2014 7:53 AM To: CentOS list Subject: [CentOS] MySQL - replication - how to restore master?
Hello,
<SNIP>
However, I am having trouble finding out what to do should we lose the master server. Typically mysqldump backups of the master are done overnight, so a failure during the day would mean that the slave is ahead of the master backup. So this poses two questions:
<SNIP>
Note: I have not been running MySQL or HA systems for a very good while now. Salt appropriately.
Perhaps the following URL can help: http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-switch.html
I believe useful sets of key words for the searching the web would be: mysql master slave promotion and mysqldump slave
http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-backups-mysqldu...
Even when this disclaimer is not here: I am not a contracting officer. I do not have authority to make or modify the terms of any contract.