Install MariaDB 1.08 Columnstore on Centos 7.2

install_mariadb_columnstore_centos_7_2.md

Following instructions at

• https://mariadb.com/kb/en/mariadb/preparing-for-columnstore-installation/
• https://mariadb.com/kb/en/mariadb/installing-and-configuring-mariadb-columnstore/

Install

sudo yum -y install boost expect perl perl-DBI openssl zlib snappy libaio
wget https://downloads.mariadb.com/ColumnStore/1.0.8/centos/x86_64/7/mariadb-columnstore-1.0.8-1-centos7.x86_64.rpm.tar.gz
tar xzf mariadb-columnstore-1.0.7-1-centos7.x86_64.rpm.tar.gz
sudo rpm -ivh mariadb-columnstore*.rpm
sudo /usr/local/mariadb/columnstore/bin/postConfigure

Add useful aliases found in /usr/local/mariadb/columnstore/bin/columnstoreAlias to your ~/.bashrc

alias mcsmysql='/usr/local/mariadb/columnstore/mysql/bin/mysql --defaults-file=/usr/local/mariadb/columnstore/mysql/my.cnf'
alias mcsadmin=/usr/local/mariadb/columnstore/bin/mcsadmin
alias cpimport=/usr/local/mariadb/columnstore/bin/cpimport
alias tdebug='tail -f /var/log/mariadb/columnstore/debug.log'
alias tinfo='tail -f /var/log/mariadb/columnstore/info.log'

Configure

# setup cross engine join support
sudo /usr/local/mariadb/columnstore/bin/setConfig CrossEngineSupport Host 127.0.0.1
sudo /usr/local/mariadb/columnstore/bin/setConfig CrossEngineSupport Port 3306
sudo /usr/local/mariadb/columnstore/bin/setConfig CrossEngineSupport User root
sudo /usr/local/mariadb/columnstore/bin/setConfig CrossEngineSupport Password ""

Suggested config options in /usr/local/mariadb/columnstore/mysql/my.cnf

[mysqld]
max_allowed_packet = 32M
max_length_for_sort_data=8388608
character-set-server=utf8
collation-server=utf8_bin
init-connect='SET NAMES utf8'
sql_mode=TRADITIONAL

Restart

/usr/local/mariadb/columnstore/bin/mcsadmin restartsystem y

Connect

mcsmysql

Manage

mcsadmin
mcsadmin getsystemstatus
mcsadmin help

Create a new user

create user 'username'@'hostname' identified by 'password';
grant ALL on infinidb_vtable.* to 'username'@'hostname';
flush privileges;