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.
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/
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?