Enhancing the binlog with row event annotations

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.

Getting ready

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.

How to do it...

1. On db01, edit the system my.cnf or my.ini file and add the following to the [mysqld] section:

   binlog_format = row
   binlog_annotate_row_events
   

2. On db03, edit the system my.cnf or my.ini file and add the following to the [mysqld] section:

   binlog_format = row
   replicate_annotate_row_events
   

3. Restart MariaDB on both servers.

4. On db01, launch the mysql command-line client and...