One $10 server or two $5 servers?

Posted June 13, 2013 6.9k views
Hi everyone, I was wondering what is the fastest setup for a typical LAMP (or LANMP) application on DO. I'm rather underwhelmed by the performance of my Drupal (Pressflow) site running on Nginx on DO. I suspect it might be because of poor DB performance. Would I gain anything by using two $5 servers instead of my current single $10 server? That way I could distribute Nginx + PHP on one VPS and MariaDB on the other one. Thanks for your help!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
3 answers
1. Turn cache on
2. Inspect your slow-query.log and make proper indexing in DB

If you don't have proper indexing the HDD I/O slows down your site. If you migrate DB to another machine it will have minimal effect depending on how I/O heavy is your code, because the HDD is the same.

How to check if I/O is the problem:
1. A lot of records in slow-query.log most of them SELECTs
2. Low CPU usage and High load averages (you can use for monitoring)
To monitor the I/O activity, you can install iotop ;-)