Additional languages
MySQL 5.1 Reference Manual :: 15 MySQL Cluster
« 14.12 The BLACKHOLE 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 Cluster 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. MySQL Cluster Replication
15.10.1. Abbreviations and Symbols
15.10.2. Assumptions and General Requirements
15.10.3. Known Issues
15.10.4. Replication Schema and Tables
15.10.5. Preparing the Cluster for Replication
15.10.6. Starting Replication (Single Replication Channel)
15.10.7. Using Two Replication Channels
15.10.8. Implementing Failover with MySQL Cluster
15.10.9. MySQL Cluster Backups With Replication
15.11. MySQL Cluster Disk Data Tables
15.11.1. Disk Data Objects
15.11.2. Disk Data Storage Requirements
15.11.3. Disk Data Configuration Parameters
15.12. Using High-Speed Interconnects with MySQL Cluster
15.12.1. Configuring MySQL Cluster to use SCI Sockets
15.12.2. Understanding the Impact of Cluster Interconnects
15.13. Known Limitations of MySQL Cluster
15.14. MySQL Cluster Development Roadmap
15.14.1. MySQL Cluster Changes in MySQL 5.1
15.15. MySQL Cluster Glossary

Due to a build slippage, binary distributions of MySQL 5.1.12 contained neither NDB Cluster nor Partitioning. We apologize for any inconvenience. Please upgrade to 5.1.14. If you build from source, you can execute configure with the --with-ndbcluster and --with-partition options.

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.

MySQL 5.1 is currently available and supported on a number of platforms, including Linux, Solaris, Mac OS X, BSD, HP-UX, and many 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 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