Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




Chapter 16. MySQL Cluster

Table of Contents

16.1. MySQL Cluster Overview
16.2. Basic MySQL Cluster Concepts
16.2.1. MySQL Cluster Nodes, Node Groups, Replicas, and Partitions
16.3. Simple Multi-Computer How-To
16.3.1. Hardware, Software, and Networking
16.3.2. Multi-Computer Installation
16.3.3. Multi-Computer Configuration
16.3.4. Initial Startup
16.3.5. Loading Sample Data and Performing Queries
16.3.6. Safe Shutdown and Restart
16.4. MySQL Cluster Configuration
16.4.1. Building MySQL Cluster from Source Code
16.4.2. Installing the Software
16.4.3. Quick Test Setup of MySQL Cluster
16.4.4. Configuration File
16.5. Process Management in MySQL Cluster
16.5.1. MySQL Server Process Usage for MySQL Cluster
16.5.2. ndbd, the Storage Engine Node Process
16.5.3. ndb_mgmd, the Management Server Process
16.5.4. ndb_mgm, the Management Client Process
16.5.5. Command Options for MySQL Cluster Processes
16.6. Management of MySQL Cluster
16.6.1. MySQL Cluster Startup Phases
16.6.2. Commands in the Management Client
16.6.3. Event Reports Generated in MySQL Cluster
16.6.4. Single-User Mode
16.6.5. On-line Backup of MySQL Cluster
16.7. MySQL Cluster Replication
16.7.1. Abbreviations and Symbols
16.7.2. Assumptions and General Requirements
16.7.3. Known Issues
16.7.4. Replication Schema and Tables
16.7.5. Preparing the Cluster for Replication
16.7.6. Starting Replication (Single Replication Channel)
16.7.7. Using Two Replication Channels
16.7.8. Implementing Failover with MySQL Cluster
16.7.9. MySQL Cluster Backups With Replication
16.8. Using High-Speed Interconnects with MySQL Cluster
16.8.1. Configuring MySQL Cluster to use SCI Sockets
16.8.2. Understanding the Impact of Cluster Interconnects
16.9. Known Limitations of MySQL Cluster
16.10. MySQL Cluster Development Roadmap
16.10.1. MySQL Cluster Changes in MySQL 5.0
16.10.2. MySQL 5.1 Development Roadmap for MySQL Cluster
16.11. MySQL Cluster FAQ
16.12. MySQL Cluster Glossary

MySQL Cluster is a high-availability, high-redundancy version of MySQL adapted for the distributed computing environment. It uses the NDB Cluster storage engine to enable running several MySQL servers in a cluster. This storage engine is available in MySQL 5.1 binary releases and in RPMs compatible with most modern Linux distributions.

The operating systems on which MySQL Cluster is currently available are Linux, Mac OS X, and Solaris. (Some users have reported success with running MySQL Cluster on FreeBSD, although this is not yet officially supported by MySQL AB.) We are working to make Cluster run on all operating systems supported by MySQL, including Windows, and will update this page as new platforms are supported.

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

Additional resources

  Published under the terms of the GNU General Public License Design by Interspire