- 16.3.3 Overview of MySQL Cluster Configuration Parameters
- 16.3.3.1 MySQL Cluster Data Node Configuration Parameters
- 16.3.3.2 MySQL Cluster Management Node Configuration Parameters
- 16.3.3.3 MySQL Cluster SQL Node and API Node Configuration Parameters
- 16.3.3.4 Other MySQL Cluster Configuration Parameters
The summary table in this section provides information about
parameters used in the [ndbd] or
[ndbd default] sections of a
config.ini file for configuring MySQL
Cluster data nodes. For detailed descriptions and other
additional information about each of these parameters, see
Section 16.3.2.5, “Defining MySQL Cluster Data Nodes”.
Restart types. Changes in MySQL Cluster configuration parameters do not take effect until the cluster is restarted. The type of restart required to change a given parameter is indicated in the summary table as follows:
N—Node restart: The parameter can be updated using a rolling restart (see Section 16.5.4, “Performing a Rolling Restart of a MySQL Cluster”).S—System restart: The cluster must be shut down completely, then restarted, to effect a change in this parameter.I—Initial restart: Data nodes must be restarted using the--initialoption.
For more information about restart types, see Section 16.3.3, “Overview of MySQL Cluster Configuration Parameters”.
Table 16.1. Data Node Configuration Parameters
| Name | Type/Units | Default | Min Value | Max Value | Restart Type |
|---|---|---|---|---|---|
| ArbitrationTimeout | milliseconds | 3000 | 10 | 4G | N |
| BackupDataBufferSize | bytes | 2M | 4G | N | |
| BackupDataDir | path | FileSystemPath | IN | ||
| BackupLogBufferSize | bytes | 2M | 4G | N | |
| BackupMaxWriteSize | bytes | 256K | 2K | 4G | N |
| BackupMemory | bytes | 4M | 4G | N | |
| BackupWriteSize | bytes | 32K | 2K | 4G | N |
| BatchSizePerLocalScan | integer | 64 | 1 | 992 | N |
| DataDir | path | . | IN | ||
| DataMemory | bytes | 80M | 1M | 1024G | N |
| Diskless | true|false (1|0) | 1 | IS | ||
| ExecuteOnComputer | name | S | |||
| HeartbeatIntervalDbApi | milliseconds | 1500 | 100 | 4G | N |
| HeartbeatIntervalDbDb | milliseconds | 1500 | 10 | 4G | N |
| HostName | name or IP address | localhost | S | ||
| Id | unsigned | 1 | 48 | N | |
| IndexMemory | bytes | 18M | 1M | 1T | N |
| LockPagesInMainMemory | true|false (1|0) | 1 | N | ||
| LogLevelCheckpoint | log level | 15 | IN | ||
| LogLevelCongestion | levelr | 15 | N | ||
| LogLevelConnection | integer | 15 | N | ||
| LogLevelError | integer | 15 | N | ||
| LogLevelInfo | integer | 15 | N | ||
| LogLevelNodeRestart | integer | 15 | N | ||
| LogLevelShutdown | integer | 15 | N | ||
| LogLevelStartup | integer | 1 | 15 | N | |
| LogLevelStatistic | integer | 15 | N | ||
| LongMessageBuffer | bytes | 1M | 512K | 4G | N |
| MaxNoOfAttributes | integer | 1000 | 32 | 4G | N |
| MaxNoOfConcurrentIndexOperations | integer | 8K | 4G | N | |
| MaxNoOfConcurrentOperations | integer | 32K | 32 | 4G | N |
| MaxNoOfConcurrentScans | integer | 256 | 2 | 500 | N |
| MaxNoOfConcurrentTransactions | integer | 4096 | 32 | 4G | S |
| MaxNoOfFiredTriggers | integer | 4000 | 4G | N | |
| MaxNoOfLocalOperations | integer | UNDEFINED | 32 | 4G | N |
| MaxNoOfLocalScans | integer | UNDEFINED | 32 | 4G | N |
| MaxNoOfOpenFiles | N | ||||
| MaxNoOfOrderedIndexes | integer | 128 | 4G | N | |
| MaxNoOfSavedMessages | integer | 25 | 4G | N | |
| MaxNoOfTables | integer | 128 | 8 | 20320 | N |
| MaxNoOfTriggers | integer | 768 | 4G | N | |
| MaxNoOfUniqueHashIndexes | integer | 64 | 4G | N | |
| NodeId | unsigned | 1 | 48 | N | |
| NoOfDiskPagesToDiskAfterRestartACC | 8K pages/100 milliseconds | 20 | 1 | 4G | N |
| NoOfDiskPagesToDiskAfterRestartTUP | 8K pages/100 milliseconds | 40 | 1 | 4G | N |
| NoOfDiskPagesToDiskDuringRestartACC | 8K pages/100 milliseconds | 20 | 1 | 4G | N |
| NoOfDiskPagesToDiskDuringRestartTUP | 8K pages/100 milliseconds | 40 | 1 | 4G | N |
| NoOfFragmentLogFiles | integer | 8 | 3 | 4G | IN |
| NoOfReplicas | integer | None | 1 | 4 | IS |
| RedoBuffer | bytes | 8M | 1M | 4G | N |
| RestartOnErrorInsert | error code | 2 | 4 | N | |
| ServerPort | unsigned | 1 | 64K | N | |
| StartFailureTimeout | milliseconds | 4G | N | ||
| StartPartialTimeout | milliseconds | 30000 | 4G | N | |
| StartPartitionedTimeout | milliseconds | 60000 | 4G | N | |
| StopOnError | true|false (1|0) | true | N | ||
| StringMemory | % or bytes | 4G | S | ||
| TimeBetweenGlobalCheckpoints | milliseconds | 2000 | 10 | 32000 | N |
| TimeBetweenInactiveTransactionAbortCheck | milliseconds | 1000 | 1000 | 4G | N |
| TimeBetweenLocalCheckpoints | number of 4-byte words, as a base-2 logarithm | 20 | 31 | N | |
| TimeBetweenWatchDogCheck | milliseconds | 6000 | 70 | 4G | N |
| TransactionBufferMemory | bytes | 1M | 1K | 4G | N |
| TransactionDeadlockDetectionTimeout | milliseconds | 1200 | 50 | 4G | N |
| TransactionInactiveTimeout | milliseconds | 4G | 4G | N | |
| UndoDataBuffer | unsigned | 16M | 1M | 4G | N |
| UndoIndexBuffer | unsigned | 2M | 1M | 4G | N |
To add new data nodes to a MySQL Cluster, it is necessary to
shut down the cluster completely, update the
config.ini file, and then restart the
cluster, starting all data node processes using the
--initial option—that is,
you must perform a system restart.
It is possible to add new data node groups to a running cluster online using MySQL Cluster NDB 7.0 or later (see Adding MySQL Cluster Data Nodes Online); however, we do not plan to implement this change in MySQL 5.0.
User Comments
Add your own comment.