Bug #75127 'Disadvantages of row-based replication' needs update for query_log_events
Submitted: 6 Dec 2014 10:58 Modified: 20 Aug 2015 15:32
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 CPU Architecture:Any

[6 Dec 2014 10:58] Daniël van Eeden
Description:
From: http://dev.mysql.com/doc/refman/5.6/en/replication-sbr-rbr.html
In the 'Disadvantages of row-based replication' section:

"You cannot examine the logs to see what statements were executed, nor can you see on the slave what statements were received from the master and executed.

However, you can see what data was changed using mysqlbinlog with the options --base64-output=DECODE-ROWS and --verbose."

This disadvantage is no longer true if binlogs_rows_query_events is enabled as that will add a Rows_query event with the statement to mysqlbinlog -vv output.

http://dev.mysql.com/doc/refman/5.6/en/replication-options-binary-log.html#sysvar_binlog_r...

How to repeat:
See description
[6 Dec 2014 23:53] Miguel Solorzano
Thank you for the bug report.
[20 Aug 2015 15:32] David Moss
Thank you for your feedback. This has now been fixed in the 5.6 and 5.7 documentation.