So I have three rack servers here, the main one connected to the WWW and has a public ip, its running HAProxy set up to point to the other two servers.
The other two are running apache which a cron rsync job is downloading the web files to them from a directory on the master controller server.
It all works fine but, I'm currently running MySQL on the control server but I want it to work like the apache and haproxy system is. What are the way to do this?
Also say if a user is on wordpress and uploads a file/image for a post, it is only stored on the local server which the files get overwritten by rsync every 1min. How do I do a merge of directories?
btw, All three servers are Ubuntu 10.04 server