MySQL™ Cluster Manager 1.1.6 User Manual

Abstract

Deprecated release series.  MySQL Cluster Manager 1.1 has been superseded by MySQL Cluster Manager 1.2, which adds new features and incorporates fixes to bugs found in MySQL Cluster Manager 1.1. MySQL Cluster Manager 1.1 is now considered obsolete, and is no longer available for new installations; users of MySQL Cluster Manager 1.1 should upgrade to MySQL Cluster Manager 1.2. Thus, this document is archival in nature, and no longer actively maintained. Documentation for the most recent MySQL Cluster Manager 1.2 release can be found at http://dev.mysql.com/doc//mysql-cluster-manager/1.2/en/. You can obtain documentation for the most recent releases of MySQL Cluster and related products at http://dev.mysql.com/doc//index-cluster.html.

This is the User Manual for the MySQL™ Cluster Manager, version 1.1.6. It documents the MySQL Cluster Manager Agent and MySQL Cluster Manager Client software applications which can be used to administer MySQL Cluster, a version of the MySQL Database System (referred to hereafter as MySQL Server or simply MySQL) that incorporates the NDB storage engine for high availability and data redundancy in a distributed computing environment.

This Manual applies to MySQL Cluster Manager 1.1.6 and contains information that may not apply to older versions of the MySQL Cluster Manager software. For documentation covering previous MySQL Cluster Manager releases, see MySQL Documentation: MySQL Cluster, on the MySQL website.

MySQL Cluster Manager features.  This manual describes features that may not be included in every version of MySQL Cluster Manager, and such features may not be included in the version of MySQL Cluster Manager licensed to you. If you have any questions about the features included in your version of MySQL Cluster Manager, refer to your MySQL Cluster Manager license agreement or contact your Oracle sales representative.

MySQL Cluster Manager, MySQL Server, and MySQL Cluster features.  This manual contains certain basic information about MySQL Server and MySQL Cluster; however, it is not in any way intended as an exhaustive reference for either of these products.

Current versions of MySQL Cluster compatible with MySQL Cluster Manager are based on versions 6.3, 7.0, 7.1, and 7.2 of the NDB storage engine; these versions of MySQL Cluster are known as MySQL Cluster NDB 6.3, MySQL Cluster NDB 7.0, MySQL Cluster NDB 7.1, and MySQL Cluster NDB 7.2. MySQL Cluster functionality varies between MySQL Cluster releases; MySQL Cluster Manager cannot supply or emulate MySQL Cluster features that are not present in the version of the MySQL Cluster software in use.

For complete information about MySQL Server and MySQL Cluster, please refer to the appropriate version of the MySQL Manual:

If you do not have the MySQL Server and MySQL Cluster documentation, you can obtain it free of charge from the MySQL Documentation Library, on the MySQL website.

For legal information, see the Legal Notices.

Document generated on: 2013-08-09 (revision: 35905)


Table of Contents

Preface and Legal Notices
1. Overview of MySQL Cluster Manager
1.1. MySQL Cluster Manager Terminology
1.2. MySQL Cluster Manager Architecture
2. MySQL Cluster Manager Installation, Configuration, Cluster Setup
2.1. Obtaining MySQL Cluster Manager
2.2. Operating Platform and MySQL Cluster Version Compatibility
2.3. MySQL Cluster Manager Agent Installation
2.3.1. Installing MySQL Cluster Manager on Unix Platforms
2.3.2. Installing MySQL Cluster Manager on Windows Platforms
2.4. MySQL Cluster Manager Configuration File
2.5. Starting and Stopping the MySQL Cluster Manager Agent
2.5.1. Starting and Stopping the Agent on Linux
2.5.2. Starting and Stopping the MySQL Cluster Manager Agent on Windows
2.5.3. Installing the MySQL Cluster Manager Agent as a Windows Service
2.6. Starting the MySQL Cluster Manager Client
2.7. Setting Up MySQL Clusters with MySQL Cluster Manager
2.7.1. Creating a MySQL Cluster with MySQL Cluster Manager
2.7.2. Migrating a MySQL Cluster to MySQL Cluster Manager
3. MySQL Cluster Manager Client Commands
3.1. Online Help for MySQL Cluster Manager Commands
3.2. MySQL Cluster Manager Site Commands
3.2.1. The create site Command
3.2.2. The delete site Command
3.2.3. The list sites Command
3.2.4. The add hosts Command
3.2.5. The list hosts Command
3.3. MySQL Cluster Manager Package Commands
3.3.1. The add package Command
3.3.2. The delete package Command
3.3.3. The list packages Command
3.4. MySQL Cluster Manager Cluster Commands
3.4.1. The create cluster Command
3.4.2. The delete cluster Command
3.4.3. The start cluster Command
3.4.4. The stop cluster Command
3.4.5. The restart cluster Command
3.4.6. The upgrade cluster Command
3.4.7. The list clusters Command
3.5. MySQL Cluster Manager Configuration Commands
3.5.1. The get Command
3.5.2. The set Command
3.5.3. The reset Command
3.6. The show status Command
3.7. The stop agents Command
3.8. MySQL Cluster Manager Process Commands
3.8.1. The add process Command
3.8.2. The start process Command
3.8.3. The stop process Command
3.8.4. The change process Command
3.8.5. The list processes Command
4. MySQL Cluster Manager Limitations and Known Issues
4.1. MySQL Cluster Manager Usage and Design Limitations
4.2. MySQL Cluster Manager 1.1.6 Limitations Relating to the MySQL Server
4.3. MySQL Cluster Manager Limitations Relating to MySQL Cluster
4.4. Syntax and Related Issues in MySQL Cluster Manager
A. Changes in MySQL Cluster Manager
B. Licenses for Third-Party Components Used in MySQL Cluster Manager 1.1.6
B.1. GLib License (for MySQL Cluster Manager)
B.2. GNU Lesser General Public License Version 2.1, February 1999
B.3. libevent License
B.4. libintl License
B.5. LPeg Library License
B.6. Lua (liblua) License
B.7. LuaFileSystem Library License
B.8. md5 (Message-Digest Algorithm 5) License
B.9. PCRE License
B.10. SHA-1 in C License
C. Attribute Summary Tables
Index