What Is New in MariaDB 11.5
MariaDB 11.5 is a medium-term maintenance release that consolidates features and improvements from previous versions. It focuses on enhancing performance, security, and adding new functionality to keep the database competitive and robust.
| Category | Key Changes |
|---|---|
| New Features | Generated Columns, System Versioning, CHECK constraint enhancements, new functions. |
| Improvements | InnoDB performance optimizations, better query planning, replication enhancements. |
| Security | Password validation plugin, TLS 1.3 support, audit plugin updates. |
| Deprecated & Removed | Old storage engines, outdated configuration options. |
What are the key new SQL features in MariaDB 11.5?
Generated columns are a major addition, allowing you to define columns whose values are computed from expressions involving other columns. This simplifies schema design by moving calculation logic from the application layer directly into the database.
System Versioning (SQL:2011) enables temporal tables, making it straightforward to track historical changes to your data. You can query a table's state at any point in the past without needing to build a custom audit trail. This is incredibly useful for compliance and data analysis.
Enhancements to CHECK constraints provide more robust data integrity. The engine now more strictly enforces these constraints, ensuring only valid data is written to your tables. Several new functions, like JSON_TABLE, also expand your data manipulation capabilities.
How does MariaDB 11.5 improve performance?
This release includes significant optimizations for the InnoDB storage engine, which is the default for most workloads. These optimizations target better memory utilization and reduced I/O, leading to faster read and write operations under heavy load.
The optimizer has seen improvements in query planning, particularly for complex joins and subqueries. It can now make smarter decisions about index usage and join order, which can drastically cut down query execution times for analytical workloads.
Replication performance has also been tuned. These changes reduce latency in replication streams, ensuring your replicas stay more closely in sync with the primary server, which is critical for high-availability setups.
What security enhancements should I know about?
MariaDB 11.5 introduces a password validation plugin, which allows administrators to enforce strong password policies for database users. This helps prevent the use of weak passwords that are easily compromised.
Full support for TLS 1.3 is now included, providing the latest in encrypted connection protocols for data in transit. This ensures your client-server communications use the most secure and performant encryption available.
The MariaDB Audit Plugin has been updated with new capabilities, offering more granular control over what events are logged. This gives you a clearer audit trail for monitoring database access and potential security incidents.
Is anything deprecated or removed in this version?
Yes, several older and less-used storage engines have been deprecated. This is a continuation of the effort to simplify the codebase and focus development resources on the most performant and reliable engines, like InnoDB.
A number of outdated server and client configuration options have also been marked as deprecated. You should review the release notes for a complete list and start planning to update any configuration files that use these old parameters to avoid future upgrade issues.
FAQ
Should I use generated columns or virtual columns?
Generated columns are the standard SQL term and implementation. In practice, they replace the older MariaDB-specific "virtual columns" and are the recommended way to define computed columns going forward for better compatibility.
Does system versioning work with all storage engines?
No, system versioning (temporal tables) primarily works with the InnoDB and Aria storage engines. You'll need to ensure your tables are using a compatible engine to utilize this feature.
How do I enable the password validation plugin?
You need to install the plugin and configure its policy rules in your my.cnf file. The specific steps and policy options are detailed in the MariaDB documentation for the simple_password_check plugin.
Will my existing applications break due to stricter CHECK constraints?
If your application already writes data that violates an existing CHECK constraint, it might start receiving errors where it previously did not. It's a good idea to audit your data and application logic before upgrading.
Is upgrading from MariaDB 10.11 to 11.5 a major jump?
While 11.5 is a feature-rich release, the upgrade path from 10.11 is generally well-defined. As always, thoroughly test your application with the new version in a staging environment before upgrading production systems.