- Preface, Notes, Licenses
- 1 General Information
- 2 Installing and Upgrading MySQL
- 3 Tutorial
- 4 MySQL Programs
- 5 MySQL Server Administration
- 6 Backup and Recovery
- 7 Optimization
- 8 Language Structure
- 9 Internationalization and Localization
- 10 Data Types
- 11 Functions and Operators
- 12 SQL Statement Syntax
- 13 Storage Engines
- 14 High Availability and Scalability
- 15 MySQL Enterprise Monitor
- 16 Replication
- 17 MySQL Cluster
- 18 Stored Programs and Views
- 19 INFORMATION_SCHEMA Tables
- 20 Connectors and APIs
- 21 Extending MySQL
- A MySQL 5.0 Frequently Asked Questions
- B Errors, Error Codes, and Common Problems
- C MySQL Change History
- D Restrictions and Limits
- Index
- Standard Index
- C Function Index
- Command Index
- Function Index
- INFORMATION_SCHEMA Index
- Transaction Isolation Level Index
- JOIN Types Index
- Operator Index
- Option Index
- Privileges Index
- SQL Modes Index
- Status Variable Index
- Statement/Syntax Index
- System Variable Index
Table of Contents [+/-]
- 17.1. MySQL Cluster Overview [+/-]
- 17.2. MySQL Cluster Multi-Computer How-To [+/-]
- 17.2.1. MySQL Cluster Multi-Computer Installation
- 17.2.2. MySQL Cluster Multi-Computer Configuration
- 17.2.3. Initial Startup of MySQL Cluster
- 17.2.4. Loading Sample Data into MySQL Cluster and Performing Queries
- 17.2.5. Safe Shutdown and Restart of MySQL Cluster
- 17.2.6. Upgrading and Downgrading MySQL Cluster
- 17.3. MySQL Cluster Configuration [+/-]
- 17.4. MySQL Cluster Programs [+/-]
- 17.4.1. MySQL Server Usage for MySQL Cluster
- 17.4.2. ndbd — The MySQL Cluster Data Node Daemon
- 17.4.3. ndb_mgmd — The MySQL Cluster Management Server Daemon
- 17.4.4. ndb_mgm — The MySQL Cluster Management Client
- 17.4.5. ndb_config — Extract MySQL Cluster Configuration Information
- 17.4.6. ndb_cpcd — Automate Testing for NDB Development
- 17.4.7. ndb_delete_all — Delete All Rows from an NDB Table
- 17.4.8. ndb_desc — Describe NDB Tables
- 17.4.9. ndb_drop_index — Drop Index from an NDB Table
- 17.4.10. ndb_drop_table — Drop an NDB Table
- 17.4.11. ndb_error_reporter — NDB Error-Reporting Utility
- 17.4.12. ndb_print_backup_file — Print NDB Backup File Contents
- 17.4.13. ndb_print_schema_file — Print NDB Schema File Contents
- 17.4.14. ndb_print_sys_file — Print NDB System File Contents
- 17.4.15. ndb_restore — Restore a MySQL Cluster Backup
- 17.4.16. ndb_select_all — Print Rows from an NDB Table
- 17.4.17. ndb_select_count — Print Row Counts for NDB Tables
- 17.4.18. ndb_show_tables — Display List of NDB Tables
- 17.4.19. ndb_size.pl — NDBCLUSTER Size Requirement Estimator
- 17.4.20. ndb_waiter — Wait for MySQL Cluster to Reach a Given Status
- 17.4.21. Options Common to MySQL Cluster Programs
- 17.5. Management of MySQL Cluster [+/-]
- 17.5.1. Summary of MySQL Cluster Start Phases
- 17.5.2. Commands in the MySQL Cluster Management Client
- 17.5.3. Online Backup of MySQL Cluster
- 17.5.4. Event Reports Generated in MySQL Cluster
- 17.5.5. MySQL Cluster Log Messages
- 17.5.6. MySQL Cluster Single User Mode
- 17.5.7. Quick Reference: MySQL Cluster SQL Statements
- 17.5.8. MySQL Cluster Security Issues
This chapter contains information about MySQL
Cluster is a high-availability, high-redundancy version
of MySQL adapted for the distributed computing environment. It uses
the NDBCLUSTER storage engine to enable
running several computers with MySQL servers and other software in a
cluster. This storage engine is available in MySQL 5.0
binary releases and in RPMs compatible with most modern Linux
distributions.
MySQL Cluster is currently available and supported on a number of platforms, including Linux, Solaris, Mac OS X, 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 http://www.mysql.com/support/supportedplatforms/cluster.html, maintained by the MySQL Support Team on the MySQL web site.
Compatibility with standard MySQL.
While many standard MySQL schemas and applications can work using
MySQL Cluster, it is also true that unmodified applications and
database schemas may be slightly incompatible or have suboptimal
performance when run using MySQL Cluster (see
Section 17.1.5, “Known Limitations of MySQL Cluster”). Most of these issues
can be overcome, but this also means that you are very unlikely to
be able to switch an existing application datastore — that
currently uses, for example, MyISAM
or InnoDB — to use the
NDB storage engine without allowing
for the possibility of changes in schemas, queries, and
applications.
Beginning with MySQL Cluster NDB 7.0, MySQL Cluster is available for testing on Microsoft Windows (but not yet for production use). We are working to make Cluster available on all operating systems supported by MySQL; we will update the information provided here as this work continues. However, we do not plan to make MySQL Cluster available on Microsoft Windows in MySQL 5.0 or any other release series prior to MySQL Cluster NDB 7.0, which is based on MySQL 5.1. For more information, see MySQL Cluster NDB 6.X/7.X.
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 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.0 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.
User Comments
Add your own comment.