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 <phani.mullapudi@stripped> 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:dhandapani.shanmugam@stripped]
> Sent: Friday, May 16, 2008 1:07 PM
> To: Ananda Kumar
> Cc: replication@stripped; mysql@stripped
> 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:dhandapani.shanmugam@stripped
>
>
>
>
> ________________________________
>
> From: Ananda Kumar [mailto:anandkl@stripped]
> Sent: Friday, May 16, 2008 1:00 PM
> To: Shanmugam, Dhandapani
> Cc: replication@stripped; mysql@stripped
> 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 <dhandapani.shanmugam@stripped>
> 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/mysql?unsub=1
>
>
