MariaDB ColumnStore software upgrade 1.0.6 to 1.0.7

MariaDB ColumnStore software upgrade 1.0.6 to 1.0.7

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.

If you have specified a root database password (which is good practice), then you must configure a .my.cnf file with user credentials for the upgrade process to use. Create a .my.cnf file in the user home directory with 600 file permissions with the following content (updating PASSWORD as appropriate):

[mysqladmin] 
user = root
password = PASSWORD

This file can be removed after the upgrade is complete.

Changes for 1.0.7

MariaDB ColumnStore Schema Sync feature

There is a new prompt in postConfigure for MariaDB ColumnStore Schema Sync feature. In previous versions, this is defaulted to enabled. Starting in the 1.0.7 version, there is a prompt to the user to give you the option to disable it, in the case you have another application that is doing this functionality. So for upgrade, if you use the upgrade option of '-u', then this feature will be left enabled.

Amazon AMI Certification Keys

In 1.0.6, if you were running on a multi-node system and utilizing the AWS EC2 API toolset, you was required to have the Certification Keys (Access and Secret) in files that were referenced during the postConfigure install. in 1.0.7, these keys are now read from the IAM role that is provided or is read from a file called .aws/certification. Please check the Amazon AMI Installation Guide for additional details.

So if you are upgrading from from the Amazon AMI 1.0.6 to the 1.0.7 package and you are utilizing these keys, you will need to either have the keys in the IAM role that you used to launch the AMI with or in the .aws/certification file.

Choosing the type of upgrade

Root User Installs

Upgrading MariaDB ColumnStore using RPMs

Upgrade MariaDB ColumnStore as user root on the server designated as PM1:

Download the package mariadb-columnstore-1.0.7-1-centos#.x86_64.rpm.tar.gz to the PM1 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 mariadb-columnstore-1.0.7-1-centos#.x86_64.rpm.tar.gz

• Upgrade the RPMs. The MariaDB ColumnStore software will be installed in /usr/local/.

rpm -e --nodeps $(rpm -qa | grep '^mariadb-columnstore')
rpm -ivh mariadb-columnstore-*1.0.7*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

Upgrade MariaDB ColumnStore as user root on the server designated as PM1:

• Download the package into the /usr/local directory -mariadb-columnstore-1.0.7-1.x86_64.bin.tar.gz (Binary 64-BIT)to the server where you are installing MariaDB ColumnStore.

• Shutdown the MariaDB ColumnStore system:

mcsadmin shutdownsystem y

• Run pre-uninstall script

/usr/local/mariadb/columnstore/bin/pre-uninstall

• Unpack the tarball, in the /usr/local/ directory.

tar -zxvf -mariadb-columnstore-1.0.7-1.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 -u

Upgrading MariaDB ColumnStore using the DEB package

A DEB upgrade would be done on a system that supports DEBs like Debian or Ubuntu systems.

Upgrade MariaDB ColumnStore as user root on the server designated as PM1:

• Download the package into the /root directory

mariadb-columnstore-1.0.7-1.amd64.deb.tar.gz

(DEB 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 DEBs.

tar -zxf mariadb-columnstore-1.0.7-1.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 Columnstore.xml,rpmsave

/usr/local/mariadb/columnstore/bin/postConfigure -u

<</style>>

Non-Root User Installs

Initial download/install of MariaDB ColumnStore binary package

Upgrade MariaDB ColumnStore as user root on the server designated as PM1:

• Download the package into the /home/'non-root-user" directory

mariadb-columnstore-1.0.7-1.x86_64.bin.tar.gz (Binary 64-BIT)to the server where you are installing MariaDB ColumnStore.

• Shutdown the MariaDB ColumnStore system:

mcsadmin shutdownsystem y

• Run pre-uninstall script

$HOME/mariadb/columnstore/bin/pre-uninstall -i /home/guest/mariadb/columnstore

• Unpack the tarball, which will generate the $HOME/ directory.

tar -zxvf -mariadb-columnstore-1.0.7-1.x86_64.bin.tar.gz

• Run post-install scripts
  1. $HOME/mariadb/columnstore/bin/post-install -i /home/guest/mariadb/columnstore

• Run postConfigure using the upgrade option, which will utilize the configuration from the Columnstore.xml,rpmsave

$HOME/mariadb/columnstore/bin/postConfigure -u -i /home/guest/mariadb/columnstore