Okay. So this has been the biggest headache I've ever dealt with in the 'online world'.
I have a quad core server right now with 4gb of ram hosted through inmotion hosting. I've had some SERIOUS issues with CPU load. I've split it up into 4 accounts, each account hosting anywhere between 5-15 wordpress sites.
My CPU load is shooting through the roof and hits well above 4 every 15 min or so and hits as high as 200/300 and then crashes. When running 2 accounts, the load normally stays below 2, but does have it's occasional spikes to 6ish.
I don't think this can work with this server anymore, so I'm thinking about either upgrading the server or buying a second server or possibly even a third. My accounts look like this right now
Account #1: 14 sites Account #2: 11 sites Account #3: 5 sites Account #4: 8 sites
Running 14 sites/server is pretty safe I'd say. I don't have very much traffic at all and I think a lot of this has to do with the fact that my server keeps crashing or is way too slow.
The hosting company keeps saying that it has to do with the way that I've coded my scripts, but I've recoded to make the PHP scripts run faster, and the problem is still going strong. When I run 2 smaller accounts, then there's no problems at all.
Any ideas on what I should do here? I'd like to stay with inmotion hosting, but if it just won't work, then I'll have to migrate somewhere else. I'm on the Advanced Dedicated Server (http://www.inmotionhosting.com/dedicated_servers.html
) and I'm thinking of either buying an elite server as well as keeping the the advanced, or going for the "Commercial Class 1" or the "Commercial Class 2 - 24 Threads!"
If anyone can provide some sound advice, I'd GREATLY appreciate it. The last thing I want to do is spend days upon days trying to fix this issue when it probably can't be fixed with this 1 server. If you have any other recommendations for hosting that could be more affordable and do the trick, I'd appreciate any links as well.
Or would it be better to go with cloud hosting? I know nothing about it, but I see a lot of apps being used on the cloud. The load is going crazy from thousands of cron scripts that I run which grabs data and inserts it into MySQL