MySQL Enterprise Monitor is available as part of the MySQL Enterprise subscription, learn more at http://www.mysql.com/products/.
MySQL Enterprise Monitor 3.0 features a new
Asset Selector on the
left side of many UI pages that controls content in the main-body of
the page. On the Events page, for example,
selecting a Host, Group, or MySQL Instance will display only those
Events relevant for the selected Asset. Reports &
Graphs pages also feature a full-blown Asset Selector,
while other UI pages show or hide various Asset types depending on
the content of the page.
Asset Selector content is automatically
populated as monitoring connections are made and maintained and
state information is gathered. The Groups shown in the
Asset Selector are the ones you create and manage
(on the MySQL Instances
dashboard or during Agent installation), and those that are
discovered automatically from monitoring replication topologies.
Use the Magnifying glass icon at the top of the
Selector panel to open up a control panel:
The Show All Assets checkbox. Toggle showing only Groups and MySQL Instances ("streamlined" mode) or showing all known Assets. These include:
This include hosts with (and without) MySQL instances.
Host-related Assets such as File Systems and Network Interfaces
Monitoring-related Assets such as:
The Service Manager itself, and its related Assets
The Tomcat web server, used by the Service Manager
And your monitored MySQL Instances and Groups
In "stream-lined mode", MySQL Instances are directly contained in Groups. In "All" mode, Groups contain Hosts, which then contain the MySQL Instances running on those Hosts; the same Group membership is represented but with a bit more detail about the operational relationship. Agents are also shown and listed as subordinate to the Hosts that they are running on.
The Query Analyzer page does not allow the selection of the "All" mode, as Query Analyzer only applies to Groups of MySQL Instances.
A Search box. Search all Assets for the specified Display Name; this provides a quick way to navigate to a specific MySQL Instance or Host when you know the name and is especially useful if you are monitoring a large number of Assets.
The search is case-insensitive, and requires the search string to be 3+ characters in length. Searching for nothing (blank) will reset the search filter.
Expand All / Collapse All tree controls.
Expanding this can be expensive when you are monitoring a large number of Assets.
There is also a control to horizontally collapse the entire
Asset Selector against the left-hand side of the
page and allow the main-body content to take more screen width.
Most Assets names are automatically derived from the conventional
name and other identifying details of the Asset. For example, MySQL
Instances are displayed as the "[hostname]:[port]" of the instance
unless you have manually edited the Display Name on the
MySQL Instances page.
Network interfaces display as: "[network-interface name] ([network address])", while File Systems are shown as: "[mount-point name] ([filesystem type])".
Agents are listed as "Agent ([UUID-fragment])", where "UUID-fragment" is the first and last 3 characters of the Agent's internal UUID (the remaining 26 characters are omitted); these 6 characters should be sufficiently unique to help you identify the right Agent when the UI presents you with a selection list.
Finally, the Service Manager has a built-in Agent that will be displayed as "MEM Built-in Agent".
Asset Status Styling
Agent Unavailable: The
Selector will show an Asset for which it has no recent
status information in
red italic text. This
usually means the Agent responsible for monitoring the Asset is
unexpectedly not communicating to the Service Manager.
Asset Unavailable: An Asset which is
actively monitored but determined by its Agent to be
inaccessible ("down") will be displayed in
Planned Notification Blackout: An Asset
which is in a planned "Blackout" state with respect to Event
Notifications is displayed in
Logical Assets: An Asset which is inferred
to be present and needed as a "container" but not actually being
monitored is displayed in
gray italic text.
If you are remotely monitoring an MySQL Instance, for example,
its Host would be displayed in
Emergency Event Badges
Asset Selector will display a numeric "badge"
next to any Asset that has open Emergency Events. Click on the badge
to view the Emergency Events.
MySQL Instance Notes
If you annotate a MySQL Instance with a Note on the MySQL Instances
Asset Selector will display a Note Icon
to the right when you hover over the Instance. View the Note in a
tooltip by then hovering over the Note Icon.