Oracle celebrated the start of July with the final availability of three releases of its open supply database, MySQL: MySQL 8.0.38, the primary replace of its long-term assist (LTS) model, MySQL 8.4, and the primary main model of its 9.x innovation launch, MySQL 9.0.
Whereas the v8 releases are bug fixes and safety releases solely, MySQL 9.0 Innovation is a shiny new model with extra options, in addition to some adjustments that will require consideration when upgrading from a earlier model.
The brand new 9.0 variations of MySQL Shoppers, Instruments, and Connectors are additionally reside, and Oracle recommends that they be used with MySQL Server 8.0, and eight.4 LTS in addition to with 9.0 Innovation.
New options in MySQL 9.0.0
This preliminary 9.x Innovation launch, Oracle says, is preparation for brand spanking new options in upcoming releases. But it surely nonetheless accommodates helpful issues and might be upgraded to from MySQL 8.4 LTS; the MySQL Configurator robotically does the improve with out consumer intervention throughout MSI installations on Home windows.
The main adjustments embody:
- A brand new Vector datatype is supported in CREATE and ALTER statements.
- JavaScript Saved Applications, which assist JavaScript-based saved applications and features, has come to MySQL Enterprise Version. JavaScript Saved Applications can name SQL, and SQL can name them.
- MySQL 9.0 Innovation has moved to newer variations of libraries and compilers: Linux 8 and 9 on GCC13, and Increase 1.85.
- Within the Occasion Scheduler, customers can now put together SQL statements CREATE EVENT, ALTER EVENT, and DROP EVENT.
What’s going away in MySQL 9.0
Insecure and aged SHA-1, after being deprecated in MySQL 8, is gone, and the server now rejects mysql_native authentication requests from older consumer applications which shouldn’t have CLIENT_PLUGIN_AUTH functionality. Earlier than upgrading to 9.0, Oracle says, consumer accounts in 8.0 and eight.4 should be altered from mysql_native_password to caching_sha2_password.
Within the Optimizer, ER_SUBQUERY_NO_1_ROW has been faraway from the checklist of errors that are ignored by statements which embody the IGNORE key phrase. This modification could make an UPDATE, DELETE, or INSERT assertion which incorporates the IGNORE key phrase increase errors if it accommodates a SELECT assertion with a scalar subquery that produces a couple of row.
What’s subsequent after MySQL 9.0
MySQL is now on a three-month launch cadence, with main LTS releases each two years. In October, Oracle says we will count on bug and safety releases MySQL 8.4.2 LTS and MySQL 8.0.39, and the MySQL 9.1 Innovation launch, with new options in addition to bug and safety fixes.
Copyright © 2024 IDG Communications, Inc.
