MySQL Forums
Forum List  »  Replication

Re: binlog not containing all the queries.
Posted by: Irfan Ali
Date: October 21, 2011 06:36AM

Yes, you are right.
Trigger not working for auto-incrments.

Replication Format you are using ?
Statement or Row ?

i foresee row based replication will not create any issues.

Trigger code also replicated to slave ?

I think you destination table also contains auto-increment column and you also inserting auto-increment column from source to destination through trigger.

Please provide show create table to trace the exact problem.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: binlog not containing all the queries.
880
October 21, 2011 06:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.