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

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@eds.com> 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
>

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@eds.com




________________________________

From: Ananda Kumar [mailto:anandkl@gmail.com]
Sent: Friday, May 16, 2008 1:00 PM
To: Shanmugam, Dhandapani
Cc: replication@lists.mysql.com; 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 <dhandapani.shanmugam@eds.com>
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

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 [mailtohani.mullapudi@zustek.com]
Sent: Friday, May 16, 2008 1:25 PM
To: Shanmugam, Dhandapani; 'Ananda Kumar'
Cc: replication@lists.mysql.com; 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:dhandapani.shanmugam@eds.com]
Sent: Friday, May 16, 2008 1:07 PM
To: Ananda Kumar
Cc: replication@lists.mysql.com; 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:dhandapani.shanmugam@eds.com




________________________________

From: Ananda Kumar [mailto:anandkl@gmail.com]
Sent: Friday, May 16, 2008 1:00 PM
To: Shanmugam, Dhandapani
Cc: replication@lists.mysql.com; 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 <dhandapani.shanmugam@eds.com>
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

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@zustek.com> 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@eds.com]
> Sent: Friday, May 16, 2008 1:07 PM
> To: Ananda Kumar
> Cc: replication@lists.mysql.com; 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:dhandapani.shanmugam@eds.com
>
>
>
>
> ________________________________
>
> From: Ananda Kumar [mailto:anandkl@gmail.com]
> Sent: Friday, May 16, 2008 1:00 PM
> To: Shanmugam, Dhandapani
> Cc: replication@lists.mysql.com; 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 <dhandapani.shanmugam@eds.com>
> 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=anandkl@gmail.com
>
>

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

>-----Original Message-----
>From: Shanmugam, Dhandapani [mailto:dhandapani.shanmugam@eds.com]
>Sent: Friday, May 16, 2008 4:01 AM
>To: Phani; Ananda Kumar
>Cc: replication@lists.mysql.com; 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 [mailtohani.mullapudi@zustek.com]
>Sent: Friday, May 16, 2008 1:25 PM
>To: Shanmugam, Dhandapani; 'Ananda Kumar'
>Cc: replication@lists.mysql.com; 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:dhandapani.shanmugam@eds.com]
>Sent: Friday, May 16, 2008 1:07 PM
>To: Ananda Kumar
>Cc: replication@lists.mysql.com; 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:dhandapani.shanmugam@eds.com
>
>
>
>
>________________________________
>
> From: Ananda Kumar [mailto:anandkl@gmail.com]
> Sent: Friday, May 16, 2008 1:00 PM
> To: Shanmugam, Dhandapani
> Cc: replication@lists.mysql.com; 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 <dhandapani.shanmugam@eds.com>
>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=jschwartz@the-
>infoshop.com

1. have one (or more) slave readonly and don't give the developer the
root pwd.
2. have another slave for him to play with.
3. when you need to clean up his mess, stop the readonly slave, take a
dump, copy to playpen, start up both.


Rick James
MySQL Geeks - Consulting & Review



> -----Original Message-----
> From: Shanmugam, Dhandapani [mailto:dhandapani.shanmugam@eds.com]
> Sent: Friday, May 16, 2008 12:14 AM
> To: replication@lists.mysql.com
> Cc: mysql@lists.mysql.com
> Subject: Slave Server
>
>
> 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
>