Oracle celebrated the start of July with the overall 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 which will require consideration when upgrading from a earlier model.
The brand new 9.0 variations of MySQL Shoppers, Instruments, and Connectors are additionally stay, 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. Nevertheless it nonetheless accommodates helpful issues and may be upgraded to from MySQL 8.4 LTS; the MySQL Configurator routinely does the improve with out consumer intervention throughout MSI installations on Home windows.
The foremost adjustments embrace:
- 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 Enhance 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 shopper applications which wouldn’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 listing of errors that are ignored by statements which embrace the IGNORE key phrase. This alteration could make an UPDATE, DELETE, or INSERT assertion which incorporates the IGNORE key phrase elevate errors if it accommodates a SELECT assertion with a scalar subquery that produces multiple 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.