18 February, 2017
Plastic server in our company is backed up in several ways. One of them is MySQL replication, simple master -> slave setup. One day the error above (logging format issues) popped up. Thankfully, the fix was pretty simple, but it took some time to find it.
Firstly, you need to stop the MySQL slave. Execute “STOP SLAVE;” command in MySQL console to do it.
Secondly, run the commands below on the master’s MySQL console:
FLUSH TABLES WITH READ LOCK; FLUSH LOGS; SET GLOBAL binlog_format = 'MIXED'; FLUSH LOGS; UNLOCK TABLES;
Remember to set the binlog format in the master’s config file!
The last step is to start the slave replication. That’s it!