Upgrading MariaDB ColumnStore
Contents
MariaDB ColumnStore single server software upgrade
Note: Columnstore.xml modifications you manually made are not automatically carried forward on an upgrade. These modifications will need to be incorporated back into .XML once the upgrade has occurred.
The previous configuration file will be saved as /usr/local/MariaDB/Columnstore/etc/Columnstore.xml.rpmsave.
Choosing the type of upgrade
Root User Installs
Upgrading MariaDB ColumnStore using RPMs
- Upgrade MariaDB ColumnStore as user root:
- Download the package -release#.x86_64.tar.gz (RHEL5 64-BIT)to the server where you are installing MariaDB ColumnStore.
- Shutdown the MariaDB ColumnStore system:
# mcsadmin shutdownsystem y
- Unpack the tarball, which will generate a set of RPMs that will reside in the /root/ directory.
tar -zxf -release#.x86_64.tar
- Upgrade the RPMs. The MariaDB ColumnStore software will be installed in /usr/local/.
Note: If another version of MariaDB is currently running, this service will need to be stopped before running this command. After the rpm command has been executed, you can restart the service.
rpm -Uvh *release#*.rpm
- Run postConfigure using the upgrade option, which will utilize the configuration from the Columnstore.xml,rpmsave
# /usr/local/MariaDB/Columnstore/bin/postConfigure -u
For RPM Upgrade, the previous configuration file will be saved as:
/usr/local/MariaDB/Columnstore/etc/Columnstore.xml.rpmsave
Initial download/install of MariaDB ColumnStore binary package
Install MariaDB ColumnStore as user root on the server designated as PM1:
- Download the package into the /usr/local directory -mariadb-columnstore-release#.x86_64.bin.tar.gz (Binary 64-BIT)to the server where you are installing MariaDB ColumnStore.
- Shutdown the MariaDB ColumnStore system:
cc shutdownsystem y
- Run pre-uninstall script
/usr/local/MariaDB/Columnstore/bin/pre-uninstall
- Unpack the tarball, which will generate the /usr/local/ directory.
tar -zxvf -mariadb-columnstore-release#.x86_64.bin.tar.gz
- Run post-install scripts
/usr/local/MariaDB/Columnstore/bin/post-install
- Run postConfigure using the upgrade option, which will utilize the configuration from
the Columnstore.xml,rpmsave
/usr/local/MariaDB/Columnstore/bin/postConfigure -n
Upgrading MariaDB ColumnStore using the DEB package
A DEB upgrade would be done on a system that supports DEBs like Debian or Ubuntu systems. Install MariaDB ColumnStore as user root on the server designated as PM1:
- Download the package into the /root directory
-mariadb-columnstore-release#.amd64.deb.tar.gz
(DEB 64-BIT) to the server where you are installing MariaDB ColumnStore. - Shutdown the MariaDB ColumnStore system:
cc shutdownsystem y
- Unpack the tarball, which will generate 3 DEBs.
tar -zxf -mariadb-columnstore-release#.amd64.deb.tar.gz
- Remove, purge and install all MariaDB ColumnStore debs
cd /root/ dpkg -r mariadb-columnstore*deb dpkg -P mariadb-columnstore*deb
- Run postConfigure using the upgrade option, which will utilize the
configuration from the Calpont.xml,rpmsave
/usr/local/MariaDB/Columnstore/bin/postConfigure -u