Hi All,
We have one master and two slave dbs.
Now we want one of the slaves to work as a stand alone master db, so what
are the steps that i need to take to make one of the slaves as a stand alone
master db.

regards
anandkl

Ananda,

The answer to your question is very simple actually, but there is some subtleties that you need to think of.

To stop the slave from getting replication data from the master just issue a "stop slave" command. I would also recommend that you run a "reset master" command in addition. This will reset the master server information to empty (not pointing anywhere).

The reason why it is subtle is that you need to know what state you want your data in. When you issue the stop slave command it breaks the replication with the master with your data on the old slave basically the same as the master. Is that what you really want? If not, you need to take other measures to get your data in the state you want before bringing it online as a standalone server.

Hope that s.

Keith

What data do you want on the new master?
----- Original Message -----
From: "Ananda Kumar" <anandkl@gmail.com>
To: "MySql" <mysql@lists.mysql.com>
Sent: Thursday, August 30, 2007 3:37:48 AM (GMT-0500) America/New_York
Subject: make a slave db a master db

Hi All,
We have one master and two slave dbs.
Now we want one of the slaves to work as a stand alone master db, so what
are the steps that i need to take to make one of the slaves as a stand alone
master db.

regards
anandkl


--
B. Keith Murphy
Database Administrator
iContact
2635 Meridian Parkway, 2nd Floor
Durham, North Carolina 27713
blog: http://www.paragon-cs.com/wordpress
(o) 919-433-0786
(c) 850-637-3877

Hi Keith,
Thanks for the info,
Actually, we are moving our db to a new database center, so during one point
of time, we will not have access to the old data center (master db), so i
want to set up a second slave, and at a specific point in time, make the
second slave, a stand alone master db.

regards
anandkl


On 8/30/07, B. Keith Murphy <kmurphy@icontact.com> wrote:
>
> Ananda,
>
> The answer to your question is very simple actually, but there is some
> subtleties that you need to think of.
>
> To stop the slave from getting replication data from the master just issue
> a "stop slave" command. I would also recommend that you run a "reset
> master" command in addition. This will reset the master server information
> to empty (not pointing anywhere).
>
> The reason why it is subtle is that you need to know what state you want
> your data in. When you issue the stop slave command it breaks the
> replication with the master with your data on the old slave basically the
> same as the master. Is that what you really want? If not, you need to take
> other measures to get your data in the state you want before bringing it
> online as a standalone server.
>
> Hope that s.
>
> Keith
>
> What data do you want on the new master?
> ----- Original Message -----
> From: "Ananda Kumar" <anandkl@gmail.com>
> To: "MySql" <mysql@lists.mysql.com>
> Sent: Thursday, August 30, 2007 3:37:48 AM (GMT-0500) America/New_York
> Subject: make a slave db a master db
>
> Hi All,
> We have one master and two slave dbs.
> Now we want one of the slaves to work as a stand alone master db, so what
> are the steps that i need to take to make one of the slaves as a stand
> alone
> master db.
>
> regards
> anandkl
>
>
> --
> B. Keith Murphy
> Database Administrator
> iContact
> 2635 Meridian Parkway, 2nd Floor
> Durham, North Carolina 27713
> blog: http://www.paragon-cs.com/wordpress
> (o) 919-433-0786
> (c) 850-637-3877
>