MariaDB has announced the general availability of the MariaDB Platform X5 open source database solution. The release contains upgrades for every component of the platform as well as the new intelligent MariaDB Xpand engine for distributed SQL to enable global and complete availability. MariaDB Platform X5 is now available to customers with a subscription. To get a free 30-day trial version of MariaDB Platform X5 with Xpand for distributed SQL, interested parties can contact MariaDB directly. MariaDB Platform X5 will soon be available in SkySQL, MariaDB’s cloud database. MariaDB Enterprise Server 10.5, a core component of MariaDB Platform, is now available on SkySQL.
MariaDB promises versatility and scalability and, according to MariaDB, should be able to meet most workload requirements, including interactive analytics, schema flexibility, and continuous availability. MariaDB leverages the popularity of MariaDB’s MySQL heritage and is widely accessible to tens of millions of users around the world.
New features include Xpand for distributed SQL, InnoDB revision, ColumnStore improvements, high availability orchestration, the integration of Apache Kafka and Redis, and a new security plug-in.
New to the MariaDB Platform X5 is the Xpand Smart Engine, which is based on a distributed SQL architecture. Due to the possibility to distribute the entire database or only selected tables, according to the manufacturer MariaDB Platform with Xpand offers great flexibility for elastic scaling and high availability. This carefully coordinated flexibility is intended to enable companies to start small and to expand indefinitely if necessary. By using Xpand, MariaDB Platform is able to execute millions of transactions per second.
InnoDB, the standard engine used for transactions in MariaDB Platform, has undergone a significant overhaul to improve its performance. Important optimization parameters such as the size of the log file (redo log size) and the number of purge threads can now be changed at runtime without the need for a restart.
In addition to optimizing performance and improving recording, the implementation of an API for cluster management simplifies the use of massive parallel processing (MPP) and high availability (HA).
MariaDB MaxScale has long been used for platform services such as query routing, read / write separation, and high availability for multi-node transaction deployments. In this release, the role of high availability orchestration has been extended to analytical implementations that take advantage of the new ColumnStore APIs and provide a unified architecture that, according to the manufacturer, is easy to install and manage.
MariaDB Platform X5 can be integrated into modern data infrastructures such as Kafka and Redis, whereby data is published in Kafka topics and query results are cached in a Redis cluster. Customers are said to benefit by increasing query performance for a better user experience, reducing database usage to reduce hardware costs, and replicating data to external systems to enable new features and information.
A new plugin for the proven Hashicorp Vault has been added to manage encryption keys outside of the database.
“MariaDB Platform X5 is the culmination of many years of intensive development work to bring together the best technologies in a meaningful way,” said Michael Howard, CEO of MariaDB Corporation. “Once again, we contradict the view that different databases are required to complete a single task. With the MariaDB Platform X5, our customers can start small and grow as needed – adaptable, pragmatic and extremely easy. ”
Webinar: To new heights with SkySQL, the ultimate MariaDB cloud
In this online seminar we will introduce SkySQL to you, explain the architecture and explain how it differs from other systemsRDS on. You will also get an insight into the product roadmap, a live demo, and how to get SkySQL up and running in minutes.