![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_16461961571.webp)
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.
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...