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:bstill...@limitedbrands.com] > Sent: Monday, September 24, 2012 11:56 AM > To: Shawn Green > Cc: mysql@lists.mysql.com > 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.gr...@oracle.com> > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
