MariaDB Blog

May 02, 2016

ColumnStore Architecture & Use-case

MariaDB ColumnStore is built on a three-tier scalable architecture that supports the kind of growth that MariaDB users have grown accustomed to. Queries are processed by user modules, which assign tasks to parallel performance modules that access the columnar distributed storage layer below. Performance modules scale almost infinitely, providing both performance and capacity growth as you add servers. They also provide built-in data redundancy. These modules don’t process queries; they just take instructions from the user modules, which organize and deliver the results.

Read More

April 29, 2016

Why is ColumnStore important?

Relational databases store data in rows because a typical SQL query looks for multiple fields within a record. For example, if you ask for name, zip code and email address of all your customers in New York, the result is presented in rows, with each row containing several fields from a single record. Row structures are also well optimized to handle a lot of inserts and updates.

Read More