Threshold and Availability for MySQL NDB Cluster monitor

Set up alerts when your MySQL NDB Clusters reach specified threshold limits so that you can take informed actions.

Add a Threshold and Availability Profile

1. Log in to Site24x7.
2. Go to Admin > Configuration Profiles > Threshold and Availability > Add Threshold Profile. You can also navigate via Server > Server Monitor > MySQL NDB and click the MySQL NDB Cluster monitor to which you want to add a threshold profile. Hover on the hamburger icon beside the display name and click Edit > Configuration Profiles, then click the pencil icon beside Threshold and Availability.
3. Specify the following details:
   • Monitor Type: Select the MySQL NDB cluster monitor from the drop-down list.
   • Display Name: Provide a label for identification purposes.
   • Threshold Type: Choose between Static and AI-based thresholds. Refer to the list of supported metrics for the metrics that can have thresholds.
   • Static Thresholds: Choose the desired metrics from the drop-down menu, enter the threshold values specific to the unit, and set the threshold conditions (<, <=, =, >, or >=) and the monitor state (to be notified as) for each metric. Alerts will be generated when these threshold conditions are violated.
   • AI-based Zia Thresholds: If you choose AI-based thresholds, the system will track abnormal spikes using anomaly detection and offer dynamic thresholds that will be updated accordingly. Choose the associated anomaly severity and status as required.
4. Click Save.The threshold and availability profile created for the MySQL NDB Cluster monitor will be automatically listed in the Threshold and Availability screen along with the others already created.

List of Supported Metrics

Here is the latest updated list of metrics supported by Site24x7 for MySQL NDB Cluster monitoring. Enter a value specific to the unit, set the threshold conditions (<, <=, =, >, or >=), and specify the monitor state (to be notified as) for each metric. You'll receive alerts when these threshold conditions are violated. Refer to the performance metrics help document for MySQL NDB Cluster monitoring for detailed explanations of each metric.

General metric

• Long message buffer used
• Long message buffer used pages

Memory usage threshold

• Long message buffer total
• Long message buffer total pages
• Long message buffer available
• Long message buffer available pages
• Data memory used
• Data memory used pages
• Data memory total
• Data memory total pages
• Data memory available
• Data memory available pages
• Index memory used
• Index memory used pages
• Index memory total
• Index memory total pages
• Index memory available
• Index memory available pages

Log buffer usage threshold

• Redo log buffer available
• Redo log buffer total
• Redo log buffer used
• Undo log buffer available
• Undo log buffer total
• Undo log buffer used
• Backup data log buffer available
• Backup data log buffer total
• Backup data log buffer used
• Backup-log log buffer total
• Backup-log log buffer total
• Backup-log log buffer used

Log spaces usage threshold

• Redo log spaces available
• Redo log spaces total
• Redo log spaces used
• Undo log spaces available
• Undo log spaces total
• Undo log spaces used

Node count based threshold

• Management nodes down
• Data nodes down
• MySQL nodes down

Edit a Threshold and Availability Profile

1. Click the profile you want to edit.
2. Edit the parameters that need to be changed in the Add Threshold Profile window.
3. Click Save.

Delete a Threshold and Availability Profile

1. Click the profile in the Threshold and Availability screen that you want to delete.
2. You will be directed to the Edit Threshold Profile window.
3. Click Delete.

Related content

• MySQL NDB Cluster - Add a monitor | Performance metrics monitored
• Add a MySQL monitor
• Add a linux server monitor
• MySQL performance metrics supported