MySQL :: MySQL 5.1 Reference Manual

This chapter contains information about MySQL Cluster, which is a high-availability, high-redundancy version of MySQL adapted for the distributed computing environment, using the NDB (also known as NDBCLUSTER) storage engine to enable running several MySQL servers in a cluster.

This storage engine is available in MySQL 5.1 binary releases through MySQL 5.1.23, including RPMs compatible with most modern Linux distributions. Beginning with MySQL 5.1.24, standard MySQL server binaries built by MySQL no longer provide support for the NDBCLUSTER storage engine. Instead, users of MySQL Cluster binaries built by MySQL should upgrade to MySQL Cluster NDB 6.2.15 (or a later MySQL Cluster release) which includes binary releases for supported platforms, including RPMs that should work with most Linux distributions. MySQL Cluster users who build from source should be aware that, also beginning with MySQL 5.1.24, NDBCLUSTER sources in the standard MySQL 5.1 tree are no longer maintained; these users should upgrade using the MySQL Cluster NDB 6.2.15, 6.3.16, or a later MySQL Cluster NDB 6.2 or 6.3 source release.

Note

MySQL Cluster NDB 6.1, 6.2, and 6.3 were formerly known as “MySQL Cluster Carrier Grade Edition”. Beginning with MySQL Cluster NDB 6.2.15 and MySQL Cluster NDB 6.3.14, this term is no longer applied to the MySQL Cluster software — which is now known simply as “MySQL Cluster” — but rather to a commercial licensing and support package. You can learn more about available options for commercial licensing of MySQL Cluster from MySQL Cluster Features, on the MySQL web site.

This chapter contains information about MySQL Cluster in MySQL 5.1 mainline releases through MySQL 5.1.23, MySQL Cluster NDB 6.2 releases through 5.1.30-ndb-6.2.17, and MySQL Cluster NDB 6.3 releases through 5.1.30-ndb-6.3.20. It also contains historical information about the MySQL Cluster NDB 6.1 series, although this series is no longer in active development.

Platforms supported. MySQL Cluster is currently available and supported on a number of platforms, including Linux, Solaris, Mac OS X, HP-UX, and other Unix-style operating systems on a variety of hardware. For exact levels of support available for on specific combinations of operating system versions, operating system distributions, and hardware platforms, please refer to the Cluster Supported Platforms list, maintained by the MySQL Support Team on the MySQL web site.

Important

MySQL Cluster is not currently supported on Microsoft Windows. We are working to make Cluster available on all operating systems supported by MySQL, including Windows, and will update the information provided here as this work continues.

Availability. MySQL Cluster NDB 6.2 binary and source packages are available for supported platforms from http://dev.mysql.com/downloads/cluster.

Note

Binary releases and RPMs are not available for MySQL Cluster NDB 6.2 prior to MySQL Cluster NDB 6.2.15.

MySQL Cluster NDB 6.3 is currently available only as source. Source tarballs for the latest MySQL Cluster NDB 6.3 release can be obtained from ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/.

MySQL Cluster versioning. Starting with MySQL Cluster NDB 6.1 and 6.2, MySQL Cluster follows a somewhat different release pattern from the mainline MySQL 5.1 Cluster series of releases. Each MySQL Cluster release is identified by a two-part version string, which is displayed by SELECT VERSION() in the mysql client, as shown here:

shell> mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.24-ndb-6.2.16-debug Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SELECT VERSION();
+-------------------------+
| VERSION()               |
+-------------------------+
| 5.1.24-ndb-6.2.16-debug |
+-------------------------+
1 row in set (0.00 sec)

This version string is also displayed in the output from the ndb_mgm client's SHOW command:

ndb_mgm> SHOW
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=1    @10.0.10.6  (mysql-5.1.24 ndb-6.2.15, Nodegroup: 0, Master)
id=2    @10.0.10.8  (mysql-5.1.24 ndb-6.2.15, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=3    @10.0.10.2  (mysql-5.1.24 ndb-6.2.15)

[mysqld(API)]   2 node(s)
id=4    @10.0.10.10  (mysql-5.1.24 ndb-6.2.15)
id=5 (not connected, accepting connect from any host)

The version string identifies the mainline MySQL version from which the MySQL Cluster release was branched and the version of the NDB storage engine used. For example, the full version string for MySQL Cluster NDB 6.1.15 (the first MySQL Cluster NDB 6.2 binary release, as shown in the preceding examples) is mysql-5.1.24 ndb-6.2.15. From this we can determine the following information:

The portion of the version string preceding ndb is the MySQL Server base version. This means that MySQL Cluster NDB 6.2.15 derives from the MySQL 5.1.24, and contains all feature enhancement and bugfixes from MySQL 5.1 up to and including MySQL 5.1.24.
The portion of the version string following ndb- represents the version number of the NDB (or NDBCLUSTER) storage engine. MySQL Cluster NDB 6.2.15 uses version 6.2.15 of the NDB storage engine.

MySQL Cluster development source trees. MySQL Cluster development trees can also be accessed via https://code.launchpad.net/~mysql/:

The MySQL Cluster development sources maintained at https://code.launchpad.net/~mysql/ are GPL-licensed. For information about obtaining MySQL sources using Bazaar and building them yourself, see Section 2.9.3, “Installing from the Development Source Tree”.

Currently, MySQL Cluster NDB 6.2 and MySQL Cluster NDB 6.3 are both under active development, with the 6.2 series now available in source and binary format and 6.3 as source only. MySQL Cluster NDB 6.4 is beginning to be developed internally and is intended for testing purposes. MySQL Cluster NDB 6.1 is no longer in active development. For an overview of major features added in MySQL Cluster, see Section 17.15, “MySQL Cluster Development Roadmap”.

This chapter represents a work in progress, and its contents are subject to revision as MySQL Cluster continues to evolve. Additional information regarding MySQL Cluster can be found on the MySQL AB Web site at http://www.mysql.com/products/cluster/.

Additional resources. More information may be found in the following places:

Answers to some commonly asked questions about Cluster may be found in the Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”.
The MySQL Cluster mailing list: http://lists.mysql.com/cluster.
The MySQL Cluster Forum: http://forums.mysql.com/list.php?25.
Many MySQL Cluster users and some of the MySQL Cluster developers blog about their experiences with Cluster, and make feeds of these available through PlanetMySQL.
If you are new to MySQL Cluster, you may find our Developer Zone article How to set up a MySQL Cluster for two servers to be helpful.

Chapter 17. MySQL Cluster

Note

Important

Note

User Comments