Mysql Replication trigger not executing on slave

Posted on

Question :

Mixed replication is enabled.

MySQL master has a table Products that has triggers on update and delete. On slave database we have different trigger on same table on update and delete.

Master database trigger executing properly but slave db trigger not executing. Is there any way we can achieve this. Slave db trigger we dont want on master db.

Answer :

There are many reason when mixed binary log format the statement-based replication is converted to row-based replication.

Here, I think it matches to your case :

When one or more tables with AUTO_INCREMENT columns are updated and a
trigger or stored function is invoked. Like all other unsafe
statements, this generates a warning if binlog_format = STATEMENT.

Hope this resolves your query.

Leave a Reply

Your email address will not be published.