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

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

* stop mysqld
* rm -f mysql-relay-bin*
* rm -f master.info
* rm -f relay-log.info
* start mysqld

so, and now your slave is no longer any slave

to make sure you are binary-identical with the new master
stop the new master, remove all it's BINLOGS, not its
relay-logs, stop the new salve, rsync the data,
start both mywqld and start replication from slave

this is really easy after you understand what
each file in the datadir is supposded to do

Am 24.08.2012 23:53, schrieb Rick James:
> 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 b=
etween #1 and #2.
> Could you please lay out the precise steps, so that I can understand ho=
w un-tricky it can be.
>=20
>> -----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=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
>=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


--------------enig94A373907A29D8F5DC219EAE
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/

iEYEARECAAYFAlA3+hoACgkQhmBjz394AnksDwCgh5TCB1JJz9uKKrG1QpTzCgUf
6q4An3qFL7Jd6JcfF+3zMCe4coVbHx8q
=3SN2
-----END PGP SIGNATURE-----

--------------enig94A373907A29D8F5DC219EAE--