List:General Discussion« Previous MessageNext Message »
From:Manuel Arostegui Date:March 21 2013 8:17am
Subject:Re: Promoting MySQL 5.5 slave to master
View as plain text  
2013/3/21 Miguel Gonzalez <miguel_3_gonzalez@stripped>

>
>
>
> 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.

Thread
Promoting MySQL 5.5 slave to masterMiguel González Castaños20 Mar
  • Re: Promoting MySQL 5.5 slave to masterManuel Arostegui21 Mar
Re: Promoting MySQL 5.5 slave to masterManuel Arostegui21 Mar
  • Re: Promoting MySQL 5.5 slave to masterMiguel Gonzalez21 Mar
    • RE: Promoting MySQL 5.5 slave to masterAndrew Morgan21 Mar
      • Re: Promoting MySQL 5.5 slave to masterMiguel Gonzalez21 Mar