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?