From: Reindl Harald
Date: August 24 2012 9:43pm
Subject: Re: Replication question: How to make a slave a master?
List-Archive: http://lists.mysql.com/mysql/228082
Message-Id: <5037F57E.2070408@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enigB21F77E6067C15BF224CA7C3"

--------------enigB21F77E6067C15BF224CA7C3
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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.
>=20
>> -----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
>>
>=20

--=20

Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofm=FChlgasse 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


--------------enigB21F77E6067C15BF224CA7C3
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAlA39X4ACgkQhmBjz394AnkusACeKhcWWOUUVhpiYLNpFDzvjcHC
qywAn0WD8d0StAfTMOH4Iiup942gRSNH
=S7gh
-----END PGP SIGNATURE-----

--------------enigB21F77E6067C15BF224CA7C3--