List:General Discussion« Previous MessageNext Message »
From:Jeff Date:September 20 2005 8:52pm
Subject:RE: Circular Replication
View as plain text  
> -----Original Message-----
> From: Alec.Cawley@stripped [mailto:Alec.Cawley@stripped] 
> Sent: Monday, September 19, 2005 10:10
> To: jakes.dad@stripped
> Cc: mysql@stripped
> Subject: Re: Circular Replication
> 
> 
> Sid Lane <jakes.dad@stripped> 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 which 
> originated it. When the update returns to its originating 
> server, it is 
> dropped instead of being executed. That is why every server 
> must have a 
> unique id.
> 
>         Alec
> 

Actually, isn't it required that you start each server with
--log_slave_updates?

Or is that only necessary in a replication situation like this with more
than 2 servers?

A -> B -> C -> A

If it's just:

A -> B -> A 

Is it necessary to start the servers with --log_slave_updates?

Thanks,

Jeff


Thread
Circular ReplicationJeff16 Sep
  • Re: Circular ReplicationDan Nelson16 Sep
    • RE: Circular ReplicationJeff16 Sep
      • Re: Circular ReplicationDevananda16 Sep
  • Re: Circular ReplicationStefan Kuhn16 Sep
    • Re: Circular ReplicationRaphaĆ«l 'SurcouF' Bordet27 Oct
      • Re: Circular ReplicationStefan Kuhn27 Oct
        • Re: Circular ReplicationJigal van Hemert27 Oct
          • Re: Circular ReplicationDevananda28 Oct
RE: Circular ReplicationJeff McKeon16 Sep
  • RE: Circular ReplicationJeff16 Sep
    • Re: Circular ReplicationDevananda16 Sep
      • Re: Circular ReplicationSid Lane19 Sep
        • Re: Circular ReplicationAlec.Cawley19 Sep
          • Re: Circular ReplicationSid Lane19 Sep
          • RE: Circular ReplicationJeff20 Sep
            • Re: Circular ReplicationDevananda20 Sep
    • Re: Circular ReplicationBruce Dembecki21 Sep
RE: Circular ReplicationJeff20 Sep
RE: Circular ReplicationJeff21 Sep
  • Re: Circular ReplicationBruce Dembecki22 Sep
    • Re: Circular ReplicationHank26 Sep
      • Re: Circular ReplicationHank26 Sep