Serverless aurora v1 5.7 mysql migration to provisioned aurora mysql 5.7 using DMS with migrate type Full load, ongoing replication is not working

0

Hi, I want to migrate from Serverless aurora 5.7 mysql to provisioned aurora mysql 5.7 using DMS service, however it is failing with below error. I also try to enable log_bin by configuring binlog_format value to ROW but still not working. I also want that replication remain enabled means if any record is inserted into source it should be replicated into provisioned aurora mysql so that we can have zero downtime.

Please if anyone can guide me then i'll be much thankful.

2024-03-04T12:15:15 [SOURCE_CAPTURE ]E: Error Code [10001] : Binary Logging must be enabled for MySQL server [1020418] (mysql_endpoint_capture.c:424)

2024-03-04T12:15:15 [SOURCE_CAPTURE ]E: Errors in MySQL server validation. Follow all prerequisites for 'MySQL as a source in DMS' from https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.MySQL.html or'MySQL as a target in DMS' from https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.MySQL.html [1020418] (mysql_endpoint_imp.c:767)

Huzafa
preguntada hace 2 meses122 visualizaciones
No hay respuestas

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