RE: Slave Server

2008-05-16 Thread Rick James
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 > -Origina

RE: Slave Server

2008-05-16 Thread Jerry Schwartz
>-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

Re: Slave Server

2008-05-16 Thread Ananda Kumar
, 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 >>

Re: Slave Server

2008-05-16 Thread Ananda Kumar
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:

RE: Slave Server

2008-05-16 Thread Shanmugam, Dhandapani
ailto:[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 | B

RE: Slave Server

2008-05-16 Thread Phani
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

RE: Slave Server

2008-05-16 Thread Shanmugam, Dhandapani
: [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

Re: Slave Server

2008-05-16 Thread Ananda Kumar
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,

Re: Slave server and InnoDB

2002-10-03 Thread Jeremy Zawodny
On Fri, Oct 04, 2002 at 12:51:16AM +0300, Heikki Tuuri wrote: > > only successful queries are written to the binlog and replicated. It is a > bug in MySQL replication if a duplicate key error in the master is > propagated to the slave. Or someone accidentallly muged data on the slave. We've had

Re: Slave server and InnoDB

2002-10-03 Thread Heikki Tuuri
James, - Original Message - From: "James Kelty" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, October 04, 2002 12:13 AM Subject: Slave server and InnoDB > sql,query > > Hello. > > Is there an option for the slave server to NOT stop when an error > inducing query i

Re: slave server in readonly

2002-07-10 Thread Gerald Clark
Well, if it is read only, it won't be able to update from the master. GRANT your users no write permission. Pierre Baridon wrote: > > is it possible to start a server in 'read only' mode ? > so that users cannot write in my slave server ? > > thanks, > > Pierre > > > > > > > --sql,query > > >