北海网站建设,做视频网站服务器配置,wordpress是什么来的,扬中网站建设效果目录下载安装包安装(Ubuntu18.04)配置 I/O Scheduler配置 TZSupport Tools配置 swapinessDisk ReadaheadEnabling chrony or ntpd自启动项错误处理后重装下载安装包
官网11.0版本或者10.0(deb)安装包可私信提供百度网盘链接#xff1b;
安装(Ubuntu18.04)
testvertica:~$ s…
目录下载安装包安装(Ubuntu18.04)配置 I/O Scheduler配置 TZSupport Tools配置 swapinessDisk ReadaheadEnabling chrony or ntpd自启动项错误处理后重装下载安装包
官网11.0版本或者10.0(deb)安装包可私信提供百度网盘链接
安装(Ubuntu18.04)
testvertica:~$ sudo dpkg -i vertica_10.0.0-0_amd64.deb
#缺少依赖安装依赖
testvertica:~$ 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#cshidS0151HINT(eS0151): These disks do not have known IO schedulers: /dev/sda2(sda) noneHINT (S0305): https://www.vertica.com/docs/11.0.x/HTML/index.htm#cshidS0305HINT(eS0305): TZ is unset for dbadmin. Consider updating .profile or.bashrcHINT (S0041): https://www.vertica.com/docs/11.0.x/HTML/index.htm#cshidS0041HINT(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#cshidS0040HINT(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#cshidS0045HINT(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#cshidS0112WARN(eS0112): vm.swappiness is higher than recommended: your 60 1FAIL (S0020): https://www.vertica.com/docs/11.0.x/HTML/index.htm#cshidS0020FAIL(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#cshidS0030FAIL(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.
testvertica:~$ cat /sys/block/sda/queue/scheduler
[none]
testvertica:~$ echo mq-deadline | sudo tee /sys/block/sda/queue/scheduler
# 加入开机自启
testvertica:~$ echo echo mq-deadline /sys/block/sda/queue/scheduler | sudo tee -a /etc/rc.localOn 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
testvertica:~$ cat EOF~/.bashrc
export TZAsia/Shanghai
EOF如果是集群必须在所有节点上将 TZ 变量设置为相同的值; Support Tools
testvertica:~$ sudo apt install pstack sysstat [rasdaemon]mcelogFor Ubuntu versions 18.04 and higher, run apt install rasdaemon instead of apt install mcelog. 配置 swapiness
testvertica:~$ cat /proc/sys/vm/swappiness
testvertica:~$ echo vm.swappiness0 | sudo tee -a /etc/sysctl.conf
testvertica:~$ sudo sysctl -p
testvertica:~$ cat /proc/sys/vm/swappinessDisk Readahead
testvertica:~$ sudo /sbin/blockdev --setra 2048 /dev/sda
testvertica:~$ echo /sbin/blockdev --setra 2048 /dev/sda | sudo tee -a /etc/rc.localOn 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
testvertica:~$ sudo apt install chrony
testvertica:~$ sudo systemctl status chrony
testvertica:~$ chronyc tracking自启动项
testvertica:~$ echo #!/bin/sh -e | sudo tee /etc/rc.local
testvertica:~$ echo echo mq-deadline /sys/block/sda/queue/scheduler | sudo tee -a /etc/rc.local
testvertica:~$ echo /sbin/blockdev --setra 2048 /dev/sda | sudo tee -a /etc/rc.local
testvertica:~$ echo exit 0 | sudo tee -a /etc/rc.local
#自启动启动略错误处理后重装
testvertica:~$ 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).
#.......
testvertica:~$ su dbadmin
#Password:
dbadminvertica:/home/test$ /opt/vertica/bin/adminTools
# create database,第一步证书Tab键直接选择OK使用社区版
