Re: binlog not containing all the queries.

[Sunil Divyeshvar]

Hello ,

Rick i alrdy checked following variables. i am having issue vth particular one table for which we are inserting through trigger.
Binlog does not contains all the insert queries for that table though data is there in table.

mysql> show variables like 'auto%';
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| autocommit | ON |
| automatic_sp_privileges | ON |
+--------------------------+-------+

Irfan -


" By default, MySQL replicates all db tables and objects (trigger) to slave and data inserts on master and slave with same auto increment ids if you didn't changed auto incrment offset variable value. But table on which trigger changes data won't replicate. which is true. "

** what do u means by this ?? "But table on which trigger changes data won't replicate. which is true."

**I am using Mysql5.5. Still its not supporting purely to trigger replication ?

** Can i enable ROW base binlog format for one table only ?

Thanks