Tuesday, January 28, 2014

Install MariaDB for Liferay @ Ubuntu


Follow https://downloads.mariadb.org/mariadb/repositories/

Problem:

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.

Solution:

sudo echo 'binlog_format=row' >> /etc/mysql/conf.d/mariadb.cnf && sudo /etc/init.d/mysql restart