Tuesday, 27 January 2009

Tinkering with MySQL Cluster - Part 2 - Getting the software

The next step in my project is probably the most simple - getting hold of the software.

Go to MySQL's website and select to Download MySQL cluster. I chose to do the tar version for Solaris 10 SPARC 64bit, but there is also a package format installer.


Create a mysql user and group on each of the nodes - this user will own the MySQL software.

# mkdir /export/home
# groupadd -g 101 mysql
# useradd -g mysql -u 1001 -s /bin/ksh -d /export/home/mysql -m mysql
# gunzip mysql-cluster-gpl-6.3.20-solaris10-sparc-64bit.tar.gz
# tar xf mysql-cluster-gpl-6.3.20-solaris10-sparc-64bit.tar

Then you copy the directory to /usr/local/bin and create a symbolic link to it

# mkdir /usr/local/bin

# mv mysql-cluster-gpl-6.3.20-solaris10-sparc-64bit /usr/local/bin
# cd /usr/local/bin
# ln -s mysql-cluster-gpl-6.3.20-solaris10-sparc-64bit mysql

You don't actually need the full software directory on every node, but to allow me to repurpose nodes as necessary I'm taking the full software

Change the software owner and group on the MySQL software to help secure the installation

# cd /usr/local/bin
# chown -R mysql mysql
# chgrp -R mysql mysql
Well, that's the software installed on the nodes. As part of this process I noticed that the disk in use for pup3's root partition is heading off to the great computer scrapyard in the sky so this node may no longer be part of the configuration.
Then you copy the directory to /usr/local/bin and create a symbolic link to it

# mkdir /usr/local/bin

# mv mysql-cluster-gpl-6.3.20-solaris10-sparc-64bit /usr/local/bin
# cd /usr/local/bin
# ln -s mysql-cluster-gpl-6.3.20-solaris10-sparc-64bit mysql

You don't actually need the full software directory on every node, but to allow me to repurpose nodes as necessary I'm taking the full software

Change the software owner and group on the MySQL software to help secure the installation

# cd /usr/local/bin
# chown -R mysql mysql
# chgrp -R mysql mysql

Well, that's the software installed on the nodes. As part of this process I noticed that the disk in use for pup3's root partition is heading off to the great computer scrapyard in the sky so this node may no longer be part of the configuration.

No comments:

Post a Comment