Hi everyone.
I would like to know your opinion on how to evaluate costs for using Aurora Serverless 2 against a current RDS workload.
Basically, I have a client running a PG RDS. Given the workload they have with sudden spikes during business hours and very low usage off business hours and weekends, I would like to recommend serverless 2.
But is their a way I can predict their TCO (Total Cost of Ownership) using Serveless 2 based on their current RDS metrics from Cloud Watch?? That would be really helpful to get the client to buy in
Thanks in advance!!
Our production database needs some maintenance because it was neglected for a while. Some dba friends I know keep telling me to migrate to Postgres compatible Aurora. Others tell me it is too expensive.
When I did some quick estimates in the aws calculator, the cost seems unrealistically low.
Is there some tool that would give me a better idea of how much it would realistically cost?
Videos
Hey folks,
I’m managing a critical live production workload on Amazon Aurora MySQL (8.0.mysql_aurora.3.05.2), and I need some urgent help with cost optimization.
Last month’s RDS bill hit $966, and management asked me to reduce it. I tried switching to Aurora Serverless V2 with ACUs 1–16, but it was unstable — connections dropped frequently. I raised it to 22 ACUs and realized it was eating cost unnecessarily, even during idle periods.
I switched back to a provisioned db.r5.2xlarge, which is stable but expensive. I tried evaluating t4g.2xlarge, but it couldn’t handle the load. Even db.r5.large chokes under pressure.
Constraints:
Can’t downsize the current instance without hurting performance.
This is real-time, critical db.
I'm already feeling the pressure as the “cloud expert” on the team 😓
My Questions:
Has anyone faced similar cost issues with Aurora and solved it elegantly?
Would adding a read replica meaningfully reduce cost or just add more?
Any gotchas with I/O-Optimized I should be aware of?
Anything else I should consider for real-time, production-grade optimization?
Thanks in advance — really appreciate any suggestions without ego. I’m here to learn and improve.
Hey there,
Sorry if I lack any technical jargon for this question, I'm still pretty novice to AWS.Right now I have a desktop application that has a leaderboard function. For this I decided with would be best to go down the RDS path. I know pretty little about connecting and running databases, so I opted to go with the serverless route, and wanted to access the database using the Aurora API/ lambda.
I saw AWS deprecated mySQL for serverless 1.0, and since serverless 2.0 does not support the aurora API, I went with the postgres option, as I could still use the API.
I think this is the first mistake, as it seems the minimum ACUs for the postgres option is double of the mySQL. But either way my database has a min and max of 2 ACUs which is probably far more than my application needs. I would estimate max, my user pool will be about 50k and its just storing simple leaderboard numbers.
After one month of running the database, my monthly bill came out to ~230 dollars, which is just a lot especially since I have not even launched this product yet.My main cost was in just running the database :
$0.08 per Aurora Capacity Unit hour running Amazon Aurora PostgreSQL Serverless
2,840.991 ACU-Hr
$227.28
So does anyone have any advice on where to start in reducing the cost ? Should I move off postgres?Would running the EC2 and manually managing the database be cheaper? Would no longer using the API be cheaper ? Any help appreciated
Edit : Wow I just realized while posting this my ACU numbers did not add up and it turns out I was running a second database all month with nothing in it. So thats half the cost atleast lol. But still my questions apply
Say I run a very small query once a day. Something simple like inserting 100 rows into a single table.
I might read all of the records once a month, what would my incurred monthly charge be?
Something like this should only cost a few pennies per month, assuming you have it set to scale down to zero when you're not actively using the database.
Just keep in mind that it can take 25+ seconds to wake the database up again when you want to perform a query after a few minutes (or more) of inactivity. If you need the database to be responsive all the time, then you will have to incur the costs associated with keeping database instances running 24/7 throughout the month which would be significantly more expensive.
Anecdote, but in case you are worried about the lower bound of what it might cost: I have an RDS database I set up a couple of weeks ago to fuck about with a chat bot I am making, so far this month my RDS spend is $0.01.
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
I've been exploring AWS Aurora for my database needs, and while the service seems promising, I'm a bit confused about its pricing structure.
Is it true that, even if your Aurora DB instance is idle and not receiving any requests, there's still a minimum of 0.5 ACU 'in usage', which contributes to the billing. This information is not really visible in the AWS Pricing examples.
If anybody is using Aurora DB do you recommend it and how much do you pay for which cluster?
Hi all,
I've been reading some older threads about using Serverless v2 and see a lot of mentions of DBs never idling at 0.5.
I'm looking to migrate a whole bunch of Wordpress MySQL DBs and was thinking about migrating to Aurora to save on costs, by combining multiple DBs in one instance, as most of them, especially the Test and Staging DBs, are almost never used.
However seeing this has me worried, as any cost savings would be diminished immediately if the clusters wouldn't idle at .5 ACU.
What are your experiences with Serverless? Happy to hear them, especially in relation to Wordpress DBs!
Any other suggestions RE WP DBs are welcome too!
https://aws.amazon.com/rds/aurora/serverless/
It has the following: "You pay a flat rate per second of ACU usage, with a minimum of 1 minute of usage each time the database is activated."
Does that mean if I use it for lets say 10 seconds, I'll be charged for a minute? If I then run it 10 mins later and use it again for 10 seconds, I am charged for using it for a minute?
Or is it totaled up at the end of the month i.e. I've used it for 20 seconds, so I am charged for 1 minute?
I'm just trying to figure out if it's worth using serverless Aurora for personal projects that require a DB but run very infrequently.
Hi
I'm new to Aurora Serverless as well as serverless services in general. I'm looking for relational db managed services that support foreign keys (I looked up planetscale, but they don't support it) that doesn't cost too much.
The usage is for hobby project.
I'm thinking to use Aurora Serverless v2 but I'm confused with the pricing calculator especially about the number of ACU running per hour. Shouldn't serverless mean "pay as you go"? Why the calculator say monthly cost?
Does the pricing calculator assume the instance keeps running and never stops due to inactivity for 30 day straight? For how long of inactivity that the db instance would stop on its own?
So Aurora pricing is based on I/O compute and storage, and not actual uptime of the DBs (https://aws.amazon.com/rds/aurora/pricing/)
So how is Aurora Serverless any more cost effective than regular Aurora? Aurora Serverless's main feature is automatic start/stopping. If I'm not actually paying for uptime in Aurora, then why do I want to sacrifice the performance of my app by using Aurora Serverless, if there's no actual cost difference?
Aurora Serverless's main feature is automatic start/stopping.
Plus automatic scaling... that's a key component.
Serverless allows you to dynamically scale the resources available to your database cluster and only pay for what you use. Scaling a standard RDS instance is nowhere near as easy and will often involve short downtime.
I use serverless as I manage a site which receives large predictable spikes in traffic. We scale the database up to handle those spikes and save ourselves hundreds each month as we don't need to have that large amount of capacity used all the time.