Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

Thanks

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

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:

http://www.mysqlperformanceblog.com/2006/10/16/should-mysql-and-web-server-share-the-same-box/

share|improve this answer
    
Thanks for the link.Finally we used separate ebs backed ec2 instance(currently m1.small) to run database.Our requirement is to have a high availability solution provided with two clustered Liferay servers as Application server running in two separate EBS backed instance. And separate database storage for scalability issue. We are using ELB, which loadbalances two App Server. Can anybody share their experience regarding the liferay clustering under Amazon AWS? Thanks –  panalbish Sep 27 '11 at 13:58
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.