Vertica
From Bashlinux
Setup
How to bypass Vertica's version checking on CentOS
yum -y install redhat-lsb-core lsb_release -d | grep -i "Red Hat" >> /dev/null || echo "Bashlinux release 5 (Vertica check bypass)" >> /etc/redhat-release
How to tune-up the system for Vertica
- Setup the required kernel settings for Vertica on /etc/sysctl.conf
vm.max_map_count=$V_MAX_MAP_COUNT kernel.sem=250 32000 100 2048 fs.file-max = 65536 vm.min_free_kbytes = 4096 vm.swappiness = 0 EOF
- where
- V_NPROC is feched from
free -g | grep Mem | awk '{printf "%.0f000", $2}'
- V_MAX_MAP_COUNT is fetched from
grep MemTotal /proc/meminfo | awk '{printf "%.0f", $2/16}')
- Setup limits for Vertica's dbadmin account on /etc/security/limits.conf
dbadmin soft nofile 65536 dbadmin hard nofile 65536 dbadmin soft nproc $V_NPROC dbadmin hard nproc $V_NPROC dbadmin soft fsize unlimited dbadmin hard fsize unlimited
- Setup I/O Scheduler appending the following parameters
GRUB_CMDLINE_LINUX
on /etc/default/grug
elevator=deadline intel_idle\.max_cstate=0 processor\.max_cstate=0 idle=mwait transparent_hugepage=never
- Re-build grub.cfg
# grub2-mkconfig -o /boot/grub2/grub.cfg
- Ensure the Vertica requirements for pam.d are present on /etc/pam.d/su
session required pam_limits.so
- Set block device ioctls
for DISK in `df | grep vertica | awk '{print $1}' | sed 's/.$//g'`; do echo "blockdev --setra 2048 $DISK" >> /etc/rc.d/rc.local done
- Enable NTP, vertica is very sensitive to time offsets in between nodes
chkconfig ntpd on service ntpd start