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