« 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

Hard Drive Recovery Group offers hard disk data recovery services for RAID, laptops and servers. Complete clean room and hard drive repair service.

Trackback Pings

TrackBack URL for this entry:
http://mike.kruckenberg.com/mt/mt-tb.cgi/956

Listed below are links to weblogs that reference MySQL Cluster Setup, in a Single Screenshot:

» Mike Kruckenberg: MySQL Cluster Setup, in a Single Screenshot from Chuqui 3.0
Mike Kruckenberg: 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 Paralle... [Read More]

Tracked on November 23, 2006 11:11 PM

Comments

Post a comment




Remember Me?