准备环境:
1.CentOS 7.0 镜像
2.vertica-9.1.1-1.x86_64.RHEL6.rpm
安装过程:
1. 安装 CentOS 7.0
注意: 挂载的文件系统必须是 ext4, 不能是默认的 xfs!
2. 关闭防火墙
- [root@localhost ~]# systemctl disable firewalld
- [root@localhost ~]# systemctl stop firewalld
3. 设置 selinux 为 disable
- [root@localhost ~]# vi /etc/selinux/config SELINUX=disabled
- [root@localhost ~]# setenforce 0
4. 安装依赖包
[root@localhost ~]# yum install gdb mcelog sysstat chrony ntp ntpdate -y
5. 安装必要工具: java,python,rsync,pts
- [root@localhost ~]# python --version
- [root@localhost ~]# yum install rsync -y
- [root@localhost ~]# rsync --version
- [root@localhost ~]# ls /dev |grep pts
- [root@localhost ~]# yum install java-1.8.0-openjdk.x86_64 -y
- [root@localhost ~]# java -version
6. 调整参数
- [root@localhost ~]# vi /etc/sysctl.conf vm.swappiness = 1
- [root@localhost ~]# echo 1> /proc/sys/vm/swappiness
- [root@localhost ~]# vi /etc/rc.d/rc.local
- echo deadline> /sys/block/sdb/queue/scheduler
- echo deadline> /dev/sdb
- /sbin/blockdev --setra 8192 /dev/sdb
7. 安装 vertica
- [root@localhost ~]# rpm -ivh vertica-9.1.1-1.x86_64.RHEL6.rpm
- [root@localhost ~]# /opt/vertica/sbin/install_vertica --host 192.168.*.* --rpm vertica-9.1.1-1.x86_64.RHEL6.rpm --failure-threshold FAIL --dba-user dbadmin
8. 初始化数据库
- [root@localhost ~]# su - dbadmin
- [dbadmin@localhost ~]$ ./opt/vertica/bin/adminTools
(1) 提示输入 License File Path 时, 因为用的是社区版 license, 不用填, 直接回车
- (2)Accept EULA
- (3)Configuration Menu
- (4)Create Database
(5) 输入 Database Name: vertica
(6) 输入密码和确认密码
(7) 选择主机 IP, 因为是单节点安装, 直接选择默认的那个 IP
(8) 确认数据实例安装目录, 看需求, 或者不用改, 直接用默认的,/home/dbadmin
(9) 会出现一个 k-safe 的提示, 这是只有一个节点导致的, 直接忽略, 继续下一步
(10) 安装成功
9. 测试连接
- [dbadmin@localhost bin]$
- vsql -h 127.0.0.1 -d vertica -u dbadmin
- vsql: warning: extra command-line argument "dbadmin" ignored
- vsql: Warning: The -u option is deprecated. Use -U.
- User name: dbadmin
- Password: ******
- Welcome to vsql, the Vertica Analytic Database interactive terminal.
- Type: \h or \? for help with vsql commands
- \g or terminate with semicolon to execute query
- \q to quit
- vertica =>
来源: http://www.bubuko.com/infodetail-2923545.html