I've two Mysql servers (both 5.0.45) on RHEL 5 boxes. I've setup Master to Master Replication and its running perfectly since few weeks. Both servers are accepting read/write with heavy usage.
few related settings (my.cnf):
So, both servers will insert records without conflicting on auto increment fields, one will generate even numbers and other will odds.
This is what I understood and happening but I just checked an incident where a table has weird values in autoincrement field. A script insert records in this table connecting Server 2 only. No other program/script accessing this table.
ID: 10011 Time: 2009-10-13 02:00:25
ID: 10014 Time: 2009-10-13 02:00:23
Hows this possible? record 1 has higher timestamp but smaller id value then record 2 and moreover isn't record 2 should have odd id value (ie 10013)
Any pointer will be helpful.