• sudhakar

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:

  1. Vertica 7.0 to 7.1

  2. Vertica 7.1 to 7.2

  3. Vertica 7.2 to 8.0

  4. Vertica 8.0 to 8.1

  5. 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.

  4. 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 ~]$

  1. Perform FULL DB Backup https://my.vertica.com/docs/9.0.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/BackingUpAndRestoringTheDatabase.htm

  2. Verify Platform Requirements https://my.vertica.com/docs/9.0.x/HTML/Content/Authoring/InstallationGuide/Upgrade/PreUpgrade/RequirementsTesting.htm

  3. As dbadmin STOP the database in clean mode

  4. Backup the DB

  5. As root install the RPM

  6. As dbadmin perform DB upgrade

  7. Reinstall any packages that were uninstalled

  8. 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=>

1 view0 comments