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
중재자
질문됨 4년 전571회 조회
1개 답변
0
수락된 답변

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/

답변함 4년 전
profile picture
전문가
검토됨 한 달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인