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 displays 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 filter icon at the top of the
Selector panel to open 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) resets 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
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 is displayed as "MEM Built-in Agent".
Asset Status Styling
Agent Unavailable: The
Selector displays Assets 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") is displayed in red text.
Planned Notification Blackout: An Asset which is in a planned "Blackout" state with respect to Event Notifications is displayed in gray italic text.
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 gray italic text.
Emergency Event Badges
The Asset Selector displays a numeric badge next to any Asset that has open Emergency Events, and the text of the asset changes colour to red. Click on the badge to view the Emergency Events. These Emergency Events apply to assets which are monitored by Advisors checking for those specific conditions, only. For example, if one of the network interfaces becomes unavailable, it is not marked with a badge, it is removed from the Asset Selector because the network-specific Advisors do not check for the availability of network interfaces, just the data transmitted on them. For assets such as agents, filesystems and MySQL instances, Advisors monitor their availability in addition to their activities. If an agent or instance becomes unavailable, or a filesystem approaches its free-space limit, a numeric badge is displayed on the asset's icon and the name of the asset is displayed in red.
If problems exist for multiple assets on a host, the number of problems on that host are displayed in a numeric badge at the host level.
MySQL Instance Notes
If you annotate a MySQL Instance with a Note on the MySQL Instances page, the Asset Selector displays 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.