When using replication, it's popular to set binlog_format to row. The only issue with this is that when we look at the binlog, it is harder to read because the statements aren't included. We can see the changes but not the SQL statement that made the changes.
For this recipe, we'll assume that we've set up replication as described in either the Setting up replication or Using multisource replication recipes earlier in this chapter. Pick a master server and a slave server to use. In this recipe, we'll call the master server db01 and the slave server db03.
On
db01, edit the systemmy.cnformy.inifile and add the following to the[mysqld]section:binlog_format = row binlog_annotate_row_events
On
db03, edit the systemmy.cnformy.inifile and add the following to the[mysqld]section:binlog_format = row replicate_annotate_row_events
Restart MariaDB on both servers.
On
db01, launch themysqlcommand-line client and...