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

Neelesh Gurjar has written 122 articles

Leave a Reply