DMS CDC - MySQL Binlog Precision - Seconds to Microseconds

0

I have a DMS CDC task reading binlogs from MySQL and writing the changes as csv files. An issue I have encountered is that the resolution of the timestamps for changes is in seconds. As a result, I see multiple update statements occurring at the same time. Since I am trying to use these changes to incrementally update another table, I do not have a deterministic result for which update was applied at the source (MySQL).

Is there a way to increase the precision of the CDC task on DMS? Are the order of changes within a file guaranteed to match the binlogs?

Keine Antworten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen