Don't use circular replication with more than 2 servers. If one of your 3 crashes and
cannot be recovered, you will have a nightmare on your hands to fix the broken
replication.
> -----Original Message-----
> From: Stillman, Benjamin [mailto:BStillman@stripped]
> Sent: Monday, September 24, 2012 11:56 AM
> To: Shawn Green
> Cc: mysql@stripped
> Subject: Re: Doubt Regd. Circular Replication In Mysql
>
> I stand corrected and apologize. Numerous multi-master setup
> descriptions I've read have said to set this (including the one linked
> in the original question). However, as you said, the entry in the
> manual clearly says it defaults to 0. Learn something new every day.
> Thanks Shawn.
>
>
>
> On Sep 24, 2012, at 2:05 PM, "Shawn Green" <shawn.l.green@stripped>
> wrote:
>
> > replicate-same-server-id = 0
>
> ________________________________
>
> Notice: This communication may contain privileged and/or confidential
> information. If you are not the intended recipient, please notify the
> sender by email, and immediately delete the message and any attachments
> without copying or disclosing them. LBI may, for any reason, intercept,
> access, use, and disclose any information that is communicated by or
> through, or which is stored on, its networks, applications, services,
> and devices.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql
