Bug #86646 Documentation claims lack of binlog checksums when RBL is used
Submitted: 11 Jun 2017 9:30 Modified: 12 Jun 2017 8:55
Reporter: Alexey Kopytov Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.7 OS:Any
Assigned to: CPU Architecture:Any
Tags: binlog, checksums, documenation, RBL, replication

[11 Jun 2017 9:30] Alexey Kopytov
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
[12 Jun 2017 8:55] Umesh Shastry
Hello Alexey,

Thank you for the report!

Thanks,
Umesh