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 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) 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
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
text. This usually means the Agent responsible for
monitoring the Asset is unexpectedly not communicating to the
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
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 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.