MySQL Cluster Manager 8.4.6 User Manual

Abstract

This is the User Manual for theMySQL Cluster Manager, version 8.4.6. It documents theMySQL Cluster Manager Agent andMySQL Cluster Manager Client software applications, which can be used to administerMySQL NDB Cluster, a version of theMySQL Database System (referred to hereafter asMySQL Server or simplyMySQL) that incorporates theNDB storage engine for high availability and data redundancy in a distributed computing environment.

This manual applies to MySQL Cluster Manager 8.4.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, seeMySQL Documentation: MySQL NDB 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 NDB Cluster features.  This manual contains certain basic information about MySQL Server and MySQL NDB Cluster; however, it is not in any way intended as an exhaustive reference for either of these products.

MySQL Cluster Manager 8.4 supports MySQL NDB Cluster 8.4, MySQL NDB Cluster 8.0, and MySQL NDB Cluster 7.6.

MySQL NDB Cluster functionality varies between MySQL NDB Cluster releases; MySQL Cluster Manager cannot supply or emulate MySQL NDB Cluster features that are not present in the version of the MySQL NDB Cluster software in use.

For complete information about MySQL Server and MySQL NDB Cluster seeMySQL NDB Cluster 8.4,MySQL NDB Cluster 8.0, orMySQL NDB Cluster 7.5 and NDB Cluster 7.6.

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

For notes detailing the changes in each release of MySQL Cluster Manager , seeMySQL Cluster Manager 8.4 Release Notes.

For legal information, see theLegal Notices.

For help with using MySQL, please visit theMySQL Forums, where you can discuss your issues with other MySQL users.

Document generated on: 2025-12-11 (revision: 84131)


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
1.3 Basic Operational Concepts for MySQL Cluster Manager
1.3.1 Quorum Requirement
1.3.2 Eventual Consistency
2 What Is New in MySQL Cluster Manager 8.4
3 MySQL Cluster Manager Installation, Configuration, Cluster Setup
3.1 Obtaining MySQL Cluster Manager
3.2 Supported Platforms and MySQL NDB Cluster Versions
3.3 MySQL Cluster Manager Installation
3.3.1 Installing MySQL Cluster Manager on Unix-like Platforms
3.3.2 Installing MySQL Cluster Manager on Windows Platforms
3.3.3 Setting the MySQL Cluster Manager Agent User Name and Password
3.4 MySQL Cluster Manager Configuration File
3.5 Upgrading MySQL Cluster Manager
4 Using MySQL Cluster Manager
4.1mcmd, the MySQL Cluster Manager Agent
4.2 Starting and Stopping the MySQL Cluster Manager Agent
4.2.1 Starting and Stopping the Agent on Linux
4.2.2 Starting and Stopping the MySQL Cluster Manager Agent on Windows
4.3 Starting the MySQL Cluster Manager Client
4.4 Setting Up MySQL NDB Clusters with MySQL Cluster Manager
4.4.1 Creating a MySQL NDB Cluster with MySQL Cluster Manager
4.5 Importing MySQL NDB Clusters into MySQL Cluster Manager
4.5.1 Importing a Cluster Into MySQL Cluster Manager: Basic Procedure
4.5.2 Importing a Cluster Into MySQL Cluster Manager: Example
4.6 MySQL NDB Cluster Backup and Restore Using MySQL Cluster Manager
4.6.1 Requirements for Backup and Restore
4.6.2 Basic MySQL NDB Cluster Backup and Restore Using MySQL Cluster Manager
4.7 Backing Up and Restoring MySQL Cluster Manager Agents
4.8 Restoring a MySQL Cluster Manager Agent with Data from Other Agents
4.9 Setting Up MySQL NDB Cluster Replication with MySQL Cluster Manager
4.10 Using Encrypted Connections for MySQL Cluster Manager Agents and Clients
4.11 Using TLS Connections for NDB Clusters
5 MySQL Cluster Manager Client Commands
5.1 Online Help and Information Commands
5.2 MySQL Cluster Manager Site and Agent Commands
5.2.1 Theadd hosts Command
5.2.2 Theremove hosts Command
5.2.3 Thechange log-level Command
5.2.4 Therotate log Command
5.2.5 Thecollect logs Command
5.2.6 Thecreate site Command
5.2.7 Thedelete site Command
5.2.8 Thelist sites Command
5.2.9 Thelist hosts Command
5.2.10 Theshow settings Command
5.2.11 Thestop agents Command
5.2.12 Theversion Command
5.2.13 Theshow warnings Command
5.2.14 Thelist warnings Command
5.3 MySQL Cluster Manager Package Commands
5.3.1 Theadd package Command
5.3.2 Thedelete package Command
5.3.3 Thelist packages Command
5.4 MySQL Cluster Manager Cluster Commands
5.4.1 Thecreate cluster Command
5.4.2 Thedelete cluster Command
5.4.3 Thelist clusters Command
5.4.4 Thelist nextnodeids Command
5.4.5 Therestart cluster Command
5.4.6 Theshow status Command
5.4.7 Thestart cluster Command
5.4.8 Thestop cluster Command
5.4.9 Theautotune Command
5.4.10 Theupgrade cluster Command
5.5 MySQL Cluster Manager Configuration Commands
5.5.1 Theget Command
5.5.2 Thereset Command
5.5.3 Theset Command
5.5.4 Theshow variables Command
5.6 MySQL Cluster Manager Process Commands
5.6.1 Theadd process Command
5.6.2 Thechange process Command
5.6.3 Thelist processes Command
5.6.4 Thestart process Command
5.6.5 Thestop process Command
5.6.6 Theupdate process Command
5.6.7 Theremove process Command
5.7 MySQL Cluster Manager TLS Connection Commands
5.7.1 Thecreate certs Command
5.7.2 Thelist certs Command
5.8 MySQL Cluster Manager Backup and Restore Commands
5.8.1 Theabort backup Command
5.8.2 Thebackup cluster Command
5.8.3 Thelist backups Command
5.8.4 Thedelete backup Command
5.8.5 Therestore cluster Command
5.8.6 Thebackup agents Command
5.9 MySQL Cluster Manager Cluster Importation Commands
5.9.1 Theimport cluster Command
5.9.2 Theimport config Command
6 MySQL Cluster Manager Limitations and Known Issues
6.1 MySQL Cluster Manager Usage and Design Limitations
6.2 MySQL Cluster Manager 8.4.6 Limitations Relating to the MySQL Server
6.3 MySQL Cluster Manager Limitations Relating to MySQL NDB Cluster
6.4 Syntax and Related Issues in MySQL Cluster Manager
A Attribute Summary Tables
A.1 Management Node Configuration Parameters
A.2 Data Node Configuration Parameters
A.3 API Node Configuration Parameters
A.4 Other Node Configuration Parameters
A.5 MySQL Server Option and Variable Reference for MySQL Cluster
Index