Oracle 5.0, Reference Manual

Page: 1572 / 3232

MySQL Cluster Configuration Files
1552
There are a number of different ways to specify the connectstring:
• Each executable has its own command-line option which enables specifying the management server
at startup. (See the documentation for the respective executable.)
• It is also possible to set the connectstring for all nodes in the cluster at once by placing it in a
[mysql_cluster]
section in the management server's
my.cnf
file.
• For backward compatibility, two other options are available, using the same syntax:
1. Set the
NDB_CONNECTSTRING
environment variable to contain the connectstring.
2. Write the connectstring for each executable into a text file named
Ndb.cfg
and place this file in
the executable's startup directory.
However, these are now deprecated and should not be used for new installations.
The recommended method for specifying the connectstring is to set it on the command line or in the
my.cnf
file for each executable.
The maximum length of a connectstring is 1024 characters.
17.3.2.3. Defining Computers in a MySQL Cluster
The
[computer]
section has no real significance other than serving as a way to avoid the need of
defining host names for each node in the system. All parameters mentioned here are required.
•
Id
Effective Version Type/Units Default Range/Values
MySQL 5.0.0 string [none] ...
Restart Type: IN
This is a unique identifier, used to refer to the host computer elsewhere in the configuration file.
Important
The computer ID is not the same as the node ID used for a management,
API, or data node. Unlike the case with node IDs, you cannot use
NodeId
in
place of
Id
in the
[computer]
section of the
config.ini
file.
•
HostName
Effective Version Type/Units Default Range/Values
MySQL 5.0.0 name or IP address [none] ...
Restart Type: S
This is the computer's hostname or IP address.
17.3.2.4. Defining a MySQL Cluster Management Server
The
[ndb_mgmd]
section is used to configure the behavior of the management server.
[mgm]
can be
used as an alias; the two section names are equivalent. All parameters in the following list are optional
and assume their default values if omitted.
Note
If neither the
ExecuteOnComputer
nor the
HostName
parameter is present,
the default value
localhost
will be assumed for both.