Table of Contents [+/-]
MySQL Enterprise subscription, MySQL Enterprise Monitor, MySQL Replication Monitor, and MySQL Query Analyzer are only available to commercial customers. To learn more, see: http://www.mysql.com/products/enterprise/features.html.
The purpose of the MySQL Enterprise Dashboard is to provide you with
information about your MySQL servers. It provides a list of the
latest MySQL Enterprise Advisor reports, server status information,
MySQL Enterprise alerts, and updated views of monitored MySQL
servers. The Monitor
screen gives a quick
overview of the status of your MySQL servers.
The MySQL Enterprise Dashboard interface is provided through a standard web browser. For more details on the supported browsers, see Section E.2, “Supported Browsers”.
You can open the Dashboard and connect to the MySQL Enterprise Dashboard either
using the standard HTTP protocol, or using an SSL connection
(HTTPS). By default, you can connect to MySQL Enterprise Dashboard using
http://
,
where host
:18080host
is the hostname or IP address of the
MySQL Enterprise Service Manager. The default SSL URL is
http://
.
These values can be overridden during installation. You can check
the configured values by looking at the
host
:18443configuration_report.txt
file within your
installation directory.
If you are connecting using SSL, the built-in certificate has been self-signed and may be highlighted as 'unsafe' within the browser on initial connection. You should add an exception for the certificate on this server to prevent problems accessing the site.
The Monitoring page provides an instant health check for all of the MySQL servers across the enterprise.
From this page users can:
View monitoring data and all critical MySQL Advisor Rule violations for all or selected servers.
Close and annotate MySQL Advisor Rule violations.
Quickly determine if there is a Monitor Agent that is not communicating with the Service Manager.
Quickly determine if there is a server that is in trouble or completely down.
View indicator value graphs for key MySQL and operating system (OS) level metrics. Graph presentation will default to a thumbnail view but will open into a larger image upon being clicked.
The monitored server or servers are displayed in a tab on the left
known as the Server Tree
. You can navigate to a
number pages that provide more detailed information. These pages
include:
Monitor
— the overview page providing
you with a quick summary of the servers, their status, events,
availability and load. The remainder of this chapter details the
contents of this page.
Advisors
— shows the various advisors
configured in your installation and allows you to schedule their
execution on different servers, apply and manage rules and
manage the advisor installation itself. For more information,
see Chapter 6, The Advisors Page.
Events — provides an interface into the event system that highlights specific issues and problems on your monitored servers. For more information on using Events, see Chapter 7, The Events Page.
Query Analyzer
— interfaces to the
query monitoring system that can be used to monitor and track
the individual queries that are being executed on a system and
help to highlight problem queries that may need optimization or
that may be affecting server load. For more information, see
Chapter 9, The Query Analyzer Page.
Graphs
— enables you to view and
configure a number of individual graphcs covering a range of
different statistics. For more details on how to view and use
these graphs, see Chapter 8, The Graphs Page.
Replication
— provides information on
the status and structure of your servers that are using
replication. This page is only available if you have a suitable
subscription level. For more information, see
Chapter 10, The Replication Page.
Settings
— controls the settings for
the server, including email configuration, passwords, and server
and user management. For more information, see
Chapter 5, The Settings Page.
Graphs are shown in the center of the page beneath the tabs. If applicable, you'll also find a list of critical events.
On the right is the color-coded Heat Chart
,
showing the advisors that are installed by default. The
Heat Chart
shows the most important advisors,
allowing a quick overview of the state of your servers. You may open
the Heat Chart
in its own window by clicking the
Standalone Heat Chart
link. If applicable, you'll
also find a list of critical events.
The Show/Hide Legend
link toggles display of the
key to the icons used in the Heat Chart
.
Find colorblind-accessible icons in the
alternate
directory. On Linux this directory
is immediately below the
/monitor/apache-tomcat/webapps/ROOT/web/resources/images/
directory. These images are stored in the same directory on
Windows. To use them, backup the originals and then copy and paste
the alternate set into the images
directory.
If a specific server is selected in the Server
Tree
details about this server are shown beneath the
legend in the Meta Info
area. The information
shown in this area is the host name, the MySQL version number, the
number of scheduled rules, the operating system, and the CPU.
The Meta Info
section also shows how long the
agent has been running, when it last contacted the MySQL server it
is monitoring, and the last time the agent contacted the dashboard.
Mouse over the date shown beside Up Since and a
pop-up box displays the time that has elapsed since the server
instance was last started. You can also mouse over the
Last MySQL Contact and the Last Agent
Contact dates.
In the case of remote monitoring, the agent runs on a different
machine than the MySQL server that it is monitoring. The
Hostname
, MySQL
, and
Rules
information applies to the system being
monitored. The OS
and CPU
information applies to the machine on which the agent is running.
For more information about remote monitoring see,
Section 2.3.6.4, “Configuring an Agent to Monitor a Remote MySQL Server”.
The top of the screen shows the refresh cycle and
Help
and Log Out
links. Click
the Help
link to open the documentation in a
separate browser window. Choose Log Out
if you
wish to leave the Dashboard or to log in as a different user.
Different refresh rates are available from the drop-down listbox.
In the footer are external links to MySQL Enterprise and information about the current user. Users can remain connected to the Dashboard and update their subscription, use the Enterprise Knowledge Base, and contact technical support. Your subscription information is also displayed here, showing the number of days remaining and the number of licenses. The number of licenses indicates to the number of machines that may be monitored; any number of MySQL servers may be running on a specific machine.
The footer also contains a link to the Settings
page. If your subscription is current it reads
Subscription is up-to-date. More info..... For
more information about the Settings
page see
Section 5.7, “The Product Information Screen”.