Re: Replication

Craig Ringer wrote:
> On Mon, 2009-06-22 at 22:20 -0400, Gerry Reno wrote:
>
>
>> Here is a link that describes the technique:
>> http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html?page=1
>>
>
> Ah. You were referring to multiple-master replication, and your
> reference to setting non-overlapping sequences referred to avoiding
> collisions caused by inserts on two different masters. Yes, using
> non-overlapping allocation ranges for sequences is indeed one way to
> handle that, but it's not actually related to what I was talking about
> anyway.
>
>
> What I was referring to in the parent post was an issue with
> statement-based replication of concurrent statements sharing a sequence.
> It's completely unrelated; both statements are running on the SAME
> server (master) and replicating to the slave.
I think mysql actually turns off autoincrement on the slave inserts and
just plugs them in. Since the masters have non-overlapping allocation
this assures that the slaves will have proper sequences as well.

Regards,
Gerry