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
>>> 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
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/
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc