For those of you with high traffic sites or would like to add some redundancy to your MySQL database, clustering is a very good starting point. That is assuming that you have about 4 or 5 machines that you can spare. Howto Forge has a great tutorial on setting this up on 4 machines using MySQL 5 Cluster. The setup requires two storage nodes and one management node and two nodes for load balancing. The example utilizes 4 machines by loading the cluster management server onto one of the load balancing machines. Read the rest of this entry »