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 helps.
>
> 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
>