From: Rick James
Date: September 24 2012 7:11pm
Subject: RE: Doubt Regd. Circular Replication In Mysql
List-Archive: http://lists.mysql.com/mysql/228257
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB148CF91A2E@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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
>=20
> 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.
>=20
>=20
>=20
> On Sep 24, 2012, at 2:05 PM, "Shawn Green" <shawn.l.green@stripped>
> wrote:
>=20
> > replicate-same-server-id =3D 0
>=20
> ________________________________
>=20
> 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.
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql