MySQL 9.0: Oracle’s Latest Release

Oracle has recently introduced MySQL 8.0.38 and the first version of MySQL 9.0 on July 1st. Below is a summary of the new features and expectations:

Oracle positions MySQL 9.0 as a foundational release, setting the stage for future enhancements. Key features include initial support for the vector datatype in CREATE and ALTER statements, as well as JavaScript-based stored programs and functions, available exclusively in the Enterprise Edition and managed HeatWave service.

MySQL 9.0: Key Highlights

New Features in MySQL 9.0:

• Introduction of vector datatype support.
• JavaScript-based stored programs and functions (Enterprise Edition only).

Emphasis on Stability:

• MySQL 8.0.38 and 8.4 LTS releases concentrate on enhancing stability, delivering security updates, fixing bugs, and boosting performance.

David Stokes, a technology advocate at Percona, discussed the release in his article “MySQL 9.0 Community Edition: A Quick Peek.” He observed that the 9.0 version lacks groundbreaking technical features, focusing more on solid engineering.

Changes and Improvements:

Authentication:

• Removal of the mysql_native_password authentication plugin.
• Maintained compatibility with older versions through client-side support.

Vector Columns:

• Introduction of VECTOR datatype.
• Restrictions on usage (e.g., cannot serve as keys).

Oracle has also released updated MySQL clients, tools, and connectors that support MySQL Server 8.0, 8.4 LTS, and 9.0 Innovation. Mike Frank, Oracle’s product management director, states:

Throughout the innovation cycle, MySQL 9.x quarterly releases will incorporate new features, deprecations, removals, and bug fixes. MySQL DBAs, developers, and users should transition to the latest 9.0 GA versions of the Connectors and Clients supporting 9.0 Innovation, 8.4 LTS, and 8.0 releases.

Bug Fixes

• Significant Fixes:
  • 127 bug fixes, addressing issues like performance regressions for GROUP BY queries in MySQL 8.0.

A critical bug has already been identified in this release, leading the community to recommend caution before upgrading to the newest versions. The next quarterly updates are expected in October, including bug and security fix releases for MySQL 8.4.2 LTS and MySQL 8.0.39, as well as the next innovation release, MySQL 9.1.0.

Versiob 9.0 brings some new features but is mainly an engineering release preparing for future enhancements. Developers and DBAs should prioritize stability and performance, cautiously adopting the new version.

At Introduct, we are committed to staying at the forefront of technological advancements. Our team is dedicated to providing you with the latest insights and support to ensure seamless integration with your existing systems. For further details and technical guidance, feel free to reach out to us. We are here to assist you in navigating these updates and enhancing your database solutions.