Install Vertica 10.0 on CentOS 6.10

Introduction

Since I operate Vertica at work, I will summarize the operations and settings that I actually performed by saying that I will prepare a Vertica environment for home study.

About the environment

OS:CentOS 6.10 SW:Vertica10.0.0

Advance preparation

Installing Oracle VirtualBox → I will omit this time.

Download CentOS iso file Please download the CentOS 6.10 iso from the URL below. https://www.centos.org/download/

Download Vertica Trial Click "Download Now" of "Access Our Free Community Edition Trial" from the following URL. https://www.vertica.com/try/

You can download the rpm file by registering the user information.

Pre-work

Create a virtual environment with VirtualBox and install CentOS 6.10.

The basics are to proceed by default, but the storage size must be 10GB or more or it may overflow.

In addition, the following settings are made separately.

  1. Network settings From the VirtualBox settings, change "Network"-> "Adapter 1"-> "Assignment" to a bridge adapter. This work is set so that the IP of the private LAN is given so that you can log in and work with the ssh connection. (Details have not been investigated ...)

  2. Add disk Create two disks to separate the "data area" and "catalog area" of Vertica.

Select "Storage"-> "Controller: SATA"-> "Add Hard Disk" from the VirtualBox settings to create two 10GB storages.

スクリーンショット 2020-09-22 19.01.09.png

This work

Add disk

Make sure you have the storage you have created.

# ll /dev/sd*
brw-rw---- 1 root disk 8,16 September 22 15:59 2020 /dev/sdb
brw-rw---- 1 root disk 8,32 September 22 15:59 2020 /dev/sdc



# fdisk /dev/sdb <==First disc creation
# fdisk /dev/sdc <==Second disc creation
...
command(Help with m): n  <==Type n and Enter
Command action
e-extension
p fundamental domain(1-4)
p   <==Type p and Enter
Area number(1-4): 1  <==Select 1 the first time, select 2 the second time
First cylinder(1-652, default 1): 1 <==Enter the minimum value on the left for the time being
End point cylinder or+Size or+Size M or+Size K(1-652, default 652): 652 <==Enter the maximum value on the right
command(Help with m): w <==Enter w to write.


# ll /dev/sd*
brw-rw---- 1 root disk 8,16 September 22 15:59 2020 /dev/sdb
brw-rw---- 1 root disk 8,17 September 22 15:59 2020 /dev/sdb1
brw-rw---- 1 root disk 8,32 September 22 15:59 2020 /dev/sdc
brw-rw---- 1 root disk 8,34 September 22 15:59 2020 /dev/sdc2

Create a file system with ext4
# mkfs -t ext4 /dev/sdb1
# mkfs -t ext4 /dev/sdc2

Create a mount point for Vertica
# mkdir /data
# mkdir /catalog

Mount
# mount -t ext4 /dev/sdb1 /data
# mount -t ext4 /dev/sdc2 /catalog

Confirm that it was mounted
# df -h
ilesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup-lv_root
                      8.3G  6.7G  1.2G  85% /
tmpfs                 1.9G     0  1.9G   0% /dev/shm
/dev/sda1             477M   28M  424M   7% /boot
/dev/sdb1             9.8G   23M  9.2G   1% /data <==Vertica data area
/dev/sdc2             9.8G  1.8G  7.5G  19% /catalog <==Vertica catalog area

Disk ID(UUID)confirm
# blkid /dev/sdb1
# blkid /dev/sdc2
/dev/sdb1: UUID="ffb142f2-62c3-4646-950b-8f1f9e543c8c" TYPE="ext4"


Set to be mounted automatically when the OS starts
# cp -p /etc/fstab /etc/fstab.org <==Get backup
# vi /etc/fstab
UUID=<Enter the confirmed UUID> /data ext4 defaults 1 1

Package installation

# yum install gcc unzip wget dialog perl

Respond to errors when installing Vertica

** Supports HINT "S0305" ** == Error details ======== HINT(eS0305): TZ is unset for dbadmin. Consider updating .profile or .bashrc https://www.vertica.com/docs/10.0.x/HTML/index.htm#cshid=S0305
Update tzdata
# yum update tzdata

