Disaster recovery for MySQL connector

[Liang Mou]

Hi there,

I'm trying to use MySQL connector for some production use cases. Currently we are using Maxwell, sometimes we have to reset the offset (GTID) for reasons like incidents, it's easy to do it as it's stored in a mysql table. Now with Debezium, suppose there is an incident where we find data loss in the pipeline and we would like to reset GTID to an easier time, is there an official way to do this?

I did some research, this looks the best match: https://rmoff.net/2019/08/15/reset-kafka-connect-source-connector-offsets/

Below is my connector config, I'm not it matters or not.

"snapshot.mode": "schema_only",
"snapshot.locking.mode": "none",

Thanks,

Liang

[Robin Tang]

You can update the offsets: https://debezium.io/documentation/faq/#how_to_change_the_offsets_of_the_source_database

--
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/4da9063f-63db-4f4d-b255-1be10b14ffb3n%40googlegroups.com.