MariaDB Corporation releases MariaDB Community Server 10.6 with enhancements that bring significant advancements to the MariaDB open source community.
MariaDB Community Server 10.6 adds important developer functionality with JSON table functionality, frees users from costly proprietary links with extensive PL / SQL compatibility, and adds powerful insurance for database bad days with Atomic DDL.
Finally, MariaDB’s columnar engine for powerful analytics received major upgrades for user experience, stability, and new features like on-disk aggregation.
“MariaDB is one of the best relational databases in the world, known for its rapid innovation, strong community, and modern architecture that supports workload flexibility,” said Max Mether, co-founder and Vice President of Server Product Management, MariaDB Corporation. “We are committed to delivering continuous innovation to the community and are thrilled to deliver this year’s release packed with amazing features for developers and DBAs. “
MariaDB Community Server 10.6 adds major new features, including:
- Extending JSON: JSON is fast becoming the standard format for data interchange and for unstructured data, and MariaDB (in fact, all MariaDB versions 10.2 and later) includes a range of JSON support functions . With this release, MariaDB adds JSON table functions, allowing a table view into the JSON data stored in MariaDB. The queries are returned as a standard table using SQL.
- Oracle Compatibility: Starting with version 10.3, MariaDB was the first open source database to add PL / SQL compatibility, making it easy to migrate from Oracle to MariaDB. This release adds several new community-developed PL / SQL compatibility features, reflecting the far-reaching impact this open source innovation has had around the world.
- Atomic DDL: With MariaDB Community Server 10.6, the Data Definition Language (DDL) is now atomic, which increases disaster recovery by ensuring that any DDL statement is fully executed or not executed at all. Unlike MySQL, MariaDB implemented Atomic DDL in the database layer to support various workloads using different storage engines, with immediate support for InnoDB and Aria storage engines. Atomic DDL support for other storage engines will be available soon.
- Analytics: Last year Column Analysis was added as a supported storage engine for MariaDB, providing analytics for everyone. Unlike MySQL, the analysis in MariaDB is open source and can be deployed anywhere. MariaDB Community Server 10.6 includes significant enhancements to its analytical capabilities, including performance improvements, additional Oracle compatibility, better resiliency, and new on-disk aggregation to support larger aggregated datasets and lower hardware costs.
For more information on this version, visit https://mariadb.com/.