MySQL Cluster Manager 8.4 User Manual  /  Overview of MySQL Cluster Manager  /  MySQL Cluster Manager Architecture

1.2 MySQL Cluster Manager Architecture

This section provides an architectural overview of MySQL Cluster Manager, its components, and their deployment.

MySQL Cluster Manager is a distributed client/server application consisting of two main components. The MySQL Cluster Manager agent is a set of one or more agent processes that manage NDB Cluster nodes, and the MySQL Cluster Manager client provides a command-line interface to the agent's management functions.

Agent.  The MySQL Cluster Manager agent is comprised of the set of all MySQL Cluster Manager agent processes running on the hosts making up a given management site. A MySQL Cluster Manager agent process is a daemon process that runs on each host to be used in the cluster. In MySQL Cluster Manager, there is no single central server or process; all agents collaborate in managing a cluster as a whole. This means that any connected agent can be used to carry out tasks that effect the entire cluster.

Each agent process is responsible for managing the MySQL NDB Cluster nodes running on the host where the agent is located. MySQL NDB Cluster management and SQL nodes are managed directly by the MySQL Cluster Manager agent; cluster data nodes are managed indirectly, using the cluster management nodes.

Management responsibilities handled by the MySQL Cluster Manager agent include the following:

  • Creating and deleting clusters

  • Starting, stopping, and restarting cluster nodes

  • Cluster configuration changes

  • Backing up and restoring clusters

  • Cluster software upgrades

  • Host and node status reporting

  • Recovery of failed cluster nodes

Creating, performing initial configuration of, or starting a cluster, requires that agent processes be running on all cluster hosts. Once the cluster has been started, it continues to run even if one or more agent processes fail. However, any failed agent processes must be restarted before you can perform additional cluster management functions.

Client.  A MySQL Cluster Manager client is a software application used to access an MySQL Cluster Manager agent. The mcm client in the MySQL Cluster Manager release package is based on the mysql client.

By way of example, we show how MySQL Cluster Manager would be deployed for use with a MySQL NDB Cluster running on 4 host computers. This is illustrated in the following diagram:

Figure 1.1 MySQL Cluster Manager Deployment

Content is described in the surrounding text.

In this example cluster, two of the hosts each house a management server (ndb_mgmd) and an SQL node (mysqld); the other 2 hosts each house two data nodes (ndbd). However, regardless of the distribution of cluster nodes among the hosts, a MySQL Cluster Manager agent process must be running on each host.

A MySQL Cluster Manager client can be used to access the agent from any of the hosts making up the management site to which the cluster belongs. In addition, the client can be used on any computer that has a network connection to at least one of the hosts where an agent process is running. The computer where the client itself runs is not required to be one of these hosts. The client can connect to and use different agent processes on different hosts within the management site, at different times, to perform cluster management functions.