MariaDB ColumnStore
MariaDB ColumnStore is a columnar storage engine that utilizes a massively parallel distributed data architecture. It's a columnar storage system built by porting InfiniDB 4.6.7 to MariaDB, and released under the GPL license.
From MariaDB 10.5.4, it is available as a storage engine for MariaDB Server. Before then, it is only available as a separate download.
MariaDB ColumnStore is designed for big data scaling to process petabytes of data, linear scalability and exceptional performance with real-time response to analytical queries. It leverages the I/O benefits of columnar storage, compression, just-in-time projection, and horizontal and vertical partitioning to deliver tremendous performance when analyzing large data sets.
Release notes and other documentation for ColumnStore is also available in the Enterprise docs section of the MariaDB website. For example:
-
About MariaDB ColumnStore
About MariaDB ColumnStore. -
MariaDB ColumnStore Release Notes
MariaDB ColumnStore Release Notes -
ColumnStore Getting Started
Quick summary of steps needed to install MariaDB ColumnStore -
ColumnStore Upgrade Guides
Documentation on upgrading from prior versions and InfiniDB migration. -
ColumnStore Architecture
MariaDB ColumnStore Architecture -
Managing ColumnStore
Managing MariaDB ColumnStore System Environment and Database -
ColumnStore Data Ingestion
How to load and manipulate data into MariaDB ColumnStore -
ColumnStore SQL Structure and Commands
SQL syntax supported by MariaDB ColumnStore -
ColumnStore Performance Tuning
Information relating to configuring and analyzing the ColumnStore system for optimal performance. -
ColumnStore System Variables
ColumnStore System Variables -
ColumnStore Security Vulnerabilities
Security vulnerabilities affecting MariaDB ColumnStore -
ColumnStore Troubleshooting
Articles on troubleshooting tips and techniques -
StorageManager
Articles on StorageManager and S3 configuration -
Using MariaDB ColumnStore
Provides details on using third party products and tools with MariaDB ColumnStore -
Building ColumnStore in MariaDB
This is a description of how to build and start a local ColumnStore install... -
Can't create a table starting with a capital letter. All tables are lower case-
Hi, I was playing around with my MariaDB ColumnStore and I noticed the I am...
