Suppose I have a load balanced cluster with three servers that are all for example.com. I have example.com/newsection/ and want /newsection/ to only use one server in that cluster. Is this possible in Apache (or otherwise)? How?
How much traffic you are receiving? You can offload Mysql to a different server to improve the performance or have one mysql and multiple web servers and load balance using round robin.
To set up load-balancer, you may use apache modules mod_proxy and mod_proxy_balancer. http://httpd.apache.org/docs/2.2/mod/mod_proxy.html http://httpd.apache.org/docs/2.2/mod..._balancer.html