The issue I am running into is that in the first command (using --replicate to compute the actual checksums), I see 1’s appear in the DIFFS column for various tables. However, when I run --replicate-check-only command after the checksum command, it reports no DIFFS. This seems contradictory. I then checked percona.checksums table in the database for some of the tables in question and the CRC is identical on master and slave. In addition, there are no row mismatches between master and slave. Therefore, I’m left to wonder, why did the checksum output report a 1 in the DIFF column?
Has anyone else run into this or know of why this would occur?