Folks, for my own learning, I want to learn how to configure and use HA Proxy. I want a simple setup like this:
One load balancer running HA Proxy and behind it are two webservers - A and B -both running Apache, Pressflow and Wordpress on each along with MariaDB databases on each.
What is the easiest way of setting this up as a load balanced failover cluster?
Also I have the following questions:
How will the databases and the contents on the servers be synchronized? - For e.g. if one adds a post with an attachment in A, how will server B pick it up? Will it be automatic?
Any guides to configure this? I want to learn how to do this.
What is the best OS to do this? Debian, Centos or FreeBSD?