Install and Configure the Vertica Database

Vertica is the database where ITBA stores DWH configuration and data. The instructions in this section explain how to setup the Vertica database on a single node or on multiple nodes.

Prerequisites

Review the General Operating System Configuration - Manual Configuration section in the HPE Vertica Installation Guide and complete the tasks to ensure that all of the nodes in your Vertica server meet all the prerequisites described in the HP Vertica Installation Guide before you proceed. For details, see HP_Vertica_7.1.x_Install_Guide.pdf at https://my.vertica.com/docs/7.1.x/PDF/HP_Vertica_7.1.x_Install_Guide.pdf

Setup the Vertica Database in a Single Node

1. Log on to the node as the root user.
2. Get the Vertica installer and license file from the ITBA binary delivery.

3. Install the Vertica package with the root user using the following command:

   rpm -ivh vertica-7.1.2-4.x86_64.RHEL5.rpm

4. Run the Vertica installation script with the root user using the following command:

   /opt/vertica/sbin/install_vertica -s localhost -r vertica-7.1.2-4.x86_64.RHEL5.rpm -u <dba_account_name> -p <dba_account_password> -L <license file name> -Y

   where:

   • <dba_account_name> is the db administrator system account at the operating system level.
   • <dba_account_password> is the password of db administrator system account.
   • <license file name> is the file name of the Vertica license file.
   • If you copy and paste the above command, carefully review the results in a text editor before pasting and running the command in a command window. Make sure that you do not have embedded line breaks when running the command.

   • The above command often fails due to warnings about the environment. If this happens, make sure to correct the issue with corresponding links. Only use the following command if you have determined that you must override these warnings. For additional help on this command format, see the Vertica documentation.

     /opt/vertica/sbin/install_vertica -s localhost -r vertica-7.1.2-4.x86_64.RHEL5.rpm -u <dba_account_name> -p <dba_account_password> -L <license file name> --failure-threshold FAIL -Y

5. Switch to the DBA user you created in the previous step.

6. Create a database for ITBA using the following command:

   /opt/vertica/bin/admintools -t create_db -s localhost -d <database_name> -p <dba_user_password>

   where:

   • <database name> is the name of the Vertica database.
   • <dba_user_password> is the password of the DBA Administrator.

   Note By default, Vertica creates a DBA user with the same name as the DB administrator system account. So now you can log on to the Vertica database with the DBA account name you set in step 4 and the password you set in step 6.

Setup the Vertica Database in Multiple Nodes

1. Get the Vertica installer and license file from the ITBA binary delivery.
2. On one of the nodes:
   1. Log on as the root user.

   2. Install the Vertica package with the root user using the following command:

      rpm -ivh vertica-7.1.2-4.x86_64.RHEL5.rpm

   3. Run the Vertica installation script with root user using the following commands, replacing the hosts with all of your intended cluster node host names:

      /opt/vertica/sbin/install_vertica --host Vertica1,Vertica2,Vertica3 -r vertica-7.1.2-4.x86_64.RHEL5.rpm -u <dba_account_name> -p <dba_account_password> -L <license file name> -Y

      where:

      • <dba_account_name> is the db administrator system account at the operating system level.
      • <dba_account_password> is the password of db administrator system account.
      • <license file name> is the file name of vertica license file.
      • The command installs Vertica on all the nodes at the same time.
      • If you copy and paste the above command, carefully review the results in a text editor before pasting and running the command in a command window. Make sure that you do not have embedded line breaks when running the command.
      • As this script runs, enter the root passwords for the nodes. The script also checks that you have implemented the prerequisites from the Vertica documentation.
      • The above command often fails due to warnings about the environment. If this happens, make sure ou have implemented all of the prerequisites. Only use the following command if you have determined that you must override these warnings. For additional help on this command format, see the Vertica documentation.

      /opt/vertica/sbin/install_vertica --host Vertica1,Vertica2,Vertican3 -r vertica-7.1.2-4.x86_64.RHEL5.rpm -u <dba_account_name> -p <dba_account_password> -L <license file name> --failure-threshold FAIL -Y

   4. Switch to the DBA user you created in the previous step.

   5. Create a database for ITBA using the following command, replacing the hosts with all of your intended cluster node host names:

      /opt/vertica/bin/admintools -t create_db --hosts Vertica1,vertica2,vertica3 -d <database_name> -p <dba_user_password>

      where:

      • <database name> is the name of the Vertica database.
      • <dba_user_password> is the password of the DBA Administrator.

      Note By default, Vertica creates a DBA user with the same name as the DB administrator system account. So now you can log on to the Vertica database with the DBA account name you set in step c and the password you set in step e.

3. After the Installation - Connection Load Balancing

   If you setup Vertica in multiple nodes, you can enable the database connection load balancing. ITBA supports two load balancing capabilities on your HP Vertica cluster:

   1. Native connection load balancing.

      To enable the native connection load balancing, run the following command as the Vertica database administrator user replacing the dba_user_name.

      /opt/vertica/bin/vsql -U <dba_user_name> -c "SELECT SET_LOAD_BALANCE_POLICY ('ROUNDROBIN');"
      

   2. Internet Protocol Virtual Server (IPVS).

      For details, see Connection Load Balancing Using IPVS in the Vertica Administrator Guide.