« How MySQL Loads Configuration Options | Main | Bar Graphs with MySQL »

November 22, 2006

MySQL Cluster Setup, in a Single Screenshot

Have been meaning to post about the cluster setup I'm using for *functional* testing (not appropriate for performance testing or production environments).

The gist is that I'm using Parallels on OS X, running 4 nodes (1 management, 2 & 3 storage, 4 SQL) on 4 virtual machines. Each machine has between 128Mb and 256Mb of allocated RAM which isn't much for a cluster, but is as much as I can give from the 2Gb on the MacBook Pro. Each virtual machine has a version of MySQL 5.1.12 compiled from source. Actually, I built one VM with the compiled and installed source and then cloned that for the other 3 machines. The preferred flavor of Linux for these is Ubuntu server.

As I was setting up for a screenshot I walked through bringing the cluster online and with a little crafting was able to provide (I believe) the information in the screenshot for doing this elsewhere. On each machine screen (numbered 1-4 in order of startup) you can see the network settings, cluster configuration, and commands for starting the cluster up for the first time.

I'm not going to explain all the details, but if you've set up a cluster before you'll recognize the process here. If you haven't, take a walk through the MySQL docs and it might make some sense.

Posted by mike at November 22, 2006 12:15 AM