The binary logs used for replication set the value used for
autoincrementing before each insert query. The number on the master
will always be replicated properly. If a row already exists with the
autoincrement value, my guess is that replication will die with an
error.
I'm not too sure which
When you set a field to auto-increment, can you tell it where to start?
I'm trying to set up multimaster replication, but I'm worried about
auto-increment collisions.
Q: If server A starts auto-incrementing at 0, and server B starts
auto-incrementing at some point higher than the maximum
5001
Peter
-Original Message-
From: Robinson, Eric [mailto:[EMAIL PROTECTED]
Sent: 18 November 2004 21:35
To: [EMAIL PROTECTED]
Subject: Auto-Increment Starting Point? (Multimaster Replication
Question)
When you set a field to auto-increment, can you tell it where to start