Re: make a slave db a master db

2007-08-30 Thread Ananda Kumar
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. rega

Re: make a slave db a master db

2007-08-30 Thread B. Keith Murphy
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. Th