Update mysql binlog connector & changes for transaction payload events

[debjeetsarkar]

This change is w.r.t to the corresponding changes done to mysql binlog connector and Debezium to support transaction payload events (generated when mysql server has binlog compression ON).

Ticket in Debzium: DBZ-2663 Reference to Debezium changelog: https://debezium.io/releases/2.0/release-notes#new_features_4 Changes in debezium: https://github.com/debezium/debezium/pull/3769

[debjeetsarkar]

@leonardBang please help me with the review of this change. Wasn't able to see the logs for pipelines. Let me know if any you have questions / are curious about the change ?

[yuxiqian]

Thanks @debjeetsarkar for the great work! Could you please rebase it with latest master branch?

[github-actions[bot]]

This pull request has been automatically marked as stale because it has not had recent activity for 60 days. It will be closed in 30 days if no further activity occurs.