From single server to cluster
Our single server running a LAMP application at our coloc is getting slower, and I was thinking of putting X Apache servers as front-end, all connecting to a data server for MySQL + JPG. I've never done this before, and have a couple of questions:
1. Should I use NFS to connect the Apache servers to the MySQL server, or should I look at something else for higher performance (FireWire, etc.)?
2. In case we need to have more than one data server, what would you recommend for load balancing + data synchronization?