I have reached a state in my research where I understood that a database-driven web app (portal) can be optimised by replication / scaling (even sharding for huge db) and employing a solution like mysql replication or clustering (Percona).
The following question came up in my head as I was thinking...
"Ok, so database can be safely distributed to users. But what happens if my powerful machine 4 x Xeon CPUs + 16GB ram (max avail in this pack i'm getting) cannot survive to http requests?"
How can one tackle the apache / httpd load-balancing ? Are there any solutions for it ? Maybe it's very simple, but I don't see one right now.