MariaDB ColumnStore – A Columnar Storage Engine, First Class Citizen in MariaDB

by Vicențiu Ciorbaru

Vicențiu Ciorbaru - MariaDB Foundation - MariaDB ColumnStore – A Columnar Storage Engine, First Class Citizen in MariaDB - Percona Live 2021 - MariaDB Track Room

MariaDB has had ColumnStore (a columnar storage engine) available for a while now. The problem was that ColumnStore (formerly known as InniDB) was coded in such a way that required a custom version of MariaDB to function. The installation was also non-trivial, with quite a set of dependencies needed. After a significant amount of work, both within MariaDB’s codebase and ColumnStore’s codebase, it is now possible with MariaDB 10.5 to simply load the ColumnStore plugin and run CREATE TABLE … ENGINE=ColumnStore. In this talk we will do an overview of the state of ColumnStore in MariaDB, discuss use cases as well as cover some implementation details to better understand performance implications when using ColumnStore.

Video

Link: https://youtu.be/CHOVd12_PW8

Vicențiu Ciorbaru

MariaDB Foundation, Team Lead, Senior Developer

Vicentiu works at the MariaDB Foundation as a Software Engineer and Team Lead. He focuses on optimizer development, but has also worked on other parts of the MariaDB Server. Vicențiu has been part of the MariaDB ecosystem since 2013, where he first contributed Roles to MariaDB. Over the years, Vicențiu has coded numerous features and helped with the packaging of MariaDB for various distributions. Recently, Vicențiu has also been involved in the QA process of MariaDB, by contributing to https://buildbot.mariadb.org as well as mariadb.org/download infrastructure

See all talks by Vicențiu Ciorbaru »

✎ Edit this page on GitHub