List:General Discussion« Previous MessageNext Message »
From:Jeff Date:September 20 2005 9:22pm
Subject:RE: Circular Replication
View as plain text  
> -----Original Message-----
> From: Devananda [mailto:karnah805@stripped] 
> Sent: Tuesday, September 20, 2005 17:13
> To: Jeff
> Cc: mysql@stripped
> Subject: Re: Circular Replication
> 
> 
> Jeff wrote:
> >>-----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
> > 
> > 
> > 
> 
> log-slave-updates causes the server to write to it's own binlog any 
> statements it read from it's master's binlog. This is necessary in 
> chains of servers (ie, A->B->C->A); in such chains, it is 
> necessary that 
> all servers have BOTH log-bin and log-slave-updates.
> 
> With just 2 servers (A->B->A), you need log-bin, but do not need 
> log-slave-updates.
> 
> Regards,
> Devananda vdv
> 

Muchos Gracias!


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