Currently we are using One EC2 instance to run our Services. And we are planning to add one more instance to put our application Server. Is it better to put the database in separate instance and query from both instances or is there any better solution?
Meanwhile we also have to consider about the scalability when we want to add more servers at runtime.
The answer to this question is basically the same inside or outside of EC2.
Without hearing more about the specifics of your architecture and application requirements, I would default to recommending that MySQL be put on its own server.
Here’s a good writeup on some of the issues to consider:
- AWS (Amazon) EC2 – instance basic question
- How to setup a shared webhost for multiple subdomains on a single amazon ec2 instance
- What’s the quickest way to convert a micro instance to a small instance on AWS EC2?
- What is the probability on AWS EC2 that I will lose my instance store data?
- Amazon Web Services – How do I use IAM to restrict a single user to managing a single EC2 instance?