On Wednesday 24 June 2020, MariaDB Server 10.5 was released GA. While there are several cool new features included, this first 10.5 blog is about the groundbreaking new component, ColumnStore.
ColumnStore brings data warehousing to the world of MariaDB Server. It’s a columnar storage engine (Wikipedia: Column-oriented DBMS), enabling what is often called HTAP (Wikipedia: Hybrid Transactional/Analytical Processing). The Columnar data type stores data by columns, not by rows, enabling quick analytical reporting over huge data volumes.
The ColumnStore engine is part of MariaDB Server 10.5.
MariaDB has an Open Source engine called ColumnStore which provides columnar storage capabilities. During the MariaDB Day Andrew Hutchings (a.k.a. LinuxJedi) will hold a talk explaining what columnar storage is, how it works and the advantages / disadvantages of it. He will also talk about how you can use it to help with things such as your analytical workloads alongside your traditional OLTP workloads.