MySQL Enterprise Monitor 4.0.0 GA has been released

[Andy Bang]

We are very happy to announce the general availability of MySQL
Enterprise Monitor, Version 4.0. MySQL Enterprise Monitor is the best-
in-class tool for monitoring and management of your MySQL assets and
is included with your MySQL Enterprise Edition and MySQL Enterprise
Carrier Grade subscriptions.

You’ll find information about what’s new here:

http://dev.mysql.com/doc/relnotes/mysql-monitor/4.0/en/news-4-0-0.html
(also included at the end of this note for convenience)

Highlights

* Modern look and feel: a redesigned user interface delivers a vastly
improved overall user experience. The visible changes--the layout,
the icons, the and the overall aesthetics--provide a more natural
and intuitive experience. Views dynamically change and adjust to
your current context and the assets you've selected, everything from
individual MySQL instances or hosts to your custom Groups, to your
complex replication and clustered topologies. Additional
enhancements include a much more responsive UI and a greater
capacity to scale, allowing you to more effectively manage thousands
of MySQL related assets.

* MySQL Cluster monitoring: we now auto-discover your MySQL Cluster
installations and give you visibility into the performance,
availability, and health of each MySQL instance and NDB process, as
well as the health of the MySQL Cluster instance as a single logical
system. The Overview dashboard displays detailed instrumentation
available for each MySQL Cluster and the Topology dashboard displays
the current configuration of your MySQL Cluster enabling you to
quickly see the status of the MySQL Cluster instance as a whole and
each individual process. The Topology dashboard allows you to easily
see how your MySQL Cluster installations are currently functioning.

* A User Statistics report: which provides an easy way to monitor
MySQL resource utilization broken down by user.

Download

You will find binaries for the new release on My Oracle Support:

http://support.oracle.com

Choose the "Patches & Updates" tab, and then choose the "Product or
Family (Advanced Search)" side tab in the "Patch Search" portlet.
Note that it may take a day or so for the "Release" drop-down cache
to refresh to include "MySQL Enterprise Monitor 4.0".

You will also find the binaries on the Oracle Software Delivery Cloud:

http://edelivery.oracle.com/

Search "All Categories" for "MySQL" and choose from the results
accordingly. You will find the Enterprise Monitor along with other
MySQL products.

If you are not a MySQL Enterprise customer and want to try the Monitor
and Query Analyzer using our 30-day free customer trial, go to
http://www.mysql.com/trials, or contact Sales at
http://www.mysql.com/about/contact.

Please open a bug or a ticket on My Oracle Support to report problems,
request features, or give us general feedback about how this release
meets your needs.

Useful URLs

* My Oracle Support - http://support.oracle.com/
* What's New in 4.0 - https://dev.mysql.com/doc/mysql-monitor/4.0/en/mem-comparison.html
* Change log - http://dev.mysql.com/doc/relnotes/mysql-monitor/4.0/en/
* Installation documentation - http://dev.mysql.com/doc/mysql-monitor/4.0/en/mem-installing.html
* Complete documentation - http://dev.mysql.com/doc/mysql-monitor/4.0/en/
* Product information - http://www.mysql.com/products/enterprise/monitor.html
* Download - http://support.oracle.com/ or http://edelivery.oracle.com/

Thanks and Happy Monitoring!

- The MySQL Enterprise Tools Development Team

==========

Changes in MySQL Enterprise Monitor 4.0.0

NDB Cluster Monitoring

* Important Change: MySQL NDB Cluster monitoring has been added in
this release for NDB Cluster 7.5.7, or higher.

The following changes were made to support it:

- Overview was extended to provide detailed information on NDB
Cluster nodes.

- Advisors were updated.

The following NDB Cluster advisors were added in this release:

NDB Cluster Memory Usage:

NDB Cluster Status:

- All existing Cluster advisors were renamed with the prefix NDB
Cluster.

- The following advisors were removed and their functionality rolled
into the NDB Cluster Memory Usage advisor:

Cluster Data Node Data Memory Getting Low

Cluster Data Node Index Memory Getting Low

- The following advisors were removed and their functionality rolled
into the NDB Cluster Status advisor:

Cluster Data Node Has Been Restarted

Cluster Data Nodes Not Running

Cluster Has Stopped

- Discovery of ndbd, ndbmtd, and ndb_mgmd processes.

- Events view is extended to support MySQL NDB Cluster. Events are
now generated for NDB Data Nodes, Management Nodes, and API Nodes,
as well as MySQL instances and hosts.

- The Topology view is updated to support NDB Cluster topologies.

- An NDB Cluster Memory Usage report is added in this release. For
more information, see NDB Cluster Memory Usage. The report is
based on the output from the ndbinfo.memory_per_fragment table.
For more information, see The ndbinfo memory_per_fragment Table.

User Interface Enhancements

* Important Change: The user interface was extensively redesigned.

- A navigation bar is added to the left side of the interface. All
functional navigation is now performed through this navigation
bar.

- The Overview was extensively redesigned. See Overview for more
information.

