MySQL Cluster Members Test
This test monitors the current status of each node in the target MySQL cluster and also reports whether/not the node is a primary node. Using this test, administrators can proactively figure out error-prone nodes, nodes that are unreachable and nodes that are removed/missing and take corrective actions for those nodes to be available.
Target of the test : A MySQL Cluster
Agent deploying the test : A remote agent
Outputs of the test : One set of results for each node on the target MySQL Cluster database server being monitored
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. |
Database |
Specify the name of a database on the target MySQL Cluster database server being monitored |
Username and Password |
The eG agent has to be configured with the credentials of a user who has server-wide Process and Select privileges on the monitored MySQL Cluster database server. To know how to create such a user, refer to Pre-requisites for Monitoring the MySQL Cluster Database Server |
Confirm Password |
Confirm the password by retyping it here. |
Measurement | Description | Measurement Unit | Interpretation | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Status |
Indicates the current status of this node. |
|
The values reported by this measure and their numeric equivalents are available in the table below:
Note: This measure reports the Measure Values listed in the table above to indicate whether/not the target cluster is running. However, in the graph, this measure is indicated using the Numeric Values listed in the table above. |
||||||||||||||
Is primary? |
Indicates whether/not this node is a primary node. |
|
The values reported by this measure and their numeric equivalents are available in the table below:
Note: This measure reports the Measure Values listed in the table above to indicate whether/not the node is a primary node. However, in the graph, this measure is indicated using the Numeric Values listed in the table above. |