or what u can do is create a new set of databases on slave and dump all the data from the master into it and ask your developers to test there, in this case, you can have both your master and slave in sync.
The new set of databases u create on slave will not be replicated to master. On 5/16/08, Ananda Kumar <[EMAIL PROTECTED]> wrote: > > Hi Shanmugam, > If its a simple master, slave replication, any changes on SLAVE will not be > replicated to master. If its a circular replication any change on master > will be done on slave and any changes on slave will be done on master. So > you need to pick what u want. > > regards > anandkl > > > On 5/16/08, Phani <[EMAIL PROTECTED]> wrote: >> >> You can try circular replication between server. So each server will act >> as >> both Master and Slave. >> >> Regards, >> >> Phani | Business Analyst >> >> zetainteractive >> Road No 12, Banjara Hills, Hyderabad, AP 500034 >> T +91 40 23390080 | Ext: 337 | F +91 40 23390934 | >> Vongage +1 714 209 7484 >> >> -----Original Message----- >> From: Shanmugam, Dhandapani [mailto:[EMAIL PROTECTED] >> Sent: Friday, May 16, 2008 1:07 PM >> To: Ananda Kumar >> Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com >> Subject: RE: Slave Server >> >> No Anand..My question is ..If the developer do any changes on the slave >> server, it will not get reflected to the Master server right? So there >> will be data inconsistency. My requirement is When the developer do any >> testing on slave databases. I need to revert back as of Master server >> data...In order to have consistence of data. How can i do with that >> >> >> >> Thanks and Regards, >> Dhandapani S >> + mailto:[EMAIL PROTECTED] >> >> >> >> >> ________________________________ >> >> From: Ananda Kumar [mailto:[EMAIL PROTECTED] >> Sent: Friday, May 16, 2008 1:00 PM >> To: Shanmugam, Dhandapani >> Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com >> Subject: Re: Slave Server >> >> >> Hi Shanmugam, >> Your question quite confusing. >> Do you mean to say, if any changes happen to slave it should get >> refeleted in the master, if yes, then u can setup two masters which are >> slave to each other. >> >> regards >> anandkl >> >> >> On 5/16/08, Shanmugam, Dhandapani <[EMAIL PROTECTED]> >> wrote: >> >> >> Hi There, >> >> I am setting up a replication with one master and one >> slave. >> I have created two databases in Master Server and it >> gets replicated to >> the slave. When developer do changes on the slave >> database, It will not >> be sync with the Master server. My requirement is when >> ever developer do >> changes in the slave database. I need to revert backup >> to the Master >> server. How this is possible. Thanks in Advance >> >> Thanks and Regards, >> DD >> >> >> >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >> >> >
