Vertica Upgrade from version 8.1.x to 9.0.x on CentOS 6.5

With release of version 9.0.x release in October 2017, Vertica is dropping support of 7.x and 8.x. Upgrading to 9.0 is highly recommended and very useful, as many great features have been added in version 9.x.

HPE recommended path is as follows, as upgrades are increments:

  • Vertica 7.0 to 7.1
  • Vertica 7.1 to 7.2
  • Vertica 7.2 to 8.0
  • Vertica 8.0 to 8.1
  • Vertica 8.1 to 9.0

Steps for Upgrade are highlighted below:

  1. Download Vertica RPM from my.vertica.com.
  2. In one of the nodes of the cluster store the RPM in your desired place.
  3. As dbadmin user perform following checks.
    1. Check the Catalog usage/space:
      Password:
      [dbadmin@COENGS-VRTD01 ~]$ du -s -BG /vdata/comcast/v_comcast_node0001_catalog/
      2G      /vdata/comcast/v_comcast_node0001_catalog/
      [dbadmin@COENGS-VRTD01 ~]$ df -BG /vdata/comcast/v_comcast_node0001_catalog/
      Filesystem     1G-blocks  Used Available Use% Mounted on
      /dev/sdb1          4399G    5G     4171G   1% /vdata
      [dbadmin@COENGS-VRTD01 ~]$ vsql
      Welcome to vsql, the Vertica Analytic Database interactive terminal.
      Type:  \h or \? for help with vsql commands
             \g or terminate with semicolon to execute query
             \q to quit
      dbadmin=> select version();
                    version
      ------------------------------------
       Vertica Analytic Database v8.1.0-1
      (1 row)
      dbadmin=> \q
      [dbadmin@COENGS-VRTD01 ~]$
    2. Perform FULL DB Backup https://my.vertica.com/docs/9.0.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/BackingUpAndRestoringTheDatabase.htm
    3. Verify Platform Requirements https://my.vertica.com/docs/9.0.x/HTML/Content/Authoring/InstallationGuide/Upgrade/PreUpgrade/RequirementsTesting.htm
    4. As dbadmin STOP the database in clean mode
    5. Backup the DB
    6. As root install the RPM
    7. As dbadmin perform DB upgrade
    8. Reinstall any packages that were uninstalled
    9. Restart the DB.

Now we are ready to upgrade the database.

Perform a FULL Hard Link LOCAL backup (before running upgrade, just in case you have to roll-back).

[dbadmin@COENGS-VRTD01 ~]$ ll
total 12
drwxr-xr-x 3 dbadmin verticadba 4096 Jun 13 14:05 script
drwxr-xr-x 2 dbadmin verticadba 4096 Jul  6 10:18 VerticaBR
drwxr-xr-x 4 dbadmin verticadba 4096 Jun 13 14:07 VerticaUDFs
[dbadmin@COENGS-VRTD01 ~]$ cd VerticaBR/
[dbadmin@COENGS-VRTD01 VerticaBR]$ /opt/vertica/bin/vbr -t backup --config-file HLbackup01_8101.ini
Starting backup of database comcast.
Participating nodes: v_comcast_node0001.
Snapshotting database.
Snapshot complete.
Approximate bytes to copy: 0 of 544696344 total.
[==================================================] 100%
Copying backup metadata.
Finalizing backup.
Backup complete!
[dbadmin@COENGS-VRTD01 VerticaBR]$

Use ADMIN Tools to shutdown the DB.

[dbadmin@COENGS-VRTD01 VerticaBR]$ admintools -t stop_db -d comcast -F
Info: no password specified, using none
        Connecting to database
        Issuing shutdown command to database
Database comcast stopped successfully
[dbadmin@COENGS-VRTD01 VerticaBR]$

Now SUDO as root and install the RPM

[root@COENGS-VRTD01 ~]# ll /home/vertica90/
total 217400
-rw-r--r-- 1 root root 222390092 Oct 23 22:53 vertica-9.0.0-0.x86_64.RHEL6.rpm
[root@COENGS-VRTD01 ~]# rpm -Uvh /home/vertica90/vertica-9.0.0-0.x86_64.RHEL6.rpm
Preparing...                ########################################### [100%]
   1:vertica                ########################################### [100%]
Shutting down vertica services for upgrade
Stopping vertica
Shutting down vertica agent daemon
Stopping vertica agent:
Vertica Analytic Database V9.0.0-0 successfully installed on host COENGS-VRTD01
To complete your NEW installation and configure the cluster, run:
 /opt/vertica/sbin/install_vertica
