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
已提问 2 个月前122 查看次数
没有答案

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则