MySQL NDB Cluster monitor

Set up Site24x7's MySQL NDB Cluster monitoring to better understand your MySQL NDB Clusters. MySQL NDB Cluster monitoring will equip you with the knowledge and tools necessary to ensure the node availability, performance, and scalability of your NDB Cluster environment.

Table of Contents

Add a MySQL NDB Cluster monitor

Follow the steps provided in the how to add a MySQL NDB Cluster monitor help document to set up monitoring for your MySQL NDB Clusters.

Performance metrics

Find the extensive list of essential metrics that can be monitored using our advanced MySQL NDB Cluster monitor. Monitoring these metrics is crucial for gaining deep insights into the performance and health of your NDB Cluster. By closely tracking these parameters, you can proactively identify potential bottlenecks, troubleshoot issues, and optimize the overall efficiency of your NDB Cluster.

Set thresholds

The list of metrics for which you can set threshold limits and the instructions to set up such threshold limits are available in the Threshold and availability for a MySQL NDB Cluster monitor help document.

IT Automation

Automate remedial and repetitive actions with Site24x7's IT Automation Templates. The IT Automation Templates you can use are listed here.

Uninstall the Linux agent

To uninstall the Linux agent, execute the following commands based on the user type:

Root user:

sudo /opt/site24x7/monagent/bin/uninstall

Non-root user:

/site24x7/monagent/bin/uninstall

Licensing

Each MySQL NDB Cluster consumes one advanced monitor.

Best practice

To ensure uninterrupted access to the metrics of your MySQL NDB Cluster, we recommend installing Site24x7's Linux server monitoring agent on all of the SQL nodes. Site24x7 recommends this as a best practice because if the monitoring agent is installed on all of the SQL nodes, you will have uninterrupted data even if one of your SQL nodes goes down. Installing the server monitoring agent on either the data (NDB) node or the management (MGM) node will get you that particular node's metrics, such as:

• Disk utilization
• CPU utilization
• Memory utilization