MySQL Enterprise Monitor 3.4.2 has been released

[Andy Bang]

We are pleased to announce that MySQL Enterprise Monitor 3.4.2 is now
available for download on the My Oracle Support (MOS) web site. It
will also be available for download via the Oracle Software Delivery
Cloud in a few days. 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 Cluster
Carrier Grade Edition subscriptions.

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

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

Highlights of MySQL Enterprise Monitor 3.4 include:

* The Replication Dashboard is extended to provide monitoring support
for Group Replication, which was introduced in MySQL Server 5.7.17.
The Topology view provides a visual representation of your group
replication topologies, and the Status drill downs are updated with
Group Replication-specific information. The status of the entire
group is reported on, also showing node failure tolerances and
whether Group Replication has quorum.

* New Group Replication Configuration and Group Replication Status
Advisors provide continuous analysis of the condition of your group
replication topologies. The Configuration Advisor checks for
misconfigurations which could lead to unstable or insecure
installations; the Status Advisor continuously monitors for servers
which go offline or fall out of sync with the other members of the
cluster.

* The new Table Statistics report utilizes sys schema and its
schema_table_statistics view to show detailed table statistics in
both table and treemap forms. Available on MySQL 5.6 and above,
report details include total latencies, total number of rows
deleted, total I/O write requests.

* In general, the user interface page-loading times and page
responsiveness are improved in 3.4. In addition, time series graphs
are much faster in this release, particularly when you specify a
long time period. This graph performance improvement is gained by
continuous aggregation of time series data. If you are updating from
an earlier version, a one-time aggregation of your historic time
series data is performed when you first start the Service Manager
(as shown by a progress indicator next to the System Status
Summary).

Download

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

https://support.oracle.com

Choose the "Patches & Updates" tab, and then choose the "Product or
Family (Advanced Search)" side tab in the "Patch Search" portlet.

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

http://edelivery.oracle.com/

Choose "MySQL Database" as the Product Pack and 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 3.4 - https://dev.mysql.com/doc/mysql-monitor/3.4/en/mem-comparison-3-4.html
* Change log - http://dev.mysql.com/doc/relnotes/mysql-monitor/3.4/en/
* Installation documentation - http://dev.mysql.com/doc/mysql-monitor/3.4/en/mem-installing.html
* Complete documentation - http://dev.mysql.com/doc/mysql-monitor/3.4/en/
* Product information - http://www.mysql.com/products/enterprise/monitor.html
* Download - http://support.oracle.com/ (available now) or http://edelivery.oracle.com/

Thanks and Happy Monitoring!

- The MySQL Enterprise Tools Development Team

==========

Changes in MySQL Enterprise Monitor 3.4.2

Agent-specific Issues in 3.4.2

* Important Change: As MySQL Enterprise Monitor is enhanced over time,
it is not always possible to maintain backward compatibility between
new MySQL Enterprise Service Managers and older MySQL Enterprise
Monitor Agents. Running mismatched versions can result in
unpredictable behaviour.

The Wrong Version Agent Tracker advisor is updated in this release
and renamed Unsupported Agent Version Advisor. This advisor checks
all agents connecting to the MySQL Enterprise Service Manager and
raises events for unsupported agents.

It is strongly recommended that you upgrade your agents after
upgrading your MySQL Enterprise Service Manager. MySQL Enterprise
Service Manager and MySQL Enterprise Monitor Agent should be the
same version.

* If the following reports were run from a MySQL Enterprise Service
Manager 3.4.1, which used older MySQL Enterprise Monitor Agents, a
deserialization error occurred:

- InnoDB Buffer Pool Usage

- Processes

- Lock Waits

- Database File I/O

- Table Statistics

Important: To run those reports, the MySQL Enterprise Monitor Agent
version must match the MySQL Enterprise Service Manager version.
That is, if you are running MySQL Enterprise Service Manager 3.4.2,
you must also run MySQL Enterprise Monitor Agent 3.4.2.
(Bug #26307003)

* The MySQL User Account advisor in MySQL Enterprise Service Manager
3.4.1 could not evaluate data from MySQL Enterprise Monitor Agents
of version 3.4.0 or earlier.

* If MySQL Enterprise Monitor Agents were upgraded before the MySQL
Enterprise Service Manager, under certain circumstances they
disconnected and threw serialization errors.

It is strongly recommended that you upgrade your agents after
upgrading your MySQL Enterprise Service Manager. MySQL Enterprise
Service Manager and MySQL Enterprise Monitor Agent should be the
same version.

Functionality Added or Changed

* The following advisors were removed and their functionality added to
the MySQL User Account:

- Non-root User Has GRANT Privileges On All Databases

- Non-root User Has Server Admin Privileges

- Account Has Strong MySQL Privileges

For more information, see MySQL User Account. (Bug #26130781)

* The OpenSSL libraries used by the MySQL Enterprise Monitor
installers and MySQL Enterprise Monitor Aggregator have been
upgraded to 1.0.2l.

* As of this release, if you are using a MySQL Server repository other
than the installation bundled with the MySQL Enterprise Service
Manager installation, the installer checks the MySQL Server for the
following, minimum requirements:

- MySQL Server version: versions older then MySQL 5.7.9 are not
supported.

- SSL: SSL must be enabled on the MySQL Server.

- innodb_file_format: innodb_file_format must be barracuda.

- innodb_file_per_table: innodb_file_per_table must be enabled.

If any of those checks fail, the installer displays an error and
cannot proceed until the configuration is corrected.

The upgrade process performs the same checks.

To check your repository is correctly configured, the MySQL
Enterprise Service Manager's configuration utility is extended with
the parameter --mysql-check-requirements.

For more information, see Service Manager Configuration Utilities.

Bugs Fixed

* It was not possible to install the MySQL Enterprise Service Manager
on Solaris due to a missing file, libstlport.so.1. (Bug #26336679)

* The MySQL Enterprise Service Manager upgrade installer did not check
the version of the MySQL server used as the repository. If the
repository version was less than 5.7.9, the upgrade completed, but
MySQL Enterprise Service Manager did not behave as expected.

As of this release, the MySQL Enterprise Service Manager upgrade
package requires MySQL server 5.7.9, or later, and will not install
if the version is lower than 5.7.9. (Bug #25953683)

* Validation messages were not displayed on the Settings page after a
successful change was made.