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.