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
: [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
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
:[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
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
+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
-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 for testing it will
affect Master
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
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 is run on
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
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
11 matches
Mail list logo