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.rei...@thelounge.net] >> Sent: Friday, August 24, 2012 8:29 AM >> To: mysql@lists.mysql.com >> 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/ http://www.thelounge.net/signature.asc.what.htm
signature.asc
Description: OpenPGP digital signature