To complete your Vertica UPGRADE, run:
 /opt/vertica/sbin/update_vertica
----------------------------------------------------------------------------------
Important
----------------------------------------------------------------------------------
Before upgrading Vertica, you must backup your database.  After you restart your
database after upgrading, you cannot revert to a previous Vertica software version.
----------------------------------------------------------------------------------
View the latest Vertica documentation at http://my.vertica.com/docs/
[root@COENGS-VRTD01 ~]#

As root or SUDO run the upgrade_vertica script with ORIGINAL options that were used for install or last upgrade.

[root@COENGS-VRTD01 ~]#  /opt/vertica/sbin/update_vertica --rpm /home/vertica90/vertica-9.0.0-0.x86_64.RHEL6.rpm --dba-user dbadmin --data-dir /vdata/ --dba-user-home /opt/home/dbadmin/
Vertica Analytic Database 9.0.0-0 Installation Tool
>> Validating options...
>> Starting installation tasks.
>> Getting system information for cluster (this may take a while)...
Default shell on nodes:
172.28.105.199 /bin/bash
>> Validating software versions (rpm or deb)...
>> Beginning new cluster creation...
successfully backed up admintools.conf on 172.28.105.199
>> Creating or validating DB Admin user/group...
Successful on hosts (1): 172.28.105.199
    Provided DB Admin account details: user = dbadmin, group = verticadba, home = /opt/home/dbadmin
    Creating group... Group already exists
    Validating group... Okay
    Creating user... User already exists
    Validating user... Okay
>> Validating node and cluster prerequisites...
System prerequisites passed.  Threshold = WARN
>> Establishing DB Admin SSH connectivity...
Installing/Repairing SSH keys for dbadmin
>> Setting up each node and modifying cluster...
Creating Vertica Data Directory...
Updating agent...
>> Sending new cluster configuration to all nodes...
Starting agent...
>> Completing installation...
Running upgrade logic
No spread upgrade required: /opt/vertica/config/vspread.conf not found on any node Installation complete.
Please evaluate your hardware using Vertica's validation tools:
    https://my.vertica.com/docs/9.0.x/HTML/index.htm#cshid=VALSCRIPT
To create a database:
  1. Logout and login as dbadmin. (see note below)
  2. Run /opt/vertica/bin/adminTools as dbadmin
  3. Select Create Database from the Configuration Menu
  Note: Installation may have made configuration changes to dbadmin
  that do not take effect until the next session (logout and login).
To add or remove hosts, select Cluster Management from the Advanced Menu.
[root@COENGS-VRTD01 ~]#

Vertica 9.0 upgrade is complete!!!

Now we need to login as dbadmin and install any optional packages ad restart the DB. Note the mandatory packages will be installed during restart. If you were already logged in as dbadmin, please log off and login again, as permissions/groups might have changed.

*** Starting database: comcast ***
        Starting nodes:
                v_comcast_node0001 (172.28.105.199)
        Starting Vertica on all nodes. Please wait, databases with a large catalog may take a while to initialize.
        Node Status: v_comcast_node0001: (DOWN)
        Node Status: v_comcast_node0001: (DOWN)
        Node Status: v_comcast_node0001: (DOWN)
        Node Status: v_comcast_node0001: (DOWN)
        Node Status: v_comcast_node0001: (UP)
        Vertica version upgrade detected. Running package upgrade tasks.
        Running upgrade hooks
Upgrading (re-installing) extension packages:
Package: AWS
        Installing AWS
        Success: package AWS installed
Package: flextable
        Installing flextable
        Success: package flextable installed
Package: ParquetExport
        Installing ParquetExport
        Success: package ParquetExport installed
Package: approximate
        Installing approximate
        Success: package approximate installed
Package: txtindex
        Installing txtindex
        Success: package txtindex installed
Package: kafka
        Installing kafka
        Success: package kafka installed
Package: place
        Installing place
        Success: package place installed
Package: MachineLearning
        Installing MachineLearning
        Success: package MachineLearning installed
Package: idol
        Installing idol
        Success: package idol installed
Package: logsearch
        Installing logsearch
        Success: package logsearch installed

Now let us check the DB version…

[dbadmin@COENGS-VRTD01 ~]$ vsql
Welcome to vsql, the Vertica Analytic Database interactive terminal.
Type: \h or \? for help with vsql commands
 \g or terminate with semicolon to execute query
 \q to quit
dbadmin=> select version();
 version
------------------------------------
 Vertica Analytic Database v9.0.0-0
(1 row)
dbadmin=>

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s