MySQL Cluster Core Concepts
1516
17.1.1. MySQL Cluster Core Concepts
NDBCLUSTER
(also known as
NDB
) is an in-memory storage engine offering high-availability and data-
persistence features.
The
NDBCLUSTER
storage engine can be configured with a range of failover and load-balancing
options, but it is easiest to start with the storage engine at the cluster level. MySQL Cluster's
NDB
storage engine contains a complete set of data, dependent only on other data within the cluster itself.
The “Cluster” portion of MySQL Cluster is configured independently of the MySQL servers. In a MySQL
Cluster, each part of the cluster is considered to be a node.
Note
In many contexts, the term “node” is used to indicate a computer, but when
discussing MySQL Cluster it means a process. It is possible to run multiple
nodes on a single computer; for a computer on which one or more cluster nodes
are being run we use the term cluster host.
However, MySQL 5.0 does not support the use of multiple data nodes on a
single computer in a production setting. See
Section 17.1.5.9, “Limitations
Relating to Multiple MySQL Cluster Nodes”
.
There are three types of cluster nodes, and in a minimal MySQL Cluster configuration, there will be at
least three nodes, one of each of these types:
• Management node (MGM node): The role of this type of node is to manage the other nodes within
the MySQL Cluster, performing such functions as providing configuration data, starting and stopping
nodes, running backup, and so forth. Because this node type manages the configuration of the other
nodes, a node of this type should be started first, before any other node. An MGM node is started
with the command
ndb_mgmd
.
• Data node: This type of node stores cluster data. There are as many data nodes as there are
replicas, times the number of fragments (see
Section 17.1.2, “MySQL Cluster Nodes, Node Groups,
Replicas, and Partitions”
). For example, with two replicas, each having two fragments, you need four
data nodes. One replica is sufficient for data storage, but provides no redundancy; therefore, it is
recommended to have 2 (or more) replicas to provide redundancy, and thus high availability. A data
node is started with the command
ndbd
(see
Section 17.4.1, “
ndbd
— The MySQL Cluster Data
Node Daemon”
).
MySQL Cluster tables in MySQL 5.0 are stored completely in memory rather than on disk (this is
why we refer to MySQL cluster as an in-memory database). In MySQL 5.1, MySQL Cluster NDB 6.X,
and later, some MySQL Cluster data can be stored on disk, but we do not expect to backport this
functionality to MySQL 5.0; see
MySQL Cluster Disk Data Tables
, for more information.
• SQL node: This is a node that accesses the cluster data. In the case of MySQL Cluster, an SQL
node is a traditional MySQL server that uses the
NDBCLUSTER
storage engine. An SQL node is a
mysqld
process started with the
--ndbcluster
[1610]
and
--ndb-connectstring
options,
which are explained elsewhere in this chapter, possibly with additional MySQL server options as
well.
An SQL node is actually just a specialized type of API node, which designates any application which
accesses Cluster data. Another example of an API node is the
ndb_restore
utility that is used
to restore a cluster backup. It is possible to write such applications using the NDB API. For basic
information about the NDB API, see
Getting Started with the NDB API
.
Important
It is not realistic to expect to employ a three-node setup in a production
environment. Such a configuration provides no redundancy; to benefit from
Содержание 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 ...