ndbinstaller
- version 0.2 released 10/10/2007, new features
ndbinstaller is a bash script to install and manage a MySQL Cluster, developed by Jim Dowling, working at SICS.
- Video Demo of how to install and run MySQL Cluster on a single host in under 5 minutes using ndbinstaller!
- Video Demo of how to install and run MySQL Cluster on 3 hosts in under 20 minutes using ndbinstaller.
- ClusterBestPractices
Download the script
Option 1 (Browser-based): Right-Click here and click "Save Link as" and save the ndbinstaller.sh file in a local directory (for example, /tmp/).
Option 2 (Command-line):
wget http://www.jimdowling.info/ndbinstaller/trunk/ndbinstaller.sh # or svn co http://www.jimdowling.info/ndbinstaller/trunk/ ndbinstaller
Installation of MySQL Cluster on a Single Host
This option is recommended for beginners or for testing MySQL Cluster on a single computer.
- Quickstart Installation Instructions for a Localhost Cluster Installation
- Detailed Installation Instructions for a Localhost Cluster Installation
Installation of a Distributed MySQL Cluster (on more than 1 machine)
This option is for setting up a MySQL Cluster to run over several computers. Both root and non-root user supported.
- Quickstart Installation Instructions for an installation of a distributed cluster
- Detailed Installation Instructions for an installation of a distributed cluster
Managing a Cluster
- Quickstart guide for managing your cluster
- Detailed Description of Cluster Management using the generated scripts
Using Latest Build of MySQL Cluster
MySQL have, as of August 2007, changed their policy of releasing binaries with every build. They will now be released twice a year. Here are instructions for how to build MySQL Cluster (community) from source, and then install using ndbinstaller.sh:
* Build MySQL Cluster Community Server from source
NDB/J
When using the Java connector, : NDB/J, to program NDB applications, set NDBJ_HOME to enable the sample programs to find the NDB/J libraries:
# Normal User Installation (bash) export NDBJ_HOME=/home/yourusername/.mysql/ # Root User Installation (bash) export NDBJ_HOME=/usr/local/mysql
Current Issues
- This script currently installs version 5.1.22 of cluster. When bug 31315 is fixed, the default table type will be changed to 'ndb'.
- You may get the following error if your machine has hostname "localhost". To resolve this, use hostname to enter a hostname for the machine. Another way to enter a hostname is to edit /etc/sysconfig/network (fedora) or /etc/hostname (debian/ubuntu).
ERROR: 1062 Duplicate entry 'localhost-' for key 1
Bug Reporting and Feature Requests
Please first read the existing reports to see if your bug or feature has already been submitted.
If your bug/feature has not been submitted, create a new report to report your bug or request a new feature.
You can also mail me at jdowling-at-sics.se if you have any questions, or send a mail to the MySQL Cluster list, cluster-at-lists.mysql.com .
MySQL Cluster Resources
- : MySQL Cluster Manual
- MySQL Cluster Expert: Johan Andersson's Blog
- Adding a Load-Balancer to the Cluster using Linux Virtual IP and Heartbeat
Other Links
- Monit and Munin can be used to manage Cluster processes (ndb_mgmd, ndbd) and view system statistics, respectively.