- The Asset Selector was replaced with target selection fields which
establish a context for all data displayed in the application. For
example, if you select a single MySQL instance, only the data for
that instance is displayed for all views. See Target Selection for
more information.

The target selector fields are persistent and present for all
views.

See Target Selection for more information.

- The Settings menu (gear icon), is removed. All its contents are
now grouped under the Configuration section of the navigation bar
on the left side of the interface.

- The Roles and Users views are updated in this release.

* The Create Event Handler dialog's Filter section was redesigned.
Also, the Group and Assets columns in the Event Handler list are
combined into the Subjects column.

For more information, see Creating Event Handlers.

Functionality Added or Changed

* It is now possible to specify an exclusion list of users with
database-level privileges on all databases in the mysql.user table.
This is done using a regular expression in the MySQL User Account
advisor. An event is generated for any user which does not match the
defined expression.

For more information, see MySQL User Account.

Note: This change replaces the Non-root User Has DB, Table, Or Index
Privileges On All Databases advisor, and moves its functionality to
the MySQL User Account advisor. If you changed the scheduling or
thresholds on the Non-root User Has DB, Table, Or Index Privileges
On All Databases advisor, the changes will be lost after upgrading
to this version.

(Bug #26260456, Bug #11748288, Bug #25696565)

References: See also: Bug #17742263, Bug #26130781.

* A User Statistics report is added in this release. For more
information, see User Statistics. The report is based on the user
summary sys schema views. For more information, see The user_summary
and x$user_summary Views. (Bug #18888933)

* The MySQL server, bundled with the MySQL Enterprise Service Manager,
has been upgraded to MySQL 5.7.19.

Important: Changes have been made to the prerequisites of MySQL
5.7.19.

- libnuma.so.1 must be present on Linux platforms. The MySQL
Enterprise Service Manager full and upgrade installers check for
the existence of this library.

- During a MySQL Enterprise Service Manager upgrade, the upgrade
installer runs the mysql_upgrade utility.

* The Tomcat server, bundled with the MySQL Enterprise Service
Manager, has been upgraded to 8.5.16.

* The bundled JRE was updated to 1.8.0_141 for both the Agent and
Service Manager.

* --mysql_ssl is no longer required by the MySQL Enterprise Service
Manager installer and has been removed.

* Data Purge settings have been added for aggregated data. For more
information, see Data Purge Behavior.

Bugs Fixed

* On the Advisors page, filtering for specific advisors did not return
all the advisors filtered for. (Bug #26668301)

* On Linux, Unix, and Mac OS X platforms, the agent installer did not
check the installation directory to ensure it had the required
permissions to install MySQL Enterprise Monitor Agent in that
location.

As of this release, the installer checks the directory for the
appropriate permissions. If it does not have the rights to install
to that location, it returns the following error message:

There has been an error.
The current installation directory could not be accessed by non-root users.
Please select a different installation directory or change the permissions
to 755 for this directory.

(Bug #26551166)

* If the Asset Selector was collapsed, there was no indication of
which asset was selected. (Bug #25252032)

* It was not possible to filter a group twice in the Asset Selector.
(Bug #20584984)

* Auto-refresh interfered with menu selection. (Bug #11748623)

* Sparkline graphs did not refresh dynamically.

* The Group Replication advisor, when expanded, listed MySQL instances
which were not involved in Group Replication.

* Under certain circumstances, if the server hosting MySQL Enterprise
Service Manager was restarted, MySQL Enterprise Service Manager
failed to restart, logging the following error: Error creating bean
with name 'groupReplicationMembership'.

* The Add a new graph drop-down menu was not displayed on the Overview
dashboard.

* It was not possible to open a selected range of a timeseries graph
in the Query Analyzer. The Query Analysis link did not behave as
expected.

* An error was displayed when selecting the Table Statistics report:
Unable to generate SYS Schema report for selected MySQL Server.
(U0422).

As of this release, the agent's Admin, General, and Limited users
are granted the EXECUTE privilege.

Important: If you defined these users manually, you must grant them
the EXECUTE privilege.

For more information, see Creating MySQL User Accounts for the
Monitor Agent.

* The Data Purge Behavior drop-down menus displayed Never if the
first-time setup was performed using the configuration utility, and
the purge values set to any value not divisible by 7.

The values were correctly defined, this was a display issue, only.

* Graphs were not included in the Support Diagnostics report.

* On Mac OS X platforms, the java_home_dir variable was not set
properly by the installer. As a result, the configuration report
contained the following error: ***unknown variable java_home_dir.

* On Linux, Unix, and Mac OS X platforms, the MySQL Enterprise Service
Manager upgrade installer could not upgrade the installation if the
installation directory contained files or directories created by a
different user, or a user with permissions which differed from those
of the user running the upgrade.

As of this release, the installers check the installation directory
to ensure all files and directories have the correct permissions. If
they do not, it exits with an informative error message.

* Under certain circumstances, it was not possible to montor an
instance which had previously been monitored and then deleted by
MySQL Enterprise Service Manager.

* Graph data was not displayed for intervals of four or more days if
the interval was defined on a combined graph.