HowtoForge: How To Set Up A Load-Balanced MySQL Cluster

[ Thanks to Falko
for this link. ]

“This tutorial shows how to configure a MySQL 5 cluster with
three nodes: two storage nodes and one management node. This
cluster is load-balanced by a high-availability load balancer that
in fact has two nodes that use the Ultra Monkey package which
provides heartbeat (for checking if the other node is still alive)
and ldirectord (to split up the requests to the nodes of the MySQL

“In this document I use Debian Sarge for all nodes. Therefore
the setup might differ a bit for other distributions. The MySQL
version I use in this setup is 5.0.19. If you do not want to use
MySQL 5, you can use MySQL 4.1 as well, although I haven’t tested