CODEWITHSUNDEEP
amazon-web-servicesamazon-rdsamazon-auroraaws-aurora-serverless
Josh
Josh

Reputation: 702

Can I migrate an existing Aurora DB cluster to Aurora Serverless?

AWS Aurora FAQ states:

enter image description here

I have a snapshot of an existing Aurora (Postgres) provisioned cluster. The snapshot was originally taken in us-west-1, but I copied it to us-west-2 (not sure if this matters). When I attempt to restore this snapshot to an Aurora serverless setup, I only see the option to create a provisioned cluster.

enter image description here

What am I doing wrong?

Upvotes: 4

Views: 3067

Answers (1)

enharmonic
enharmonic

Reputation: 2080

You can do it via snapshot -> restore, but only if your source database snapshot has specific characteristics. To see if your version is compatible, use:

$ aws rds describe-db-engine-versions | 
jq -r '.DBEngineVersions[] | 
select(.SupportedEngineModes[]?=="serverless") | 
"\(.Engine): \(.EngineVersion)"'

yields

aurora-mysql: 5.7.mysql_aurora.2.07.1
aurora-postgresql: 10.14
aurora: 5.6.10a

The versions that are compatible to swap back and forth (using snapshots between serverless and provisioned) change over time. If you are using a source database snapshot that is not directly compatible, you can try mysqldump.

Upvotes: 2

Related Questions