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

• Implemented in a local virtual environment using Oracle VirtualBox.
• Vertica is created in Enterprise Mode.

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.

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

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"

Install the following packages
# yum install pstack mcelog sysstat

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

# 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

# /sbin/blockdev --setra 2048 /dev/mapper/VolGroup-lv_root
# echo '/sbin/blockdev --setra 2048 /dev/mapper/VolGroup-lv_root' >> /etc/rc.local

# 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

# yum install ntp
# service ntpd start
# chkconfig ntpd on

# 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

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.