List:General Discussion« Previous MessageNext Message »
From:Manuel Arostegui Date:March 21 2013 7:27am
Subject:Re: Promoting MySQL 5.5 slave to master
View as plain text  
2013/3/21 Miguel González Castaños <miguel_3_gonzalez@stripped>

> Dear all,
>
>    I have a pretty simple setup. A LAMP server in production and a
> failover LAMP server in case the main server is down.
>
>    I have been searching around to find out a clear answer of how to
> proceed when you need to promote a MySQL 5.5 slave server when the master
> (also 5.5) has crashed.
>
>    So far I have read that if the master crashes I should issue an stop
> slave in the slave server and restart the mysql service (otherwise the
> master info is still kept in memory) with a skip-start-slave setting. Is
> that right? Is that all?
>
>


Hi Miguel,

Do you have a master-master replication between them? How is the failover
over done? Do you just move a VIP between them?
Anyways, there's no need to do stop slave or restar MySQL service in the
new master...you just need to set it active (move the VIP, pointing your
Apache manually to write to it, however you do it).

What you have to make sure though is about the read_only parameter. Make
sure the new master comes back to life with read_only = ON just to avoid
any problems. The standby master should always have read_only = ON until it
becomes active.

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