- Original Message -
> From: "Jason J. W. Williams"
>
> I've got an issue where two MySQL servers are in circular/multimaster
> replication. One is server_id 6871 and the other 206871. The issue is
> that GRANT statements issued on 6871 are replicated to 206871 and
> then
> back to 6871 w
Hello,
EDS and MySQL are having a webinar on the subject of circular replication
today. Check out:
http://www.mysql.com/news-and-events/web-seminars/index.html
If you can't make it today, it will be archived in the "On-Demand" section.
-- Jimmy
Alex Arul Lurthu wrote:
Chain replication is f
Chain replication is fine as long as reading stale data from the last slave
in your chain is ok. the staleness depends on the write throughput and
capacity of the intermediate slaves. But Chain replication with circular
replication is a definite no no in prod since if any intermediate fails, you
wi
Jigal van Hemert wrote:
Stefan Kuhn wrote:
Am Thursday 27 October 2005 12:56 schrieb Raphaël 'SurcouF' Bordet:
Le vendredi 16 septembre 2005 à 18:14 +0200, Stefan Kuhn a écrit :
I'm using it with four machines (geographically separate) and it works
fine. Stefan
And can writes on each ser
Stefan Kuhn wrote:
Am Thursday 27 October 2005 12:56 schrieb Raphaël 'SurcouF' Bordet:
Le vendredi 16 septembre 2005 à 18:14 +0200, Stefan Kuhn a écrit :
I'm using it with four machines (geographically separate) and it works
fine. Stefan
And can writes on each server in simultaneous time ?
Am Thursday 27 October 2005 12:56 schrieb Raphaël 'SurcouF' Bordet:
> Le vendredi 16 septembre 2005 à 18:14 +0200, Stefan Kuhn a écrit :
> > I'm using it with four machines (geographically separate) and it works
> > fine. Stefan
>
> And can writes on each server in simultaneous time ?
I don't under
Le vendredi 16 septembre 2005 à 18:14 +0200, Stefan Kuhn a écrit :
> I'm using it with four machines (geographically separate) and it works fine.
> Stefan
And can writes on each server in simultaneous time ?
--
Raphaël 'SurcouF' Bordet
http://debianfr.net/ | surcouf at debianfr dot net
--
My
> I'll be setting up a second master to do this same
> thing once per day to act as my daily backup.
Oops...I meant to say "second slave".
-Hank
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> The long story short is we use the fact that MySQL has the ability to
> run the SQL thread and the IO thread of replication separately, and
> control them individually.
I'm fairly green with replication, but I have a simple cron job that
starts a PHP program that issues a "slave start", watches
On Sep 21, 2005, at 5:23 AM, Jeff wrote:
I am interested in how you go about doing a "delayed replication" to
protect against operator error. We've already fallen victim to that
situation here.
The long story short is we use the fact that MySQL has the ability to
run the SQL thread and the
> -Original Message-
> From: Bruce Dembecki [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 20, 2005 23:05
> To: Jeff
> Cc: mysql@lists.mysql.com
> Subject: Re: Circular Replication
>
>
> On Sep 16, 2005, at 11:07 AM, Jeff wrote:
>
>
On Sep 16, 2005, at 11:07 AM, Jeff wrote:
There shouldn't be a problem if:
server A is ver 4.0.x
server B is ver 4.1.x
should there?
There will totally by a problem here... The 4.1 server will take the
4.0 feed without issue. The 4.1 server however puts all sorts of
information into the
> -Original Message-
> From: Devananda [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 20, 2005 17:13
> To: Jeff
> Cc: mysql@lists.mysql.com
> Subject: Re: Circular Replication
>
>
> Jeff wrote:
> >>-Original Message-
> >>Fro
Jeff wrote:
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, September 19, 2005 10:10
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: Circular Replication
Sid Lane <[EMAIL PROTECTED]> wrote on 19/09/2005 15:02:58:
stupid ?:
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 19, 2005 10:10
> To: [EMAIL PROTECTED]
> Cc: mysql@lists.mysql.com
> Subject: Re: Circular Replication
>
>
> Sid Lane <[EMAIL PROTECTED]> wrote on 1
NOW I see the violence inhierent in the system...
this has some profoundly cool possibilities...
BWAH-HA-HA-HA!!!
muchos!
Sid Lane <[EMAIL PROTECTED]> wrote on 19/09/2005 15:02:58:
> stupid ?:
>
> what keeps them from getting caught in a write loop? turning off
> log_slave_updates?
>
> I had never thought of this but is has intriging possibilities...
Each update is marked with the unique server id of the server w
stupid ?:
what keeps them from getting caught in a write loop? turning off
log_slave_updates?
I had never thought of this but is has intriging possibilities...
Jeff wrote:
-Original Message-
From: Jeff McKeon
Sent: Friday, September 16, 2005 13:19
To: Devananda
Cc: mysql@lists.mysql.com
Subject: RE: Circular Replication
-Original Message-
From: Devananda [mailto:[EMAIL PROTECTED]
Sent: Friday, September 16, 2005 11:55
To: Jeff
Cc
> -Original Message-
> From: Jeff McKeon
> Sent: Friday, September 16, 2005 13:19
> To: Devananda
> Cc: mysql@lists.mysql.com
> Subject: RE: Circular Replication
>
>
> > -Original Message-
> > From: Devananda [mailto:[EMAIL PROTECTED]
> &
> -Original Message-
> From: Devananda [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 16, 2005 11:55
> To: Jeff
> Cc: mysql@lists.mysql.com
> Subject: Re: Circular Replication
>
>
> Jeff wrote:
> >
> > Am I correct in this setup process:
>
Jeff wrote:
Am I correct in this setup process:
Server A exists
Server B to be built
Stop Server A, take snapshot, record Master info.
Start Server A
Setup server B, Install snapshot from A
Set B up as a master
Set B up as a slave to A
Set A up as a slave to B, no need for binlog file or pos
I'm using it with four machines (geographically separate) and it works fine.
Stefan
Am Friday 16 September 2005 17:31 schrieb Jeff:
> Does anyone use circular replication with MySQL 4.x? For instance:
>
> A to B
> B to A
>
> I know it's possible as long as you're carefull with your client
> ap
> -Original Message-
> From: Dan Nelson [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 16, 2005 11:34
> To: Jeff
> Cc: mysql@lists.mysql.com
> Subject: Re: Circular Replication
>
>
> In the last episode (Sep 16), Jeff said:
> > Does anyone use ci
In the last episode (Sep 16), Jeff said:
> Does anyone use circular replication with MySQL 4.x? For instance:
>
> A to B
> B to A
>
> I know it's possible as long as you're carefull with your client
> applications and the way they write/update the db. Just wondering if
> anyone has had succes
Hi!
- Original Message -
From: ""Madscientist"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, April 23, 2002 10:44 PM
Subject: Circular replication
> Hi,
>
> We're doing something weird (what else is new). We're hoping to use
> MySQL as the base of a distributed
Just tell your boss that if you ever have turnover the former employee
will be able to log into all the customers' accounts and do whatever he
wants.
Dave
On Thu, Dec 13, 2001 at 03:29:41AM +1100, Duncan Maitland wrote:
> My questions concern a setup where a public server is running at our
> host
even/odd is a little limiting, what happens down the road when another
site needs to be added.
A better method might be to use a unique session ID for each client site
in combination with a
generated sequence ID see the white paper
at:http://www.ambysoft.com/persistenceLayer.html
in particular
28 matches
Mail list logo
