CODEWITHSUNDEEP
wordpressamazon-web-servicesamazon-ec2amazon-rds
HotDudeSmith
HotDudeSmith

Reputation: 143

Which one is the cheapest to use AWS RDS or my own database?

I have wordpress application running on my EC2 - AWS. I haven't decide which one is Amazon RDS or my own database on different hosting. Which one is the cheapest to use? Let's say I have my own MySQL database from Lunarpages or Bluehost hosting, to allow my wordpress on EC2 instance to connect/remote to my database on Lunarpages not allow my wordpress to connect remote to Amazon RDS. Which one is the cheapest to use? I heard people saying when you use Amazon RDS is very expensive, so I thought maybe to save costs to allow my wordpress to connect to my own database not Amazon RDS for wordpress. I don't know it is true or not. I don't know how it performance well. Which one is the best one. Any suggestion appreciated. Thank you.

Upvotes: 5

Views: 25662

Answers (4)

December Born
December Born

Reputation: 1

Performance wise is not good to have database on a totally different network of the website hosted itself. It'll delay. Imagine if you have a lot of calls, it'll multiply the delay.

You can host a local database on the EC2 iHaving a database on a different network from the hosted website can indeed lead to latency issues, especially with a high volume of calls. Hosting a local database on the same EC2 instance as your website can mitigate these delays by reducing network latency and improving overall performance. This setup ensures faster data access and smoother operations for your application.'self, this would be the best choice.

Upvotes: 0

micafe
micafe

Reputation: 66

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.

Upvotes: 4

ThomasVdBerge
ThomasVdBerge

Reputation: 8140

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)

  1. 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.
  2. 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)

Upvotes: 4

Simos Fasouliotis
Simos Fasouliotis

Reputation: 1390

Performance wise is not good to have database on a totally different network of the website hosted itself. It'll delay. Imagine if you have a lot of calls, it'll multiply the delay.

You can host a local database on the EC2 it'self, this would be the best choice.

Upvotes: 2

Related Questions