Difference between revisions of "Vertica"

From Bashlinux
Jump to: navigation, search
(Created page with "== 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 "Buffalo releas...")
 
 
Line 2: Line 2:
 
=== How to bypass Vertica's version checking on CentOS ===
 
=== How to bypass Vertica's version checking on CentOS ===
 
yum -y install redhat-lsb-core
 
yum -y install redhat-lsb-core
lsb_release -d | grep -i "Red Hat" >> /dev/null || echo "Buffalo release 5 (Vertica check bypass)" >> /etc/redhat-release
+
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 ===
 
=== How to tune-up the system for Vertica ===

Latest revision as of 05:03, 16 June 2015

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