====== Building ColumnStore in MariaDB ======

This is a description of how to build and start a local ColumnStore installation, for debugging purposes.

<note warning>
The content of this page might be obsolete. If you can provide updated information, please edit this page or add a comment.
</note>

===== Install the dependencies =====

For CentOS:

    yum -y groupinstall "Development Tools" \
        && yum -y install bison ncurses-devel readline-devel perl-devel openssl-devel cmake libxml2-devel gperf libaio-devel libevent-devel python-devel ruby-devel tree wget pam-devel snappy-devel libicu \
        && yum -y install vim wget strace ltrace gdb  rsyslog net-tools openssh-server expect \
        && boost perl-DBI

===== Get the source code =====

    git clone https://github.com/mariadb-corporation/mariadb-columnstore-server.git
    cd mariadb-columnstore-server/
git clone https://github.com/mariadb-corporation/mariadb-columnstore-engine.git

===== Compile =====

    cmake . -DCMAKE_BUILD_TYPE=Debug \
        -DWITHOUT_MROONGA:bool=1 -DWITHOUT_TOKUDB:bool=1 \
        -DCMAKE_INSTALL_PREFIX=/usr/local/mariadb/columnstore/mysql
        make -j10
    sudo make install
    
    cd mariadb-columnstore-engine/
    cmake . -DCMAKE_BUILD_TYPE=Debug
    make -j10
    sudo make install
    cd /usr/local/mariadb/columnstore/bin/

===== Configure =====

    Make sure you do NOT have /etc/my.cnf or /.my.cnf.
    
    sudo ./postConfigure

Answer "Enter" to all questions, except:

    Select the type of System Server install [1=single, 2=multi] (2) > 

Here, answer 1.

===== Access the server =====

    source /usr/local/mariadb/columnstore/bin/columnstoreAlias
    mcsmysql



----
[[https://web.archive.org/web/20230406212414/https://mariadb.com/kb/en/building-columnstore-in-mariadb/|Original document]]

{{page>:footer}}