|
|
|
|
|
MySQL Enterprise Monitor: Business Overview Solve Your Datacenter Staffing Problems with this Solution July 14, 2010, Volume 149, Issue 2
The MySQL white paper "Virtual MySQL Assistance for the DBA: Enterprise Monitor, Advisors, and Query Analyzer" (registration or log-in required) is directed to the DBA with concerns over staffing levels necessary to meet the demands of the modern corporate data center. MySQL Enterprise Monitor can assuage those anxieties, the white paper contends, by acting as a virtual MySQL DBA. The white paper explains how this solution can be leveraged to meet the scale out rate required of MySQL and deliver the productivity demanded of contemporary DBAs. Given the capability of MySQL to perform well on commodity hardware, the enterprise is at liberty to scale out MySQL Replication at a rate that places difficult to meet demands on both the operational and application DBAs responsible for the installation. As the white paper notes, " ... while MySQL is known for its ease-of-use, steady performance and rock-solid reliability, the sheer number of MySQL servers (both Master and Slave), each with its own administrative and support needs, will grow ... [at a pace that makes] managing even more MySQL servers seems out of the realm of possibility." One of the many saving graces of MySQL Enterprise Edition, according to the white paper, is that it comes with its own "Virtual DBA" in the form of the MySQL Enterprise Monitor, which runs entirely within the corporate firewall, enabling DBAs to monitor enterprise database environments proactively and to manage problems before they become serious enough to interrupt mission critical operations. The white paper explains that MySQL Enterprise Monitor comprises three main components: a lightweight agent that is deployed to each monitored MySQL server where it collects MySQL and OS specific data; a centralized server that stores and evaluates the collected data; and a web-enabled client application that serves as the portal for the MySQL Enterprise Monitor user interface. The user interface itself, the white paper continues, is designed to provide the rich user experience found in the most common client based applications, and to do so from a very thin, browser based solution. MySQL Enterprise Monitor comes with a feature named the Enterprise Dashboard, which enables DBAs to monitor MySQL and OS specific metrics and replication topologies for single servers or groups of servers. The paper asserts that the Enterprise Dashboard is designed to enable DBAs to easily understand the complete security, availability, and performance picture of all their MySQL servers from one console. The paper provides a screen shot of the dashboard. Also illustrated is the color-coded Heat Chart to be found in the Enterprise Dashboard that provides an at-a-glance view into the availability and performance of all of the MySQL servers across the enterprise. The heat chart informs DBAs at a glance information such as the following:
The Enterprise Monitor overcomes the limitations of traditional script monitoring in that it enables the collection of monitored data and the correlation of current to past events. Furthermore, the MySQL Advisors (which provide information on administration, security, upgrade activity, customization, replication, memory usage, schema, and performance) reveal problems and tuning opportunities and offer corrective actions. The MySQL Advisor Rules are based on a set of MySQL supplied best practices that " ... allow DBAs to implement new MySQL servers with confidence and to proactively manage the dynamic nature of all of their MySQL servers over time," the paper explains. This enables round the clock operations with minimal opportunity for human error and higher rates of productivity along with lower total operational costs. Among the attributes of MySQL Advisor Rules is the capability to customize performance thresholds for specific MySQL servers and to issue critical severity alerts to DBAs when intervention might be required. Each Advisor Rule, the paper explains, supplies tailored recommendations, straight from the engineers at MySQL, who communicate in step-by-step fashion the best approach to rectifying a particular problem. A Replication Monitor feature gives DBAs a consolidated, real-time view into the health, performance and availability of all master/slave topologies. The MySQL Query Analyzer pinpoints SQL code that might, at any moment, be causing a slowdown and diagnoses the inefficiencies that must be corrected in order to restore performance to the desired level. The Enterprise Monitor also has the capability to display the most current MySQL server and Monitor releases via optional live feeds delivered to the Monitor's What's New? page. The white paper also demonstrates how DBAs can save nearly two working days on initial set up and on average of 20 minutes a day using the MySQL Enterprise Monitor to monitor MySQL performance and availability metrics in contrast to performing the same task using homegrown scripts. More Information
MySQL Enterprise, the Enterprise Monitor, Query Analyzer, production Support MySQL Replication and Scale-Out MySQL Professional Services and Consulting Customer Success Stories and Case Studies
Spring 2010 Release of MySQL Enterprise
[...read more...]
Keywords:
|
|
||||||||||||||||||||||||||||||
MySQL Enterprise Monitor: DBA in a box
Print
Email
MySQL Enterprise Monitor: Business Overview
(this article)
|
News and Solutions for Users of Solaris, Java and Oracle's Sun hardware products
Just the news you need, none of what you don't – 42,000+ Members – 24,000+ Articles Published since 1998 |
Copyright © 1998-2011 System News, Inc.
