Hi team,
I am using airbyte version 2.0.1. I use mysql source connector(3.51.3) to sync data to bigquery using CDC - binlog.
Problem: When I upgrade my AWS RDS on which mysql runs, it creates a new instance of the RDS and destroys the old one. So the binlog file and position stored on airbyte is from the old instance and the sync breaks since that file and position is not valid for the new instance. How do you suggest we navigate this situation such that the syncs do not break and data is not lost.