Article:		Advanced MySQL Replication Techniques
Subject:		Circle Replication Question (infinite loops?)
Date:		2006-12-05 21:29:21
From:		i_h_m
In circular replication A->B->C->D->A What keeps a bin log event from propogating indefinitely? E.g. If A was updated... that update gets repeated in B, then C, then D, --- When the same update event gets sent back to A, how does A know to not execute that update? Thanks!

Showing messages 1 through 1 of 1.

• Circle Replication Question (infinite loops?)
  2006-12-05 23:51:19  Giuseppe Maxia | [View]
  
  
  Read carefully. The article explains it.
  
  "The option replicate-same-server-id has the purpose of avoiding infinite replication loops, effectively telling each node to ignore from its master's binary log any statement that originated with its own server ID."
  
  Giuseppe