Introduction of Vertica
* Vertica was founded in 2005 by database researcher Michael Stonebraker, and Andrew Palmer.
* Vertica was acquired by Hewlett Packard on March 22, 2011
* It's supports only linux systems and support jdbc and odbc connections
* It's Column-oriented database
* Vertica was acquired by Hewlett Packard on March 22, 2011
* It's supports only linux systems and support jdbc and odbc connections
* It's Column-oriented database
Store data to optimize for access.it can dramatically reduce disk I/O process.
* It's store database for Compression format
Store more data in less physical storage, HP Vertica stores more data, provides more views, and uses less hardware than other databases. Compression rates of 50-90% are possible.
* It's Cluster Based Database
Scale your database easily, whether you need three nodes or 300 but hp provides free on 3 nodes only .
Installation of Vertica
Pre-Installation Steps
1. su root
2. yum install mcelog
3. yum install ntp
4. yum install sysstat
5. yum install pstack
6. service iptables save
7. service iptables stop
8. chkconfig iptables off
9. /sbin/service ntpd restart
10. /sbin/chkconfig ntpd on
11. cat /etc/selinux/config
set SELINUX=disabled
12. df -h (Check your disk name - /dev/sda1 or /dev/sda2 or /dev/sda3)
13. vi /etc/rc.local
/sbin/blockdev --setra 2048 /dev/sda1
/sbin/blockdev --setra 2048 /dev/sda3
if test -f /sys/kernel/mm/redhat_transparent_hugepage/enabled; then
echo never > /sys/kernel/mm/redhat_transparent_hugepage/enabled
fi
echo deadline > /sys/block/sda/queue/scheduler
echo never > /sys/kernel/mm/transparent_hugepage/enabled
echo performance > /sys/devices/system/cpu/cpu0/cpufreq/scaling_governor
14. init 6
Installation Steps
1. su
2. rpm -Uvh vertica-7.0.1-0.x86_64.RHEL5.rpm ->replace your package
3. /opt/vertica/sbin/install_vertica -s 10.10.40.65 -r vertica-7.0.1-0.x86_64.RHEL5.rpm -u dbadmin
10.10.40.65 - My ip address
vertica-7.1.1-0.x86_64.RHEL5.rpm - my vertica packages
4. vi /home/dbadmin/.bashrc
export TZ='Asia/Kolkata'
Post-Installation Steps
1. $su dbadmin
2. $cd
3. $adminTools
Once its completed automatically open vertica admin menu.
Same procedure for add another host
example
above commands working on 10.10.40.65 now i want to add another node 10.10.10.40.66
10.10.40.66 :
1.Complete All the Pre-Installation Steps
2. Set Passwordless login both systems
Goto 10.10.40.65
1. su
2. /opt/vertica/sbin/install_vertica -s 10.10.40.66 -r vertica-7.0.1-0.x86_64.RHEL5.rpm -u dbadmin
3. vi /home/dbadmin/.bashrc
export TZ='Asia/Kolkata'
10.10.40.66
Post-Installation Steps
1. $su dbadmin
2. $cd
3. $adminTools
Successfully added Two nodes. with K-safety value =0
No comments:
Post a Comment