Chapter 23 MySQL NDB Cluster 8.0 Table of Contents 23.1 NDB Cluster Overview .......................................................................................................... 3925 23.1.1 NDB Cluster Core Concepts ....................................................................................... 3926 23.1.2 NDB Cluster Nodes, Node Groups, Fragment Replicas, and Partitions .......................... 3929 23.1.3 NDB Cluster Hardware, Software, and Networking Requirements .................................. 3932 23.1.4 What is New in NDB Cluster ....................................................................................... 3933 23.1.5 Options, Variables, and Parameters Added, Deprecated or Removed in NDB 8.0 ........... 3956 23.1.6 MySQL Server Using InnoDB Compared with NDB Cluster ........................................... 3961 23.1.7 Known Limitations of NDB Cluster .............................................................................. 3964 23.2 NDB Cluster Installation ........................................................................................................ 3976 23.2.1 Installation of NDB Cluster on Linux ............................................................................ 3978 23.2.2 Installing NDB Cluster on Windows ............................................................................. 3987 23.2.3 Initial Configuration of NDB Cluster ............................................................................. 3996 23.2.4 Initial Startup of NDB Cluster ...................................................................................... 3998 23.2.5 NDB Cluster Example with Tables and Data ................................................................ 3999 23.2.6 Safe Shutdown and Restart of NDB Cluster ................................................................ 4002 23.2.7 Upgrading and Downgrading NDB Cluster ................................................................... 4003 23.2.8 The NDB Cluster Auto-Installer (No longer supported) .................................................. 4006 23.3 Configuration of NDB Cluster ................................................................................................ 4028 23.3.1 Quick Test Setup of NDB Cluster ................................................................................ 4029 23.3.2 Overview of NDB Cluster Configuration Parameters, Options, and Variables .................. 4031 23.3.3 NDB Cluster Configuration Files .................................................................................. 4052 23.3.4 Using High-Speed Interconnects with NDB Cluster ....................................................... 4236 23.4 NDB Cluster Programs .......................................................................................................... 4237 23.4.1 ndbd — The NDB Cluster Data Node Daemon ............................................................ 4237 23.4.2 ndbinfo_select_all — Select From ndbinfo Tables ........................................................ 4248 23.4.3 ndbmtd — The NDB Cluster Data Node Daemon (Multi-Threaded) ................................ 4254 23.4.4 ndb_mgmd — The NDB Cluster Management Server Daemon ..................................... 4255 23.4.5 ndb_mgm — The NDB Cluster Management Client ...................................................... 4268 23.4.6 ndb_blob_tool — Check and Repair BLOB and TEXT columns of NDB Cluster Tables .... 4273 23.4.7 ndb_config — Extract NDB Cluster Configuration Information ....................................... 4280 23.4.8 ndb_delete_all — Delete All Rows from an NDB Table ................................................. 4292 23.4.9 ndb_desc — Describe NDB Tables ............................................................................. 4297 23.4.10 ndb_drop_index — Drop Index from an NDB Table .................................................... 4307 23.4.11 ndb_drop_table — Drop an NDB Table ..................................................................... 4312 23.4.12 ndb_error_reporter — NDB Error-Reporting Utility ...................................................... 4317 23.4.13 ndb_import — Import CSV Data Into NDB ................................................................. 4318 23.4.14 ndb_index_stat — NDB Index Statistics Utility ............................................................ 4335 23.4.15 ndb_move_data — NDB Data Copy Utility ................................................................. 4345 23.4.16 ndb_perror — Obtain NDB Error Message Information ............................................... 4351 23.4.17 ndb_print_backup_file — Print NDB Backup File Contents .......................................... 4354 23.4.18 ndb_print_file — Print NDB Disk Data File Contents ................................................... 4359 23.4.19 ndb_print_frag_file — Print NDB Fragment List File Contents ...................................... 4360 23.4.20 ndb_print_schema_file — Print NDB Schema File Contents ........................................ 4361 23.4.21 ndb_print_sys_file — Print NDB System File Contents ............................................... 4361 23.4.22 ndb_redo_log_reader — Check and Print Content of Cluster Redo Log ....................... 4362 23.4.23 ndb_restore — Restore an NDB Cluster Backup ........................................................ 4365 23.4.24 ndb_select_all — Print Rows from an NDB Table ....................................................... 4399 3921