Changes in MySQL Router 8.0.23 (2021-01-18, General Availability)

• Functionality Added or Changed

• Bugs Fixed

Functionality Added or Changed

• Added configurable server<->router<->client TLS endpoint support, which allows additional configuration for Router, Client, and Server interactions.

  The default behavior changed from client_ssl_mode = PASSTHROUGH to client_ssl_mode = PREFERRED where PASSTHROUGH forwards everything to the server and lets the client and server decide TLS settings, whereas PREFERRED establishes TLS connections between the client and Router if the client desires switching to TLS if the server supports TLS. This also matches the existing behavior for client and server without the Router in-between.

  Many new options were created, such as client_ssl_mode and server_ssl_mode that are documented under TLS Configuration. (Bug #31141095, WL #12012)

Bugs Fixed

• On Linux, bootstrap would not function if the host had no external interfaces. (Bug #32200253)

• Host names resolving to IPv6 were wrapped in square brackets as it assumed the host name was an IPv6 address. (Bug #32198746)

• Refactored MySQLSession functionality to more consistently report syntax related errors. (Bug #32151782)

• Large SQL statements that were larger than the send buffer would lead errors such as "write error: Resource temporarily unavailable" and drop the connection. (Bug #32081158)

• Queries expected to return a single row were not being added to the debugging SQL log. (Bug #32071807)

• Setting the --conf-use-gr-notifications bootstrap option increased the ttl value to a value higher than the default auth_cache_refresh_interval value allowed thus not creating a valid MySQL Router configuration file. Now, setting --conf-use-gr-notifications also adjusts the auth_cache_refresh_interval value accordingly. (Bug #32062483)