MySQL Cluster
Section Navigation [Toggle]
- MySQL Cluster
- Preface and Legal Notices
- 1 MySQL Cluster NDB 6.1 - 7.1
- 2 Preface and Notes
- 3 MySQL Cluster Overview
- 4 MySQL Cluster Installation and Upgrades
- 5 MySQL Cluster Configuration
- 6 MySQL Cluster Programs
- 7 Management of MySQL Cluster
- 8 MySQL Cluster Replication
- A Licenses for Third-Party Components
- B MySQL 5.1 FAQ: MySQL Cluster
Abstract
This is the MySQL Cluster extract from the MySQL 5.1 Reference Manual.
Document generated on: 2013-05-23 (revision: 35249)
Table of Contents [+/-]
- Preface and Legal Notices
- 1. MySQL Cluster NDB 6.1 - 7.1
- 2. Preface and Notes
- 3. MySQL Cluster Overview [+/-]
- 3.1. MySQL Cluster Core Concepts
- 3.2. MySQL Cluster Nodes, Node Groups, Replicas, and Partitions
- 3.3. MySQL Cluster Hardware, Software, and Networking Requirements
- 3.4. MySQL Cluster Development History [+/-]
- 3.4.1. MySQL Cluster Development in MySQL Cluster NDB 7.2.0
- 3.4.2. MySQL Cluster Development in MySQL Cluster NDB 7.1
- 3.4.3. MySQL Cluster Development in MySQL Cluster NDB 7.0
- 3.4.4. MySQL Cluster Development in MySQL Cluster NDB 6.3
- 3.4.5. MySQL Cluster Development in MySQL Cluster NDB 6.2
- 3.4.6. MySQL Cluster Development in MySQL Cluster NDB 6.1
- 3.4.7. Development History of MySQL Cluster in MySQL 5.1
- 3.5. MySQL Server Using
InnoDBCompared with MySQL Cluster [+/-] - 3.6. Known Limitations of MySQL Cluster [+/-]
- 3.6.1. Noncompliance with SQL Syntax in MySQL Cluster
- 3.6.2. Limits and Differences of MySQL Cluster from Standard MySQL Limits
- 3.6.3. Limits Relating to Transaction Handling in MySQL Cluster
- 3.6.4. MySQL Cluster Error Handling
- 3.6.5. Limits Associated with Database Objects in MySQL Cluster
- 3.6.6. Unsupported or Missing Features in MySQL Cluster
- 3.6.7. Limitations Relating to Performance in MySQL Cluster
- 3.6.8. Issues Exclusive to MySQL Cluster
- 3.6.9. Limitations Relating to MySQL Cluster Disk Data Storage
- 3.6.10. Limitations Relating to Multiple MySQL Cluster Nodes
- 3.6.11. Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x
- 4. MySQL Cluster Installation and Upgrades [+/-]
- 4.1. Installing MySQL Cluster on Linux [+/-]
- 4.2. Installing MySQL Cluster on Windows [+/-]
- 4.3. Initial Configuration of MySQL Cluster
- 4.4. Initial Startup of MySQL Cluster
- 4.5. MySQL Cluster Example with Tables and Data
- 4.6. Safe Shutdown and Restart of MySQL Cluster
- 4.7. Upgrading and Downgrading MySQL Cluster [+/-]
- 5. MySQL Cluster Configuration [+/-]
- 5.1. Quick Test Setup of MySQL Cluster
- 5.2. MySQL Cluster Configuration Files [+/-]
- 5.2.1. MySQL Cluster Configuration: Basic Example
- 5.2.2. Recommended Starting Configurations for MySQL Cluster NDB 6.2 and Later
- 5.2.3. The MySQL Cluster Connectstring
- 5.2.4. Defining Computers in a MySQL Cluster
- 5.2.5. Defining a MySQL Cluster Management Server
- 5.2.6. Defining MySQL Cluster Data Nodes
- 5.2.7. Defining SQL and Other API Nodes in a MySQL Cluster
- 5.2.8. MySQL Cluster TCP/IP Connections
- 5.2.9. MySQL Cluster TCP/IP Connections Using Direct Connections
- 5.2.10. MySQL Cluster Shared-Memory Connections
- 5.2.11. SCI Transport Connections in MySQL Cluster
- 5.2.12. Configuring MySQL Cluster Parameters for Local Checkpoints
- 5.2.13. Configuring MySQL Cluster Send Buffer Parameters
- 5.3. Overview of MySQL Cluster Configuration Parameters [+/-]
- 5.4. MySQL Server Options and Variables for MySQL Cluster [+/-]
- 5.5. Using High-Speed Interconnects with MySQL Cluster [+/-]
- 6. MySQL Cluster Programs [+/-]
- 6.1. ndbd — The MySQL Cluster Data Node Daemon
- 6.2. ndbinfo_select_all — Select From ndbinfo Tables
- 6.3. ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)
- 6.4. ndb_mgmd — The MySQL Cluster Management Server Daemon
- 6.5. ndb_mgm — The MySQL Cluster Management Client
- 6.6. ndb_config — Extract MySQL Cluster Configuration Information
- 6.7. ndb_cpcd — Automate Testing for NDB Development
- 6.8. ndb_delete_all — Delete All Rows from an NDB Table
- 6.9. ndb_desc — Describe NDB Tables
- 6.10. ndb_drop_index — Drop Index from an NDB Table
- 6.11. ndb_drop_table — Drop an NDB Table
- 6.12. ndb_error_reporter — NDB Error-Reporting Utility
- 6.13. ndb_index_stat — NDB Index Statistics Utility
- 6.14. ndb_print_backup_file — Print NDB Backup File Contents
- 6.15. ndb_print_schema_file — Print NDB Schema File Contents
- 6.16. ndb_print_sys_file — Print NDB System File Contents
- 6.17. ndbd_redo_log_reader — Check and Print Content of Cluster Redo Log
- 6.18. ndb_restore — Restore a MySQL Cluster Backup
- 6.19. ndb_select_all — Print Rows from an NDB Table
- 6.20. ndb_select_count — Print Row Counts for NDB Tables
- 6.21. ndb_show_tables — Display List of NDB Tables
- 6.22. ndb_size.pl — NDBCLUSTER Size Requirement Estimator
- 6.23. ndb_waiter — Wait for MySQL Cluster to Reach a Given Status
- 6.24. Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs
- 7. Management of MySQL Cluster [+/-]
- 7.1. Summary of MySQL Cluster Start Phases
- 7.2. Commands in the MySQL Cluster Management Client
- 7.3. Online Backup of MySQL Cluster [+/-]
- 7.4. MySQL Server Usage for MySQL Cluster
- 7.5. Performing a Rolling Restart of a MySQL Cluster
- 7.6. Event Reports Generated in MySQL Cluster [+/-]
- 7.7. MySQL Cluster Log Messages [+/-]
- 7.8. MySQL Cluster Single User Mode
- 7.9. Quick Reference: MySQL Cluster SQL Statements
- 7.10. The
ndbinfoMySQL Cluster Information Database [+/-] - 7.10.1. The
ndbinfo arbitrator_validity_detailTable - 7.10.2. The
ndbinfo arbitrator_validity_summaryTable - 7.10.3. The
ndbinfo blocksTable - 7.10.4. The
ndbinfo cluster_operationsTable - 7.10.5. The
ndbinfo cluster_transactionsTable - 7.10.6. The
ndbinfo config_paramsTable - 7.10.7. The
ndbinfo countersTable - 7.10.8. The
ndbinfo diskpagebufferTable - 7.10.9. The
ndbinfo logbuffersTable - 7.10.10. The
ndbinfo logspacesTable - 7.10.11. The
ndbinfo membershipTable - 7.10.12. The
ndbinfo memoryusageTable - 7.10.13. The
ndbinfo nodesTable - 7.10.14. The
ndbinfo poolsTable - 7.10.15. The
ndbinfo resourcesTable - 7.10.16. The
ndbinfo server_operationsTable - 7.10.17. The
ndbinfo server_transactionsTable - 7.10.18. The
ndbinfo threadblocksTable - 7.10.19. The
ndbinfo threadstatTable - 7.10.20. The
ndbinfo transportersTable
- 7.10.1. The
- 7.11. MySQL Cluster Security Issues [+/-]
- 7.12. MySQL Cluster Disk Data Tables [+/-]
- 7.13. Adding MySQL Cluster Data Nodes Online [+/-]
- 7.14. Distributed MySQL Privileges for MySQL Cluster
- 7.15. NDB API Statistics Counters and Variables
- 8. MySQL Cluster Replication [+/-]
- 8.1. MySQL Cluster Replication: Abbreviations and Symbols
- 8.2. General Requirements for MySQL Cluster Replication
- 8.3. Known Issues in MySQL Cluster Replication
- 8.4. MySQL Cluster Replication Schema and Tables
- 8.5. Preparing the MySQL Cluster for Replication
- 8.6. Starting MySQL Cluster Replication (Single Replication Channel)
- 8.7. Using Two Replication Channels for MySQL Cluster Replication
- 8.8. Implementing Failover with MySQL Cluster Replication
- 8.9. MySQL Cluster Backups With MySQL Cluster Replication [+/-]
- 8.10. MySQL Cluster Replication: Multi-Master and Circular Replication
- 8.11. MySQL Cluster Replication Conflict Resolution
- A. Licenses for Third-Party Components [+/-]
- A.1. Ant-Contrib License
- A.2. ANTLR 3 License
- A.3. ANTLR 3.3 License
- A.4. Boost Library License
- A.5. c3p0 JDBC Library License
- A.6.
dtoa.cLicense - A.7. Editline Library (
libedit) License - A.8.
FindGTest.cmakeLicense - A.9. Fred Fish's Dbug Library License
- A.10.
getargLicense - A.11. GLib License (for MySQL Proxy)
- A.12. GNU General Public License Version 2.0, June 1991
- A.13. GNU Lesser General Public License Version 2.1, February 1999
- A.14. GNU Libtool License
- A.15. GNU Readline License
- A.16. Google Controlling Master Thread I/O Rate Patch License
- A.17. Google Perftools (TCMalloc utility) License
- A.18. Google SMP Patch License
- A.19. jboss-common-jdbc-wrapper.jar License
- A.20.
lib_sql.ccLicense - A.21.
libeventLicense - A.22. Libiconv License
- A.23.
libintlLicense - A.24. Linux-PAM License
- A.25.
LPegLibrary License - A.26. Lua (liblua) License
- A.27.
LuaFileSystemLibrary License - A.28. md5 (Message-Digest Algorithm 5) License
- A.29.
memcachedLicense - A.30. nt_servc (Windows NT Service class library) License
- A.31. OpenPAM License
- A.32. OpenSSL v1.0 License
- A.33. Paramiko License
- A.34. PCRE License
- A.35. Percona Multiple I/O Threads Patch License
- A.36. RegEX-Spencer Library License
- A.37. RFC 3174 - US Secure Hash Algorithm 1 (SHA1) License
- A.38. Richard A. O'Keefe String Library License
- A.39. SHA-1 in C License
- A.40. Simple Logging Facade for Java (SLF4J) License
- A.41.
zlibLicense - A.42. ZLIB.NET License
- B. MySQL 5.1 FAQ: MySQL Cluster
Copyright © 1997, 2013, Oracle and/or its affiliates. All
rights reserved.
Legal Notices
