MySQL Enterprise Advisors

Only available in select Commercial Editions

Your Virtual MySQL DBA Assistant

• Improved Monitoring for MySQL Enterprise Edition and MySQL Cluster CGE

MySQL Enterprise Monitor differs from traditional monitoring tools in that it supplies best practice Advisors that are designed to automatically examine a MySQL server’s configuration, security, and performance levels, and identify any deviations from best practice rules that are built by the database experts at MySQL.

The MySQL Enterprise Advisors provide you with the following benefits:

• Easily identify the most secure, up to date version of MySQL you should deploy across all your servers.
• Improve MySQL security, performance and replication and simplify administration by proactively receiving MySQL best practice advice.
• Run 160+ MySQL and OS specific rules that continuously monitor and advise you on optimal settings for 600+ MySQL and OS specific variables.
• Implement out of the box scripts that save DBAs time and effort coding, testing, implementing and maintaining scripts.
• Build custom Advisors and Rules tailored to the needs of your particular MySQL environment.
• Regularly receive new Advisors and Rules to ensure you are always current on MySQL recommended best practices.

The MySQL Enterprise Monitor ships with the following set of best practice Advisors:

• Upgrade - Monitors and advises you on using the most secure and up to date version of MySQL you should deploy.
• Administration – Monitors and advises on problems relating to general database administration, recoverability and performance configuration settings
• MySQL Enterprise Backup – Monitors and Advises on MySQL Enterprise Backup operations, status and MySQL servers needing to be backed up
• Security – Monitors and advises on tightening security vulnerabilities in the MySQL Server
• Replication – Monitors and advises on problems relating to Replication setup, security and Master/Slave latency
• Memory Usage - Monitors dynamic memory related server metrics (cache usage, hit ratios, etc.) and advises on configuration changes to improve performance
• Performance – Monitors dynamic performance related server metrics and advises on configuration and variable settings to improve performance
• Schema – Monitors and advises on unplanned changes to a database schema
• MySQL Cluster – Monitors and Advises on health, performance and availability of MySQL Cluster data nodes
• Custom – Create your own Best Practice Advisors and Rules to fit your specific use of MySQL

Having the MySQL Enterprise Monitor and MySQL Advisors constantly checking the configuration and workload of monitored MySQL servers is like having a virtual MySQL DBA always on guard.

White Papers

• MySQL Enterprise Monitor: What's New
• MySQL Enterprise Monitor: Business Overview

On Demand Webinars

• Monitoring and Enforcing Security, Performance and Replication Best Practices Using MySQL Enterprise

Frequently Asked Questions (FAQ)

• MySQL Enterprise Monitor
• MySQL Query Analyzer