Skip to content

Instantly share code, notes, and snippets.

@dtheodor
Last active December 3, 2018 23:48
Show Gist options
  • Save dtheodor/c0d365f9b8456b8088576ce094e0fadd to your computer and use it in GitHub Desktop.
Save dtheodor/c0d365f9b8456b8088576ce094e0fadd to your computer and use it in GitHub Desktop.
Install MariaDB 1.08 Columnstore on Centos 7.2

Following instructions at

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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment