MySQL NDB Cluster 8.0

Abstract

This is the MySQL NDB Cluster 8.0 extract from the MySQL 8.0 Reference Manual.

For legal information, see the Legal Notices.

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

Document generated on: 2024-03-18 (revision: 78098)


Table of Contents

Preface and Legal Notices
1 General Information
2 NDB Cluster Overview
2.1 NDB Cluster Core Concepts
2.2 NDB Cluster Nodes, Node Groups, Fragment Replicas, and Partitions
2.3 NDB Cluster Hardware, Software, and Networking Requirements
2.4 What is New in MySQL NDB Cluster 8.0
2.5 Options, Variables, and Parameters Added, Deprecated or Removed in NDB 8.0
2.6 MySQL Server Using InnoDB Compared with NDB Cluster
2.6.1 Differences Between the NDB and InnoDB Storage Engines
2.6.2 NDB and InnoDB Workloads
2.6.3 NDB and InnoDB Feature Usage Summary
2.7 Known Limitations of NDB Cluster
2.7.1 Noncompliance with SQL Syntax in NDB Cluster
2.7.2 Limits and Differences of NDB Cluster from Standard MySQL Limits
2.7.3 Limits Relating to Transaction Handling in NDB Cluster
2.7.4 NDB Cluster Error Handling
2.7.5 Limits Associated with Database Objects in NDB Cluster
2.7.6 Unsupported or Missing Features in NDB Cluster
2.7.7 Limitations Relating to Performance in NDB Cluster
2.7.8 Issues Exclusive to NDB Cluster
2.7.9 Limitations Relating to NDB Cluster Disk Data Storage
2.7.10 Limitations Relating to Multiple NDB Cluster Nodes
2.7.11 Previous NDB Cluster Issues Resolved in NDB Cluster 8.0
3 NDB Cluster Installation
3.1 Installation of NDB Cluster on Linux
3.1.1 Installing an NDB Cluster Binary Release on Linux
3.1.2 Installing NDB Cluster from RPM
3.1.3 Installing NDB Cluster Using .deb Files
3.1.4 Building NDB Cluster from Source on Linux
3.1.5 Deploying NDB Cluster with Docker Containers
3.2 Installing NDB Cluster on Windows
3.2.1 Installing NDB Cluster on Windows from a Binary Release
3.2.2 Compiling and Installing NDB Cluster from Source on Windows
3.2.3 Initial Startup of NDB Cluster on Windows
3.2.4 Installing NDB Cluster Processes as Windows Services
3.3 Initial Configuration of NDB Cluster
3.4 Initial Startup of NDB Cluster
3.5 NDB Cluster Example with Tables and Data
3.6 Safe Shutdown and Restart of NDB Cluster
3.7 Upgrading and Downgrading NDB Cluster
3.8 The NDB Cluster Auto-Installer (NO LONGER SUPPORTED)
4 Configuration of NDB Cluster
4.1 Quick Test Setup of NDB Cluster
4.2 Overview of NDB Cluster Configuration Parameters, Options, and Variables
4.2.1 NDB Cluster Data Node Configuration Parameters
4.2.2 NDB Cluster Management Node Configuration Parameters
4.2.3 NDB Cluster SQL Node and API Node Configuration Parameters
4.2.4 Other NDB Cluster Configuration Parameters
4.2.5 NDB Cluster mysqld Option and Variable Reference
4.3 NDB Cluster Configuration Files
4.3.1 NDB Cluster Configuration: Basic Example
4.3.2 Recommended Starting Configuration for NDB Cluster
4.3.3 NDB Cluster Connection Strings
4.3.4 Defining Computers in an NDB Cluster
4.3.5 Defining an NDB Cluster Management Server
4.3.6 Defining NDB Cluster Data Nodes
4.3.7 Defining SQL and Other API Nodes in an NDB Cluster
4.3.8 Defining the System
4.3.9 MySQL Server Options and Variables for NDB Cluster
4.3.10 NDB Cluster TCP/IP Connections
4.3.11 NDB Cluster TCP/IP Connections Using Direct Connections
4.3.12 NDB Cluster Shared-Memory Connections
4.3.13 Data Node Memory Management
4.3.14 Configuring NDB Cluster Send Buffer Parameters
4.4 Using High-Speed Interconnects with NDB Cluster
5 NDB Cluster Programs
5.1 ndbd — The NDB Cluster Data Node Daemon
5.2 ndbinfo_select_all — Select From ndbinfo Tables
5.3 ndbmtd — The NDB Cluster Data Node Daemon (Multi-Threaded)
5.4 ndb_mgmd — The NDB Cluster Management Server Daemon
5.5 ndb_mgm — The NDB Cluster Management Client
5.6 ndb_blob_tool — Check and Repair BLOB and TEXT columns of NDB Cluster Tables
5.7 ndb_config — Extract NDB Cluster Configuration Information
5.8 ndb_delete_all — Delete All Rows from an NDB Table
5.9 ndb_desc — Describe NDB Tables
5.10 ndb_drop_index — Drop Index from an NDB Table
5.11 ndb_drop_table — Drop an NDB Table
5.12 ndb_error_reporter — NDB Error-Reporting Utility
5.13 ndb_import — Import CSV Data Into NDB
5.14 ndb_index_stat — NDB Index Statistics Utility
5.15 ndb_move_data — NDB Data Copy Utility
5.16 ndb_perror — Obtain NDB Error Message Information
5.17 ndb_print_backup_file — Print NDB Backup File Contents
5.18 ndb_print_file — Print NDB Disk Data File Contents
5.19 ndb_print_frag_file — Print NDB Fragment List File Contents
5.20 ndb_print_schema_file — Print NDB Schema File Contents
5.21 ndb_print_sys_file — Print NDB System File Contents
5.22 ndb_redo_log_reader — Check and Print Content of Cluster Redo Log
5.23 ndb_restore — Restore an NDB Cluster Backup
5.23.1 Restoring an NDB Backup to a Different Version of NDB Cluster
5.23.2 Restoring to a different number of data nodes
5.23.3 Restoring from a backup taken in parallel
5.24 ndb_secretsfile_reader — Obtain Key Information from an Encrypted NDB Data File
5.25 ndb_select_all — Print Rows from an NDB Table
5.26 ndb_select_count — Print Row Counts for NDB Tables
5.27 ndb_show_tables — Display List of NDB Tables
5.28 ndb_size.pl — NDBCLUSTER Size Requirement Estimator
5.29 ndb_top — View CPU usage information for NDB threads
5.30 ndb_waiter — Wait for NDB Cluster to Reach a Given Status
5.31 ndbxfrm — Compress, Decompress, Encrypt, and Decrypt Files Created by NDB Cluster
6 Management of NDB Cluster
6.1 Commands in the NDB Cluster Management Client
6.2 NDB Cluster Log Messages
6.2.1 NDB Cluster: Messages in the Cluster Log
6.2.2 NDB Cluster Log Startup Messages
6.2.3 Event Buffer Reporting in the Cluster Log
6.2.4 NDB Cluster: NDB Transporter Errors
6.3 Event Reports Generated in NDB Cluster
6.3.1 NDB Cluster Logging Management Commands
6.3.2 NDB Cluster Log Events
6.3.3 Using CLUSTERLOG STATISTICS in the NDB Cluster Management Client
6.4 Summary of NDB Cluster Start Phases
6.5 Performing a Rolling Restart of an NDB Cluster
6.6 NDB Cluster Single User Mode
6.7 Adding NDB Cluster Data Nodes Online
6.7.1 Adding NDB Cluster Data Nodes Online: General Issues
6.7.2 Adding NDB Cluster Data Nodes Online: Basic procedure
6.7.3 Adding NDB Cluster Data Nodes Online: Detailed Example
6.8 Online Backup of NDB Cluster
6.8.1 NDB Cluster Backup Concepts
6.8.2 Using The NDB Cluster Management Client to Create a Backup
6.8.3 Configuration for NDB Cluster Backups
6.8.4 NDB Cluster Backup Troubleshooting
6.8.5 Taking an NDB Backup with Parallel Data Nodes
6.9 Importing Data Into MySQL Cluster
6.10 MySQL Server Usage for NDB Cluster
6.11 NDB Cluster Disk Data Tables
6.11.1 NDB Cluster Disk Data Objects
6.11.2 NDB Cluster Disk Data Storage Requirements
6.12 Online Operations with ALTER TABLE in NDB Cluster
6.13 Privilege Synchronization and NDB_STORED_USER
6.14 File System Encryption for NDB Cluster
6.14.1 NDB File System Encryption Setup and Usage
6.14.2 NDB File System Encryption Implementation
6.14.3 NDB File System Encryption Limitations
6.15 NDB API Statistics Counters and Variables
6.16 ndbinfo: The NDB Cluster Information Database
6.16.1 The ndbinfo arbitrator_validity_detail Table
6.16.2 The ndbinfo arbitrator_validity_summary Table
6.16.3 The ndbinfo backup_id Table
6.16.4 The ndbinfo blobs Table
6.16.5 The ndbinfo blocks Table
6.16.6 The ndbinfo cluster_locks Table
6.16.7 The ndbinfo cluster_operations Table
6.16.8 The ndbinfo cluster_transactions Table
6.16.9 The ndbinfo config_nodes Table
6.16.10 The ndbinfo config_params Table
6.16.11 The ndbinfo config_values Table
6.16.12 The ndbinfo counters Table
6.16.13 The ndbinfo cpudata Table
6.16.14 The ndbinfo cpudata_1sec Table
6.16.15 The ndbinfo cpudata_20sec Table
6.16.16 The ndbinfo cpudata_50ms Table
6.16.17 The ndbinfo cpuinfo Table
6.16.18 The ndbinfo cpustat Table
6.16.19 The ndbinfo cpustat_50ms Table
6.16.20 The ndbinfo cpustat_1sec Table
6.16.21 The ndbinfo cpustat_20sec Table
6.16.22 The ndbinfo dictionary_columns Table
6.16.23 The ndbinfo dictionary_tables Table
6.16.24 The ndbinfo dict_obj_info Table
6.16.25 The ndbinfo dict_obj_tree Table
6.16.26 The ndbinfo dict_obj_types Table
6.16.27 The ndbinfo disk_write_speed_base Table
6.16.28 The ndbinfo disk_write_speed_aggregate Table
6.16.29 The ndbinfo disk_write_speed_aggregate_node Table
6.16.30 The ndbinfo diskpagebuffer Table
6.16.31 The ndbinfo diskstat Table
6.16.32 The ndbinfo diskstats_1sec Table
6.16.33 The ndbinfo error_messages Table
6.16.34 The ndbinfo events Table
6.16.35 The ndbinfo files Table
6.16.36 The ndbinfo foreign_keys Table
6.16.37 The ndbinfo hash_maps Table
6.16.38 The ndbinfo hwinfo Table
6.16.39 The ndbinfo index_columns Table
6.16.40 The ndbinfo index_stats Table
6.16.41 The ndbinfo locks_per_fragment Table
6.16.42 The ndbinfo logbuffers Table
6.16.43 The ndbinfo logspaces Table
6.16.44 The ndbinfo membership Table
6.16.45 The ndbinfo memoryusage Table
6.16.46 The ndbinfo memory_per_fragment Table
6.16.47 The ndbinfo nodes Table
6.16.48 The ndbinfo operations_per_fragment Table
6.16.49 The ndbinfo pgman_time_track_stats Table
6.16.50 The ndbinfo processes Table
6.16.51 The ndbinfo resources Table
6.16.52 The ndbinfo restart_info Table
6.16.53 The ndbinfo server_locks Table
6.16.54 The ndbinfo server_operations Table
6.16.55 The ndbinfo server_transactions Table
6.16.56 The ndbinfo table_distribution_status Table
6.16.57 The ndbinfo table_fragments Table
6.16.58 The ndbinfo table_info Table
6.16.59 The ndbinfo table_replicas Table
6.16.60 The ndbinfo tc_time_track_stats Table
6.16.61 The ndbinfo threadblocks Table
6.16.62 The ndbinfo threads Table
6.16.63 The ndbinfo threadstat Table
6.16.64 The ndbinfo transporter_details Table
6.16.65 The ndbinfo transporters Table
6.17 INFORMATION_SCHEMA Tables for NDB Cluster
6.18 NDB Cluster and the Performance Schema
6.19 Quick Reference: NDB Cluster SQL Statements
6.20 NDB Cluster Security Issues
6.20.1 NDB Cluster Security and Networking Issues
6.20.2 NDB Cluster and MySQL Privileges
6.20.3 NDB Cluster and MySQL Security Procedures
7 NDB Cluster Replication
7.1 NDB Cluster Replication: Abbreviations and Symbols
7.2 General Requirements for NDB Cluster Replication
7.3 Known Issues in NDB Cluster Replication
7.4 NDB Cluster Replication Schema and Tables
7.5 Preparing the NDB Cluster for Replication
7.6 Starting NDB Cluster Replication (Single Replication Channel)
7.7 Using Two Replication Channels for NDB Cluster Replication
7.8 Implementing Failover with NDB Cluster Replication
7.9 NDB Cluster Backups With NDB Cluster Replication
7.9.1 NDB Cluster Replication: Automating Synchronization of the Replica to the Source Binary Log
7.9.2 Point-In-Time Recovery Using NDB Cluster Replication
7.10 NDB Cluster Replication: Bidirectional and Circular Replication
7.11 NDB Cluster Replication Using the Multithreaded Applier
7.12 NDB Cluster Replication Conflict Resolution
A NDB Cluster FAQ