Weird issue in mysql db server
Hi,
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): Server 1: --------- Code:
server-id=1 ---------- Code:
server-id=2 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. Record 1: ID: 10011 Time: 2009-10-13 02:00:25 Record 2: 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. |
Per MySQL Reference Manual
I am not a MySql guru by any means . . .
You don't say what type of table you are using but it looks like you may have been premature in your settings, since there were problems with them until 5.0.46, at least with NDB tables. Quote:
http://dev.mysql.com/doc/refman/5.0/...crement_offset Hope this is useful |
Hi, thanks for info but all tables in our databases are in MyISAM. I'm still clueless.
|
...
|
Hello Smartpatrol, thanks for info. Just checked the time on both servers and found exactly same.
Any other thoughts? Thanks, |
All times are GMT -5. The time now is 06:42 AM. |