Bug #86646 Documentation claims lack of binlog checksums when RBL is used
Submitted: 11 Jun 2017 9:30 Modified: 27 Jan 2020 14:25
Reporter: Alexey Kopytov Email Updates:
Status: Closed 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] MySQL Verification Team
Hello Alexey,

Thank you for the report!

Thanks,
Umesh
[27 Jan 2020 14:25] Margaret Fisher
Posted by developer:
 
Thanks for reporting this. Sorry it has been a while to get a response to you! I checked and the statement has already been removed from the documentation for 5.6, 5.7 and 8.0. So I guess this was either fixed from another report, or from your report but someone forgot to close it off. Anyway, it's done, thank you!