Oracle has formed a new branch of the MySQL 8.3 DBMS and published a corrective update to MySQL 8.0.36. MySQL Community Server 8.3.0 builds are prepared for all major Linux, FreeBSD, macOS and Windows distributions.
MySQL 8.3.0 is the third release formed under the new release model, which provides for the presence of two types of MySQL branches - “Innovation” and “LTS”. The Innovation branches, which include MySQL 8.1, 8.2 and 8.3, are recommended for those who want to get access to new functionality earlier. These branches are published every 3 months and are supported only until the next major release is published (for example, after the appearance of the 8.3 branch, support for the 8.2 branch was discontinued). LTS branches are recommended for implementations that require predictability and long-term persistence of unchanged behavior. LTS branches will be released every two years and will be supported normally for 5 years, in addition to which you can get another 3 years of extended support. An LTS release of MySQL 2024 is expected in the spring of 8.4, after which a new Innovation branch 9.0 will be formed.
Major changes in MySQL 8.3:
- 25 vulnerabilities have been fixed, of which one (CVE-2023-5363, affecting OpenSSL) can be exploited remotely. The most severe issue related to the use of the Kerberos protocol is assigned a severity level of 8.8. Less severe vulnerabilities with severity level 6.5 affect the optimizer, UDF, DDL, DML, replication, privilege system, and encryption tools.
- On the Linux platform, support for the mold linker has been added. To enable it, the option “-DWITH_LD=mold|lld” is provided.
- The requirements for the C++ standard supported by the compiler have been raised from C++17 to C++20.
- Support for building with external Boost C++ libraries has been discontinued - only the built-in Boost libraries are now used when compiling MySQL. CMake has removed the WITH_BOOST, DOWNLOAD_BOOST and DOWNLOAD_BOOST_TIMEOUT build options.
- Build support for Visual Studio 2022 has been discontinued. The minimum supported version of the Clang toolkit has been raised from Clang 10 to Clang 12.
- MySQL Enterprise Edition has added support for collecting telemetry with metrics about server operation in the OpenTelemetry format and transferring data to a network processor that supports this format.
- The GTID (global transaction identifier) format, used during replication to identify transaction groups, has been expanded. The new GTID format is "UUID::NUMBER" (instead of "UUID:NUMBER"), where TAG is an arbitrary string that allows unique names to be assigned to a specific group of transactions for easier processing and parsing.
- Added two new variables "Deprecated_use_i_s_processlist_count" and "Deprecated_use_i_s_processlist_last_timestamp" to track usage of the deprecated INFORMATION_SCHEMA.PROCESSLIST table.
- Setting the AUTHENTICATION_PAM_LOG environment variable no longer causes passwords to be displayed in diagnostic messages (the value PAM_LOG_WITH_SECRET_INFO is required to mention a password).
- Added tp_connections table with information about each connection in the thread pool.
- Added system variable "explain_json_format_version" to select the JSON format version used in "EXPLAIN FORMAT=JSON" statements.
- In InnoDB storage, the "--innodb" and "--skip-innodb" options, which were deprecated in the MySQL 5.6 release, have been removed. The memcached plugin for InnoDB, which was deprecated in MySQL 8.0.22, has been removed.
- Removed some replication related settings and command line options that were deprecated in previous releases: "--slave-rows-search-algorithms", "--relay-log-info-file", "-relay-log-info-repository" ", "-master-info-file", "-master-info-repository", "log_bin_use_v1_events", "transaction_write_set_extraction", "group_replication_ip_whitelist", "group_replication_primary_member". The ability to use the IGNORE_SERVER_IDS option with GTID replication mode (gtid_mode=ON) has been removed.
- Support for C API functions has been discontinued: mysql_kill(), mysql_list_fields(), mysql_list_processes(), mysql_refresh(), mysql_reload(), mysql_shutdown(), mysql_ssl_set().
- The "FLUSH HOSTS" expression, which was deprecated in MySQL 8.0.23, has been discontinued.
Source: opennet.ru