I have MariaDB running on my dev server (no replication or anything else) running version 5.3.5. It's an Ubuntu 10.04 server running all the latest patches and updates. I am having issued getting errors regarding the the binlog_format, so I went to change it from STATEMENT to MIXED or ROW, but when I run
SET GLOBAL binlog_format = 'MIXED', nothing gets updated. I have tried everything from this post: http://dba.stackexchange.com/questions/6150/what-is-the-safest-way-to-switch-the-binlog-format-at-runtime, but nothing changes. The only way I have gotten it to change is with the following:
sudo service stop mysql sudo mysqld --binlog_format=MIXED
The only problem is that when I restart the format goes back to statement based. Is there anything else I am supposed to do to change it as a global variable?