> "JK" == Jan Kirchhoff <[EMAIL PROTECTED]> writes:
JK> If the Slave gets out of sync (loses the connection to the server), connects
JK> again and tries to catch up, it processes those two queries *within one
JK> second* which would result in an duplicate primary key on the slave. The
JK>
My Replication-Slave crashed a few days ago with an error in the error-log
saying something like "duplicate primary key processing query "INSERT INTO
testtable (time,name,number) VALUES (NOW(),'Hello',10)"
testtable's primary key was (time,name)
time: datetime
name: varchar
number: int
What I
