Tech Specs: SQL Diagnostic Manager for MySQL

Technical Specifications

What Is New

Expand

Version 8.9

  • Query load profiling to Query Analysis along with new interface for Query Details to make it easier to analyze query performance over time
  • New APIs for updating user passwords and LDAP bind user password.
  • Enterprise security improvements:
    • Restrict access to individual custom dashboards and the ability to create new dashboards to newly created users
    • Capability to hide literals in SQL statements
    • Ability to remove default admin user, and rename the default Admin name
    • Improved audit log filtering, adding and excluding filter
    • Configurable SNMP trap format

Please also refer to the product documentation New Features and Fixed Issues.


Platform Support

Expand
  • Web console: Microsoft Windows, Linux
  • Cloud: Microsoft Azure VM, Amazon EC2
  • Monitored database platforms: Oracle MySQL Enterprise, MySQL Community Server, MariaDB, Percona Server for MySQL, Galera Cluster for MySQL, MariaDB Galera Cluster
  • Monitored managed cloud databases: Amazon RDS for MySQL, Amazon RDS for MariaDB, Amazon for Amazon Aurora, Microsoft Azure MySQL, Google Cloud SQL for MySQL, Oracle MySQL Cloud Service

Please also refer to the product documentation SQL DM for MySQL Requirements.


System Requirements

Expand

Web Console

  • Microsoft Windows: Server 2016, Server 2012 R2, Server 2012, Server 2008 R2, Server 2008, 8.1, 8, 7; 64-bit, 32-bit
  • Linux: all distributions, kernel 2.6.32

Cloud

  • Runs on cloud virtual machines such as Microsoft Azure Virtual MAchine (VM) and Amazon Elastic Compute Cloud (EC2) with Microsoft Windows and Linux.
  • Monitors database instances on cloud virtual machines such as Microsoft Azure Virtual MAchine (VM) and Amazon Elastic Compute Cloud (EC2).
  • Monitors the managed cloud databases Amazon Relational Database Service (RDS), Microsoft Azure Database, Google Cloud SQL, and Oracle Cloud Service.

Please also refer to the product documentation SQL DM for MySQL Requirements.


Supported Systems

Expand

Monitored Database Platforms

  • Oracle MySQL Enterprise: 5.8, 5.7, 5.6, 5.5, 5.1
  • MySQL Community Server: 8.0, 5.7, 5.6, 5.5, 5.1
  • MariaDB: 10.3, 10.2, 10.1, 10, 5.5 (, 5.3, 5.2, 5.1)
  • Percona Server for MySQL: 5.7, 5.6, 5.5, 5.1
  • Galera Cluster for MySQL: 3
  • MariaDB Galera Cluster: 10.0, 5.5
  • Amazon RDS for MySQL, for MariaDB, for Amazon Aurora
  • Microsoft Azure MySQL
  • Google Cloud SQL for MySQL
  • Oracle MySQL Cloud Service

Please also refer to the product documentation SQL DM for MySQL Requirements.


Version History

Expand

Version 8.8.0

  • Monitor Google Cloud SQL server Operating System metrics
  • This release includes Google Cloud SQL server file based log monitoring for General query, Slow query, and Error log files

Version 8.7.0

There are no new features for this product version release.

Version 8.6.0

  • A Galera cluster can now be automatically registered specifying any single node in cluster
  • Optimized counter migration logic
  • Added more columns for Slow Query log (for MariaDB and Percona Server)
  • Connection timeout (MySQL, SSH and SSH Tunnel) can now be set for servers individually

Version 8.5.0

  • Analyze MariaDB and MySQL enterprise Audit log
  • Support for LDAP with StarTLS and SSL
  • Default path for MONyog.log can be changed using parameter “MONyogLogPath” from MONyog.ini file

Version 8.4.1

There are no new features for this product version release.

Version 8.4.0

  • Added more notification channels (Slack and Pagerduty) for alerts.
  • Write alerts in Syslog of machine where SQL DM for MySQL is installed; this option is only available for Linux
  • Edit subject line for alerts.
  • Added API to disable notification for monitor based on server or tag.
  • Complete redesign of Settings page.

Version 8.3.2

There are no new features for this product version release.

Version 8.3.1

There are no new features for this product version release.

Version 8.3.0

  • Option to set distinct email distribution list for warning and critical alerts
  • Improved Graph Analysis
  • Disk monitoring of system where SQL DM for MySQL is installed
  • Filter to exclude unwanted long running queries in Sniffer
  • Ignore particular type of query by specifying regular expression
  • Option to filter queries based on poor indexes, missing indexes, errors and warnings
  • Redesigned Server selector
  • Redesigned Query Analyzer: more intuitive view of top 5 queries based on total time
  • Added proper Y-axis unit for charts, along with option to define units and unit-factors

Version 8.2.0

  • Same Y-axis scaling for Dashboard charts across all servers

Version 8.1.1

There are no new features for this product version release.

Version 8.1.0

  • Get OS metrics from Amazon RDS/Aurora (but not Azure, where interface for same is disabled).
  • Generate token to be used with API as alternative to user and password
  • Define “seconds_behind_master” setting in Replication page determining if slave should be considered in sync or not. On some environments, slave is rarely fully in sync and in such cases, alerting was not really useful before
  • MONyog-bin.pid location on Linux can now be changed from Monyog.ini file
  • Reintroduced tabular view for Replication overview page
  • Select way the server selector should work

Version 8.0.4

There are no new features for this product version release.

Version 8.0.3

  • Option to export entire Dashboard charts
  • Option to search tags in Server selectors
  • Completely re-designed Servers page

Version 8.0.2

  • Added Dashboard charts and monitors for Aria storage engine
  • Performance schema can now be used with Amazon RDS Aurora (version 5.6.10)

Version 8.0.1

There are no new features in this product version release.

Version 8.0.0

  • Added support for Multi-Source Replication
  • SNMP v2 is now supported
  • Added new Monitors for number of plugins (Failed to load plugin list, Non mature plugin, Audit log enabled, Audit log load_option FORCE_PLUS_PERMANENT, Password verification enabled)

Please also refer to the product documentation Previous Features and Fixed Issues.

Try SQL Diagnostic Manager for MySQL FREE for 14 days

SQL Diagnostic Manager for MySQL and MariaDB

Start for Free


Share This
Contact IDERA: