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ビュー
回答なし

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