Check the time zone
# cat /etc/sysconfig/clock

Get backup
# cp -p /etc/profile /etc/profile.org

Add timezone to profile
# vi /etc/profile
Add the following
	export TZ="Asia/Tokyo"

Apply environment variables
# source /etc/profile

Confirm that it has been applied
# env | grep TZ
export TZ="Asia/Tokyo"
** Supports HINT "S0041, S0040, S0045" **
== Error details ========

HINT(eS0041): Could not find the following tools normally provided by the mcelog package: mcelog https://www.vertica.com/docs/10.0.x/HTML/index.htm#cshid=S0041

HINT(eS0040): Could not find the following tools normally provided by the pstack or gstack package: pstack/gstack https://www.vertica.com/docs/10.0.x/HTML/index.htm#cshid=S0040

HINT(eS0045): Could not find the following tools normally provided by the sysstat package: iostat, mpstat https://www.vertica.com/docs/10.0.x/HTML/index.htm#cshid=S0045

Install the following packages
# yum install pstack mcelog sysstat
** Supports WARN "N0010" ** == Error details ======== WARN(eN0010): Linux iptables (firewall) has some non-trivial rules in tables: filter https://www.vertica.com/docs/10.0.x/HTML/index.htm#cshid=N0010
Stop the iptables service.(Not recommended in production environment)
# service iptables save
# service iptables stop
# chkconfig iptables off

# service ip6tables save
# service ip6tables stop
# chkconfig ip6tables off
** Supports WARN "S0112" ** == Error details ======== WARN(eS0112): vm.swappiness is higher than recommended: your 60 > 1 https://www.vertica.com/docs/10.0.x/HTML/index.htm#cshid=S0112
# sysctl -a | grep vm.swappiness
# cp -p /etc/sysctl.conf /etc/sysctl.conf.org
# vi /etc/sysctl.conf
Add the following
	vm.swappiness = 1
# reboot
# sysctl -a | grep vm.swappiness
# cat /proc/sys/vm/swappiness
** Supports FAIL "S0020" ** == Error details ======== FAIL(eS0020): Readahead size of (/dev/mapper/VolGroup-lv_root) is too low for typical systems: 256 < 2048 https://www.vertica.com/docs/10.0.x/HTML/index.htm#cshid=S0020
# /sbin/blockdev --setra 2048 /dev/mapper/VolGroup-lv_root
# echo '/sbin/blockdev --setra 2048 /dev/mapper/VolGroup-lv_root' >> /etc/rc.local
** Supports FAIL "S0180" ** == Error details ======== FAIL(eS0180): Insufficient swap size. Need 2.00 GB, have 0.80 GB https://www.vertica.com/docs/10.0.x/HTML/index.htm#cshid=S0180
# dd if=/dev/zero of=/swapfile bs=1M count=2048
# mkswap /swapfile
# chmod 600 /swapfile
# swapon /swapfile
# swapon -s

# vi /etc/fstab
Add the following
	/swapfile		swap			swap	defaults	0 0
# reboot
** Supports FAIL "S0030" ** == Error details ======== FAIL(eS0030): ntp daemon process is not running: ['ntpd', 'ntp', 'chronyd'] https://www.vertica.com/docs/10.0.x/HTML/index.htm#cshid=S0030
# yum install ntp
# service ntpd start
# chkconfig ntpd on
** Supports FAIL "S0081" ** == Error details ======== FAIL(eS0081): SELinux appears to be enabled and not in permissive mode. https://www.vertica.com/docs/10.0.x/HTML/index.htm#cshid=S0081
# getenforce  <==No action required if disabled is output
# vi /etc/selinux/config
Change the following line to disabled to disable it.
 SELINUX=disabled

# reboot
# getenforce <==disabled is output
** Supports FAIL "S0310" ** == Error details ======== FAIL(eS0310): Transparent hugepages is set to 'always'. Must be 'never' or 'madvise'. https://www.vertica.com/docs/10.0.x/HTML/index.htm#cshid=S0310
Execute the following and change it to never.
# echo never > /sys/kernel/mm/redhat_transparent_hugepage/enabled

