The Technical Specifications show requirements at a high level. For more detailed information, including hardware sizing guidelines, see the topics listed under SQL DM for MySQL Requirements.


What's New

For the new features and fixed issues in the latest version of SQL Diagnostic Manager for MySQL, see SQL DM New Features and Fixed Issues.

System Requirements

TypePlatformVersion
Operating System


Linux (64-bit)
  • All distributions
  • Kernel 2.6.32

Microsoft Windows (32-bit)

  • 11
  • 10
  • 8.1
  • 8
  • 7
Microsoft Windows Server (32-bit)
  • 2022
  • 2019
  • 2016
  • 2012 R2
  • 2012
  • 2008 R2
  • 2008
  • Vista
Cloud
  • Amazon Elastic Compute Cloud (EC2)
  • Microsoft Azure Virtual Machine (VM)

Database

Amazon

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


Oracle MySQL Enterprise
  • 5.8
  • 5.7
  • 5.6
  • 5.5
  • 5.1
Percona Server for MySQL
  • 5.7
  • 5.6
  • 5.5
  • 5.1

Version History

Version 8.9.2

  • Analyze audit logging in Aurora Server.

Version 8.9.0

  • 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

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)


IDERA |  Products | Purchase | Support |  Resources |  About Us  | Legal