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?

asked 4 months ago41 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions