AWS re:Post을(를) 사용하면 다음에 동의하게 됩니다. AWS re:Post 이용 약관
AWS re:Postre:Post

MySQL time field type conversion issue with AWS DMS

0

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

주제
마이그레이션 및 현대화분석데이터베이스
태그
AWS 데이터베이스 마이그레이션 서비스아마존 Relational Database ServiceMySQL
언어
English
blagi connecto
질문됨 6달 전248회 조회
1개 답변
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!

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