MySQL Cluster Configuration Files
1551
•
[computer]
: Defines cluster hosts. This is not required to configure a viable MySQL Cluster, but
be may used as a convenience when setting up a large cluster. See
Section 17.3.2.3, “Defining
Computers in a MySQL Cluster”
, for more information.
•
[ndbd]
: Defines a cluster data node (
ndbd
process). See
Section 17.3.2.5, “Defining MySQL
Cluster Data Nodes”
, for details.
•
[mysqld]
: Defines the cluster's MySQL server nodes (also called SQL or API nodes). For a
discussion of SQL node configuration, see
Section 17.3.2.6, “Defining SQL and Other API Nodes in
a MySQL Cluster”
.
•
[mgm]
or
[ndb_mgmd]
: Defines a cluster management server (MGM) node. For information
concerning the configuration of MGM nodes, see
Section 17.3.2.4, “Defining a MySQL Cluster
Management Server”
.
•
[tcp]
: Defines a TCP/IP connection between cluster nodes, with TCP/IP being the default
connection protocol. Normally,
[tcp]
or
[tcp default]
sections are not required to set up a
MySQL Cluster, as the cluster handles this automatically; however, it may be necessary in some
situations to override the defaults provided by the cluster. See
Section 17.3.2.7, “MySQL Cluster
TCP/IP Connections”
, for information about available TCP/IP configuration parameters and how to
use them. (You may also find
Section 17.3.2.8, “MySQL Cluster TCP/IP Connections Using Direct
Connections”
to be of interest in some cases.)
•
[shm]
: Defines shared-memory connections between nodes. In MySQL 5.0, it is enabled by
default, but should still be considered experimental. For a discussion of SHM interconnects, see
Section 17.3.2.9, “MySQL Cluster Shared-Memory Connections”
.
•
[sci]
:Defines Scalable Coherent Interface connections between cluster data nodes. Such
connections require software which, while freely available, is not part of the MySQL Cluster
distribution, as well as specialized hardware. See
Section 17.3.2.10, “SCI Transport Connections in
MySQL Cluster”
for detailed information about SCI interconnects.
You can define
default
values for each section. All Cluster parameter names are case-insensitive,
which differs from parameters specified in
my.cnf
or
my.ini
files.
17.3.2.2. The MySQL Cluster Connectstring
With the exception of the MySQL Cluster management server (
ndb_mgmd
), each node that is part
of a MySQL Cluster requires a connectstring that points to the management server's location. This
connectstring is used in establishing a connection to the management server as well as in performing
other tasks depending on the node's role in the cluster. The syntax for a connectstring is as follows:
[nodeid=
node_id
, ]
host-definition
[,
host-definition
[, ...]]
host-definition
:
host_name
[:
port_number
]
node_id
is an integer larger than 1 which identifies a node in
config.ini
.
host_name
is a string
representing a valid Internet host name or IP address.
port_number
is an integer referring to a TCP/
IP port number.
example 1 (long): "nodeid=2,myhost1:1100,myhost2:1100,192.168.0.3:1200"
example 2 (short): "myhost1"
localhost:1186
is used as the default connectstring value if none is provided. If
port_num
is
omitted from the connectstring, the default port is 1186. This port should always be available on the
network because it has been assigned by IANA for this purpose (see
http://www.iana.org/assignments/
port-numbers
for details).
By listing multiple host definitions, it is possible to designate several redundant management servers. A
MySQL Cluster data or API node attempts to contact successive management servers on each host in
the order specified, until a successful connection has been established.
Summary of Contents for 5.0
Page 1: ...MySQL 5 0 Reference Manual ...
Page 18: ...xviii ...
Page 60: ...40 ...
Page 396: ...376 ...
Page 578: ...558 ...
Page 636: ...616 ...
Page 844: ...824 ...
Page 1234: ...1214 ...
Page 1427: ...MySQL Proxy Scripting 1407 ...
Page 1734: ...1714 ...
Page 1752: ...1732 ...
Page 1783: ...Configuring Connector ODBC 1763 ...
Page 1793: ...Connector ODBC Examples 1773 ...
Page 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Page 2850: ...2830 ...
Page 2854: ...2834 ...
Page 2928: ...2908 ...
Page 3000: ...2980 ...
Page 3122: ...3102 ...
Page 3126: ...3106 ...
Page 3174: ...3154 ...
Page 3232: ...3212 ...