MySQL time field type conversion issue with AWS DMS

Question

I have a source DB MySQL v5.6 community edition as a source DB and AWS RDS MySQL v5.7 as target in AWS DMS and have an issue with time field type. DMS task is full load and replication. During full load all time columns are migrated correctly, but during ongoing replication/CDC all time field values are converted to either 00:00:00 or 23:59:59. Probably the source of the issue is in bin log used for replication, but I need help in solving that.

blagi connecto
5 months ago
Conversions are like this: 00:52:19 -> 00:00:00 02:39:08 -> 00:00:00 00:25:56 -> 23:59:59 00:33:01 -> 23:59:59 00:22:51 -> 23:59:59 00:30:26 -> 23:59:59 06:00:52 -> 23:59:59

Answer

Hi,

This post will provide you with full details on how to obtain timestamps on target when migrating from MySQL to MySQL via AWS DMS:

https://medium.com/devops-journal/migrating-mysql-timestamp-from-non-utc-database-to-rds-with-aws-dms-6a5c382c9d5c

Best,

Didier

MySQL time field type conversion issue with AWS DMS

Relevant content