How to transition from a statement based log to row based log for Galera replication? I'm new to clustering and I'm trying to implement a Galera cluster. I'm transitioning from a standalone MySQL instance to a MariaDB Galera Cluster consisting of (at the moment) 2 nodes.

I have installed MariaDB-Galera-server.x86_64 10.0.13-1.el6 &amp; MariaDB-client.x86_64 10.0.14-1.el6 on a CentOS 6 server.

I have also converted all the MyISAM tables to InnoDB.

My question is how do I make the switch? I was reading the (old?) codership notes on how to set up the my.cnf (https://web.archive.org/web/20131021065420/http://www.codership.com/wiki/doku.php?id=mysql_galera_configuration) and they say that these parameters are Required:

binlog_format=ROW
innodb_autoinc_lock_mode=2


My current log file (even though it's a standalone instance and not a cluster) is statement based and my database has a lot of data. How does making this change affect my current logs and current data?

Should I just make changes as per the my.cnf listed in the codership example file and play around until I get it right? Any other advice before I get started?
If you have a one-node cluster, add those settings to my.cnf

[mysqld]
binlog_format=ROW
innodb_autoinc_lock_mode=2


Login in a run 

mysql&gt; reset master;
mysql&gt; set global innodb_fast_shutdown = 0;


Shutdown mysql

service mysql stop


Go to the folder where the binary logs are located and manually delete the binary logs (should only be one at this point) and also the binary log index file.

Start up MySQL

service mysql start


That's all you need to do.