当前位置: 首页 > news >正文

Ubuntu18.04安装Vertica

目录

    • 下载安装包
    • 安装(Ubuntu18.04)
      • 配置 I/O Scheduler
      • 配置 TZ
      • Support Tools
      • 配置 swapiness
      • Disk Readahead
      • Enabling chrony or ntpd
      • 自启动项
      • 错误处理后重装

下载安装包

  • 官网
  • 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使用社区版
http://www.lryc.cn/news/318.html

相关文章:

  • 2.计算机基础-计算机网络面试题—基础知识、容器、面向对象、并发编程
  • 解决Mac 安装应用提示:xx已损坏,无法打开。 您应该将它移到废纸篓问题
  • xpath注入[NPUCTF2020]ezlogin
  • 【Python学习笔记】22.Python3 数据结构
  • 一文搞懂 什么是CPU上下文?为什么要切换?如何减少切换?
  • 【Python】Python学习笔记(二)基本输入输出
  • LeetCode刷题系列 -- 724. 寻找数组的中心下标
  • Linux编辑器vim
  • 基于“python+”潮汐、风驱动循环、风暴潮等海洋水动力模拟
  • 《Terraform 101 从入门到实践》 第二章 Providers插件管理
  • 03- pandas 数据库可视化 (机器学习)
  • Spring为什么这么火 之 Bean的6种作用域和Bean的生命周期
  • 【CSS面试题】2023前端最新版css模块,高频15问
  • SpringCloud-Netflix学习笔记10——Hystrix实现服务熔断
  • 精华文稿|迈向统一的点云三维物体检测框架
  • 面试题:Redis网络模型
  • 微信小程序开发你可能不知道的开发技巧
  • STM32开发(8)----CubeMX配置串口通讯(中断方式和DMA方式)
  • 7.1 微服务-SpringCloud(二)
  • Spring的AOP开发-基于xml配置的AOP
  • JAVA的垃圾收集器与内存分配策略【一篇文章直接看懂】
  • NLP学习——信息抽取
  • 【深度学习基础7】预训练、激活函数、权重初始化、块归一化
  • MetaMQ
  • 热门盘点 | 10款评分最高的项目管理工具
  • 若依框架---分页功能
  • CHAPTER 3 Jenkins SVN GItlab
  • 为什么Redis集群的最大槽数是16384个?
  • 餐饮企业数据可视化大屏(智慧餐饮)
  • Kafka安装及zookeeper is not a recognized option问题解决