Code: Select all
Error: GSQLBackend unable to store key: Failed to execute mysql_query, perhaps connection died?
Err=1: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging.
InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
The most likely reason you encounter this error is because you are using MySQL database replication together with STATEMENT based binary logging. This may cause some issues in some situation. To fix this you could use ROW based binary logging instead, which is more reliable but results in larger log files.
Another option is to use MIXED binary logging which basically allows MySQL to choose between binary and row based logging when whatever suits best for the entry logged.
How to setup:
Open the /etc/my.cnf configuration file on all MySQL servers in your replication cluster.
After:
Code: Select all
[mysqld]
Code: Select all
binlog_format = MIXED
Please note depending on your situation a ROW binlog format may be favourable over MIXED. When using this binlog format we do recommend setting the --binlog-row-event-max-size option as well.
Please also see: