From: Mihail Manolov
Date: August 24 2012 11:28pm
Subject: Re: Replication question: How to make a slave a master?
List-Archive: http://lists.mysql.com/mysql/228085
Message-Id: <5D968437-C214-48FD-A824-2024F3FB5654@liquidation.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Are you trying to promote a slave as a new master and replace current maste=
r or create intermediate slave? If it is the latter all you need to do is t=
o:

1. Stop the slave
2. Add "log_slave_updates =3D 1" in the slave's config file
3. Copy the slave files to the new slave(s)
4. Start your intermediate slave
5. Add replication user on your intermediate slave and allow new slaves to =
replicate
6. Start your slave(s) of intermediate slave
7. Issue following on your new slaves: CHANGE MASTER TO master_log_file =3D=
 'mysql-bin.000001', master_log_pos =3D 4;

On Aug 24, 2012, at 11:25 AM, Richard Reina wrote:

> I have a couple of mysql database slaves and would like to make one of th=
em
> be a master as well so that I can set another machine to replicate from i=
t.
> Can anyone tell me how I should go about it or know of any howtos for thi=
s
> specific task?
>=20
> Thanks,
>=20
> Richard