MySQL binlog checksum not set

Description

When archiving or backing up your binary logs, binary log checksums adds resilience to integrity checking and validity.

For more information, see binlog_checksum in the MySQL documentation.

Resolution

In the server, set binlog_checksum=CRC32 to improve consistency and reliability. The CRC32 checksum is the only checksum supported and is the default.

SET GLOBAL binlog_checksum=CRC32;

Resetting the variable, even to the existing value, forces a binary log rotation.

Need more support from Percona?

Percona experts bring years of experience in tackling tough database performance issues and design challenges.