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