How to install a HP Vertica Database Cluster

In this tutorial we will demonstrate how to create,install and configure a 3 nodes Vertica Cluster.

Install the SO (Linux-CentOS)

1-Increase the swap space to a minimum of 2 Gb

2-Space and CPU requirements:

-Vertica requires at least 1 GB per CPU.
-disk utilization per node should no more than sixty percent (60%):
Disk space is temporarily required by certain query execution operators, such as hash joins and sorts, in the case when they have to spill to disk.
-configure TEMP SPACE separate from data disk space.

3-Install the prerequisite for Vertica Cluster

4-Edit the /etc/pam.d/su file

5-Verify that the NTP Daemon is Running

6-Remove Nonessential Applications

For optimal performance, Vertica is designed to use all available resources on each host machine. Vertica recommends that you:
Remove or disable all non-essential applications from cluster hosts

7-Configuring the Network

7.1-Setting Up Cluster Hosts

Make sure that the /etc/hosts file includes all of the hosts that become part of the cluster. For example, if the hosts are named host01, host02, host03, and host04, the /etc/hosts file on each host looks like this:

This should be done in all hosts(nodes)

7.2- Edit the /etc/sysconfig/network file :

7.3 Setting the HOSTNAME Environment Variable

7.4-Verify that the hostname resolution works correctly

Verify this with the command

Restart the hosts(nodes)
Make sure you do all this steps in all Hosts(nodes)as root user.

7.5 – Disable the firewall

Firewalls – not recommended for database hosts
SELinux (Security-Enhanced Linux)

7.6 Provide Root and for dbadmin user to SSH Access to the Cluster

Steps to do it for root or dbadmin user:

Do on all hosts the steps show upperd – and then follow the next steps

And copy the the content of the into authorized_keys and save it .
Do this for all hosts so that they all have the keys form all hosts in their authorized_keys file.
Host1 – will hold host1,host2,host3 -public keys inside
Host2 – will hold host1,host2,host3 -public keys inside
Host3 – will hold host1,host2,host3 -public keys inside
-and so on if you have more hosts in your cluster.

Similar Article  How to Monitor Mergeout in Vertica ?

8 -Download and install Vertica software on Master Node(where you will run the Administrative jobs of the cluster)

As root :

Normaly by default vertica will be installed into /opt/vertica dir.

8.1- Run the Install Script

On the master node run the following command

  • Where options are :

-s host_list comma-separated list of hostnames or IP addresses to include in the cluster; do not include space characters in the list.

  • Example :


-this will be the name of the user how will run the admintools(only)
– If you omit the -u parameter, the default database administrator account name is dbadmin.

Example of full command for 3 nodes cluster :

9- Create the database using the admintools tool

From the comand line open the admintools and choose the “Create Database option”

Choose the name of the database.

Choose the hosts where the database will reside.

Choose the place where the data and catalog will be stored. (Remember that this path must be the same in all hosts/nodes that
the database will be part of)

Confirm the database creation.

Similar Article  Gerenciar Usuários do Console de Gerenciamento Vertica

After the database creation view the Cluster State choosing the option form the admintools menu.

See that cluster is up and running on all nodes.

Using the option from the admintools connect to the database.

Welcome to Vertica 6.


I hope this was helpful and i appreciate if you would like, subscribe or share our posts. I it is just a click


No Comments
Leave a Comment

%d bloggers like this: