HOWTO: Apache & MySQL load balanced using only software

[flyjedi]

It had been challenging me for a while how to do it, so I thought I'd share now I've got it all working:

The Apache, HAProxy and Heartbeat bit:
http://bluhaloit.wordpress.com/2009/...pache-cluster/

The MySQL and mysql-proxy bit:
http://bluhaloit.wordpress.com/2009/...on-the-slaves/

End result is a replicated MySQL cluster, Apache cluster, and high availability load balancers in front of each, all with software.

[fujikofujio]

Very nice post thanks, I'm sure this will be useful to me one day, I'm actually looking for mysql replication.