How to install Vertica for test purposes

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

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 https://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 
 ...

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

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