MariaDB 12.2 Preview released
MariaDB, one of the most widely used open-source relational databases, has recently released a preview version of its latest iteration, MariaDB 12.2. As the brainchild of the original MySQL developers and backed by the MariaDB Foundation, this database is guaranteed to remain open-source. Its commitment to values such as performance, stability, and openness has earned it a prominent place in most cloud offerings and serves as the default relational database in numerous Linux distributions.
TThe MariaDB Foundation's approach to accepting contributions based on technical merit ensures that new features are seamlessly incorporated into the database. RRecent advancements have included the introduction of advanced clustering capabilities via Galera Cluster 4, as well as compatibility features for Oracle Database and Temporal Data Tables. The latter allows users to query data as it existed at any point in the past.
Now, a major update is on the horizon with MariaDB 12.2, which will feature a rolling release model. This significant change reflects the database's ongoing commitment to innovation and its willingness to adapt to evolving user needs. As part of this rollout, several new features have been incorporated into the latest version of MariaDB.
The compatibility features introduced in MariaDB 12.2 are among its most notable additions. One such feature is the introduction of the TO_NUMBER() function, which enables users to convert character strings into numerical values (MDEV-20022). Additionally, the TRUNC() function has been implemented, allowing for more efficient data manipulation and storage (MDEV-20023).
Another crucial aspect of MariaDB 12.2 is its enhanced support for temporary tables. Specifically, global temporary tables have been added to provide users with a flexible solution for storing and managing data on a session basis (MDEV-35915). Furthermore, the database now includes optimizer hints that enable users to influence query performance by controlling rowid filtering and index merge operations (MDEV-36089, MDEV-36125).
Several other new features have been incorporated into MariaDB 12.2, including the addition of a TRIGGERED_UPDATE_COLUMNS column in the INFORMATION_SCHEMA table for trigger-related information (MDEV-36996). Additionally, users can now leverage named query blocks and views when utilizing optimizer hints, which helps optimize database performance (MDEV-37511).
The release also includes several miscellaneous enhancements. For instance, the PARAMETERS column in the INFORMATION_SCHEMA table has been updated to include a PARAMETER_DEFAULT field for storing default parameter values (MDEV-37054). Moreover, the database's replication capabilities have been improved to support replication between tables with different structures, which significantly enhances its flexibility and usability (MDEV-36290).
Overall, MariaDB 12.2 represents a substantial step forward in the evolution of this popular open-source relational database. Its innovative features and continued commitment to openness make it an attractive choice for users seeking a reliable and adaptable solution for their data management needs.
MariaDB 12.2 preview available
We are pleased to announce the availability of a preview of the MariaDB 12.2 series. MariaDB 12.2 will be a rolling release.
