I plan to move a site from a shared host to AWS. For that I plan to use a medium EC2 Ubuntu instance on which I will install wordpress.
The question I have is regarding my lack of understanding of the difference between installing MySQL into my EC2 instance and creating another RDS instance to manage the DB for WordPress (apart from the cost of another instance just for the MySQL DB)
I do understand that RDS seems a more robust solution for big sites and lots of transactions, but for a WP site with 5000 visits a day what will be the adequate solution?
Thanks
With 5,000 visits a day, either one will be fine. The main benefit to RDS isn’t power, but the fact that it’s managed. Amazon handles version upgrades, backups, etc. for you, whereas with an EC2 instance you have to do that all yourself.
Don’t waste your money on two instances, one should be more than enough for the wordpress + MySQL and should give you great results