DEV Community

Cover image for Heroku Database VS AWS RDS

Heroku Database VS AWS RDS

Sam on March 11, 2022

Database is the heart of almost any real world software system, and when it comes to choosing the right platform to host your database, two of the ...
Collapse
 
mxdpeep profile image
Filip Oščádal

don't run on AWS!

devs running AWS support slavery

Collapse
 
mohsenkamrani profile image
Sam

It's very accurate. That's the whole idea behind Utopiops.

Using AWS is like buying from factory but it's extremely costly and time consuming to manage it. Utopiops is all about fixing that issue.

Collapse
 
mxdpeep profile image
Filip Oščádal

My story is like this:

1) buy a dedicated server (40 Eur/m.)
2) setup with Ubuntu or Debian
3) git clone and run setup scripts
4) deploy containers
5) setup backup and monitoring (20 Eur/m.)

It's the most reliable and cheapest solution ever.
No need for 3rd party devops.

Thread Thread
 
mohsenkamrani profile image
Sam

Do you implement all of this on that single server?

Is it reliable at all, let a lone most reliable? Is it highly available? Any load-balancing by any chance?

What are the RTO and RPO?
What container orchestrator do you use? Just please don't tell me docker swarm.

And on top of that is your time is less valuable than $9 per month?

Thread Thread
 
mxdpeep profile image
Filip Oščádal

6 CPU AMD Ryzen (12 threads) / 64 GB RAM / 500 GB nVME RAID1

1) reliable 100 % so far (10 months), better than DigitalOcean or GoDaddy
2) I don't need load-balancing - average load is 0.04, no need for a clone
3) recovery of a failed container under 2 minutes or max. 10 minutes if done manually from a daily backup
4) customers pay $4 a month so they don't need much (it's a managed hosting, so we take care of their needs, setup changes, plugins, debugging problems)
5) it's not a professional business, it's a hobby
6) my time is my time, I prefer to know what's happening on the server
7) I have my own orchestration, I am a programmer for fucking 35 years

Thread Thread
 
mxdpeep profile image
Filip Oščádal

BTW I take care of customers solutions under 1 hour a month, it works on its own, everything is automated (I <3 cron)

Thread Thread
 
mohsenkamrani profile image
Sam

Well, number 5 tells it all.

And regarding number 7, actually your time is then 10x more valuable because you can make money out of each second of it with your experience.

But again, if it works for you it's good.

Thread Thread
 
mxdpeep profile image
Filip Oščádal

no, my time is not valuable, I am nearly dead

Collapse
 
luccabiagi profile image
Lucca Biagi de Paula Prado

how?

Collapse
 
mxdpeep profile image
Filip Oščádal

There have been many complaints from employees at Amazon's fulfillment centers. Workers alleged that they are given back-breaking tasks in the warehouses. They also vent their dismay over intrusive surveillance technologies, including automated tracking systems and cameras that monitor their every move.

Collapse
 
mxdpeep profile image
Filip Oščádal

get DigitalOcean VPS or a dedicated server from Hetzner
run Ubuntu and Docker, it's much cheaper anyway (1 beer a day)

Collapse
 
sin13 profile image
Sina

this is a solid and detailed comparison. thank you!

Collapse
 
eduardonwa profile image
Eduardo Cookie Lifter • Edited

honestly, avoid comparisons

Collapse
 
mohsenkamrani profile image
Sam

I'm curious to know why you think so.

Collapse
 
mehdikamrani profile image
mehdikamrani

interesting , thanks

Collapse
 
mxdpeep profile image
Filip Oščádal

docker run --detach --name some-mariadb --env MARIADB_USER=example-user --env MARIADB_PASSWORD=my_cool_secret --env MARIADB_ROOT_PASSWORD=my-secret-pw mariadb:latest

is it too hard??

Collapse
 
mohsenkamrani profile image
Sam

I'm not sure if you really mean this can be used in production and I really doubt that's your intention.

Of course it's a great idea to use a simple docker container in your local dev. We always have a docker compose in each repository as well.

Collapse
 
mxdpeep profile image
Filip Oščádal

this works just fine:
docker-compose

Collapse
 
mxdpeep profile image
Filip Oščádal

Actually we run many simple containers in production, using docker-compose.
Where's the problem?

Speed? nope! Reliability? nope! Security? nope!

So if you find a problem here I am all ears...

Thread Thread
 
mohsenkamrani profile image
Sam

I just say it's good if it works for you!

Collapse
 
pblgllgs profile image
pbl.gllgs

En mi opinión igual necesitaras un contenedor, administrar la base de datos, respaldos, espacio en disco... AWS RDS > servicios de bases de datos relacionales en la nube.

Collapse
 
collimarco profile image
Marco Colli

I agree that Heroku is simple, but extremely expensive. We save thousands of dollars per month by using 10 bare servers directly on DigitalOcean: it's reliable but you need good DevOps.

Now I am building Cuber and we plan to move to it: github.com/cuber-cloud/cuber-gem It makes the deployment of apps on Kubernetes extremely simple and you can choose any cloud provider.

Other projects related to your idea are Dokku, Kuby (for Ruby), Coolify and probably many others (?).

Collapse
 
mohsenkamrani profile image
Sam

Best of luck Marco. Have to make cloud a lot more user friendly.
We're trying our best and have gained amazing feedback so far.