MySQL Enterprise Advisors

Your Virtual MySQL DBA Assistant

• Spring 2008 Release Available Now

The 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 110+ security, performance and replication specific rules that 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 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
• 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
• 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 Certified MySQL DBA always on guard. And with a MySQL Enterprise subscription you regularly receive new Advisors and Advisor Rules from MySQL, so your MySQL servers always has the latest protection levels in place.