Vertica Ubuntu 14.04 Notes

post-install.sh

su dbadmin
admintools -t create_db -d <dbname> --hosts localhost
admintools -t start_db  -d <dbname>
vsql -h 127.0.0.1 -d <dbname> -U dbadmin

vertica-ubuntu-1404.sh

apt-get install dialog


# Disable transparent_hugepage, and run on every boot
cat <<EOF > /etc/rc.local
#!/bin/sh -e

if test -f /sys/kernel/mm/transparent_hugepage/enabled; then
    echo never > /sys/kernel/mm/transparent_hugepage/enabled
fi

sysctl vm.swappiness=1

exit 0
EOF

# Not sure about this one...
mkdir -p /db/vertica
/opt/vertica/sbin/install_vertica –-hosts 127.0.0.1 –-data-dir /db/vertica/
/opt/vertica/sbin/install_vertica --hosts 127.0.0.1 --failure-threshold FAIL

# create swap file
fallocate -l 4G /swapfile
chmod 600 /swapfile
mkswap /swapfile
swapon /swapfile
echo "/swapfile   none    swap    sw    0   0" >> /etc/fstab

# Read-ahead size must be increased
blockdev --setra 2048 /dev/sda

# Some optimizations
# https://thisdataguy.com/2013/09/11/vertica-optimisation-part-1-system/
# This might help tune the scheduler to give better performance
echo 'deadline' > /sys/block/sda/queue/scheduler
# Add 'noatime' to data partition