MySQL Router 8.0.17 for MySQL Server 8.0 and 5.7 has been released

[Balasubramanian Kandasamy]

 
Dear MySQL users,

MySQL Router 8.0.17 is a new release for MySQL Router 8.0 series.

MySQL Router 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7.
Please upgrade to MySQL Router 8.0.17.

The MySQL Router is a new building block for high availability solutions
based on MySQL InnoDB clusters.

By taking advantage of the new Group Replication technology, and
combined with the MySQL Shell, InnoDB clusters provide an integrated
solution for high availability and scalability for InnoDB based MySQL
databases, that does not require advanced MySQL expertise.

The deployment of applications with high availability requirements is
greatly simplified by MySQL Router. MySQL client connections are
transparently routed to online members of a InnoDB cluster, with MySQL
server outages and cluster reconfigurations being automatically handled
by the Router.

To download MySQL Router 8.0.17, see the "Generally Available (GA)
Releases" tab at http://dev.mysql.com/downloads/router. Package
binaries are available for several platforms and also as a source code
download.

Documentation for MySQL Router can be found at
http://dev.mysql.com/doc/mysql-router/en/

Enjoy!

Changes in MySQL Router 8.0.17 (2019-07-22)


     * Functionality Added or Changed

     * Bugs Fixed

Functionality Added or Changed


     * Added the use_gr_notifications [metadata-cache] option to
       enable Group Replication notifications, which is disabled
       by default. It supports
       group_replication/membership/quorum_loss,
       group_replication/membership/view,
       group_replication/status/role_change, and
       group_replication/status/state_change.
       Optionally use the new --conf-use-gr-notifications
       bootstrap command-line to enable this option in the
       generated configuration file.

     * Added a REST API that follows the OpenAPI 2.0
       specification and is implemented as a plugin; load the
       plugin using [rest_api] in the configuration file. It
       also requires the http_server plugin. Use the optional
       require_realm configuration option (string) to define the
       authentication realm.
       The base-path for all REST endpoints is "api" followed by
       a numeric API version that is defined as the release
       date, such as "/api/20190722/". The system follows
       camelCase naming rules and errors follow RFC 7807. The
       system exposes a swagger.json file as /api/
       {apiVersion}/swagger.json.

Bugs Fixed


     * Bootstrapping could misclassify a hostname as IPv6 and
       surround it with square brackets in the state
       (state.json) file; and this produced a "Configuration
       error: cluster-metadata-servers is incorrect" error. A
       workaround was to disable ipv6 support on the system.
       (Bug #29876948, Bug #95531)

     * Starting the http_server plugin against a port that was
       already bound would yield a confusing error, such as
       "Error: bind('0.0.0.0:10100) failed: The operation
       completed successfully." (Bug #29823472)

     * Improved the connection counter logic to prevent a
       potential unexpected halt before completing the shutdown
       process. (Bug #29820725)

     * Requesting the metadata-cache health immediately after
       start up could cause an expected exit by
       get_destinations() if metadata_cache's cache-api was not
       yet initialized. (Bug #29820155)

     * Bootstrapping would fail on hosts that defined multiple
       network interfaces. (Bug #29814629)

     * Optimized logging mechanism; system generated log
       messages independent of the log level. Now log messages
       are only prepared if configured to do so. (Bug #29798420)

     * Fixed potential blocking during shutdown by adding proper
       libmysqlclient deinitialisation where needed. This bug
       only affected DEBUG builds. (Bug #29635378)

     * harness/CMakeLists.txt was renamed to
       harness/src/CMakeLists.txt. (Bug #29629788)

     * The loaded plugin message level was changed from level
       "info" to "debug". (Bug #29616101)

     * The bootstrap "invalid URI" error message was improved.
       (Bug #29609170)

     * HTTPS connections with ECDHE ciphers to Router's
       http_server component failed if built against OpenSSL
       1.0.1. (Bug #29609052)

     * The file generated by mysqlrouter_passwd was
       world-readable, and is now user-readable (Bug #29589127)

     * For the REST API, unsupported query parameters now return
       the 400 HTTP status code; and remain ignored. (Bug
       #29556935)

     * Log lines above 512 characters were truncated. (Bug
       #29540910)

     * For the REST API, OPTION, TRACE, and CONNECT requests now
       return the application/problem+json Content-Type and 405
       HTTP status code. (Bug #29539557)

     * The HTTP server component now supports .jpg/.jpeg image
       files, and file extension matches are now
       case-insensitive. (Bug #29508595)

     * Added Visual Studio 2019 support. (Bug #29454252)

     * An unknown [http_auth_realm] backend yielded an unclear
       error. (Bug #29421759)

     * An uncaught exception was generated if a client socket
       was shutdown the client peer address was retrieved. (Bug
       #29382585)

     * Misleading "Potential changes detected in cluster"
       warnings were added to Router's log file. Node order
       differences no longer cause these errors. (Bug #29264764,
       Bug #94060)

     * Router would start if bootstrap_server_addresses was
       empty or not set. Now Router fails to start in this case
       if cluster-metadata-servers (a dynamic-config attribute)
       is also empty. (Bug #28352482)

     * The .ini configuration file locations are now detected
       and displayed in --help output. (Bug #28261802)

     * With Debian packages, the bootstrap process could fail
       when used with the --directory option. (Bug #27034449)