dtheodor/install_mariadb_columnstore.md

## install_mariadb_columnstore.md

      
    Raw
  

              install_mariadb_columnstore.md
            
          
    Install MariaDB Columnstore on Centos 6 - Single server as root installation

Information put together from
https://mariadb.com/kb/en/mariadb/preparing-for-columnstore-installation/
https://github.com/mariadb-corporation/mariadb-columnstore-vagrant/blob/master/bootstrap.sh
Install some prerequisites

yum update
yum -y install avahi wget sudo net-tools vim
vim /etc/avahi/avahi-daemon.conf, find the line: "#disallow-other-stacks=no" and change to "disallow-other-stacks=yes"
service avahi-daemon start

Install MariaDB Columnstore

tar -xzf mariadb-columnstore-1.0.7-1-centos6.x86_64.rpm.tar.gz
yum -y localinstall mariadb*.rpm
Install boost library

yum -y install boost
yum -y install expect perl perl-DBI openssl zlib perl-DBD-MySQL
yum -y groupinstall "Development Tools"
yum -y install cmake
cd /usr
wget http://sourceforge.net/projects/boost/files/boost/1.55.0/boost_1_55_0.tar.gz
tar zxvf boost_1_55_0.tar.gz
cd boost_1_55_0
./bootstrap.sh --with-libraries=atomic,date_time,exception,filesystem,iostreams,locale,program_options,regex,signals,system,test,thread,timer,log --prefix=/usr
./b2 install
Copy the built library to the MariaDB lib directory

cp /usr/boost_1_55_0/bin.v2/libs/system/build/gcc-4.4.7/release/threading-multi/libboost_system.so.1.55.0 /usr/local/mariadb/columnstore/lib/
ldconfig -v
Configure and start MariaDB Columnstore

/bin/echo -e "1\n\n\n\n\n" | /usr/local/mariadb/columnstore/bin/postConfigure
/usr/local/mariadb/columnstore/mysql/bin/mysql --defaults-file=/usr/local/mariadb/columnstore/mysql/my.cnf -uroot -vvv -Bse "set sql_mode=NO_ENGINE_SUBSTITUTION;GRANT ALL ON *.* to root@'%';FLUSH PRIVILEGES;"
/usr/local/mariadb/columnstore/bin/setConfig CrossEngineSupport Host 127.0.0.1
/usr/local/mariadb/columnstore/bin/setConfig CrossEngineSupport Port 3306
/usr/local/mariadb/columnstore/bin/setConfig CrossEngineSupport User root
/usr/local/mariadb/columnstore/bin/setConfig CrossEngineSupport Password ""
. /usr/local/mariadb/columnstore/bin/columnstoreAlias
/usr/local/mariadb/columnstore/bin/mcsadmin restartsystem y
mcsmysql