CODEWITHSUNDEEP
amazon-web-services
Chris Scott
Chris Scott

Reputation: 643

Should I use AWS RDS for EC2 MYSQL?

Let's say I've got 100,000 visitors per day and multiple EC2 instances running with load balancers to balance the traffic between the instances.

Would it be wise to have all the EC2 instances connect to the same RDS MySQL database? We're talking about 100K visitors here and let's say that number has the potential to grow. The MySQL database isn't any larger than 10 tables with a maximum of 1K rows in each.

I guess the alternative is to have duplications of the database in each of the ec2 instances, but that really isn't feasible as it would need to be re-duplicated each time there was a change. Thoughts, considerations?

Upvotes: 1

Views: 146

Answers (1)

Mike Brant
Mike Brant

Reputation: 71384

Yes. If you have multiple application servers, you would most likely want a single database that they work with, so as to keep all data for the application in a single place. I guess there could be some exceptions, like if the database was read only and you didn't want overhead of remote network call.

Upvotes: 2

Related Questions