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 <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > 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 >
