I should say, "How do I set up a load balanced cluser". I am not a sysadmin of any merit.. apt-getted and yum installed my way to some stacks in the cloud but nothing fancy.
Now I have a problem with a Drupal site that has gone beyond its hardware's capabilities. There are two servers behind a firewall, the application server which is hitting 90%+ during extra-peak times and the db/solr server which is rarely above 10% (typically 3-4) at those same times. These are managed physical hardware. DB is very read heavy.
Financially it makes sense to move these to the cloud anyway, even without a configuration change.
So what I have imagined is a load balancer running mod_proxy balancing requests between 2 (I would like to have something that magically grows) application servers synced with nfs talking to one DB server.
Currently the application server is a DELL PowerEdge 2950 MKIII with 32gb of ram, 2.5ghz x 4. Db is the same with half the ram. Both have 15000 rpm raid 1 setups.
So really, it seems doable. The load balancer upfront seems like it doesn't have to be anything at all, maybe a 1GB image?
I saw somewhere that there can be issues with cookies if the user switches servers mid-session, can anyone speak to that?
Any general advice, places to learn more, etc.. keeping in mind I really just want to knock this out rather than become an expert.