Bug #72522 Replication compatibility of 5.5/5.6 should mention checksums etc.
Submitted: 3 May 2014 8:01 Modified: 25 Jun 2014 11:07
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.6 OS:Any
Assigned to: David Moss

[3 May 2014 8:01] Daniël van Eeden
Description:
Pages: 
- https://dev.mysql.com/doc/refman/5.6/en/replication-compatibility.html
- https://dev.mysql.com/doc/refman/5.6/en/replication-upgrade.html

There are a few important variables which must be set when replicating from 5.6 to earlier releases:
- binlog_checksums
- binlog-rows-query-log-events
- log-bin-use-v1-row-events (only for ndb?)
- enforce-gtid-consistency
- gtid_mode
There might be some more.

The documentation doesn't seem to mention these settings on these pages.

How to repeat:
Read docs
[5 May 2014 9:45] Umesh Shastry
Hello Daniel,

Thank you for the report.

Thanks,
Umesh
[24 Jun 2014 13:46] David Moss
I have content ready for this, but currently checking with Luis to confirm if there are more variables to add to the list.
[25 Jun 2014 11:07] David Moss
Based on discussion with Luis, the following was added with commit 39156:
Important Variables in MySQL 5.6.
Features have been added to MySQL 5.6 which need to be disabled when replicating to earlier MySQL versions. To avoid incompatibilities, set the following variables on the MySQL 5.6 master:

    binlog_checksum=NONE

    binlog_row_image=FULL

    binlog_rows_query_log_events=OFF

    log_bin_use_v1_row_events=1

    gtid_mode=OFF