New answers tagged


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. ...

Top 50 recent answers are included