I created a new DB, and set up for Standard, tried Aurora MySQL, and MySQL, etc. Somehow Aurora is cheaper than reg. MySQL.
When I do the drop down option for Instance size, t3.medium is the lowest. I've tried playing around with different settings and I'm very confused. Does anyone know a very cheap set up. I'm doing a project to become more familiar with RDS, etc.
Thank you
Videos
What is the cheapest RDS instance type?
Which RDS instance should I choose?
What's the difference between RDS instance classes?
Running on a different hosting will cause extra latency.
Let's do the math on AWS RDS for the smallest instances (taking eu-west-1 region as example)
- Running on RDS: db.t2.micro $0.018 per hour, or $12.96 per month for RDS. Free the first year under AWS free tier.
- Running on EC2: t2.micro (You configure MySQL and backups, ...), $0.0126 per hour, or $9.07 per month. Free the first year under AWS free tier
If your application is small enough, you could host both your database and your application on the same machine (solution 2)
I don't agree with that. In amazon AWS, the first thing you do is set up a virtual private network and create the corresponding network access interfaces. My experience working with heavy CMSs is that the architecture is much more stable with EC2 + RDS, each in one instance. In addition RDS has automated version maintenance and it is much more difficult to fail or suffer a crash, as opposed to a mysql or similar, running on the same virtual machine.
Also in terms of speed and performance, working with this scheme for example in wordpress, the system flies, the speed is much higher and appreciable even with small machines.
RDS seems to be the majority of my side project bill. I get the importance of managed DBs and the opportunity cost of something like maintenance, ingress, snapshots, etc. Right now I'm basically shutting down my instance when im not working on my project, which isnt a long term solution, but I'm curious about what's the most cost effective DB setup other than un-managed on EC2?
I've looked into Aurora Serverless but it seems a bastion node is required in the VPC for tunneling? That's another $6-8 for a tX.micro and my goal is to be cheap in the near term.
I've also toyed with a mysql container in compose, but I've never been a fan of using a DB in a container.
Lightsail seems fine I guess, but it seems like there's no CI available?