Re: make a slave db a master db

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.

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

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