The question I have is very basic, I understand what load balancing is and how it works, however I can't visualize it in practice.
Lets say I have an AMP application running on a server. One day traffic gets too great and I must start to balance the load and I add another server. I already have all of my data stored on the first one so what would I put on that server? I could copy the website's files but my database would still be on the first server and I would still have to connect to it from my new one, so that doesn't seem like a good solution? I could add a third server and make that a MySQL server and use that to store my data and have my Apache servers connect to that, but that doesn't seem like a good solution either because I would still have all requests getting data from a single place.
How is that done in reality?