mariadbmariasqlmariadb-connect-engine

MariaDB ColumnStore Questions


I have question regarding MariaDB ColumnStore:-

  1. Is this free, can use in production system?
  2. Is this the extension of Mariadb (prerequisite is MariaDB) or we can install this alone?
  3. Can install in single machine in Production, give better performance in terms of the column stores?
  4. Does it support all functionality of MariaDB, I mean directly migration from MariaDB to MariaDB columnstore is possible?
  5. Does it support procedure/functions also because I have used vectorwise actian columnar DB and its not supported.

Solution

  • MariaDB ColumnStore is a GPLv2 storage engine that enables columnar storage of data. Currently ColumnStore is distributed in a separate package (found here) that has all MariaDB functionality it was built with.

    The latest ColumnStore has the same features as MariaDB 10.2 plus the COLUMNSTORE storage engine. There are also a small set of additional functions that ColumnStore implements (e.g. some extra window functions).

    For analytical queries, ColumnStore tables are almost always faster but they are not suited for OLTP workloads. You can have InnoDB and ColumnStore tables in the same database and even do cross-engine joins.

    Stored procedures are supported in the same manner as they are in a normal MariaDB installation. The ColumnStore documentation has a list of features that it supports in addition to the base MariaDB functionality.