After 6 months of development, the first stable release of the new MariaDB 10.7 (10.7.2) DBMS branch has been published, within which a branch from MySQL is being developed that maintains backward compatibility and is distinguished by the integration of additional storage engines and advanced features. MariaDB development is overseen by the independent MariaDB Foundation, following a fully open and transparent development process independent of individual vendors. MariaDB is shipped in place of MySQL on many Linux distributions (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) and has been adopted by major projects such as Wikipedia, Google Cloud SQL, and Nimbuzz.
At the same time, the first test release of the next significant branch of MariaDB 10.8.1 and corrective updates 10.6.6, 10.5.14, 10.4.23, 10.3.33 and 10.2.42 were formed. Release 10.7.2 was the first after the project switched to a new release generation model, which implies a reduction in the support period from 5 years to 1 year and the transition to the formation of significant releases not once a year, but once a quarter.
Key improvements in MariaDB 10.7:
- A new UUID data type has been added to store 128-bit unique identifiers (Universally Unique Identifier).
- New functions for processing JSON data are proposed: JSON_EQUALS() to compare the identity of two JSON documents and JSON_NORMALIZE() to bring JSON objects into a form suitable for comparison operations (performs key sorting and removing spaces).
- The NATURAL_SORT_KEY() function has been added to sort strings based on numeric values ββ(for example, the string "v10" after sorting will take place after the string "v9").
- The SFORMAT() function has been added for arbitrary string formatting - the input is a string with formatting commands and a list of values ββfor substitution (for example, 'SFORMAT("The answer is {}.", 42)').
- Improved reporting of errors in INSERT queries that add data to multiple rows (the GET DIAGNOSTICS command now displays the ROW_NUMBER property indicating the row number with the error).
- A new password check plugin is included, password_reuse_check, which allows you to limit the reuse of passwords by one user (checking that the new password does not match the passwords used during the time specified by the password_reuse_check_interval parameter).
- Added support for the expressions "ALTER TABLE ... CONVERT PARTITION .. TO TABLE" and "ALTER TABLE ... CONVERT TABLE ... TO PARTITION" to convert a partition to a table and vice versa.
- The "--as-of" option has been added to the mariadb-dump utility to dump a dump corresponding to a specific state of a versioned table.
- For MariaDB Galera Cluster, new states "waiting to execute in isolation" "waiting for TOI DDL" "waiting for flow control" and "waiting for certification" are implemented in PROCESSLIST.
- A new parameter "reorder" has been added to the optimizer. For multibyte strings, the performance of matching has been improved, taking into account the meaning of characters in operations with ASCII ranges.
- Batch data insertion, presorting, and indexing performance has been improved in InnoDB storage.
- Fixed 5 vulnerabilities, the details of which have not yet been disclosed: CVE-2022-24052, CVE-2022-24051, CVE-2022-24050, CVE-2022-24048, CVE-2021-46659.
- Of the changes in the test release of MariaDB 10.8.1, we can note the implementation of indexes sorted in descending order, which can significantly improve the performance of ORDER BY operations when fetching in reverse order. The specifiers IN, OUT, INOUT and IN OUT have been added for stored functions. InnoDB has reduced the number of write operations when logging operations rollback (redo).
Source: opennet.ru