RDS vs. PlanetScale: Pricing Considerations
vantage.sh
vantage.sh
Per. Query.
It’s hard to know how you’d get rid of this problem: either you block terrible queries (bad for services) or have some price caps/forgiveness (bad for you).
So if you have a database on AWS, and AWS goes down, you likely don't even need to tell your CEO that AWS is down, they already probably know that from the news or because their favorite website/app is also down.
However, if PlanetScale goes down, likely everything else appears to be working except yours.
My biggest hangup with PlanetScale is the unknown cost. Maybe I'm a bad dev or I should have better stats but I have no idea how many rows are read/written (I can get the second easier of course, or at least the initial write and I don't update much beyond the profile table). Runaway bills are terrifying for a solo dev and at least with Aurora I was able to calculate what it would cost to run my prod server at full (256 instances I think? or is 128?) for the duration of the festival and I was ok with that cost if it came to that. PlanetScale is somewhat limitless and I can't have the DB go down in the middle of a festival if I hit a spending limit.
For all I know my usage will fall 100% within the "base tier" ($30/mo) but it's really hard to know (or at least it is for me). I might just need to bite the bullet and try them but it's not a zero-cost to switch DBs (I'm using MySQL at least on Aurora as well).
When we took a look at RDS costs, the vast majority of customers are using "raw" RDS. So the hope with doing this analysis (which was definitely a bit trickier to do) was to try and purposefully compare that with PlanetScale as that seems to be the "true" customer anchor.
I think folks are used to RDS type pricing models, so would expect that to remain popular.
Some notes:
Reserved instance pricing easily saves 40%+ on a one year term with AWS. For folks where RDS is really at the top end of their budget, I think its a bit weird not to bring costs down with reserved instances - most large production workloads don't handle being spun up and down every hour etc. Not sure what planetscale offers there.
For dynamic pricing AWS offers other datastores. Aurora Serverless 2 is I think
$0.10 per GB/month of storage. So $100K per PB? $0.30 per million transactions
They say
"Whatever that number produces you can line up with the Amazon RDS multi-AZ price you’re currently paying Amazon."
Do we have confirmation that plantscale has a proper multi-AZ architecture?
I migrated to PostgreSQL later than most, and I've still be using Postgres for six years...