The MariaDB Foundation has announced the release of MariaDB 12.1.2, a significant update to their rolling release version. This update brings a variety of enhancements aimed at improving performance, compatibility, and overall usability.
One of the standout features is the introduction of a segmented key cache in the Aria storage engine, which allows users to customize data caching by setting up multiple segments. While the default is set to one segment, users can define additional segments as needed. This feature, combined with general optimizations, contributes to improved performance across the database.
Another major enhancement is the implementation of parallel replication for Galera Cluster setups. This feature increases efficiency in data synchronization between clusters, utilizing a new variable called `wsrep_applier_retry_count` to manage replication tasks more effectively.
In addition to performance upgrades, the release improves compatibility with MySQL, most notably by incorporating the `caching_sha2_password` authentication plugin, facilitating smoother connections with external systems.
The SQL capabilities of MariaDB have also been expanded with the introduction of associative arrays, enabling users to directly declare and use these structures in queries, which adds flexibility in data handling.
User account management has received a thoughtful update; the process of dropping users is now safer, as the system will flag active sessions and may prevent the action in Oracle mode, thereby reducing the risk of unintended disruptions.
Further usability improvements include enhanced functionality in the `mysqldump` command, which now supports wildcards more effectively, and better performance of functional indexes within `GROUP` and `ORDER BY` clauses. These changes aim to streamline query operations.
Moreover, the update introduces new system variables that allow for finer tuning of MariaDB's internal configurations. One key variable, `optimizer_record_context`, now offers more detailed trace output, including definitions for tables and views, which aids in debugging processes.
In conclusion, MariaDB 12.1.2 represents a substantial step forward in database technology, with its mix of performance improvements, enhanced compatibility, and user-friendly features. Users are encouraged to explore these updates to fully leverage the capabilities of this latest release
One of the standout features is the introduction of a segmented key cache in the Aria storage engine, which allows users to customize data caching by setting up multiple segments. While the default is set to one segment, users can define additional segments as needed. This feature, combined with general optimizations, contributes to improved performance across the database.
Another major enhancement is the implementation of parallel replication for Galera Cluster setups. This feature increases efficiency in data synchronization between clusters, utilizing a new variable called `wsrep_applier_retry_count` to manage replication tasks more effectively.
In addition to performance upgrades, the release improves compatibility with MySQL, most notably by incorporating the `caching_sha2_password` authentication plugin, facilitating smoother connections with external systems.
The SQL capabilities of MariaDB have also been expanded with the introduction of associative arrays, enabling users to directly declare and use these structures in queries, which adds flexibility in data handling.
User account management has received a thoughtful update; the process of dropping users is now safer, as the system will flag active sessions and may prevent the action in Oracle mode, thereby reducing the risk of unintended disruptions.
Further usability improvements include enhanced functionality in the `mysqldump` command, which now supports wildcards more effectively, and better performance of functional indexes within `GROUP` and `ORDER BY` clauses. These changes aim to streamline query operations.
Moreover, the update introduces new system variables that allow for finer tuning of MariaDB's internal configurations. One key variable, `optimizer_record_context`, now offers more detailed trace output, including definitions for tables and views, which aids in debugging processes.
In conclusion, MariaDB 12.1.2 represents a substantial step forward in database technology, with its mix of performance improvements, enhanced compatibility, and user-friendly features. Users are encouraged to explore these updates to fully leverage the capabilities of this latest release
MariaDB 12.1.2 Rolling Release released
The latest version of MariaDB 12.1.2 rolling release is now available, featuring several improvements to performance, compatibility, and usability. Key enhancements include a segmented key cache in the Aria storage engine, which allows users to set up segments for data caching, and parallel replication with Galera Cluster setups. Additionally, the introduction of associative arrays has strengthened SQL features, enabling more flexible query handling. Other improvements in the release include smarter user account management, enhanced mysqldump functionality, and new system variables for fine-tuning MariaDB's inner workings.
