Re: Replication for auto-increment tables

2008-04-20 Thread Chanchal James
Hi Brent, Thanks for your response. There was no other application that was writing to slave directly. I decided to sit down and track the IDs that were being reported as duplicates. It seems this happens with tables starting at auto_increment at 0. Slave doesnt get replicated with records corresp

Re: Replication for auto-increment tables

2008-04-20 Thread Brent Baisley
If you are getting duplicate id's on the slave, then something is not setup correctly. The save should have the same ids as the master. Just because a field is auto-increment, doesn't mean you can't enter you own value. Think of auto-increment as a default value setting. Just because a data