From Bashlinux
Revision as of 05:03, 16 June 2015 by Manpaz (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


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
kernel.sem=250 32000 100 2048
fs.file-max = 65536
vm.min_free_kbytes = 4096
vm.swappiness = 0
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
  • 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
  • Enable NTP, vertica is very sensitive to time offsets in between nodes
chkconfig ntpd on
service ntpd start