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.
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.
On
db01
, launch themysql
command-line client and run the following commands:SET GLOBAL BINLOG_CHECKSUM = 1; SET GLOBAL MASTER_VERIFY_CHECKSUM = 1;
On
db03
, launch themysql
command-line client and run the following command:SET GLOBAL SLAVE_SQL_VERIFY_CHECKSUM = 1;