Configuring binlog event checksums

A rare, but still possible, problem can occur if the filesystem where we store our binary and relay logs gets corrupted. It can be especially damaging if we don't detect it early on. Event checksums are a way to detect this quickly.

Getting ready

For this recipe, we'll assume that we've set up replication as described in either the Setting up replication or the Using multisource replication recipes earlier in this chapter. Pick a master server and a slave server to use. In this recipe, we'll call db01 as the master server and db03 as the slave server.

How to do it...

1. On db01, launch the mysql command-line client and run the following commands:

   SET GLOBAL BINLOG_CHECKSUM = 1;
   SET GLOBAL MASTER_VERIFY_CHECKSUM = 1;
   

2. On db03, launch the mysql command-line client and run the following command:

   SET GLOBAL SLAVE_SQL_VERIFY_CHECKSUM = 1;
   

How it works...

When checksums are enabled on our master and slave servers, it adds an extra layer of checking as events are copied...