dtheodor/install_mariadb_columnstore_ubuntu_16_04.md

## install_mariadb_columnstore_ubuntu_16_04.md

      
    Raw
  

              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;