Additional languages
« 14.10 The ISAM Storage Engine
15.1 MySQL Cluster Overview »
Section Navigation      [Toggle]

Chapter 15. MySQL Cluster

Table of Contents

15.1. MySQL Cluster Overview
15.2. Basic MySQL Cluster Concepts
15.2.1. MySQL Cluster Nodes, Node Groups, Replicas, and Partitions
15.3. Simple Multi-Computer How-To
15.3.1. Hardware, Software, and Networking
15.3.2. Multi-Computer Installation
15.3.3. Multi-Computer Configuration
15.3.4. Initial Startup
15.3.5. Loading Sample Data and Performing Queries
15.3.6. Safe Shutdown and Restart
15.4. MySQL Cluster Configuration
15.4.1. Building MySQL Cluster from Source Code
15.4.2. Installing the Software
15.4.3. Quick Test Setup of MySQL Cluster
15.4.4. Configuration File
15.4.5. Overview of Cluster Configuration Parameters
15.4.6. Configuring Parameters for Local Checkpoints
15.5. Upgrading and Downgrading MySQL Cluster
15.5.1. Performing a Rolling Restart of the Cluster
15.5.2. Cluster Upgrade and Downgrade Compatibility
15.6. Process Management in MySQL Cluster
15.6.1. MySQL Server Process Usage for MySQL Cluster
15.6.2. ndbd — The Storage Engine Node Process
15.6.3. ndb_mgmd — The Management Server Process
15.6.4. ndb_mgm — The Management Client Process
15.6.5. Command Options for MySQL Cluster Processes
15.7. Management of MySQL Cluster
15.7.1. MySQL Cluster Startup Phases
15.7.2. Commands in the MySQL Cluster Management Client
15.7.3. Event Reports Generated in MySQL Cluster
15.7.4. Single User Mode
15.7.5. Quick Reference: MySQL Cluster SQL Statements
15.8. On-line Backup of MySQL Cluster
15.8.1. Cluster Backup Concepts
15.8.2. Using The Management Client to Create a Backup
15.8.3. ndb_restore — Restore a Cluster Backup
15.8.4. Configuration for Cluster Backup
15.8.5. Backup Troubleshooting
15.9. Cluster Utility Programs
15.9.1. ndb_config — Extract NDB Configuration Information
15.9.2. ndb_cpcd — Extract NDB Configuration Information
15.9.3. ndb_delete_all — Delete All Rows from NDB Table
15.9.4. ndb_desc — Describe NDB Tables
15.9.5. ndb_drop_index — Drop Index from NDB Table
15.9.6. ndb_drop_table — Drop NDB Table
15.9.7. ndb_error_reporter — NDB Error-Reporting Utility
15.9.8. ndb_print_backup_file — Print NDB Backup File Contents
15.9.9. ndb_print_schema_file — Print NDB Schema File Contents
15.9.10. ndb_print_sys_file — Print NDB System File Contents
15.9.11. ndb_select_all — Print Rows from NDB Table
15.9.12. ndb_select_count — Print Row Counts for NDB Tables
15.9.13. ndb_show_tables — Display List of NDB Tables
15.9.14. ndb_size.pl — NDBCluster Size Requirement Estimator
15.9.15. ndb_waiter — Wait for Cluster to Reach a Given Status
15.10. Using High-Speed Interconnects with MySQL Cluster
15.10.1. Configuring MySQL Cluster to use SCI Sockets
15.10.2. Understanding the Impact of Cluster Interconnects
15.11. Known Limitations of MySQL Cluster
15.12. MySQL Cluster FAQ
15.13. 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 and in binary releases from MySQL-Max 4.1.3. Beginning with MySQL 4.1.10a, it is also available in RPMs compatible with most modern Linux distributions. (If you install using RPM files, note that both the mysql-server and mysql-max RPMs must be installed to have MySQL Cluster capability.)

MySQL Cluster is currently available and supported on the following platforms:

  • Linux: x86, AMD64, EMT64, s/390, PPC, Alpha, SPARC, UltraSparc

  • Solaris: SPARC, UltraSparc, x86, AMD64, EMT64

  • BSD (FreeBSD, NetBSD, OpenBSD): x86, AMD64, EMT64, PPC

  • Mac OS X: PPC

  • HP-UX: PA-RISC

  • Tru64: Alpha

  • OpenVMS: Alpha

  • IRIX: MIPS

  • Novell Netware: x86

  • QNX Neutrino: x86

  • SCO OpenServer, OpenUnix, UnixWare: x86

For exact levels of support available for MySQL Cluster 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 AB Web site.

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.

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