InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.

grails 프로젝트를 올렸더니 아래와 같은 오류 메시지가 발생함

InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.

select @@binlog_format

MIXED

해결을 위해 /etc/my.cnf를 다음과 같이 수정함.

binlog_format=row

참고

https://confluence.atlassian.com/display/JIRAKB/MySQL+Binary+Logging+Problem+with+InnoDB+When+Creating+a+Workflow

http://dev.mysql.com/doc/refman/5.5/en/binary-log-setting.html