Vertica: 7.0 Community Edition
Part 1: OS Configurations Before Install Vertica
1. Disk Readahead
/sbin/blockdev --setra 2048 /dev/sda1
echo '/sbin/blockdev --setra 2048 /dev/sda1' >> /etc/rc.local
Note: I also have sda2 so I also need to execute
/sbin/blockdev --setra 2048 /dev/sda2
echo '/sbin/blockdev --setra 2048 /dev/sda2' >> /etc/rc.local
2. TZ
vi /etc/profile
add the following line
export TZ="Asia/Shanghai"
For all the valid time zone names, please refer to
3. NTP
$ chkconfig --list ntpd
/sbin/service ntpd restart
/sbin/chkconfig ntpd on
4. Disable SELInux
1). Edit /etc/selinux/config and change setting for SELINUX to disabled
(SELINUX=disabled). This disables SELinux at boot time.
2). As root/sudo, type setenforce 0 to disable SELinux immediately.
5. Disable Transparent HugePages
You can check the current setting using the following command, which is displaying the default value of "enabled=[always]".
# cat /sys/kernel/mm/transparent_hugepage/enabled
[always] madvise never
The preferred method to disable Transparent HugePages is to add "transparent_hugepage=never" to the kernel boot line in the "/etc/grub.conf" file.
vi /etc/grub.conf
and add transparent_hugepage=never
For example:
title Oracle Linux Server (2.6.39-400.24.1.el6uek.x86_64)
root (hd0,0)
kernel /vmlinuz-2.6.39-400.24.1.el6uek.x86_64 ro root=/dev/mapper/vg_ol6112-lv_root rd_NO_LUKS KEYBOARDTYPE=pc KEYTABLE=uk
LANG=en_US.UTF-8 rd_NO_MD SYSFONT=latarcyrheb-sun16 rd_NO_DM rd_LVM_LV=vg_ol6112/lv_swap rd_LVM_LV=vg_ol6112/lv_root rhgb quiet numa=off
transparent_hugepage=never
initrd /initramfs-2.6.39-400.24.1.el6uek.x86_64.img
6. Change I/O Scheduler
echo deadline > /sys/block/sda/queue/scheduler
echo 'echo deadline > /sys/block/sda/queue/scheduler' >> /etc/rc.local
7. Single Node Install Vertica
rpm -ivh vertica-7.0.0-0.x86_64.RHEL5.rpm
8. Run install_vertica to complete installation
cd /opt/vertica/sbin
./install_vertica --hosts 127.0.0.1 --dba-user vertica --dba-user-password vertica
This installs a vertica instance in localhost (127.0.0.1), and create a dba names vertica, and the password is vertica
9. Accept Vertica License
cd /opt/vertica/bin
./adminTools (The T is uppercase)
and accept the license and EULA etc. Here please note that you can use mouse click to check and accept the EULA.
10. Install VMart example database
cd /opt/vertica/sbin
./install_example VMart
I mainly followed the installation guide, which is difficult to understand. :)
http://my.vertica.com/docs/7.0.x/PDF/HP_Vertica_7.0.x_Install_Guide.pdf
I also referenced the post here:
http://my.vertica.com/docs/7.0.x/PDF/HP_Vertica_7.0.x_Install_Guide.pdf
I also referenced the post here:
Aha! All Set.
You can try to connect to database
You can also connect it from a windows environment, for example:
vsql -h 192.168.136.63 -U vertica
If you find this blog is useful, please kindly click the ads on this page to help. Thank you very much.
1 comment:
This guide is so helpful. Thanks.
Post a Comment