The newest release of MariaDB SkySQL includes MariaDB Enterprise ColumnStore 5.4. ColumnStore is a columnar smart engine used to accomplish cloud data warehousing and hybrid transactional/analytical processing (HTAP) in SkySQL. This release introduces new version numbering, adds a multi-node topology to SkySQL for highly available cloud data warehousing, and speeds up
INSERT statement processing when in a Hybrid Transactional Analytical Processing (HTAP) configuration.
Updated Version Number
SkySQL users will notice the ColumnStore release series version number is changing from 1.5 to 5.4. Since ColumnStore is now part of MariaDB Enterprise Server and Community Server, we are aligning to the Server version.
Performance Gains through Batch Caching for HTAP
MariaDB SkySQL includes an option for HTAP with MariaDB Platform optimized for smart transaction processing in the cloud. Data is stored both as rows on persistent block storage for transactional processing and as columns on object storage for near real-time analytics. This enables applications to enrich transactions with real-time analytics. With Enterprise ColumnStore 5.4 we have sped up
INSERT statement processing on the analytics side through the use of batch caching. Batch caching is a background process requiring nothing from the user while providing substantial performance benefits.
Multi-node Cloud Data Warehousing for High Availability
With the latest release of MariaDB SkySQL, customers who want to deploy a cloud data warehouse can choose either a standalone instance or a three-node topology for high availability facilitated by MariaDB MaxScale.