Oracle has formed a new branch of the MySQL DBMS, version 9.5.0. MySQL Community Server 9.5.0 builds are prepared for all major Linux distributions, FreeBSD, macOS, and Windows. In accordance with the release model implemented in 2023, MySQL 9.5 is classified as an "Innovation" branch. Innovation branches are recommended for those who want early access to new features and are published every 3 months, being supported only until the next significant release is published (for example, support for branch 9.4 will cease after the release of branch 9.5). An LTS release, version 9.6, is planned for winter, which is recommended for deployments requiring predictability and long-term consistency. Following the LTS branch, a new Innovation branch will be formed — MySQL 10.0.
Key changes in MySQL 9.5:
- The option "activate_mandatory_roles" has been added for enhanced role management — when the setting "activate_all_roles_on_login" is disabled and "activate_mandatory_roles" is enabled, support for mandatory roles (automatically assigned to the user upon login) is activated in addition to standard roles.
- The MySQL Multilingual Engine plugin has implemented support for the ECMAScript 2025 specification in its JavaScript language implementation.
- The mysqldm (MySQL Diagnostic Monitor) utility has been added, designed to collect diagnostic information (analyzing the execution of a predefined set of queries), which can be submitted by the user to support for easier problem resolution.
- The ability to simultaneously install regular and LTS releases of MySQL side by side has been added.
- In replication settings, advanced security options are now enabled by default, implying the use of encryption for all connections during replication.
- The MySQL Thread Pool plugin has implemented automatic parameter adjustments to achieve maximum performance based on the existing hardware configuration.
- The behavior of the parameter "innodb_log_writer_threads" has been changed, as its default activation now depends on the active mode of binary redo logs (log_bin). When "log_bin" is inactive, the "innodb_log_writer_threads" parameter is enabled for systems with more than 4 logical CPUs, and when active, for those with more than 31 logical CPUs.
- By default, the value of the parameter "binlog_transaction_dependency_history_size" has been increased from 25 thousand to one million. The maximum possible value for this parameter has been raised from 1 to 10 million.
- The default value of the parameter "caching_sha2_password_digest_rounds" has been increased to 10000.
- The use of the SCRAM-SHA-1 authentication method when connecting to SASL LDAP has been deprecated. Instead, the SCRAM-SHA-256 method should be used, which is now the default value in the parameter "authentication_ldap_sasl_auth_method_name".
- Support for the variables "group_replication_allow_local_lower_version_join" and "replica_parallel_type", which were previously marked as deprecated, has been discontinued.
- Support for building on Solaris using Clang and GCC has been added. The use of OpenSSL 3 on Solaris has also been enabled.
- The minimum supported version of Cmake has been raised to 3.17.5.
- Nine vulnerabilities have been eliminated, the most severe of which has been assigned a danger level of 5.5 out of 10. No details are provided, only that vulnerabilities exist in InnoDB, DML, and the optimizer. Authenticated access to the database management system is required to exploit these vulnerabilities.
Source: opennet.ru
