The summary table in this section provides information about
parameters used in the [ndb_mgmd] or
[mgm] sections of a
config.ini file for configuring MySQL
Cluster management nodes. For detailed descriptions and other
additional information about each of these parameters, see
Section 15.3.2.4, “Defining a MySQL Cluster Management Server”.
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 15.2.6.1, “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
--initial option.
For more information about restart types, see Section 15.3.3, “Overview of MySQL Cluster Configuration Parameters”.
Table 15.2. Management Node Configuration Parameters
| Name | Type/Units | Default | Min Value | Max Value | Restart Type |
|---|---|---|---|---|---|
| ArbitrationDelay | milliseconds | 4G | N | ||
| ArbitrationRank | 0-2 | 1 | 2 | N | |
| DataDir | path | . | N | ||
| ExecuteOnComputer | name | S | |||
| HostName | name or IP address | S | |||
| Id | unsigned | 1 | 63 | IS | |
| LogDestination | {CONSOLE|SYSLOG|FILE} | FILE: filename=ndb_nodeid_cluster.log, maxsize=1000000, maxfiles=6 | N | ||
| MaxNoOfSavedEvents | unsigned | 100 | 4G | N | |
| PortNumber | unsigned | 2200 | 64K | N | |
| PortNumberStats | unsigned | 64K | N |
After making changes in a management node's configuration, it is necessary to perform a rolling restart of the cluster for the new configuration to take effect. See Section 15.3.2.4, “Defining a MySQL Cluster Management Server”, for more information.
To add new management servers to a running MySQL Cluster, it
is also necessary perform a rolling restart of all cluster
nodes after modifying any existing
config.ini files. For more information
about issues arising when using multiple management nodes, see
Section 15.1.4.9, “Limitations Relating to Multiple MySQL Cluster Nodes”.
© 2013, Oracle Corporation and/or its affiliates
User Comments
Add your own comment.