How to install Vertica for test purposes
![](https://www.pythian.com/hs-fs/hubfs/Imported_Blog_Media/vertica.png?width=255&height=197&name=vertica.png)
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 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
...
>> 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).
[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
![](https://www.pythian.com/hs-fs/hubfs/Imported_Blog_Media/admintool.png?width=305&height=165&name=admintool.png)
Share this
You May Also Like
These Related Stories
How to install 18c Grid Infrastructure in Silent Mode on Linux 7
How to install 18c Grid Infrastructure in Silent Mode on Linux 7
Jul 8, 2019
4
min read
Multi Tb migration using mydumper
Multi Tb migration using mydumper
May 12, 2017
4
min read
Issues With Database Service Names Starting With Pluggable Database (PDB) Name
Issues With Database Service Names Starting With Pluggable Database (PDB) Name
Nov 5, 2020
9
min read
No Comments Yet
Let us know what you think