I'm new to this, hope what i'm saying makes sense.

I have a mysql database in a cluster.

Every once in a while, the database switches all by itself to binlog_format STATEMENT.

I can't seem to find what is the trigger for this. but in the DB the binlog is ROW and I noticed that in my.cnf binlog is MIXED.

Can this be the issue. And is there a way to understand what is happening exaclty ?


  • What statement did it execute after switching? DDL statements can only be done via STATEMENT. – Rick James Apr 22 at 1:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.