Description:
The "Usage of Row-Based Logging and Replication" page in the manual says
binary log checksums are not used in the row-based logging mode:
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-usage.html
"Lack of binary log checksums. RBL does not use checksums, so network,
disk, and other errors may not be identified when processing the binary
log. To ensure that data is transmitted without network corruption use
SSL for replication connections. The CHANGE MASTER TO statement has
options to enable replication over SSL. See also Section 13.4.2.1,
“CHANGE MASTER TO Syntax”, for general information about setting up
MySQL with SSL."
A simple test shows that checksums ARE stored in RBR events with
binlog_checksums='CRC32':
170611 12:17:45 server id 1 end_log_pos 571 CRC32 0x60cceb47 Write_rows: table id 169 flags: STMT_END_F
BINLOG '
uQo9WRMBAAAAMgAAABMCAAAAAKkAAAAAAAEABnNidGVzdAACdDMAAQMAAQEBAKCGmNk=
uQo9WR4BAAAAKAAAADsCAAAAAKkAAAAAAAEAAgAB//4BAAAAR+vMYA==
'/*!*/;
Is that statement a leftover from the pre-5.6 times?
How to repeat:
Read the checksums-related part of
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-usage.html
