0

https://cloud.google.com/datastream/docs/configure-your-source-mysql-database#rdsformysql
I followed the doc above building a datastram with RDS mysql. The stream was built successfully, but there is a problem, source_metadata.change_type only has INSERT and UPDATE-INSERT

I only can see the after-value (source_metadata.change_type = 'UPDATE-INSERT') for an UPDATE action.

https://cloud.google.com/datastream/docs/events-and-streams
According to this doc, I expected I can get a 1 UPDATE-DELETE and 1 UPDATE-INSERT for a UPDATE action. enter image description here

I have tried to set the binlog_row_image=full in the parameters group of the rds-replica according to this doc: https://aws.amazon.com/blogs/database/enable-change-data-capture-on-amazon-rds-for-mysql-applications-that-are-using-xa-transactions/ enter image description here

Then I built a new datastream, but it no use. the result is the same.

How can I configure the RDS mysql and the google datastream for geting the before and after value?

0 Answers0