Annotate rows events

Registered by Oleg Tsarev

Laurynas: upstream 5.6 implemented binlog_rows_query_log_events, https://dev.mysql.com/doc/refman/5.6/en/replication-options-binary-log.html#sysvar_binlog_rows_query_log_events, closing

=========================
 Annotate rows log events
=========================

Store in binlog (and show in mysqlbinlog output) texts of statements that caused RBR events.
This is needed for (list from Monty):
  * Easier to understand why updates happened
  * Would make it easier to find out where in application things went wrong (as you can search for exact strings)
  * Allow one to filter things based on comments in the statement.

The cost of this can be that the binlog will be approximately 2x in size (especially insert of big blob's would be a bit painful), so this should be an optional feature.
Varible :variable:`skip-annotate-rows-events` of **mysqlbinlog** utility allows to do not print *Annotate Rows Events*.
Variable :variable:`binlog-annotate-rows-events` of **mysqld** tells the master to annotate RBR events with the statement that caused these events.
Variable :variable:`replicate-annotate-rows-events` of **mysqld** tells the slave to write annotate rows events recieved from the master to its own binary log. Sensible only in pair with log-slave-updates option..

Blueprint information

Status:
Not started
Approver:
Oleg Tsarev
Priority:
Not
Drafter:
Oleg Tsarev
Direction:
Approved
Assignee:
None
Definition:
Approved
Series goal:
Accepted for 5.1
Implementation:
Unknown
Milestone target:
None

Whiteboard

Assigned to Stewart to make a decision if we merge this to 5.1 or not.
http://askmonty.org/worklog/Server-Sprint/?tid=47

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.