The first stable release of the new branch of the MariaDB database, 10.11 (10.11.2), has been published, developing a fork from MySQL that maintains backward compatibility and features the integration of additional storage engines and enhanced capabilities. The development of MariaDB is overseen by the independent organization MariaDB Foundation, in accordance with an open and transparent development process, independent of individual vendors. MariaDB is included as a substitute for MySQL in many Linux distributions (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) and is implemented in major projects such as Wikipedia, Google Cloud SQL, and Nimbuzz.
Meanwhile, the 11.0 branch is in alpha testing, which offers significant improvements and changes that break compatibility. The MariaDB 10.11 branch is categorized as a long-term support release and will be maintained alongside MariaDB 11.x until February 2028.
Key improvements in MariaDB 10.11:
- The operation 'GRANT … TO PUBLIC' has been implemented, allowing certain privileges to be granted to all users at once on server.
- The powers of SUPER and 'READ ONLY ADMIN' have been differentiated — the 'SUPER' privilege no longer encompasses the rights of 'READ ONLY ADMIN' (the ability to write, even if the read-only mode is enabled).
- In the inspection mode 'ANALYZE FORMAT=JSON', the time spent by the query optimizer is displayed.
- Performance issues manifested during reading from tables with storage scheme parameters and during full scans of tables with parameters and procedures for the storage scheme have been resolved.
- Support for saving and restoring historical data from versioned tables has been added to the mariadb-dump utility.
- The system_versioning_insert_history setting has been added to manage the ability to make changes to past versions of data in versioned tables.
- Changing the innodb_write_io_threads and innodb_read_io_threads settings on the fly is now allowed without the need for a restart. server.
- On Windows, Windows administrators can log in to MariaDB as root without entering a password.
- The variables log_slow_min_examined_row_limit (min_examined_row_limit), log_slow_query (slow_query_log), log_slow_query_file (slow_query_log_file), and log_slow_query_time (long_query_time) have been renamed.
Source: opennet.ru
