How to install Vertica for test purposes

Posted in: Big Data, Technical Track

The column-oriented Vertica Analytics Database Platform was designed to manage large, fast-growing volumes of data and provide very fast query performance when used for data warehouses and other query-intensive applications.

The following instructions show how to create a Vertica database version 9.1.1-0 in Oracle Linux Server 7.6, just for test purposes. This will be handy if we perform tests before implementing a change in the production system.

But if you need to install Vertica in a real scenario, please follow all the requirements on Vertica Installation Guide

Installing Vertica database software in a single node for test purposes

1. As root user, install dialog package with “yum install dialog”.

[root@host1 ~]# yum install dialog
...
Complete!
[root@host1 ~]#

2. Download the Vertica (Community Edition) RPM from https://vertica.com/download/vertica/community-edition/

The Vertica Community Edition is free allowing the setup of up to 3 nodes and 1 Terabyte of data
Create an user login to connect on "Vertica Community Edition (CE)"
Choose the correct OS under "Local Server (Linux OS)"

3. As root user, install Vertica RPM file.

[root@host1 Download]# rpm -Uvh vertica-9.1.1-0.x86_64.RHEL6.rpm
...
1:vertica-9.1.1-0 ################################# [100%]
View the latest Vertica documentation at http://my.vertica.com/docs/
[root@host1 Download]#

4. As root, install Vertica software and try to fix the warnings, hints and errors (as much as possible).

[root@host1 Download]# /opt/vertica/sbin/install_vertica --hosts host1 
...

>> Validating node and cluster prerequisites…

Prerequisites not fully met during local (OS) configuration for
verify-192.168.25.16.xml:
HINT (S0305): https://my.vertica.com/docs/9.1.x/HTML/index.htm#cshid=S0305
TZ is unset for dbadmin. Consider updating .profile or .bashrc
HINT (S0041): https://my.vertica.com/docs/9.1.x/HTML/index.htm#cshid=S0041
Could not find the following tools normally provided by the mcelog
package: mcelog
WARN (S0160): https://my.vertica.com/docs/9.1.x/HTML/index.htm#cshid=S0160
These disks do not have ‘ext3’ or ‘ext4’ filesystems: ‘/dev/mapper/ol-
root’ = ‘xfs’
WARN (N0010): https://my.vertica.com/docs/9.1.x/HTML/index.htm#cshid=N0010
Linux iptables (firewall) has some non-trivial rules in tables: mangle,
filter
WARN (S0112): https://my.vertica.com/docs/9.1.x/HTML/index.htm#cshid=S0112
vm.swappiness is higher than recommended: your 30 > 1

System prerequisites failed. Threshold = WARN
Hint: Fix above failures or use –failure-threshold

Installation FAILED with errors.

5. During the installation, the hints and warnings below were fixed following the URL instructions provided by Vertica.

HINT (S0305): https://my.vertica.com/docs/9.1.x/HTML/index.htm#cshid=S0305
TZ is unset for dbadmin. Consider updating .profile or .bashrc
HINT (S0041): https://my.vertica.com/docs/9.1.x/HTML/index.htm#cshid=S0041
Could not find the following tools normally provided by the mcelog
package: mcelog
WARN (S0112): https://my.vertica.com/docs/9.1.x/HTML/index.htm#cshid=S0112
vm.swappiness is higher than recommended: your 30 > 1

6. In order to bypass the remaining issues like filesystem format and Linux iptables (firewall), the following syntax was used “–failure-threshold HALT”.

[root@host1 Download]# /opt/vertica/sbin/install_vertica --hosts host1 -r vertica-9.1.1-0.x86_64.RHEL6.rpm -u dbadmin -g verticadba -d /home/dbadmin --failure-threshold HALT
...

Prerequisites not fully met during local (OS) configuration for verify-192.168.25.16.xml:
WARN (S0160): https://my.vertica.com/docs/9.1.x/HTML/index.htm#cshid=S0160
These disks do not have ‘ext3’ or ‘ext4’ filesystems: ‘/dev/mapper/ol-
root’ = ‘xfs’
WARN (N0010): https://my.vertica.com/docs/9.1.x/HTML/index.htm#cshid=N0010
Linux iptables (firewall) has some non-trivial rules in tables: mangle,
filter

System prerequisites passed. Threshold = HALT

...
>> Completing installation...

7. During the Vertica software installation, the user dbadmin was created.

7.1 Login as dbadmin. 

7.2 Create the Vertica database with admintools command line, using –skip-fs-checks to skip file system check.

[dbadmin@host1 database]$ admintools -t create_db -c /home/dbadmin/database/ -D /home/dbadmin/database/ -s host1 -d vdb –skip-fs-checks

  • Parameters used on above syntax
    -t | –tool
    -c CATALOG, the catalog is a set of files that contains information (metadata) about the objects in a database, such as the nodes, tables, constraints
    -D DATA, –data_path=DATA
    -s NODES, –hosts=NODES
    -d DB, –database=Database Name
    –skip-fs-checks Skip file system checks while creating a database (not recommended).

Enter ACCEPT to accept license terms & conditions, or REJECT to not accept the license and quit: ACCEPT

Database vdb created successfully.
[dbadmin@host1 database]$

8. As a dbadmin user, connect to the new database using vsql and check its status.

[dbadmin@host1 database]$ vsql -U dbadmin
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 node_name, node_state FROM nodes ORDER BY 1;
   node_name    | node_state
----------------+------------
 v_vdb_node0001 | UP

dbadmin=> SELECT
dbadmin-> node_name ,
dbadmin-> user_name ,
dbadmin-> client_os
dbadmin-> FROM
dbadmin-> v_monitor.sessions;
node_name | user_name | client_os
—————-+———–+——————————————–
v_vdb_node0001 | dbadmin | Linux 4.1.12-124.21.1.el7uek.x86_64 x86_64
(1 row)

dbadmin=>

dbadmin=> select GET_COMPLIANCE_STATUS();
GET_COMPLIANCE_STATUS
———————————————————————————
Raw Data Size: 0.00TB +/- 0.00TB
License Size : 1.00TB
Utilization : 0%
Audit Time : 2019-10-24 14:43:15.030145-04
Node count : 1
License Node limit : 3
Compliance Status : The database is in compliance with respect to raw data size.

No expiration date for a Perpetual license

dbadmin=>

9. The database has been created for tests. Use the admintools interface to do different tasks related to database administration, such as stopping/starting the database.

$ /opt/vertica/bin/adminTools

Vertica_AdminTools

10. VMart Example Database

Vertica ships with a sample multi-schema database called the VMart Example Database, which represents a database that might be used by a large supermarket (VMart) to access information about its products, customers, employees, and online and physical stores. Using this example, you can create, run, optimize, and test a multi-schema database for learning purposes.

Further information in VMart Example Database

11. Other posts related Vertica:
https://blog.pythian.com/d-vertica/
https://blog.pythian.com/log-buffer-62-a-carnival-of-the-vanities-for-dbas/

 

email

Interested in working with Marcos? Schedule a tech call.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *