It's the sequence that is tricky.
1. STOP SLAVE
2. CHANGE MASTER
3. START SLAVE
Do it wrong, and you miss or duplicate replication stuff that happens between #1 and #2.
Could you please lay out the precise steps, so that I can understand how un-tricky it can
> -----Original Message-----
> From: Reindl Harald [mailto:h.reindl@stripped]
> Sent: Friday, August 24, 2012 2:43 PM
> To: mysql@stripped
> Subject: Re: Replication question: How to make a slave a master?
> what would be tricky?
> remove all relay-logs, remove master.info adn that was it done this
> many times in the last years and it takes 30 seconds if you are fast
> enough to type the slave-commands
> Am 24.08.2012 23:35, schrieb Rick James:
> > Pointing the other slave to the new master is a bit tricky.
> >> -----Original Message-----
> >> From: Reindl Harald [mailto:h.reindl@stripped]
> >> Sent: Friday, August 24, 2012 8:29 AM
> >> To: mysql@stripped
> >> Subject: Re: Replication question: How to make a slave a master?
> >> Am 24.08.2012 17:25, schrieb Richard Reina:
> >>> I have a couple of mysql database slaves and would like to make one
> >> of
> >>> them be a master as well so that I can set another machine to
> >> replicate from it.
> >>> Can anyone tell me how I should go about it or know of any howtos
> >>> for this specific task?
> >> add the same master-conig lines as you did on the other master
> >> there is no magic, master-configurazion does not have any impact to
> >> slave-operation and vice versa
> Reindl Harald
> the lounge interactive design GmbH
> A-1060 Vienna, Hofmühlgasse 17
> CTO / CISO / Software-Development
> p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
> icq: 154546673, http://www.thelounge.net/