浙江省建设信息港网站个人模板建站

下载安装包

• 官网
• 11.0版本或者10.0(deb)安装包可私信提供百度网盘链接；

安装(Ubuntu18.04)

test@vertica:~$ sudo dpkg -i vertica_10.0.0-0_amd64.deb
#缺少依赖，安装依赖
test@vertica:~$ sudo /opt/vertica/sbin/install_vertica --hosts 192.168.1.xx

添加 dbadmin 用户密码后报错

Prerequisites not fully met during local (OS) configuration for
verify-192.168.1.xx.xml:HINT (S0151): https://www.vertica.com/docs/11.0.x/HTML/index.htm#cshid=S0151HINT(eS0151): These disks do not have known IO schedulers: '/dev/sda2'('sda') = 'none'HINT (S0305): https://www.vertica.com/docs/11.0.x/HTML/index.htm#cshid=S0305HINT(eS0305): TZ is unset for dbadmin. Consider updating .profile or.bashrcHINT (S0041): https://www.vertica.com/docs/11.0.x/HTML/index.htm#cshid=S0041HINT(eS0041): Could not find the following tools normally provided bythe rasdaemon package: rasdaemonHINT (S0040): https://www.vertica.com/docs/11.0.x/HTML/index.htm#cshid=S0040HINT(eS0040): Could not find the following tools normally provided bythe pstack or gstack package: pstack/gstackHINT (S0045): https://www.vertica.com/docs/11.0.x/HTML/index.htm#cshid=S0045HINT(eS0045): Could not find the following tools normally provided bythe sysstat package: iostat, mpstatWARN (S0112): https://www.vertica.com/docs/11.0.x/HTML/index.htm#cshid=S0112WARN(eS0112): vm.swappiness is higher than recommended: your 60 > 1FAIL (S0020): https://www.vertica.com/docs/11.0.x/HTML/index.htm#cshid=S0020FAIL(eS0020): Readahead size of sda (/dev/sda2) is too low for typicalsystems: 256 < 2048FAIL (S0030): https://www.vertica.com/docs/11.0.x/HTML/index.htm#cshid=S0030FAIL(eS0030): ntp daemon process is not running: ['ntpd', 'ntp','chronyd']System prerequisites failed.  Threshold = WARNHint: Fix above failures or use --failure-thresholdInstallation FAILED with errors.

打开错误中的链接地址即可解决

配置 I/O Scheduler

Vertica 使用的磁盘的 I/O 调度程序必须设置为 deadline 或 noop，默认为 deadline.

test@vertica:~$ cat /sys/block/sda/queue/scheduler
[none]
test@vertica:~$ echo "mq-deadline" | sudo tee /sys/block/sda/queue/scheduler
# 加入开机自启
test@vertica:~$ echo 'echo "mq-deadline" > /sys/block/sda/queue/scheduler' | sudo tee -a /etc/rc.local

On some Ubuntu/Debian systems, the last line in rc.local must be “exit 0”. So you must manually add the following line to etc/rc.local before the last line with exit 0.

配置 TZ

#sudo timedatectl set-timezone Asia/Shanghai
test@vertica:~$ cat <<EOF>>~/.bashrc
export TZ="Asia/Shanghai"
EOF

如果是集群，必须在所有节点上将 TZ 变量设置为相同的值;

Support Tools

test@vertica:~$ sudo apt install pstack sysstat [rasdaemon]mcelog

For Ubuntu versions 18.04 and higher, run apt install rasdaemon instead of apt install mcelog.

配置 swapiness

test@vertica:~$ cat /proc/sys/vm/swappiness
test@vertica:~$ echo "vm.swappiness=0" | sudo tee -a /etc/sysctl.conf
test@vertica:~$ sudo sysctl -p
test@vertica:~$ cat /proc/sys/vm/swappiness

Disk Readahead

test@vertica:~$ sudo /sbin/blockdev --setra 2048 /dev/sda
test@vertica:~$ echo '/sbin/blockdev --setra 2048 /dev/sda' | sudo tee -a /etc/rc.local

On some Ubuntu/Debian systems, the last line in rc.local must be “exit 0”. So you must manually add the following line to etc/rc.local before the last line with exit 0.

Enabling chrony or ntpd

test@vertica:~$ sudo apt install chrony
test@vertica:~$ sudo systemctl status chrony
test@vertica:~$ chronyc tracking

自启动项

test@vertica:~$ echo '#!/bin/sh -e' | sudo tee /etc/rc.local
test@vertica:~$ echo 'echo "mq-deadline" > /sys/block/sda/queue/scheduler' | sudo tee -a /etc/rc.local
test@vertica:~$ echo '/sbin/blockdev --setra 2048 /dev/sda' | sudo tee -a /etc/rc.local
test@vertica:~$ echo 'exit 0' | sudo tee -a /etc/rc.local
#自启动启动略

错误处理后重装

test@vertica:~$ sudo /opt/vertica/sbin/install_vertica --hosts 192.168.1.xx
#......
# To create a database:
#   1. Logout and login as dbadmin. (see note below)
#   2. Run /opt/vertica/bin/adminTools as dbadmin
#   3. Select Create Database from the Configuration Menu
#   Note: Installation may have made configuration changes to dbadmin
#   that do not take effect until the next session (logout and login).
#.......
test@vertica:~$ su dbadmin
#Password:
dbadmin@vertica:/home/test$ /opt/vertica/bin/adminTools
# create database,第一步证书Tab键直接选择OK使用社区版