Are there difficulties migrating from Aurora MySQL to Aurora Serverless

0

A customer is running Aurora MySQL on an R5.4xlarge. They have a very spiky workload and need the large server to handle the peak load, but that is for a single hour of the day. They are wanting to experiment with using Aurora Serverless that will automatically scale as they expect this would reduce their overall RDS costs.

They are looking at this post for migrating and it looks relatively straightforward. Are there any issues with migrating from Aurora MySQL to Aurora Serverless?

The pricing doc indicates that 1 ACU ~ 2GB of memory. With an r5.4xlarge having 128GB of memory that would be 64 ACU for peak load. Is that an accurate conversion?

R5.4xlarge pricing is $2.32/hour Serverless is $0.08/ACU, so 64 ACU is $5.12

AWS
MODERATOR
asked 4 years ago560 views
1 Answer
0
Accepted Answer

In addition to snapshot restore method mentioned in customer provided blog they can also migrate the data from Aurora Provisioned Cluster to Aurora Serverless cluster by using one of the below methods.

  1. Customer can use a snapshot of Provisioned Aurora cluster running in version 5.6.10a and restore the same to a Serverless cluster. It was also mentioned in the shared blog post link that only version is 5.6 10a

Reference [+] https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_CreateSnapshotCluster.html [+] https://docs.amazonaws.cn/en_us/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.restorefromsnapshot.html.

  1. Customer can use native backup and restore process using mysqldump to perform a logical static migration.

Reference [+] https://dev.mysql.com/doc/refman/5.6/en/replication-howto-mysqldump.html

  1. They can use services like DMS to perform a full migration with capture changes, but this will require extra configuration from source and also a replication instance, it can be useful to minimize database downtime.

Reference [+] Targets for Data Migration - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.html [+] https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.html

About Pricing: it may not use 64 ACU all the time and customer need to look at their usage pattern(CPU/Memory) in 24 hours and ACU will be consumed based on the usage which varies over a period of time, here are some detailed pricing examples: https://aws.amazon.com/rds/aurora/serverless/

answered 4 years ago
profile picture
EXPERT
reviewed 20 days ago

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