使用AWS re:Post即您表示您同意 AWS re:Post 使用条款
AWS re:Postre:Post

MySQL time field type conversion issue with AWS DMS

1

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
    6 个月前

    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

  • mroy
    3 天前

    We are also having a similar issue with MariaDB 10.1.46 as the source, and Kinesis as the destination.

    Conversions make no sense at all: 13:23:59 --> -911:43:62 13:22:31 --> 112:16:02

主题
迁移与现代化分析数据库
标签
AWS 数据库迁移服务Amazon Relational Database ServiceMySQL
语言
English
blagi connecto
已提问 6 个月前257 查看次数
2 回答
0

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

profile pictureAWS
专家
Didier_Durand
已回答 6 个月前
  • blagi connecto
    6 个月前

    It's not timestamp field type, it's time type: hour:min:sec!

0

This is a serious bug which Amazon needs to fix.

I did a full investigation, and posted about it on StackOverflow.

mroy
已回答 18 小时前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈，并能促进提问者的职业发展。

回答问题的准则

相关内容