aurora serverless as source and destination for DMS

0

My organisation recently acquired a different org and I am trying to migrate their aurora serverless db to its my accounts. The acquired company's customers will take a while to migrate their connections to the new DB, and therefore for a period of time, both the DBs should be operational, and in sync.Although Aurora serverless is supported as source for DMS, it doesnt allow CDC. For ongoing replication, It is required to change the values of binlog_format parameter for source database. Although, Aurora serverless allows changing value for this parameter but it has no impact in actual. Only a few parameters are supported for change which are listed here. Is there a workaround to approach this?

AWS
管理員
已提問 4 年前檢視次數 3095 次
2 個答案
0
已接受的答案

As called out in the documentation, here, Aurora MySQL Serverless does not support binlogs.

Not much you can do here, other than pausing all writes to the source (take a downtime), and migrate entire DB in a single shot. Then switch apps to the destination endpoint.

AWS
已回答 4 年前
0

As per this doc [https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html] you can see that DMS supports Amazon Aurora PostgreSQL—Serverless V1 as a source for Full load only. But you can use Amazon Aurora PostgreSQL—Serverless V2 as a source for Full load, Full load + CDC, and CDC only tasks. Please check if the source is V1 or V2

Neeraj
已回答 1 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南