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)

No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions