MySQL Bugs: #82252: Add a new option COMPLETE for binlog-row-image

Bug #82252	Add a new option COMPLETE for binlog-row-image
Submitted:	15 Jul 2016 18:40	Modified:	28 Aug 2016 6:16
Reporter:	Santosh Praneeth Banda	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Row Based Replication ( RBR )	Severity:	S4 (Feature request)
Version:	5.6, 5.7	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
Having a new mode COMPLETE for binlog-row-image is really useful. With this mode, MySQL should log full before row images for an update query and log only the changed columns in after row images.

Note the full before image is useful in identifying all the column values for any binlog subscribers. This is not possible with MINIMAL/NOBLOB modes.

How to repeat:
see description

Hello Santosh,

Thank you for the feature request!

Thanks,
Umesh

Post from the Developer:
========================

Hello Santosh, 

Thank you for filing the feature request. 

We do have binlog_row_image=FULL mode which is the default for 5.7 

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

FULL mode writes all the columns in before image and after image for all the queries which seems to cover the use case that you have mentioned.

Are you requesting a specialized mixed mode where it applicable only for update queries and the before image is COMPLETE but after image is MINIMAL ?

Regards,
Venkatesh.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".