This October release is the third LTS release and second Innovation release since MySQL announced our move to a new LTS/Innovation release model. For more details see MySQL Releases: Innovation and LTS.
During the innovation cycle, MySQL 9.x quarterly releases will include new features, deprecations and removals, and bug fixes.
The 9.x releases also include Shell, Router, Connectors and Clients. There is also a new release of VS Code for MySQL.
MySQL DBAs, developers, and users should migrate to the latest 9.x GA versions of the Connectors and clients which support 9.x Innovation, 8.4 LTS, and 8.0 releases.
MySQL continues to maintain a 3 month release cadence
In the Jan 2025 time frame expect
- Bug and security fix only releases
- MySQL 8.4.4 LTS
- MySQL 8.0.41
- Innovation release
- MySQL 9.2.0 Innovation
MySQL Server 9.1.0 Innovation GA includes:
MySQL Server 8.4.3 LTS GA includes:
MySQL Server 8.0.40 GA includes:
Upgrade Guidance
- Customers are encouraged to migrate from MySQL Servers 8.0.x to the latest 8.4.x LTS, currently 8.4.3.
- Customers wanting to explore new capabilities and features are encouraged to upgrade to MySQL 9.1 Innovation.
MySQL Server 9.1 Highlights
MySQL Community Edition: SQL
- New! CREATE DATABASE and DROP DATABASE are now fully atomic and crash-safe
- For InnoDB and storage engines that support atomic DDL
- Cleanly handles problems that can occur due to file system or other issues
- New! Create View if NOT EXISTS
- If the view does not exist, it is created as usual
- If the view already exists, there is no change the current view definition and a warning is emitted
- New! Explain Enhancements
- Includes information about the semi-join strategy
MySQL Enterprise Edition: JavaScript Stored Programs
- New! VECTOR support in JavaScript programs
- VECTOR values can now be used with JavaScript programs as input arguments, output arguments, prepared statement bind() parameters, and return values
MySQL Enterprise Edition: Flow-control monitoring for MySQL Innodb Cluster (Group Replication)
- Adds indication whether flow control was triggered and how much throttling it caused.
- Flow control throttles the primary if secondaries are falling behind
- Four new variables provide metrics for flow control tuning
- Number of sessions currently being throttled
- Number of times throttling occurred
- Total throttle time
- Timestamp of last throttled transaction
- Enables DBAs to
- Gain additional insights on throttling
- Determine if a cluster is under stress
- Optimize flow control settings, hardware, and configuration
- Enable improved and smoother throughput
MySQL Enterprise Edition: Multi-threaded Applier – extended applier statistics
- This component adds two new tables to the MySQL Performance Schema
- Providing enhanced observability by gathering statistics from the entire replication pipeline
- Applier metrics per replication channel are available in Performance Schema table replication_applier_metrics
- Worker specific metrics are available in Performance Schema table replication_applier_progress_by_worker
- Enables DBAs to
- Distinguish between DDL and DML
- Monitor Replication Throughput (bytes per second)
- Applied, queued and ongoing transactions
- Helps diagnose replication lag and estimate time to catchup
MySQL Enterprise Edition: Telemetry
- New! Support for OpenTelemetry Logging
- Exports telemetry logs from a MySQL server
- Sends to collectors and backends that support the OpenTelemetry standard
- Logs are exported to a single endpoint, using a push model via OTLP HTTP protocol.
- Network encryption is provided via TLS
- Log compression is supported.
- Enables DBAs to
- Troubleshoot operations in production
- Collect instrumented log events from the MySQL server
- Format the log data in an OpenTelemetry OTLP format
- Send the OTLP logs to an external OpenTelemetry Collector process
MySQL Enterprise Edition: OpenID Connect (Oauth2 – JWT) Authentication
- OpenID Connect (OIDC) provides
- A secure authentication method for verifying that users are who they say they are.
- OIDC Authentication protocol provides Federated SSO that leverages the OAuth 2.0 Authorization Framework.
- Organizations can leverage their secure centralized authentication systems
- Acting as OpenID Providers(OP) or Identity Provider (IDP)
- Easy for developers and enterprises to use and manage
- MySQL is the Relying Party (RP) by outsourcing its user authentication function to an OpenID Connect IDP/OP
- For more on OpenID see about Digital Identities
- OpenID enables MySQL 9.1 connectors, routers and clients to provide the identity of users based on the authentication performed by an external authorization servers (IAMs) that support OpenID Connect.
- MySQL is the Relying Party (RP) by outsourcing its user authentication function to an OpenID Connect IDP/OP
- Examples of these OpenID providers are
- Oracle
- Microsoft
- Okta
- PingIdentity
- SecureAuth
- RSA Security
- Verizon
- Akamai
- And more – Full list of Certified OpenID Providers
We have also released the 9.1 versions of MySQL Clients, Tools, and Connectors.
- Regardless of server version, always use the latest version of MySQL Clients, Tools, and Connectors.
- These 9.1 clients, tools, and connectors support MySQL Server 8.0, 8.4 LTS, and 9.1 Innovation
As always, thank you for using MySQL.