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] > >
