Skip to content

Instantly share code, notes, and snippets.

@dtheodor
Last active July 25, 2018 13:24
Show Gist options
  • Save dtheodor/baceceae4cbc1bc3f6f2861a09edcef1 to your computer and use it in GitHub Desktop.
Save dtheodor/baceceae4cbc1bc3f6f2861a09edcef1 to your computer and use it in GitHub Desktop.
Install MariaDB Columnstore on Ubuntu 16.04

Following instructions at https://mariadb.com/kb/en/mariadb/preparing-for-columnstore-installation/

Install

sudo apt-get -y install libboost-all-dev expect perl openssl file sudo libdbi-perl libreadline-dev libdbd-mysql-perl
wget https://downloads.mariadb.com/ColumnStore/1.0.7/ubuntu/dists/xenial/main/binary_amd64/mariadb-columnstore-1.0.7-1-xenial.x86_64.deb.tar.gz
tar zxf mariadb-columnstore-1.0.7-1-xenial.x86_64.deb.tar.gz
sudo dpkg -i *.deb
sudo /usr/local/mariadb/columnstore/bin/postConfigure

Expose the mcsmysql client

alias mcsmysql='/usr/local/mariadb/columnstore/mysql/bin/mysql --defaults-file=/usr/local/mariadb/columnstore/mysql/my.cnf'

Create a new user

create user 'username'@'hostname' identified by 'password';
grant ALL on infinidb_vtable.* to 'username'@'hostname'; -- this must be set as-is for any new user to be able to do anything in any db
flush privileges;
@salvatoretrimarchi
Copy link

Nice!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment