Advisor check: MySQL enforced data integrity checking is disabled¶
Description¶
The SQL thread is not verifying binary log checksums.
Setting slave_sql_verify_checksum=1 causes the replication SQL (applier) thread to verify data using the checksums read from the relay log.
In the event of a mismatch, the replica stops with an error. Setting this variable takes effect for all replication channels immediately, including running channels.
Resolution¶
Set the slave_sql_verify_checksum variable to 1. For MySQL 8.x and major: Set the replica_sql_verify_checksum variable to 1.
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.