MySQL Cluster Manager 1.1 User Manual
Table of Contents
Preface . vii
1. Overview of MySQL Cluster Manager .1
1.1. MySQL Cluster Manager Terminology . .1
1.2. MySQL Cluster Manager Architecture 1
2. MySQL Cluster Manager Installation, Configuration, Cluster Setup 4
2.1. Obtaining MySQL Cluster Manager 4
2.2. Operating Platform and MySQL Cluster Version Compatibility.4
2.3. MySQL Cluster Manager Agent Installation 4
2.4. Contents of the MySQL Cluster Manager Distribution Archive.5
2.5. MySQL Cluster Manager Configuration File . .6
2.6. Starting the MySQL Cluster Manager Agent . .7
2.7. Starting the MySQL Cluster Manager Client . .8
2.8. Setting Up MySQL Clusters with MySQL Cluster Manager . .9
2.8.1. Creating a MySQL Cluster with MySQL Cluster Manager 10
2.8.2. Migrating a MySQL Cluster to MySQL Cluster Manager . . 11
3. MySQL Cluster Manager Client Commands . . 14
3.1. Online Help for MySQL Cluster Manager Commands . 18
3.2. MySQL Cluster Manager Site Commands19
3.2.1. The create site Command. . 20
3.2.2. The delete site Command. . 20
3.2.3. The list sites Command . 21
3.2.4. The add hosts Command . . 21
3.2.5. The list hosts Command . 22
3.3. MySQL Cluster Manager Package Commands . 22
3.3.1. The add package Command. . 22
3.3.2. The delete package Command . . 23
3.3.3. The list packages Command . 24
3.4. MySQL Cluster Manager Cluster Commands . . 25
3.4.1. The create cluster Command . . 25
3.4.2. The delete cluster Command . . 27
3.4.3. The start cluster Command . 27
3.4.4. The stop cluster Command28
3.4.5. The restart cluster Command . 28
3.4.6. The upgrade cluster Command . 29
3.4.7. The list clusters Command . 30
3.5. MySQL Cluster Manager Configuration Commands30
3.5.1. The get Command . 32
3.5.2. The set Command . 37
3.5.3. The reset Command. 41
3.6. The show status Command45
3.7. MySQL Cluster Manager Process Commands . . 47
3.7.1. The add process Command. . 47
3.7.2. The start process Command . 48
3.7.3. The stop process Command49
3.7.4. The change process Command . . 49
3.7.5. The list processes Command . . 51
4. MySQL Cluster Manager Limitations and Known Issues . . 52
A. Attribute Summary Tables . 55
B. Changes in MySQL Cluster Manager 1.1 (01 November 2010) 62
C. Licenses for Third-Party Components Used in MySQL Cluster Manager 64
C.1. libevent License. . 64
C.2. LPeg Library License . . 64
C.3. Lua (liblua) License. . 65
C.4. LuaFileSystem Library License . 65
C.5. md5 (Message-Digest Algorithm 5) License 65
C.6. PCRE License . . 65
C.7. SHA-1 in C License. . 66
Index 67
List of Tables
A.1. Management Node Configuration Parameters 55
A.2. Data Node Configuration Parameters. 55
A.3. API Node Configuration Parameters. . 58
A.4. Command Options for MySQL Cluster . . 59
A.5. COMPUTER Configuration Parameters . 60
A.6. TCP Configuration Parameters 60
A.7. SHM Configuration Parameters . . 61
A.8. SCI Configuration Parameters . 61