White Paper: MySQL Enterprise Monitor: Technical Overview
A Tool for Proactive Management of MySQL Database Environments
The 32-page white paper MySQL Enterprise Monitor: A Technical Overview provides a comprehensive functional and technical overview of the MySQL Enterprise Monitor and the distributed, web-based application that is used to service the comprehensive feature set. The MySQL Enterprise Monitor proactively monitors enterprise MySQL database environments and provides expert advice on how enterprise customers can tighten security and optimize the performance and uptime of their MySQL powered systems.
The MySQL Enterprise Monitor is designed to scale existing DBA resources to include MySQL specific expertise, allowing even those new to MySQL to proactively manage more MySQL servers with less time and effort.
The Enterprise Monitor feature set is powered by a distributed web-based application that is deployed within the confines of the corporate firewall. The key features of this application include:
- Group or Server level management options.
- Auto detection, Grouping and Monitoring of Replication and Scale-out Topologies.
- Enterprise Dashboard for managing all MySQL Servers from a consolidated console.
- Monitoring page for “at a glance” global health check of key systems.
- MySQL provided Advisors and Advisor Rules for enforcing MySQL Best Practices.
- Advisor Rule Scheduling for unattended operations.
- Customizable Thresholds and Alerts for identifying Advisor Rule violations.
- User Defined Advisor Rules.
The Enterprise Monitor application’s GUI Enterprise Dashboard contains this collection of pages and administrative functions (as well as others): Monitor page, Advisors page, Events page, Graphs page, Replication Monitor page, and Settings tab with application administration pages. Each is discussed in detail.
The white paper describes the architecture of the MySQL Enterprise Monitor Application, noting that software and services are provided via the secure enterprise.mysql.com Customer Center web portal. Subscribers using MySQL Enterprise Software Updates and Alerts subscribers are kept up to date on the latest releases of the MySQL server and other MySQL products and, at the same time, are informed of any serious issues that may affect their specific implementation of MySQL. This same mechanism is used to notify subscribers of updates to the Enterprise Monitor application components or to the supporting MySQL Advisors and Rules.
The white paper also describes each of the application components, including the MySQL Enterprise Service Agent, the MySQL Enterprise Service Manager, the MySQL Enterprise Repository, and the MySQL Enterprise Web Client.
The virtue of the MySQL Enterprise Monitor solution lies in its proactive nature, a decided advantage in the face of the burgeoning volume of data to be managed. Given that data volumes are doubling every year, the paper continues, MySQL Enterprise is designed to save DBAs time and effort by providing a proactive methodology for managing their MySQL systems and eliminating problems before they occur.
Available as part of a MySQL Enterprise subscription, the MySQL Enterprise Monitor provides DBAs with an intuitive, easy to use tool to proactively monitor all of their MySQL servers and to globally enforce MySQL best practices across the enterprise. The feature set is designed to ensure the highest level of security, performance and reliability are attained for all of their MySQL powered systems.
DBAs can also follow MySQL provided expert advice and guidance for tuning their database environments for the optimal use of MySQL. Finally, DBAs can use the consolidated, enterprise view into their MySQL environments to quickly identify where they should spend their limited time, allowing them to manage more MySQL servers, with higher confidence and less time and effort.