By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Migration from Aurora to Aurora Serverless

0

Hi, my Aurora mySQL database is in production and we would like to Migration from Aurora to Aurora Serverless v2. I found this: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-restore-snapshot.html My question is, on restoring the database as serverless v2 from the snapshot, will the database automatically be used in production instead of the Aurora provisioned cluster that I already have? I have a multi AZ deployment.

Will there be any downtime, if any? Also, what is the amount of time for the Serverless v2 database to be deployed into my production environment take?

Topics
AnalyticsDatabase
Tags
Amazon AuroraAurora MySQL
Language
English
rePost-User-8883437
asked 10 months ago356 views
1 Answer
0

Here is a knowledge center article that explains how to perform this migration:

https://repost.aws/knowledge-center/aurora-migrate-provisioned-serverless

On the other hand, if you wanted to perform a migration with close to 0 downtime, you should use AWS DMS. Create a source and a destination in dms then start the replication task, which copies the existing and new data with CDC (change data capture). Then make your application point to your new database and done

profile picture
EXPERT
MaxCloud
answered 10 months ago
  • rePost-User-8883437
    10 months ago

    The knowledge center article is outdated as per the comment at the end. The steps I gathered were

    1. Take a snapshot of the currently running aurora provisioned db
    2. Restore the snapshot and by selecting Aurora serverless v2.
    3. Point my application to the restored database
    4. Terminate the provisioned database. Is this correct?

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content