Advisor check: 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 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?¶
Subscribe to Percona Platform to get database support with guaranteed SLAs or proactive database management services from the Percona team.