From: Marcus Bointon
Date: October 27 2011 10:31am
Subject: Re: Master-Master -> duplicate entry
List-Archive: http://lists.mysql.com/replication/2247
Message-Id: <29C3F428-5F85-4128-8FBD-F22905BBD7C9@synchromedia.co.uk>
MIME-Version: 1.0 (Apple Message framework v1251.1)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable

On 27 Oct 2011, at 12:07, Ricardo Freitas wrote:

> So having a Master-Master where you only write to one Master (lets say =
the
> main one), you still need the increment and offset changed?
>=20
> My guess is no, right?

No, you do need them set because if you switch back and forth between =
masters it ensures you won't ever get clashes.

It's common to use an increment of 10 and offsets within that, though be =
aware that if you're on a 32-bit system that means your autoincrement =
fields can run out of numbers after ~200million records and it will all =
go horribly wrong, especially in PHP which doesn't do unsigned ints. =
It's also very embarrassing. Run MySQL (and PHP) on a 64-bit OS!

Marcus
--=20
Marcus Bointon
Synchromedia Limited: Creators of http://www.smartmessages.net/
UK info@hand CRM solutions
marcus@stripped | http://www.synchromedia.co.uk/