> -----Original Message----- > From: Miguel Gonzalez [mailto:miguel_3_gonza...@yahoo.es] > Sent: 21 March 2013 08:29 > To: Manuel Arostegui > Cc: mysql@lists.mysql.com > Subject: Re: Promoting MySQL 5.5 slave to master > > > > > > ----- Mensaje original ----- > De: Manuel Arostegui <man...@tuenti.com> > Para: Miguel Gonzalez <miguel_3_gonza...@yahoo.es> > CC: mysql@lists.mysql.com > Enviado: Jueves 21 de marzo de 2013 9:17 > Asunto: Re: Promoting MySQL 5.5 slave to master > > 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. > > > > > > > By having both MySQL replicating from each other, you'd avoid this. > > I'm trying not to overcomplicate things. Also the server where the replica of > the production server is is not active at all. I thought master-master > configuration where more common when you were behind a web balancer. > > I thought also that replication had changed in MySQL 5.5. Is that difficult to > find a clear procedure for performing a mysql failover when a server > crashed?
[AM] If you've the option to use MySQL 5.6 then managing replication is a lot simpler and more reliable... http://www.clusterdb.com/mysql-replication/mysql-5-6-ga-replication-enhancements/ MySQL 5.6 Failing over is described in section 5 of http://www.mysql.com/why-mysql/white-papers/mysql-replication-tutorial/ - note that the paper deals with a more complex scenario where there are multiple slaves and so you could simplify. > > >Make sure you do "reply all" instead of replying only to me :-) > > Sorry about that, I thought the list was configured differently > > Miguel > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql