You are here

ColumnStore ArchitectureMariaDB 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.

Row-Orientated vs Column-OrientatedRelational 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.

MariaDB works with many clients to migrate Microsoft SQL and Oracle to MariaDB. With the CONNECT storage engine we can access any ODBC data source in MariaDB. Here's a small HOWTO for those who want to give it a quick try. In this example we use MSSQL, though the same principle should be possible with Oracle ODBC servers.

URGENT UPDATE: Do not take 1.4.2 into use. We have found a problem and will provide a 1.4.3 release shortly.

We are pleased to announce that MariaDB MaxScale 1.4.2 GA is now available for download!

MariaDB ColumnStoreMariaDB’s new analytics engine – MariaDB ColumnStore - has been in the works for some time. What is it and how did it come about? This post outlines our thinking in choosing the engine and features we implemented.

Which databases are used for OpenStack componentsWhile many are at the ongoing OpenStack Summit in Austin, it came to my attention that the OpenStack project has recently published their latest user survey.

In a recent presentation by Balazs Pocze from Gawker Media LLC made clear that there are many automation strategies for server management that would be worth packaging up into an extended solution like MariaDB Enterprise.

The latest top research identifies a number of big trends and challenges for databases. Jan Lindström, developer at MariaDB, summarises the key issues and challenges and how MariaDB approaches them.


AliSQL is the fork of MySQL (maintained by Alibaba) that powers all of the group from Tmall, Taobao,,, AliExpress, Cainiao and the payment's network Alipay.

Team MariaDB is touring across several European regions again. The theme for 2016 is "Data Management for Mission Critical Applications". Beside valuable presentations around database security, Big Data analysis and better scalability and high availability our technical experts will help you understand how to take advantage of the wide range of new features and enhancements available now in MariaDB 10.1, MariaDB MaxScale 1.4 and other MariaDB solutions. They will share tips & tricks to help you get the most out of your database.