Chapter 1 MySQL Enterprise Monitor Introduction and Architecture

Table of Contents

1.1 MySQL Enterprise Service Manager
1.2 MySQL Enterprise Monitor User Interface
1.3 Advisors
1.4 Monitored MySQL Server
1.5 MySQL Enterprise Agent
1.5.1 MySQL Enterprise Monitor Agent Basic Architecture

MySQL Enterprise Monitor is a companion product for MySQL Server that monitors your MySQL instances, notifies you of potential issues and problems, and advises on how to fix the issues. MySQL Enterprise Monitor can monitor all kinds of configurations, from a single MySQL instance to large farms of database server machines powering a busy web site.

This section describes the basic components that make up the MySQL Enterprise Monitor product. These components can be installed in various configurations depending on your own database and network topology, to give you the best combination of reliable and responsive monitoring data, with minimal overhead on the database server machines. A typical MySQL Enterprise Monitor installation consists of:

The architecture of a typical MySQL Enterprise Monitor installation is shown in the following figure:

Figure 1.1 MySQL Enterprise Monitor Architecture

MySQL Enterprise Monitor Architecture

MySQL Enterprise Monitor can monitor one or more MySQL instances, on a single computer or spread across multiple host machines. The agent collects variables, status, and health information from MySQL instances and hosts, and sends this information to the MySQL Enterprise Service Manager. It is recommended to install one agent per host.

The monitoring data is sent to the MySQL Enterprise Service Manager, which collates information from all the agents. The MySQL Enterprise Service Manager checks whether the values of status values are within reasonable limits. When thresholds are reached, the server can trigger an event (including a notification) to highlight a potential issue, such as low memory, high CPU usage, or more complex conditions such as insufficient buffer sizes.

Advisors are a vital part of the MySQL Enterprise Service Manager, warning about potential problems and providing troubleshooting advice. All Advisors are enabled by default, and may be configured, and trigger events using the event handling mechanism.

You interact with the MySQL Enterprise Service Manager through a web interface, powered by an included web server. This interface, the MySQL Enterprise Monitor User Interface, displays the information collected by the Agents. You can view current status for individual MySQL servers or groups of servers. You control and configure all aspects of the service using the MySQL Enterprise Monitor User Interface.

The MySQL Enterprise Monitor User Interface can display statistical and query information as graphs. For example, you can produce graphs over time of aspects such as server load, query numbers, or index usage information. The graphs help to pinpoint the timeframes and trends related to potential issues.

The MySQL Enterprise Monitor Agent can also collect detailed information about database queries, including the row counts and performance times for executing each query. You can correlate the detailed query data with the graph information to identify which queries were executing when you experienced an issue. A system called Query Analyzer presents the query data in various ways.