aurora serverless as source and destination for DMS
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?
- Newest
- Most votes
- Most comments
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.
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
Relevant content
- asked 9 months ago
AWS OFFICIALUpdated 2 years ago- AWS OFFICIALUpdated 10 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
