MySQL Cluster

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 Management Client

15.7.3. Event Reports Generated in MySQL Cluster

15.7.4. Single-User Mode

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. How to 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

15.9.2. ndb_delete_all

15.9.3. ndb_desc

15.9.4. ndb_drop_index

15.9.5. ndb_drop_table

15.9.6. ndb_error_reporter

15.9.7. ndb_print_backup_file

15.9.8. ndb_print_schema_file

15.9.9. ndb_print_sys_file

15.9.10. ndb_select_all

15.9.11. ndb_select_count

15.9.12. ndb_show_tables

15.9.13. ndb_size.pl

15.9.14. ndb_waiter

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 Storage

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 FAQ

15.16. 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.

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 maintained by the MySQL Support Team on the MySQL AB website.

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 .

Additional resources

• Answers to some commonly asked questions about Cluster may be found in the Section 15.15, “MySQL Cluster FAQ”.

• The MySQL Cluster mailing list: .

• The MySQL Cluster Forum: .

• Many MySQL Cluster users and some of the MySQL Cluster developers blog about their experiences with Cluster, and make feeds of these available through .

• 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.