search

cds-snc / platform-forms-client

NextJS application that serves the public-facing website for Forms
https://forms-staging.cdssandbox.xyz/
MIT License
31 stars 12 forks source link

Upgrade RDS to Aurora V2 #2000

Open bryan-robitaille opened 1 year ago

bryan-robitaille commented 1 year ago

It has been strongly suggested by Core Services to move towards Aurora V2 Serverless for some time.

This will enable significant cost savings while strengthening the applications ability to quickly scale to meed demand.

Amazon Aurora Serverless v2 is suitable for the most demanding, highly variable workloads. For example, your database usage might be heavy for a short period of time, followed by long periods of light activity or no activity at all. Some examples are retail, gaming, or sports websites with periodic promotional events, and databases that produce reports when needed. Others are development and testing environments, and new applications where usage might ramp up quickly. For cases such as these and many others, configuring capacity correctly in advance isn't always possible with the provisioned model. It can also result in higher costs if you overprovision and have capacity that you don't use. excerpt

Example upgrade path: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless-v2.upgrade.html

Abi-Nada commented 1 year ago

To be moved back to PB until versions are in place (blocker)

patheard commented 10 months ago

AWS just released a blog post on the steps required to make this happen: https://aws.amazon.com/blogs/database/upgrade-from-amazon-aurora-serverless-v1-to-v2-with-minimal-downtime

patheard commented 1 week ago

AWS has announced that Serverless v1 will be retired Dec 31, 2024. From support, here's the impact if the upgrade to Serverless v2 isn't performed by then:

Starting on or after 12:00 PM PST on December 31, 2024, if your Amazon Aurora Serverless v1 cluster has not been upgraded, Amazon Aurora will automatically upgrade your Amazon Aurora Serverless v1 cluster to Amazon Aurora Serverless v2 during your next scheduled cluster maintenance window. If your Aurora Serverless v1 cluster is running an engine version that isn't available for Aurora Serverless v2, it will be upgraded to an engine version compatible with Aurora Serverless v2.