2013/3/21 Miguel Gonzalez <miguel_3_gonza...@yahoo.es> > > > > Can you elaborate about this? I thought that once you fixed the issues in > the master server you needed to set it as slave of the new promoted master > server, and do the other way round. > > That's why you might want to have master-master replication to avoid this manual process every time the active master dies.
Anyways, you're right - you'd need to configure the dead master to become a slave of the new master. In order to do so, you need to now the binlog file and position the new master had before getting the VIP. You'd need to check the binlogs. By having both MySQL replicating from each other, you'd avoid this. Make sure you do "reply all" instead of replying only to me :-) Manuel.
