I'm hoping you can help me out. We've built an application for Real Estate agents to work with open data that they can synchronize with their MLS listings...
We've integrated everything to work with Wordpress and have chosen WPMU as our main service platform. We've gone through many of your plugins and installed many of them... pro sites, google analytics, support system, etc.
I'm running into some trouble with scaling that platform properly under some of our staging environment tests and I wanted to pick your brain in terms of architecture and best database and server setups...
We currently have lightspeed server running on CENTOS 6.5 64 bit with WHM/CPANEL servicing our main wpmu domain.
Current Server Specs:
12 GHZ dedicated CPU
4096 MB RAM
75 GB San Storage
I've played around with using external or remote MYSQL database servers before, but I'm wondering if you have a go-to guide or a place or service provider that I might be able to do some digging and experiment with some of the best options and practices to scale this correctly.
We have several other servers and are on an auto-scaling cloud platform to scale as needs arise... but i guess specifically I'm the most concerned about cpu loads on the main wordpress server especially as we ad new clients.
If you could maybe tell me:
1. How I should calculate server resource usage for expansion in wpmu.
2. if it's worth getting an external/remote db for wordpress mu install, and what provider, or system I should look at.
3. Best CDN setup... have used both cloudfront and Max CDN before..
I guess it's a broad topic but if we start there hopefully I'll be able to save some time and headache based off your experience.
Thanks for your help in advance!