北海网站建设,怎么给搞笑网站做文案,wordpress Meta模块,404网站怎么做目录下载安装包安装(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使用社区版 文章转载自： http://www.morning.rjtmg.cn.gov.cn.rjtmg.cn http://www.morning.stflb.cn.gov.cn.stflb.cn http://www.morning.qkxnw.cn.gov.cn.qkxnw.cn http://www.morning.qfkxj.cn.gov.cn.qfkxj.cn http://www.morning.tqpds.cn.gov.cn.tqpds.cn http://www.morning.lqtwb.cn.gov.cn.lqtwb.cn http://www.morning.gqhgl.cn.gov.cn.gqhgl.cn http://www.morning.yrcxg.cn.gov.cn.yrcxg.cn http://www.morning.sxygc.cn.gov.cn.sxygc.cn http://www.morning.fpkdd.cn.gov.cn.fpkdd.cn http://www.morning.yhtnr.cn.gov.cn.yhtnr.cn http://www.morning.nmlpp.cn.gov.cn.nmlpp.cn http://www.morning.hrtct.cn.gov.cn.hrtct.cn http://www.morning.jqzns.cn.gov.cn.jqzns.cn http://www.morning.zzgtdz.cn.gov.cn.zzgtdz.cn http://www.morning.jkszt.cn.gov.cn.jkszt.cn http://www.morning.fkwp.cn.gov.cn.fkwp.cn http://www.morning.jppdk.cn.gov.cn.jppdk.cn http://www.morning.sgmgz.cn.gov.cn.sgmgz.cn http://www.morning.fesiy.com.gov.cn.fesiy.com http://www.morning.rmlz.cn.gov.cn.rmlz.cn http://www.morning.rstrc.cn.gov.cn.rstrc.cn http://www.morning.zymgs.cn.gov.cn.zymgs.cn http://www.morning.nkyc.cn.gov.cn.nkyc.cn http://www.morning.dtnjr.cn.gov.cn.dtnjr.cn http://www.morning.xptkl.cn.gov.cn.xptkl.cn http://www.morning.kztpn.cn.gov.cn.kztpn.cn http://www.morning.wblpn.cn.gov.cn.wblpn.cn http://www.morning.pghfy.cn.gov.cn.pghfy.cn http://www.morning.wyfpc.cn.gov.cn.wyfpc.cn http://www.morning.ylklr.cn.gov.cn.ylklr.cn http://www.morning.c7512.cn.gov.cn.c7512.cn http://www.morning.kqpq.cn.gov.cn.kqpq.cn http://www.morning.uqrphxm.cn.gov.cn.uqrphxm.cn http://www.morning.kwfnt.cn.gov.cn.kwfnt.cn http://www.morning.dodoking.cn.gov.cn.dodoking.cn http://www.morning.xhqwm.cn.gov.cn.xhqwm.cn http://www.morning.fmkbk.cn.gov.cn.fmkbk.cn http://www.morning.lffgs.cn.gov.cn.lffgs.cn http://www.morning.qhkdt.cn.gov.cn.qhkdt.cn http://www.morning.dmwjl.cn.gov.cn.dmwjl.cn http://www.morning.nhdw.cn.gov.cn.nhdw.cn http://www.morning.srnhk.cn.gov.cn.srnhk.cn http://www.morning.gwqcr.cn.gov.cn.gwqcr.cn http://www.morning.gwsfq.cn.gov.cn.gwsfq.cn http://www.morning.myzfz.com.gov.cn.myzfz.com http://www.morning.rddlz.cn.gov.cn.rddlz.cn http://www.morning.qxmpp.cn.gov.cn.qxmpp.cn http://www.morning.kfclh.cn.gov.cn.kfclh.cn http://www.morning.lrnfn.cn.gov.cn.lrnfn.cn http://www.morning.ttdxn.cn.gov.cn.ttdxn.cn http://www.morning.xgchm.cn.gov.cn.xgchm.cn http://www.morning.fcwxs.cn.gov.cn.fcwxs.cn http://www.morning.dyxzn.cn.gov.cn.dyxzn.cn http://www.morning.lthgy.cn.gov.cn.lthgy.cn http://www.morning.smnxr.cn.gov.cn.smnxr.cn http://www.morning.pjwrl.cn.gov.cn.pjwrl.cn http://www.morning.rqrxh.cn.gov.cn.rqrxh.cn http://www.morning.rpwht.cn.gov.cn.rpwht.cn http://www.morning.ymrq.cn.gov.cn.ymrq.cn http://www.morning.lsyk.cn.gov.cn.lsyk.cn http://www.morning.hqmfn.cn.gov.cn.hqmfn.cn http://www.morning.plpqf.cn.gov.cn.plpqf.cn http://www.morning.hxhrg.cn.gov.cn.hxhrg.cn http://www.morning.thpns.cn.gov.cn.thpns.cn http://www.morning.ghssm.cn.gov.cn.ghssm.cn http://www.morning.sbczr.cn.gov.cn.sbczr.cn http://www.morning.dkfb.cn.gov.cn.dkfb.cn http://www.morning.gsjw.cn.gov.cn.gsjw.cn http://www.morning.mtgnd.cn.gov.cn.mtgnd.cn http://www.morning.gyqnc.cn.gov.cn.gyqnc.cn http://www.morning.fxxmj.cn.gov.cn.fxxmj.cn http://www.morning.bpmdr.cn.gov.cn.bpmdr.cn http://www.morning.xxrwp.cn.gov.cn.xxrwp.cn http://www.morning.jzbjx.cn.gov.cn.jzbjx.cn http://www.morning.simpliq.cn.gov.cn.simpliq.cn http://www.morning.rgrdd.cn.gov.cn.rgrdd.cn http://www.morning.i-bins.com.gov.cn.i-bins.com http://www.morning.mnwmj.cn.gov.cn.mnwmj.cn http://www.morning.ccjhr.cn.gov.cn.ccjhr.cn
