Follow this tutorial to install HP’s Vertica version 7.1.x on your Ubuntu 14.04 LTS server / desktop.

Visit HP’s my.vertica.com site and download the .deb package for the server

  1. Visit this URL : https://my.vertica.com/download-community-edition/#server
  2. Click on the link for “Debian Linux 6 and Ubuntu 14.04 LTS”.
  3. Agree with the Terms and Conditions and download the .deb file to your Ubuntu machine

Install the package with dpkg

On the command line of the new server type the following..

root@ubuntu:~# dpkg -i vertica_7.1.1-0_amd64.deb

Configure the OS

Install Some Required Packages

root@ubuntu:~# apt-get install mcelog pstack sysstat ntp

Edit the /home/dbadmin/.bashrc

I live in Brisbane Australia so I will make this my default time zone for the dbadmin user created during install. Just add the following line to the end of /home/dbadmin/.bashrc to set the time zone..

TZ='Australia/Brisbane'; export TZ;

Run the blockdev command

We need to increase the hard-disk read buffer size higher than the default for Ubuntu. On the virtual machine I am installing this on there is only one ext4 partition (/dev/sda1) we need to modify the read buffer for. Run the following command substituting the correct hard disk for the appropriate one in your setup.

root@ubuntu:~# /sbin/blockdev --setra 2048 /dev/sda1

Edit the /etc/rc.local and add blockdev option for reboot

Add the following to the line above the line that reads exit 0 like so…

#!/bin/sh -e
 #
 # rc.local
 #
 # This script is executed at the end of each multiuser runlevel.
 # Make sure that the script will "exit 0" on success or any other
 # value on error.
 #
 # In order to enable or disable this script just change the execution
 # bits.
 #
 # By default this script does nothing.
 /sbin/blockdev –setra 2048 /dev/sda
 exit 0

Install sysv-rc-conf to check NTP client runlevel

The NTP client is needed for Vertica and we should confirm that this client starts at runlevels > 1 by installing the sysv-rc-conf package

root@ubuntu:~# apt-get install sysv-rc-conf

Run the following command to start the sysv-rc-conf interface.

root@ubuntu:~# sysv-rc-conf

You should see a grid interface showing you which runlevels the various daemons and client software installed on the machine are set to start on.  We just need to make sure NTP client starts at runlevel 2.

Complete the Vertica Installation

root@ubuntu:/opt/vertica/sbin# ./install_vertica --host localhost

Create the first testdb

dbadmin@ubuntu:/opt/vertica/bin$ ./adminTools -t create_db -d testdb --hosts localhost

You should get something similar to the following output..

Info: no password specified, using none
 Database with 1 or 2 nodes cannot be k-safe and it may lose data if it crashes
 Distributing changes to cluster.
 127.0.0.1 OK [vertica][(7, 1, 1)][000][all]
 Creating database testdb
 Starting bootstrap node v_testdb_node0001 (127.0.0.1)
 Starting nodes: 
 v_testdb_node0001 (127.0.0.1)
 Starting Vertica on all nodes. Please wait, databases with large catalogs may take a while to initialize.
 Node Status: v_testdb_node0001: (INITIALIZING) 
 Node Status: v_testdb_node0001: (INITIALIZING) 
 Node Status: v_testdb_node0001: (INITIALIZING) 
 Node Status: v_testdb_node0001: (UP) 
 Database testdb created successfully.

Visit HP’s my.vertica.com site and download the .deb package for the Management Console

  1. Visit this URL : https://my.vertica.com/download-community-edition/#mc
  2. Click on the link for “Debian Linux 6 and Ubuntu 14.04 LTS”.
  3. Agree with the Terms and Conditions and download the .deb file to your Ubuntu machine (tutorial assumes you are putting this in the “root” directory).

Install the package with dpkg

On the command line of the new server type the following..

root@ubuntu:~# dpkg -i vertica-console_7.1.1-0_amd64.deb

The following should be the output of the above command…

Selecting previously unselected package vertica-console.
(Reading database ... 64059 files and directories currently installed.)
Preparing to unpack vertica-console_7.1.1-0_amd64.deb ...
Starting installation....
Unpacking vertica-console (7.1.1-0) ...
Setting up vertica-console (7.1.1-0) ...
[postinstall] Removing jre 1.6 ...
 Adding system startup for /etc/init.d/vertica-consoled ...
 /etc/rc0.d/K20vertica-consoled -> ../init.d/vertica-consoled
 /etc/rc1.d/K20vertica-consoled -> ../init.d/vertica-consoled
 /etc/rc6.d/K20vertica-consoled -> ../init.d/vertica-consoled
 /etc/rc2.d/S50vertica-consoled -> ../init.d/vertica-consoled
 /etc/rc3.d/S50vertica-consoled -> ../init.d/vertica-consoled
 /etc/rc4.d/S50vertica-consoled -> ../init.d/vertica-consoled
 /etc/rc5.d/S50vertica-consoled -> ../init.d/vertica-consoled
Cleaning up temp folder...
Starting the vertica management console....
root@ubuntu:~# Attempting to load properties from /opt/vconsole/config/console.properties

This will be followed by a bunch of output from the Java spring application that has launched.

Visit the website and configure the console.

https://<server-ip>:5450/webui

Follow the steps in the wizard shown to complete the installation. Once installed you will need to add the localhost cluster in order to see any analytical information for the cluster.

During this process it will ask you at some point to discover the GUID of the dbadmin user created during installation. Typing this on the command line will give you this GUID..

root@ubuntu:~# id -g dbadmin

This tutorial used this blog post as a starting point. Some minor changes were made to keep up with some of the latest packages and directory structure for Ubuntu 14.04 LTS