What's New in MariaDB Enterprise ColumnStore 1.4?
MariaDB Enterprise ColumnStore 1.4 introduces the following new features:
MariaDB Server Convergence
Until now, MariaDB ColumnStore has been maintained as a custom fork of MariaDB Server, to handle the unique way that queries are handled for distributed processing.
With this release, a joint project between the MariaDB Server and MariaDB ColumnStore engineering teams, ColumnStore now works as a pluggable storage engine on the standard MariaDB Enterprise Server 10.4 platform.
S3-Compatible Object Storage
MariaDB Enterprise ColumnStore now has the ability to use any object store that is Amazon S3 API compatible. The "Storage Manager" uses a persistent disk cache for read/write operations so that it has minimal performance impact on ColumnStore. In some cases it will perform better than local disk operations.
To reduce SSD wear and and increase write performance for large data sets containing many columns, ColumnStore now allocates disk as-needed, writing only real data and padding to fill the remainder of an 8KB block. ColumnStore previously wrote twice -- once to pre-allocate an empty file for each new extent (8 million item file for a column), and a second time to fill the file with real data.
Faster ORDER BY
The outer "ORDER BY" of a query is now processed using ColumnStore's engine instead of MariaDB server. This uses a faster sorting algorithm for higher performance with larger result sets.
Faster, More Efficient Hash JOINS
Expanded Data Type Support including
Statement-based Replication support
InfiniDB Alias Eliminated
ColumnStore 1.2 and earlier included the InfiniDB engine as an alias. This alias has now been removed. All ColumnStore tables must now be created with the engine name "columnstore". All MariaDB system variables prefixed with "infinidb_
For a complete list of changes, see MariaDB Enterprise ColumnStore 1.4.2 release notes.