[CentOS] MySQL - replication - how to restore master?

Wed Aug 13 14:12:55 UTC 2014
Denniston, Todd A CIV NAVSURFWARCENDIV Crane <todd.denniston at navy.mil>

> -----Original Message-----
> From: John Horne [mailto:john.horne at 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-mysqldump.html

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.