HOME TOOLS PROJECTS LIBRARY CONTACT BLOG

Configurator for MySQL Cluster - version 3.1

alt

If you only want to run localhost, please use the Sandboxes!

If you haven't used the tool before, the check the readme for requirements etc!

Need monitoring? Check out CMON! Simple to setup and pre-built binaries for Linux 64-bit.

Update 2010-Apr-14 - Configurator generates configuration and scripts for MySQL Cluster Manager (in commercial version of MySQL Cluster).

Update 2010-Apr-27 - Try out MySQL Cluster 7.1.3 SPJ (PREVIEW, NO PROD, SRC ONLY)

Update 2010-Apr-28 - Fixed typo in stop-cluster.sh script (removed blank space between '> &' on line 30

General Cluster Settings

Cluster version:		We recommend MySQL Cluster 7.0 for general purpose. MySQL Cluster 7.0 has lot of new cool features (e.g multithreading, online add node). See here for more information about the features. There are prebuilt binaries for both versions, but the source releases are made more frequently. MySQL Cluster 6.3 - discontinued (no MySQL Support, use 7.1 instead) - will be removed MySQL Cluster 7.0 is GA MySQL Cluster 7.1.3 is GA. Based on 7.0 + new features: Cluster/J and ndb_info tables. MySQL Cluster 7.1.3-SPJ (PREVIEW) is not for production usage.
Platform		Platform must be homogenous across all computers in the cluster.
Number of management servers		Two management servers are recommended in a HA setup.
Number of Data Nodes:		You should have atleast two computers (for two data nodes). A good HA setup consists of four computers: 2 computers for data nodes and two computers for mysqlds and management servers.
Number of APIs (sql nodes, slapds):		You should have atleast two mysql servers for a HA setup.
Replication role:		None - the cluster will not be used in replication Master - the cluster will act as the replication master (one or more mysqlds will produce binary logs) Slave - the cluster will act as a standby cluster
PortNumber		This is the port the management server listens on. 1186 is the default port.
Config directory		This is where the config.ini and my.cnf files will be stored. The 'user' specified below must have write access to this directory. The 'user' must exist on all machines.
User		(recommended) user='root':management servers and data nodes will be running as root, mysql servers as 'mysql' user='user': management servers, data nodes and mysql servers will be running as 'user'
Using CMON?		If you use CMON, you will get one connection slot reserved for it on the same host as management server and (two slots maximum).

Configurator

Tools

Follow us on twitter