Changes in MySQL Router 8.0.34 (2023-07-18, General Availability)

Bugs Fixed

• Deprecated ciphers were removed from the default cipher lists of client_ssl_cipher and server_ssl_cipher. Triple-DES ciphers and DSS ciphers are no longer permitted. (Bug #35489217)

• MySQL Router failed to start if configured to use ECC certificates. The following error was displayed: no RSA certificate. (Bug #35317484)

• Connections were not shared if the client enabled CLIENT_MULTI_STATEMENTS with COM_SET_OPTION. (Bug #35263986)

• If USE SCHEMA was sent by query instead of by the dedicated command, connection sharing was blocked. (Bug #35245250)

• If a client connected to the server through MySQL Router, while a SUPER connection was already established, and the server's max_connections was reached, the connection was dropped and an error similar to the following was erroneously returned to the client: Lost connection to MySQL server during query. This error was also sent twice.

  As of this release, the correct error message is returned. (Bug #35239607)

• SHOW WARNINGS did not behave as expected if connection sharing was enabled. It did not return all the status-flags, such as autocommit. (Bug #35213196)

• Client authentication failed if the client authenticated with a password and a default authentication method other than caching_sha2_password. The error message included: using password: NO. (Bug #35195287)

• Connection sharing was disabled if a change-user operation occurred, resetting the user's stored password. As of this release, if a change-user operation is called, the existing connection is updated with the new credentials. (Bug #35189721)

• The client's character set was not restored when their connection was restored from the connection pool. (Bug #35184765)

• Router is now compatible with older metadata, such as metadata created by MySQL Shell 8.0.11. This allows upgrading from these older versions. (Bug #35078886)

• It was not possible to create an InnoDB Cluster with the latest version of MySQL Router, and MySQL Server, and an older version of MySQL Shell, such as 8.0.11. MySQL Router failed to start as a result of a failure to recognize an older version of the metadata view used by MySQL Router. (Bug #35067083)