Skip to content

Instantly share code, notes, and snippets.

@aaronpeterson

aaronpeterson/mariadb-columnstore-centos7

Last active January 6, 2020 14:13
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save aaronpeterson/ddd75ebb4fa1c419fab5e496c7ab9bb1 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save aaronpeterson/ddd75ebb4fa1c419fab5e496c7ab9bb1 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. aaronpeterson revised this gist Jun 14, 2016. 1 changed file with 0 additions and 9 deletions.
    9 changes: 0 additions & 9 deletions mariadb-columnstore-centos7
    View file
    Original file line number Diff line number Diff line change
    @@ -20,15 +20,6 @@ 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

    mariadb-columnstore-1.0-0-x86_64-centos6-client.rpm
    -rw-r--r--. 1 centos centos 43208 Jun 9 13:27 mariadb-columnstore-1.0-0-x86_64-centos6-common.rpm
    -rw-r--r--. 1 centos centos 17768 Jun 9 13:27 mariadb-columnstore-1.0-0-x86_64-centos6-gssapi-client.rpm
    -rw-r--r--. 1 centos centos 73319508 Jun 9 13:28 mariadb-columnstore-1.0-0-x86_64-centos6-server.rpm
    -rw-r--r--. 1 centos centos 1317056 Jun 9 13:28 mariadb-columnstore-1.0-0-x86_64-centos6-shared.rpm
    -rw-r--r--. 1 centos centos 7133436 Jun 9 13:28 mariadb-columnstore-libs-1.0-0.x86_64.rpm
    -rw-r--r--. 1 centos centos 3264368 Jun 9 13:28 mariadb-columnstore-platform-1.0-0.x86_64.rpm
    -rw-r--r--. 1 centos centos 402824 Jun 9 13:27 mariadb-columnstore-storage-engine-1.0-0.x86_64.rpm

    # create a file named /etc/profile.d/mysql.sh
    sudo nano /etc/profile.d/mysql.sh

  2. aaronpeterson created this gist Jun 14, 2016.
    57 changes: 57 additions & 0 deletions mariadb-columnstore-centos7
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,57 @@
    # 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

    mariadb-columnstore-1.0-0-x86_64-centos6-client.rpm
    -rw-r--r--. 1 centos centos 43208 Jun 9 13:27 mariadb-columnstore-1.0-0-x86_64-centos6-common.rpm
    -rw-r--r--. 1 centos centos 17768 Jun 9 13:27 mariadb-columnstore-1.0-0-x86_64-centos6-gssapi-client.rpm
    -rw-r--r--. 1 centos centos 73319508 Jun 9 13:28 mariadb-columnstore-1.0-0-x86_64-centos6-server.rpm
    -rw-r--r--. 1 centos centos 1317056 Jun 9 13:28 mariadb-columnstore-1.0-0-x86_64-centos6-shared.rpm
    -rw-r--r--. 1 centos centos 7133436 Jun 9 13:28 mariadb-columnstore-libs-1.0-0.x86_64.rpm
    -rw-r--r--. 1 centos centos 3264368 Jun 9 13:28 mariadb-columnstore-platform-1.0-0.x86_64.rpm
    -rw-r--r--. 1 centos centos 402824 Jun 9 13:27 mariadb-columnstore-storage-engine-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