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.
While the v8 releases are bug fixes and safety releases solely, MySQL 9.0 Innovation is a shiny new model with further options, in addition to some adjustments that will require consideration when upgrading from a earlier model.
The new 9.Zero variations of MySQL Clients, Tools, and Connectors are additionally reside, and Oracle recommends that they be used with MySQL Server 8.0, and eight.Four 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 nonetheless comprises helpful issues and may be upgraded to from MySQL 8.Four LTS; the MySQL Configurator mechanically does the improve with out consumer intervention throughout MSI installations on Windows.
The main adjustments embrace:
- A brand new Vector datatype is supported in CREATE and ALTER statements.
- JavaScript Stored Programs, which assist JavaScript-based saved applications and features, has come to MySQL Enterprise Edition. JavaScript Stored Programs can name SQL, and SQL can name them.
- MySQL 9.0 Innovation has moved to newer variations of libraries and compilers: Linux Eight and 9 on GCC13, and Boost 1.85.
- In the Event 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. Before upgrading to 9.0, Oracle says, consumer accounts in 8.Zero and eight.Four have to be altered from mysql_native_password to caching_sha2_password.
In the Optimizer, ER_SUBQUERY_NO_1_ROW has been faraway from the record of errors that are ignored by statements which embrace the IGNORE key phrase. This change could make an UPDATE, DELETE, or INSERT assertion which incorporates the IGNORE key phrase increase errors if it comprises 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 anticipate bug and safety releases MySQL 8.4.2 LTS and MySQL 8.0.39, and the MySQL…
