Announcing the General Availability of SQL Diagnostic Manager for MySQL 8.9.7

We are pleased to announce the general availability of SQL Diagnostic Manager (SDM) for MySQL 8.9.7  Existing users may upgrade to this version through the Idera Customer Portal. New users may download the trial version from the Idera Website or the Monyog Website.

SDM for MySQL is  a comprehensive solution to monitor, alert, and diagnose the availability, health, and performance of MySQL, or MariaDB in physical, virtual, and cloud environments.

SQL Diagnostic Manager for MySQL addresses the most critical performance management needs of DBAs.

• Monitor in real-time to take corrective action and resolve significant issues even before they affect end users
• Track and compare all changes to the MySQL or MariaDB configuration file to identify the reason for performance issues
• Monitor, alert to, and kill locked and long-running SQL queries in real-time to reduce system and database load
• Monitor on-premises and in the cloud.  Monitor Amazon RDS for MySQL, MariaDB, Amazon Aurora, and Google Cloud SQL for MySQL including operating systems and file-based logs
• Find top 10 SQL queries across MySQL or MariaDB servers based on total execution time

With this release, we aim to strengthen the ability of SQL Diagnostic Manager for MySQL to monitor databases in the cloud and on-premises with a single tool.  

What’s New in SQL Diagnostic Manager for MySQL 8.9.7?

Our latest release of SQL Diagnostic Manager for MySQL 8.9.7 includes the following new features and quality improvements.

New API for all SQL Diagnostic Manager for MySQL metrics

This release introduces a new full-featured API for SQL Diagnostic Manager for MySQL. The new API enables integration with other applications, command shells, or scripts as users may require.

Benefits:

• Fully script or automate all administrative functions of the product to integrate and automate within existing deployment and maintenance processes.
  • Start or stop collections
  • Enable or disable alerts
  • Add or delete servers from monitoring and change passwords for servers
• Retrieve values for any chart or specific metric monitored, including trends.
  • Integrate with other monitoring systems to consolidate information in one location
  • Automate documentation of data associated with particular alerts or other systems

Resources:

• Product documentation
• Product webpage