Steps to Install and Configure VerticaDB on Cloud

Steps to Install and Configure VerticaDB on CentOS 6.x on Cloud:

• Vertica require Swap space. So if you dont have Swap on your cloud, you can still create by using below steps:

  fallocate -l 2G /swapfile
  chmod 600 /swapfile
  mkswap /swapfile -f
  swapon /swapfile
  

• It also require transparent_hugepage to be disabled and tuning of few more system parameters. It is better to add them in /etc/rc.local for persistent changes. Add below lines to /etc/rc.local:

  swapon /swapfile
  echo no > /sys/kernel/mm/transparent_hugepage/khugepaged/defrag
  echo never > /sys/kernel/mm/transparent_hugepage/enabled
  echo never > /sys/kernel/mm/transparent_hugepage/defrag
  echo noop > /sys/block/vda/queue/scheduler
  /sbin/blockdev --setra 2048 /dev/vda
  /sbin/blockdev --setra 2048 /dev/VolGroup/lv_root
  

  Please note that you need to change vda to appropriate block devices. Also make sure to apply /sbin/blockdev command to LVM volume if you are using.

• Disable iptables

  iptables -F
  iptables -t nat -F
  iptables -t mangle -F
  /etc/init.d/iptables save
  

• Disable SElinux
  $ setenforce 0
  $ sed -i ‘s/SELINUX=enforcing/SELINUX=disabled/g’ /etc/selinux/config
• Set timezone to UTC:

  $ TZ='Etc/UTC';export TZ
  

  Add above line to /root/.bashrc

  rm -f /etc/localtime
  ln -s /usr/share/zoneinfo/Etc/UTC /etc/localtime
  

• Get & Install Vertica RPM
  Get Vertica rpm from Vertica webiste. Store it under /root and run below command to install basic scripts on server

  rpm -ivh /root/vertica-7.1.1-0.x86_64.RHEL5.rpm
  

• After installing rpm, install vertica on server using below command:

  /opt/vertica/sbin/install_vertica --hosts <hostname/IPaddress> --rpm /root/vertica-7.1.1-0.x86_64.RHEL5.rpm --dba-user dbadmin --license CE --accept-eula --failure-threshold=FAIL