MySQL Cluster NDB 8.0

Abstract

This is the MySQL Cluster NDB 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: 2020-03-27 (revision: 65510)


Table of Contents

Preface and Legal Notices
1 Preface and Notes
2 MySQL NDB Cluster 8.0
3 NDB Cluster Overview
3.1 NDB Cluster Core Concepts
3.2 NDB Cluster Nodes, Node Groups, Replicas, and Partitions
3.3 NDB Cluster Hardware, Software, and Networking Requirements
3.4 What is New in NDB Cluster
3.5 Options, Variables, and Parameters Added, Deprecated or Removed in NDB 8.0
3.6 MySQL Server Using InnoDB Compared with NDB Cluster
3.6.1 Differences Between the NDB and InnoDB Storage Engines
3.6.2 NDB and InnoDB Workloads
3.6.3 NDB and InnoDB Feature Usage Summary
3.7 Known Limitations of NDB Cluster
3.7.1 Noncompliance with SQL Syntax in NDB Cluster
3.7.2 Limits and Differences of NDB Cluster from Standard MySQL Limits
3.7.3 Limits Relating to Transaction Handling in NDB Cluster
3.7.4 NDB Cluster Error Handling
3.7.5 Limits Associated with Database Objects in NDB Cluster
3.7.6 Unsupported or Missing Features in NDB Cluster
3.7.7 Limitations Relating to Performance in NDB Cluster
3.7.8 Issues Exclusive to NDB Cluster
3.7.9 Limitations Relating to NDB Cluster Disk Data Storage
3.7.10 Limitations Relating to Multiple NDB Cluster Nodes
3.7.11 Previous NDB Cluster Issues Resolved in NDB Cluster 8.0
4 NDB Cluster Installation
4.1 The NDB Cluster Auto-Installer
4.1.1 NDB Cluster Auto-Installer Requirements
4.1.2 Using the NDB Cluster Auto-Installer
4.2 Installation of NDB Cluster on Linux
4.2.1 Installing an NDB Cluster Binary Release on Linux
4.2.2 Installing NDB Cluster from RPM
4.2.3 Installing NDB Cluster Using .deb Files
4.2.4 Building NDB Cluster from Source on Linux
4.3 Installing NDB Cluster on Windows
4.3.1 Installing NDB Cluster on Windows from a Binary Release
4.3.2 Compiling and Installing NDB Cluster from Source on Windows
4.3.3 Initial Startup of NDB Cluster on Windows
4.3.4 Installing NDB Cluster Processes as Windows Services
4.4 Initial Configuration of NDB Cluster
4.5 Initial Startup of NDB Cluster
4.6 NDB Cluster Example with Tables and Data
4.7 Safe Shutdown and Restart of NDB Cluster
4.8 Upgrading and Downgrading NDB Cluster
5 Configuration of NDB Cluster
5.1 Quick Test Setup of NDB Cluster
5.2 Overview of NDB Cluster Configuration Parameters, Options, and Variables
5.2.1 NDB Cluster Data Node Configuration Parameters
5.2.2 NDB Cluster Management Node Configuration Parameters
5.2.3 NDB Cluster SQL Node and API Node Configuration Parameters
5.2.4 Other NDB Cluster Configuration Parameters
5.2.5 NDB Cluster mysqld Option and Variable Reference
5.3 NDB Cluster Configuration Files
5.3.1 NDB Cluster Configuration: Basic Example
5.3.2 Recommended Starting Configuration for NDB Cluster
5.3.3 NDB Cluster Connection Strings
5.3.4 Defining Computers in an NDB Cluster
5.3.5 Defining an NDB Cluster Management Server
5.3.6 Defining NDB Cluster Data Nodes
5.3.7 Defining SQL and Other API Nodes in an NDB Cluster
5.3.8 Defining the System
5.3.9 MySQL Server Options and Variables for NDB Cluster
5.3.10 NDB Cluster TCP/IP Connections
5.3.11 NDB Cluster TCP/IP Connections Using Direct Connections
5.3.12 NDB Cluster Shared-Memory Connections
5.3.13 Data Node Memory Management
5.3.14 Configuring NDB Cluster Send Buffer Parameters
5.4 Using High-Speed Interconnects with NDB Cluster
6 NDB Cluster Programs
6.1 ndbd — The NDB Cluster Data Node Daemon
6.2 ndbinfo_select_all — Select From ndbinfo Tables
6.3 ndbmtd — The NDB Cluster Data Node Daemon (Multi-Threaded)
6.4 ndb_mgmd — The NDB Cluster Management Server Daemon
6.5 ndb_mgm — The NDB Cluster Management Client
6.6 ndb_blob_tool — Check and Repair BLOB and TEXT columns of NDB Cluster Tables
6.7 ndb_config — Extract NDB Cluster Configuration Information
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_import — Import CSV Data Into NDB
6.14 ndb_index_stat — NDB Index Statistics Utility
6.15 ndb_move_data — NDB Data Copy Utility
6.16 ndb_perror — Obtain NDB Error Message Information
6.17 ndb_print_backup_file — Print NDB Backup File Contents
6.18 ndb_print_file — Print NDB Disk Data File Contents
6.19 ndb_print_frag_file — Print NDB Fragment List File Contents
6.20 ndb_print_schema_file — Print NDB Schema File Contents
6.21 ndb_print_sys_file — Print NDB System File Contents
6.22 ndb_redo_log_reader — Check and Print Content of Cluster Redo Log
6.23 ndb_restore — Restore an NDB Cluster Backup
6.23.1 Restoring to a different number of data nodes
6.23.2 Restoring from a backup taken in parallel
6.24 ndb_select_all — Print Rows from an NDB Table
6.25 ndb_select_count — Print Row Counts for NDB Tables
6.26 ndb_setup.py — Start browser-based Auto-Installer for NDB Cluster
6.27 ndb_show_tables — Display List of NDB Tables
6.28 ndb_size.pl — NDBCLUSTER Size Requirement Estimator
6.29 ndb_top — View CPU usage information for NDB threads
6.30 ndb_waiter — Wait for NDB Cluster to Reach a Given Status
6.31 Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs
7 Management of NDB Cluster
7.1 Summary of NDB Cluster Start Phases
7.2 Commands in the NDB Cluster Management Client
7.3 Online Backup of NDB Cluster
7.3.1 NDB Cluster Backup Concepts
7.3.2 Using The NDB Cluster Management Client to Create a Backup
7.3.3 Configuration for NDB Cluster Backups
7.3.4 NDB Cluster Backup Troubleshooting
7.3.5 Taking an NDB Backup with Parallel Data Nodes
7.4 MySQL Server Usage for NDB Cluster
7.5 Performing a Rolling Restart of an NDB Cluster
7.6 Event Reports Generated in NDB Cluster
7.6.1 NDB Cluster Logging Management Commands
7.6.2 NDB Cluster Log Events
7.6.3 Using CLUSTERLOG STATISTICS in the NDB Cluster Management Client
7.7 NDB Cluster Log Messages
7.7.1 NDB Cluster: Messages in the Cluster Log
7.7.2 NDB Cluster Log Startup Messages
7.7.3 Event Buffer Reporting in the Cluster Log
7.7.4 NDB Cluster: NDB Transporter Errors
7.8 NDB Cluster Single User Mode
7.9 Quick Reference: NDB Cluster SQL Statements
7.10 ndbinfo: The NDB Cluster Information Database
7.10.1 The ndbinfo arbitrator_validity_detail Table
7.10.2 The ndbinfo arbitrator_validity_summary Table
7.10.3 The ndbinfo blocks Table
7.10.4 The ndbinfo cluster_locks Table
7.10.5 The ndbinfo cluster_operations Table
7.10.6 The ndbinfo cluster_transactions Table
7.10.7 The ndbinfo config_nodes Table
7.10.8 The ndbinfo config_params Table
7.10.9 The ndbinfo config_values Table
7.10.10 The ndbinfo counters Table
7.10.11 The ndbinfo cpustat Table
7.10.12 The ndbinfo cpustat_50ms Table
7.10.13 The ndbinfo cpustat_1sec Table
7.10.14 The ndbinfo cpustat_20sec Table
7.10.15 The ndbinfo dict_obj_info Table
7.10.16 The ndbinfo dict_obj_types Table
7.10.17 The ndbinfo disk_write_speed_base Table
7.10.18 The ndbinfo disk_write_speed_aggregate Table
7.10.19 The ndbinfo disk_write_speed_aggregate_node Table
7.10.20 The ndbinfo diskpagebuffer Table
7.10.21 The ndbinfo diskstat Table
7.10.22 The ndbinfo diskstats_1sec Table
7.10.23 The ndbinfo error_messages Table
7.10.24 The ndbinfo locks_per_fragment Table
7.10.25 The ndbinfo logbuffers Table
7.10.26 The ndbinfo logspaces Table
7.10.27 The ndbinfo membership Table
7.10.28 The ndbinfo memoryusage Table
7.10.29 The ndbinfo memory_per_fragment Table
7.10.30 The ndbinfo nodes Table
7.10.31 The ndbinfo operations_per_fragment Table
7.10.32 The ndbinfo pgman_time_track_stats Table
7.10.33 The ndbinfo processes Table
7.10.34 The ndbinfo resources Table
7.10.35 The ndbinfo restart_info Table
7.10.36 The ndbinfo server_locks Table
7.10.37 The ndbinfo server_operations Table
7.10.38 The ndbinfo server_transactions Table
7.10.39 The ndbinfo table_distribution_status Table
7.10.40 The ndbinfo table_fragments Table
7.10.41 The ndbinfo table_info Table
7.10.42 The ndbinfo table_replicas Table
7.10.43 The ndbinfo tc_time_track_stats Table
7.10.44 The ndbinfo threadblocks Table
7.10.45 The ndbinfo threads Table
7.10.46 The ndbinfo threadstat Table
7.10.47 The ndbinfo transporters Table
7.11 INFORMATION_SCHEMA Tables for NDB Cluster
7.12 NDB Cluster Security Issues
7.12.1 NDB Cluster Security and Networking Issues
7.12.2 NDB Cluster and MySQL Privileges
7.12.3 NDB Cluster and MySQL Security Procedures
7.13 NDB Cluster Disk Data Tables
7.13.1 NDB Cluster Disk Data Objects
7.13.2 NDB Cluster Disk Data Storage Requirements
7.14 Online Operations with ALTER TABLE in NDB Cluster
7.15 Adding NDB Cluster Data Nodes Online
7.15.1 Adding NDB Cluster Data Nodes Online: General Issues
7.15.2 Adding NDB Cluster Data Nodes Online: Basic procedure
7.15.3 Adding NDB Cluster Data Nodes Online: Detailed Example
7.16 Distributed MySQL Privileges with NDB_STORED_USER
7.17 NDB API Statistics Counters and Variables
8 NDB Cluster Replication
8.1 NDB Cluster Replication: Abbreviations and Symbols
8.2 General Requirements for NDB Cluster Replication
8.3 Known Issues in NDB Cluster Replication
8.4 NDB Cluster Replication Schema and Tables
8.5 Preparing the NDB Cluster for Replication
8.6 Starting NDB Cluster Replication (Single Replication Channel)
8.7 Using Two Replication Channels for NDB Cluster Replication
8.8 Implementing Failover with NDB Cluster Replication
8.9 NDB Cluster Backups With NDB Cluster Replication
8.9.1 NDB Cluster Replication: Automating Synchronization of the Replication Slave to the Master Binary Log
8.9.2 Point-In-Time Recovery Using NDB Cluster Replication
8.10 NDB Cluster Replication: Multi-Master and Circular Replication
8.11 NDB Cluster Replication Conflict Resolution
A MySQL 8.0 FAQ: NDB Cluster