This section provides a glossary of terms which are unique to the NDB and MGM APIs, or that have a specialized meaning when applied in the context of either or both of these APIs.
The terms in the following list are useful to an understanding of MySQL Cluster, the NDB API, or have a specialized meaning when used in one of these:
Generally speaking, when data is saved to disk, it is said that
a checkpoint has been reached. When working with the
NDB storage engine, there are two sorts of
checkpoints which work together in order to ensure that a
consistent view of the cluster's data is maintained. These two
types, local checkpoints and
global checkpoints, are described in the
next few paragraphs:
Local checkpoint (LCP). This is a checkpoint that is specific to a single node; however, LCPs take place for all nodes in the cluster more or less concurrently. An LCP involves saving all of a node's data to disk, and so usually occurs every few minutes, depending upon the amount of data stored by the node.
More detailed information about LCPs and their behavior can be found in the MySQL Manual; see in particular Defining MySQL Cluster Data Nodes.
A related term is GCI, which stands for “Global Checkpoint ID”. This marks the point in the REDO log where a GCP took place.
A management (MGM) node is an instance of ndb_mgmd, the MySQL Cluster management server daemon.
A data node an instance of ndbd, the MySQL Cluster data storage daemon, and stores MySQL Cluster data. In MySQL Cluster NDB 7.0 and later, this may also be an instance of ndbmtd, a multithreaded version of ndbd.
An API nodeis an application that accesses MySQL Cluster data. SQL node refers to a mysqld (MySQL Server) process that is connected to the MySQL CLuster as an API node.
Restarting a node which has shut down on its own. (This is known as forced shutdown or node failure; the other cases discussed here involve manually shutting down the node and restarting it).
To update the node's configuration.
As part of a software or hardware upgrade.
In order to defragment the node's
Initial node restart. The process of starting a MySQL Cluster node with its file system having been removed. This is sometimes used in the course of software upgrades and in other special circumstances.
Contains a portion of a database table. In the
NDB storage engine, a table is broken up into
and stored as a number of subsets, usually referred to as
fragments. A fragment is sometimes also called a
Transporter. A protocol providing data transfer across a network. The NDB API supports 4 different types of transporter connections: TCP/IP (local), TCP/IP (remote), SCI, and SHM. TCP/IP is, of course, the familiar network protocol that underlies HTTP, FTP, and so forth, on the Internet. SCI (Scalable Coherent Interface) is a high-speed protocol used in building multiprocessor systems and parallel-processing applications. SHM stands for Unix-style shared memory segments. For an informal introduction to SCI, see this essay at www.dolphinics.com.
ACC (Access Manager).
An NDB kernel block that handles hash indexes of primary keys
providing speedy access to the records. For more information,
see Section 8.4.3, “The
TUP (Tuple Manager).
This NDB kernel block handles storage of tuples (records) and
contains the filtering engine used to filter out records and
attributes when performing reads or updates. See
Section 8.4.9, “The
DBTUP Block”, for more
TC (Transaction Coordinator).
Handles coordination of transactions and timeouts in the NDB
kernel (see Section 8.4.8, “The
Provides interfaces to the NDB API for performing indexes and
For more information, see
Section 8.4, “
NDB Kernel Blocks”, elsewhere in this
See also MySQL Cluster Overview, in the MySQL Manual.