Install MariaDB Columnstore on Ubuntu 16.04

install_mariadb_columnstore_ubuntu_16_04.md

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;

How can I fully remove/uninstall this.

Nice!