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.
OS：CentOS 6.10 SW：Vertica10.0.0
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.
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.
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 ...)
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.
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
# yum install gcc unzip wget dialog perl
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"
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
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
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.
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.
Vertica official documentation https://www.vertica.com/docs/10.0.x/HTML/Content/Home.htm
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.