Upgrade a Single-Node MariaDB ColumnStore Deployment from 1.5.X to 1.5.Y with MariaDB Community Server 10.5 on CentOS 7

These instructions detail a minor release upgrade with MariaDB ColumnStore 1.5 and MariaDB Community Server 10.5 on CentOS Linux 7 in a Single-node ColumnStore Deployment configuration.

A minor release upgrade is a change from an earlier release of MariaDB ColumnStore 1.5 with MariaDB Community Server 10.5 to a later release in the same release series.

For example, it would be a minor release upgrade to upgrade from MariaDB ColumnStore 1.5.1 with MariaDB Community Server 10.5.3 to MariaDB ColumnStore 1.5.2 with MariaDB Community Server 10.5.4.

Data Backup

Occasionally, issues can be encountered during upgrades. These issues can even potentially corrupt the database's data files, preventing you from easily reverting to the old installation. We strongly advise performing a backup prior to upgrading. If an issue is encountered during the upgrade, you can use the backup to restore your MariaDB ColumnStore database to the old version. If the upgrade finishes without issue, the backup can be deleted.

  1. Run columnstoreBackup:

    $ columnstoreBackup -zv 192.0.2.1 /data/backups/pm1
    
  2. Confirm the successful completion of the backup operation.

  3. Test the backup

Additional information on columnstoreBackup is available on the MariaDB Knowledge Base.

Shutdown ColumnStore

Before MariaDB ColumnStore can be upgraded, stop the current MariaDB ColumnStore processes.

The server and the ColumnStore processes can be stopped using the systemctl command.

  1. Stop the MariaDB Server process:

    $ sudo systemctl stop mariadb
    
  2. Stop the MariaDB ColumnStore processes:

    $ sudo systemctl stop mariadb-columnstore
    

Update

MariaDB Corporation provides a YUM package repository for CentOS Linux 7.

MariaDB Community Server 10.5 does not require additional software to operate as an analytics database with MariaDB ColumnStore.

Update via YUM (RHEL/CentOS)

  1. Configure the YUM package repository.

    To configure YUM package repositories:

    $ sudo yum install wget
    
    $ wget https://downloads.mariadb.com/MariaDB/mariadb_repo_setup
    
    $ echo "2de6253842f230bc554d3f5ab0c0dbf717caffbf45ae6893740707961c8407b7  mariadb_repo_setup" \
        | sha256sum -c -
    
    $ chmod +x mariadb_repo_setup
    
    $ sudo ./mariadb_repo_setup \
       --mariadb-server-version="mariadb-10.5"
    
  2. Update MariaDB ColumnStore and package dependencies:

    $ sudo yum update "MariaDB-*"
    

Post Update

Updating the MariaDB Community Server and MariaDB ColumnStore packages provides you with necessary packages to run the Server as a ColumnStore Instance, but only configures the Server as a Server. A few additional steps are needed to configure the MariaDB ColumnStore storage back-end.

Start the Server

The server and the ColumnStore processes can be started using the systemctl command.

  1. Start the MariaDB Server process and configure it to start automatically:

    $ sudo systemctl start mariadb
    $ sudo systemctl enable mariadb
    
  2. Start the MariaDB ColumnStore processes and configure them to start automatically:

    $ sudo systemctl start mariadb-columnstore
    $ sudo systemctl enable mariadb-columnstore
    

Update the Data Directory

  1. Execute mariadb-upgrade to update the data directory:

    $ sudo mariadb-upgrade
    

Administration

MariaDB Community Server uses systemctl to start and stop the server processes:

Operation

Command

Start

sudo systemctl start mariadb

Stop

sudo systemctl stop mariadb

Restart

sudo systemctl restart mariadb

Enable during startup

sudo systemctl enable mariadb

Disable during startup

sudo systemctl disable mariadb

Status

sudo systemctl status mariadb

MariaDB ColumnStore also uses systemctl to start and stop the ColumnStore processes:

Operation

Command

Start

sudo systemctl start mariadb-columnstore

Stop

sudo systemctl stop mariadb-columnstore

Restart

sudo systemctl restart mariadb-columnstore

Enable during startup

sudo systemctl enable mariadb-columnstore

Disable during startup

sudo systemctl disable mariadb-columnstore

Status

sudo systemctl status mariadb-columnstore

Testing

When you have MariaDB ColumnStore up and running, you should test it to ensure that it is in working order and that there were not any issues during startup.

Checking Server Status

  1. Connect to the server using MariaDB Client using the root@localhost user account:

    $ sudo mariadb
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 38
    Server version: 10.5.4-MariaDB MariaDB Server
    
    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    MariaDB [(none)]>