在linux6上如何安装vertica列式数据库

Port

Protocol

Service

Notes

7

TCP

Management Console

Required by Management Console to discover Vertica  nodes.

22

TCP

sshd

Required by Administration Tools and the Management Console Cluster Installation wizard.

5433

TCP

Vertica

Vertica client (vsql, ODBC, JDBC, etc) port.

5434

TCP

Vertica

Intra- and inter-cluster communication. Vertica opens the Vertica client  port +1 (5434 by default) for intra-cluster communication, such as during a  plan. If the port +1 from the default client port is not available, then  Vertica opens a random port for intra-cluster communication.

5433

UDP

Vertica

Vertica spread monitoring.

5444

TCP

Vertica
Management Console

MC-to-node and node-to-node (agent) communications port. See Changing MC or Agent Ports.

5450

TCP

Vertica
Management Console

Port used to connect to MC from a web browser and allows communication  from nodes to the MC application/web server. See Connecting to Management Console.

4803

TCP

Spread

Client connections.

4803

UDP

Spread

Daemon to Daemon connections.

4804

UDP

Spread

Daemon to Daemon connections.

6543

UDP

Spread

Monitor to Daemon connection.

[root@ verticatest ~]# lsb_release -a

LSB Version:    :base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch

Distributor ID: RedHatEnterpriseServer

Description:    Red Hat Enterprise Linux Server release  6.4 (Santiago)

Release:        6.4

Codename:       Santiago

[root@verticatest ~]# more  /etc/sysconfig/clock

ZONE="Asia/Shanghai"

[root@verticatest ~]# yum install openssh  ntp which dialog –y

[root@verticatest ~]# service ntpd  restart

Shutting down ntpd:                                        [FAILED]

Starting ntpd:                                             [  OK  ]

[root@verticatest ~]# chkconfig ntpd on

service iptables save

service iptables stop

chkconfig iptables off

service ip6tables save

service ip6tables stop

chkconfig ip6tables off

[root@verticatest ~]# more  /etc/selinux/config

# This file controls the state of SELinux  on the system.

# SELINUX= can take one of these three  values:

#     enforcing - SELinux security policy is enforced.

#     permissive - SELinux prints warnings instead of enforcing.

#     disabled - No SELinux policy is loaded.

SELINUX=disabled

# SELINUXTYPE= can take one of these two  values:

#     targeted - Targeted processes are protected,

#     mls - Multi Level Security protection.

SELINUXTYPE=targeted

[root@verticatest ~]#setenforce 0

setenforce: SELinux is disabled

echo deadline >  /sys/block/sda/queue/scheduler

echo never  >/sys/kernel/mm/redhat_transparent_hugepage/enabled

echo never >/sys/kernel/mm/redhat_transparent_hugepage/defrag

echo no >  /sys/kernel/mm/redhat_transparent_hugepage/khugepaged/defrag

echo 0 > /proc/sys/vm/swappiness

/sbin/blockdev --setra 8192 /dev/sda

LoginGraceTime 0

[root@verticatest ~]# service sshd reload

Reloading sshd:

[root@verticatest ~]#groupadd -g 601  verticadba

[root@verticatest ~]# useradd -u 601 -g  601 dbadmin

[root@verticatest ~]#mkdir -p  /home/dbadmin/data^C

[root@verticatest ~]# echo oracle|passwd  --stdin dbadmin

Changing password for user dbadmin.

passwd: all authentication tokens updated  successfully.

[root@ verticatest ~]# su - dbadmin

[dbadmin@ verticatest ~]$ mkdir -p  /home/dbadmin/data

[dbadmin@ verticatest ~]$ mkdir -p  /home/dbadmin/catalog

[dbadmin@ verticatest ~]$ more  .bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

        . ~/.bashrc

fi

# User specific environment and startup  programs

PATH=$PATH:$HOME/bin

export PATH

export  TZ="Asia/Shanghai"

[dbadmin@ verticatest ~]$ . .bash_profile

[dbadmin@ verticatest ~]$ echo $TZ

Asia/Shanghai

[root@verticatest ~]# /opt/vertica/sbin/install_vertica --hosts 192.168.117.4  --rpm /root/vertica-8.0.0-0.x86_64.RHEL6.rpm --dba-user dbadmin

Vertica Analytic Database 8.0.0-0  Installation Tool

>> Validating options...

Mapping hostnames in --hosts (-s) to  addresses...

>> Starting installation tasks.

>> Getting system information for  cluster (this may take a while)...

Default shell on nodes:

192.168.117.4 /bin/bash

>> Validating software versions  (rpm or deb)...

>> Beginning new cluster  creation...

successfully backed up admintools.conf on  192.168.117.4

>> Creating or validating DB Admin  user/group...

Successful on hosts (1): 192.168.117.4

    Provided DB Admin account details: user = dbadmin, group = verticadba,  home = /home/dbadmin

    Creating group... Group already exists

    Validating group... Okay

    Creating user... User already exists

    Validating user... Okay

>> Validating node and cluster  prerequisites...

System prerequisites passed.  Threshold = WARN

>> Establishing DB Admin SSH  connectivity...

Installing/Repairing SSH keys for dbadmin

>> Setting up each node and  modifying cluster...

Creating Vertica Data Directory...

Updating agent...

Creating node node0001 definition for  host 192.168.117.4

... Done

>> Sending new cluster  configuration to all nodes...

Starting agent...

>> Completing installation...

Running upgrade logic

No spread upgrade required:  /opt/vertica/config/vspread.conf not found on any node

Installation complete.

Please evaluate your hardware using  Vertica's validation tools:

    https://my.vertica.com/docs/8.0.x/HTML/index.htm#cshid=VALSCRIPT

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).

To add or remove hosts, select Cluster  Management from the Advanced Menu.

*** Creating database: firstvdb ***

        Creating database firstvdb

        Starting bootstrap node v_firstvdb_node0001 (192.168.117.4)

        Starting nodes:

                v_firstvdb_node0001  (192.168.117.4)

        Starting Vertica on all nodes. Please wait, databases with large  catalog may take a while to initialize.

        Node Status: v_firstvdb_node0001: (DOWN)

        Node Status: v_firstvdb_node0001: (DOWN)

        Node Status: v_firstvdb_node0001: (DOWN)

        Node Status: v_firstvdb_node0001: (DOWN)

        Node Status: v_firstvdb_node0001: (UP)

Automatically installing extension  packages

Package: flextable

        Success: package flextable successfully installed

Package: approximate

        Success: package approximate successfully installed

Package: hdfsconnector

        Success: package hdfsconnector successfully installed

Package: AWS

        Success: package AWS successfully installed

Package: logsearch

        Success: package logsearch successfully installed

Package: txtindex

        Success: package txtindex successfully installed

Package: MachineLearning

        Success: package MachineLearning successfully installed

Package: idol

        Success: package idol successfully installed

Package: kafka

        Success: package kafka successfully installed

Package: place

        Success: package place successfully installed

[dbadmin@verticatest ~]$ vsql -h  192.168.117.4 -U 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

dbadmin=>

这里也可以用本地回环地址。