[BNM] Upgrading Mysql Master.... Will it break replication?

[Alastair James]

Good plan.. cheers!

2009/6/1 David Pashley <david at davidpashley.com>:
> On Jun 01, 2009 at 15:30, Alastair James praised the llamas by saying:
>> Hi there...
>>
>> I want to update my replicated mysql cluster from 5.0.22 to
>> 5.0.44...... I upgraded the slaves first, however I was a bit upset to
>> discover that this broke replication as the local relay binary log was
>> not compatible (could not be opened according to the log). To fix I
>> simply deleted the relay logs as this causes the
>> slave to get the data again from the masters binary log.
>>
>> However, this begs the question, if I update mysql on the master
>> machine, will it screw up its binary logs causing replication to stop?
>> If there anyway to upgrade without needing to copy the database
>> across?
>>
> Probably the safest method would be to promote one of the existing
> slaves to being a master and then you're free to break the now-slave
> server at will.
>
> --
> David Pashley
> david at davidpashley.com
> Nihil curo de ista tua stulta superstitione.
> --
>
> BNM Subscribe/Unsubscribe:
> http://www.brightonnewmedia.org/options/bnmlist
>
> BNM powered by Wessex Networks:
> http://www.wessexnetworks.com
>



-- 
Dr Alastair James
CTO James Publishing Ltd.
http://www.linkedin.com/pub/3/914/163

www.worldreviewer.com
WINNER Yahoo! Finds of the Year 2007
WINNER Travolution Awards Best New Online Travel Company 2008
WINNER Travel Weekly Magellan Award 2008
WINNER IRHAS Awards, Los Angeles, Best Travel Website 2008
SPECIAL MENTION: AOP Awards 2008

"In a market increasingly crowded with new content and experience-led
sites, Worldreviewer stands out a mile. It has used exclusive
editorial and excellent tools to wonderful effect and ensured its
commercial partnerships are relevant to the target market."

Blog: onewheeledbicycle.com

"Noli nothis permittere te terere!"