Install Vertica

Place the rpm file on the server with WinSCP etc. If you are connected by ssh, you can place it directly under / home / root with the following command.

scp root @ IP address: ~ /

Run the installation from RPM

# rpm -Uvh vertica-10.0.0-0.x86_64.RHEL6.rpm

Further installation execution from the installed materials Set the password for the dbadmin user as you will be asked for the password during execution

# /opt/vertica/sbin/install_vertica --hosts 127.0.0.1 --rpm ~/vertica-10.0.0-0.x86_64.RHEL6.rpm

Change the permissions of the created vertica directory.

# chown -R dbadmin.verticadba /data
# chown -R dbadmin.verticadba /catalog

Creating a Vertica database

Switch to dbadmin user
# su - dbadmin

Create a database on the command line using admintools.
$ admintools -t create_db --data_path=/data --catalog_path=/catalog --database=vdb --password=<Password for any database> --hosts=localhost

If the creation is completed successfully, you will be able to connect to the DB with the following command.

$ vsql

Reference site

Vertica official documentation https://www.vertica.com/docs/10.0.x/HTML/Content/Home.htm

in conclusion

Basically, I read the official Vertica document and proceeded, so I did not get into it.

Now that you're ready to enjoy Vertica as much as you want, I'd like to examine it in various ways.

Thank you for visiting our website.

Recommended Posts

Install Vertica 10.0 on CentOS 6.10
Install Golang on CentOS 8
Install Neo4j 4.1.3 on centOS
Install PostgreSQL 12 on Centos8
Install nginx on centOS7
Install Python 3 on CentOS 7
Install kuromoji on CentOS7
Install Mattermost on CentOS 7
Install PostGIS 2.5.5 on CentOS7
Install jpndistrict on CentOS 7
Install Redmine 4.1.1 on CentOS 7
Smokeping Install on CentOS7
Install PostgreSQL 13 on CentOS 7.5
Install OpenFOAM v2006 on CentOS
Install Jenkins on Docker's CentOS
Install Apache on CentOS on VirtualBox
Install Ruby 2.7 on CentOS 7 (SCL)
Try DPDK20 SDK on CentOS7 ①Install
Install Ruby 2.5 on CentOS 7 using SCL
Install Java Open JDK 8 on CentOS 7
How to install MariaDB 10.4 on CentOS 8
Install apache 2.4.46 from source on CentOS7
Steps to install MySQL 8 on CentOS 8
Steps to install devtoolset-6 on CentOS 7
Install Java 9 on windows 10 and CentOS 7
Install MariaDB (CentOS 8)
[CentOS] Install apache-loggen
OpenVPN on CentOS 8
Install samba4 from source code on CentOS8
Install the webmail client Rainloop on CentOS 8
How to install beta php8.0 on CentOS8
Install CentOS 7 on Raspberry pi 4 Model B
Install NextCloud on CentOS 7 with Alibaba Cloud ECS
Install gradle on mac
Command to install nginx / PHP7 / php-fpm on CentOS7
Install Corretto 8 on Windows
Maven on CentOS 7 tutorial
Install OpenJDK on macOS
Install Java on Mac
Docker installation on CentOS 6
Use perltidy on CentOS 8
Try OpenLiteSpeed on CentOS8
Tomcat v8 on CentOS7
[CentOS7] Install aws cli
Install Docker on Manjaro
Zabbix 5 installation on CentOS 8
Install Ruby on Ubuntu 20.04
Use mod_auth_cas on CentOS 8
Install lombok on SpringToolSuite4
Install GitLab on CentOS 8 with no internet connection
Use bat on Centos.
Jetty v8 on CentOS7
Install Autoware on Ubuntu 18.04.5
OpenJDK installation on CentOS 7
Install openjdk11 on mac
Install Homebrew on Ubuntu 20.04
Install CMS Made Simple v2.2.2 on LAMP on CentOS 7.3
Install OpenJDK 8 on mac
Install BookStack Documentation Wiki on Elastic Compute Service on CentOS 7
Install the latest hardware drivers from ELRepo on CentOS
Install MySQL 5.6 on CentOS6 [How to specify the version]