I have an one-way replication, and it was working fine until adding a table with auto-increment column.
Before the slave starts, the "Auto_increment" column shows the same number as the master when I execute [show table status like "mytable"]. But when the slave starts inserting data into the table, it skips some numbers, and the master and slave become different. The master log and relay log look fine.
I did many researchs but couldn't find anything to help.
Could anybody please give me suggestions, hints?
Stop using auto-increment would solve my problem but I cannot do it. ;-)
The table type is Innodb and the Mysql Version is: 12.20 Distrib 4.0.13 (for Linux i686), in both master and slave.
Thanks in advance!