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
gefragt vor 2 Monaten122 Aufrufe
Keine Antworten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen