Hacker News Reader

Comment by silexia | Hacker News Reader

RDS is ridiculously overpriced, I just cut my bill from $1,000 to $50 per month by switching back to EC2 for my database server.

View on HN

I'm interested in hearing what your setup was like that cost $1,000 that you could replicate on your own for just $50.

I am trying to backup gmail emails my employees send and receive and make them searchable. This will enable a new account manager on an account to easily search and find previous discussions with clients and come up to speed to help them quickly.

We were pulling in millions of emails from the past few years, so we had to do a larger size RDS and we were killed on the IO charges.

We are now just on a medium sized EC2 server.

Do you have suggestions for better ways of doing this?

I can't give you direct recommendations, but it does sound like you might have used Provisioned IOPS storage instead of General Purpose storage which is simply pay by the byte.

If you're willing to post a bit more details, I'm sure people could give you some more detailed options. You basically switched from a fully-managed database solution to a fully DIY solution, and I honestly think you might have just over provisioned the RDS instance. I'm willing to bet you can switch back to RDS and get all the benefits there while remaining within budget. You can get a 1-year reserved t3.medium RDS instance with 50 GB of storage for $40/month.

Here is the rest of the details from my developer on the project-

What was our specific server size and setup and costs with RDS? We were using db.t3.medium (1 CPU, 2 vCPU, 4GB RAM), we were using a DB cluster that has 2 instances db.t3.medium overall cost (~$118 monthly) And now with EC2? We are using c5d.xlarge (4 CPU, 20 ECU, 8GB RAM), we are using one instance c5d.xlarge overall cost (~$140 monthly) What was the big cost savings? Our main issue was in I/O (Read and write), we have very high I/O demand so we was paying for I/O and storage (~$600) and the second issue is CPU credit (~$90 monthly) so the total save is ($600+$90+$118)-$140= $668 per month.

Also EC2 performance is better than RDS because we get a very good cheaper than RDS server.

Note: RDS is configuration less and has support while if you want to use EC2 then you need a person to do configuration and support for DB on it.

Still not clear what your major cost was. Were you using RDS Aurora, which has an IO fee? ($0.20 per 1 million requests?)

Yes, our major cost is IO and yes we are using Aurora and you are correct IO fee is $0.20 per 1 million requests.

So I suggest trying vanilla Postgres RDS, which doesn't have IO fees, but is still managed.

Also, if you're doing such heavy IO, you might want to also look at I3en instances, which have fantastic IO using local storage.

Same please do tell

Or you know, just use a smaller RDS instance. The price difference is not 20x over an EC2 instance. It's been a while since I checked, but I remember the markup being less than 2x.

Yup, it's about 1.8x for the instance sizes I checked.

Yeah that’s only true if you aren’t using piops. It can be an order of magnitude in price difference vs i3 when you need lots of I/O.

PIOPS is the same price whether it's attached to an EC2 instance or an RDS instance.

Reply on news.ycombinator.com