Optimal configuration for multiple WordPress websites

February 28, 2014 2.2k views
Hello everyone! Need some advice from the community. The story: I have several websites, all of them powered by WordPress. 2 are large news portals with lots of images (one currently has 18Gbs of images and 82Mb db, the second is much younger and has only 600Mb of pictures and 3Mb db). All other sites are small minimalistic blogs or kind of "static" small websites with WP backend and low traffic. Here's the "infrastructure" I'm considering: - Each large news site on separate droplet - All small sites on another droplet Questions: 1. What's better - Apace, Nginx, Apache with Nginx for static files in front of Apache? 2. Is it a good idea to use memcached on 512/1024Mb droplets? 3. What's better - 2 news sites on 2 separate 1024Mb droplets or both on one 2048Mb droplet? 4. Does it makes sense to have those 2 news websites on separate droplets (or single more powerful - see 3.) and 1 extra droplet just for MySQL? 5. Or maybe 1 droplet for both news sites under Apache (serving only WP itself), 1 separate droplet with MySQL and 1 more for static files under Nginx? Thanks in advance!
2 Answers
1. What's better - Apace, Nginx, Apache with Nginx for static files in front of Apache?
Nginx.
2. Is it a good idea to use memcached on 512/1024Mb droplets?
I don't see why not.
3. What's better - 2 news sites on 2 separate 1024Mb droplets or both on one 2048Mb droplet?
That depends on many factors, but hosting them on one droplet should be fine.
4. Does it makes sense to have those 2 news websites on separate droplets (or single more powerful - see 3.) and 1 extra droplet just for MySQL?
I would move MySQL (you should look into using MariaDB instead, which is a drop-in replacement of MySQL) to its own droplet and use it for all of the sites.
Kamal, thank you for the reply! I'm already convinced to move from Apache to Nginx and use a separate droplet for database. Other questions seem to be less important and it's pretty easy to make changes later and move sites from one droplet to another.
Have another answer? Share your knowledge.