MariaDB binlog format issues for services like Confluence and ownCloud

In an replication environment you will most likely run into this issue when installing Confluence, ownCloud or any similar service upon database creation:

“impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging”

This issue is due to the standard format of binlog which is STATEMENT and is not suited for functions like NOW() , RAND() and similar functions.

http://dba.stackexchange.com/questions/58459/mysql-error-impossible-to-write-to-binary-log

The fix is to use either ROW or MIXED as binlog format in my.cnf:

binlog-format=<TYPE>

Restart mariadb and verify variables:

SHOW VARIABLES LIKE ‘%binlog%’;

Leave a Reply

Your email address will not be published. Required fields are marked *