Last active
January 6, 2020 14:13
-
-
Save aaronpeterson/ddd75ebb4fa1c419fab5e496c7ab9bb1 to your computer and use it in GitHub Desktop.
Installing MariaDb ColumnStore on Cent OS 7
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Nice work.