Al usar AWS re:Post, aceptas las AWS re:Post Términos de uso
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
    hace 6 meses

    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
    hace 4 días

    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

Temas
Migración y modernizaciónAnálisisBase de datos
Etiquetas
Servicio de AWS Database MigrationAmazon Relational Database ServiceMySQL
Idioma
English
blagi connecto
preguntada hace 6 meses257 visualizaciones
2 Respuestas
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
EXPERTO
Didier_Durand
respondido hace 6 meses
  • blagi connecto
    hace 6 meses

    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
respondido hace un día

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas

Contenido relevante