Aurora Serverless v2 vs RDS cost comparison?
Cheapest serverless SQL database - Aurora?
Cost for an aurora cluster
Amazon Aurora Serverless v2 is Generally Available!
Scaled-out databases split across multiple servers
Customers with high write or read requirements often split databases across several instances to achieve higher throughput. However, customers often provision too many or too few instances, increasing cost or limiting scale. With Aurora serverless, customers split databases across several Aurora instances and let the service adjust capacity instantly and automatically based on need. It seamlessly adjusts capacity for each node with no downtime or disruption, and uses only the amount of capacity needed to support applications.
Variable workloads
You're running an infrequently-used application, with peaks of 30 minutes to several hours a few times each day or several times per year, such as a human resources, budgeting, or operational reporting application. You no longer have to provision to peak capacity, which would require you to pay for resources you don't continuously use, or to average capacity, which would risk performance problems and a poor user experience.
Unpredictable workloads
You're running workloads with database usage throughout the day, and also peaks of activity that are hard to predict. For example, a traffic site that might see a surge of activity when it starts raining. Your database will automatically scale capacity to meet the needs of the application's peak load and scale back down when the surge of activity is over.
Videos
I have an app in production running on RDS postgresql db.r5.xlarge , the traffic is normal peaking during the day and almost sleeps during the night without any clear spikes.
I have a read replica that is used for reporting queries, this one is problematic, it has spikes whenever the users enter the google data studio reports, and even db.r5.2xlarge doesn't do the job fairly well.
I started thinking about evaluating Aurora Serverless v2 as an option, do you think using serverless will decrease the costs? what sorts of problems using serverless might cause or you have experience with?
Thanks everyone
For a hobby project, I'm looking at database options. For my use case (single user, a few MB of storage, traffic measured in <20 transactions a day), DynamoDB seems to be very cheap - pretty much always in free tier, or at the pennies-per-month range.
But I can't find a SQL option in a similar price range - I tried to configure an Aurora Serverless Postgres DB, and the cheapest I could make it was about $50 per month.
Is there any free- or near-free SQL database option for my use case?
I'm not trying to be a cheapskate, but I do enjoy how cheap serverless options can be for hobby projects.
(My current monthly AWS spend is about $5, except when Route 53 domains get renewed!).
Thanks.