MySQL Cluster Status Test

This test reports the count of nodes in the target MySQL database cluster and indicates the number and names of those nodes that are currently available. This way, the nodes that are unresponsive/unreachable can be identified. The test also reports the nodes that are in recovering state. Using this test, administrators can figure out if only very few nodes in the cluster are available to service the client requests to the cluster. This signals a potential overload.

Target of the test : A MySQL Cluster

Agent deploying the test : A remote agent

Outputs of the test : One set of results for the target MySQL Cluster database server being monitored

Configurable parameters for the test
Parameter Description

Test Period

How often should the test be executed.

Host

The host for which the test is to be configured.

Port

The port at which the specified host listens.

MCMPath

Specify the full path to the location where the target MySQL Cluster manager is installed. For example, your location can be C:\Users\user\AppData\Roaming/mcmd.conf. By default, none is specified against this parameter.

Detailed Diagnosis

To make diagnosis more efficient and accurate, the eG Enterprise embeds an optional detailed diagnostic capability. With this capability, the eG agents can be configured to run detailed, more elaborate tests as and when specific problems are detected. To enable the detailed diagnosis capability of this test for a particular server, choose the On option. To disable the capability, click on the Off option.

The option to selectively enable/disable the detailed diagnosis capability will be available only if the following conditions are fulfilled:

  • The eG manager license should allow the detailed diagnosis capability
  • Both the normal and abnormal frequencies configured for the detailed diagnosis measures should not be 0.
Measurements made by the test
Measurement Description Measurement Unit Interpretation

Available nodes

Indicates the number of nodes in the cluster that are currently accessible.

Number

Use the detailed diagnosis of this measure to know which nodes in the cluster are currently accessible.

Recovering nodes

Indicates the number of nodes in the cluster that are currently in recovering state.

Number

Use the detailed diagnosis of this measure to know which nodes in the cluster are currently in recovering state.

Unresponsive nodes

Indicates the number of nodes in the cluster that are currently unresponsive.

Number

Use the detailed diagnosis of this measure to know which nodes in the cluster are unresponsive.

Unreachable nodes

Indicates the number of nodes in the cluster that are currently unreachable.

Number

Use the detailed diagnosis of this measure to know which nodes in the cluster are currently unreachable.