>-----Original Message----- >From: Shanmugam, Dhandapani [mailto:[EMAIL PROTECTED] >Sent: Friday, May 16, 2008 4:01 AM >To: Phani; Ananda Kumar >Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com >Subject: RE: Slave Server > > >Ok..But if I do any changes on slave databases for testing it will >affect Master server also right...I don't want that to happen.. After my >testing on the slave database I need to revert back the databases as of >master > [JS] I understand what you are trying to do, but as someone who (in a prior life) taught disaster recovery techniques I advise you not to use a standby system for development. My suggestion would be to run two instances of MySQL on your backup server; keep one as a slave, and let the developers play with the second instance. > >Thanks and Regards, >DD > >-----Original Message----- >From: Phani [mailto:[EMAIL PROTECTED] >Sent: Friday, May 16, 2008 1:25 PM >To: Shanmugam, Dhandapani; 'Ananda Kumar' >Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com >Subject: RE: Slave Server > >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] >infoshop.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]