Skip to content

Instantly share code, notes, and snippets.

@aaronpeterson
Last active January 6, 2020 14:13
Show Gist options
  • Star 4 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save aaronpeterson/ddd75ebb4fa1c419fab5e496c7ab9bb1 to your computer and use it in GitHub Desktop.
Save aaronpeterson/ddd75ebb4fa1c419fab5e496c7ab9bb1 to your computer and use it in GitHub Desktop.
Installing MariaDb ColumnStore on Cent OS 7
# Couldn't get this running on any Ubuntu instances.
# Today I used AWS CentOS Linux 7 x86_64 HVM EBS 1602-b7ee8a69-ee97-4a49-9e68-afaee216db2e-ami-d7e1d2bd.3 (ami-6d1c2007)
# install dependencies
sudo yum install perl perl-DBI expect wget nano
# download binaries for centos 7
wget https://downloads.mariadb.com/enterprise/htxx-hpee/mariadb-columnstore/1.0.0/mariadb-columnstore-1.0.0-centos7.x86_64.rpm.tar.gz
# extract
tar zxvf mariadb-columnstore-1.0.0-centos7.x86_64.rpm.tar.gz
# install rpms, (you might have to change the order but I believe this works)
sudo rpm -ivh mariadb-columnstore-1.0-0-x86_64-centos6-shared.rpm
sudo rpm -ivh mariadb-columnstore-1.0-0-x86_64-centos6-client.rpm
sudo rpm -ivh mariadb-columnstore-1.0-0-x86_64-centos6-common.rpm
sudo rpm -ivh mariadb-columnstore-1.0-0-x86_64-centos6-gssapi-client.rpm
sudo rpm -ivh mariadb-columnstore-1.0-0-x86_64-centos6-server.rpm
sudo rpm -ivh mariadb-columnstore-storage-engine-1.0-0.x86_64.rpm
sudo rpm -ivh mariadb-columnstore-libs-1.0-0.x86_64.rpm
sudo rpm -ivh mariadb-columnstore-platform-1.0-0.x86_64.rpm
# create a file named /etc/profile.d/mysql.sh
sudo nano /etc/profile.d/mysql.sh
# with the following contents
pathmunge /usr/local/mariadb/columnstore/mysql/bin
sudo chmod +x /etc/profile.d/mysql.sh
# reload bash profile
. /etc/profile
# try it
which mysql
# you should see
/usr/local/mariadb/columnstore/mysql/bin/mysql
# enable the init.d script, just noticed the columnstore script installed by the rpm, though, hmm. Skip this, probably.
sudo cp /usr/local/mariadb/columnstore/mysql/share/mysql/mysql.server /etc/init.d/mysql.server
# Run postConfigure in the ... dir, I just used all the default settings
cd /usr/local/mariadb/columnstore/bin
sudo ./postConfigure
# holy shit, it works
sudo service columnstore start
@RedShift1
Copy link

Nice work.

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