install_vertica

The install_vertica script creates a cluster of nodes on which you can create a database.

Syntax

/opt/vertica/sbin/install_vertica

-s host_list

-r rpm_package

[ -u dba_username ]

[ -p dba_password ]

[ -l dba_home_directory ]

[ -d data_directory ]

[ -P root_password ]

Semantics

host_list	a comma-separated list of hostnames or IP addresses to include in the cluster; do not include space characters in the list. Example: -s host01,host02,host03 -s 192.168.233.101,192.168.233.102,192.168.233.103 This parameter is required and has no default value.
rpm_package	the name of the rpm package that contained this script .Example: -r vertica_2.1.GA.x86_64.RHEL5.rpm This parameter is required and has no default value.
dba_username	the name of the Database Administrator Linux account to create. Only this account can run the Administration Tools. If you omit the `-u` parameter, the default database administrator account name is `dbadmin`. The database administrator (DBA) is the Linux user account that owns the database catalog and data storage on disk. The DBA can bypass all database authorization rules. However, the DBA must supply a password to connect to a running database and to use Administration Tools commands that affect a running database. The DBA can drop a stopped database without supplying a password. This parameter is optional for new installations only. If upgrading, use the -u parameter to specify the same DBA account name that you used previously. Otherwise you may encounter problems later.
dba_password	the password for the Database Administrator account; if not supplied, the script prompts for the password and does not echo the input
dba_home_directory	the home directory for the Database Administrator; default is /home/dba_username
data_directory	the default directory for database data and catalog files; default is /home/dba_home_directory
root_password	the root password to use by default for each cluster host; if not supplied, the script prompts for the password if and when necessary and does not echo the input

Notes

Do not be concerned by the message -- Checking ...Failed. It indicates that install_vertica found and is correcting an incorrect configuration parameter.

Example

# /opt/vertica/sbin/install_vertica -s host01,host02,host03 -r vertica_1.3.15-7.i386.RHEL4.rpm

Vertica Database 1.3.15-7 Installation Tool

Please enter password for root@host01:

root@host01: Installation not performed on host01, same version already installed

root@host01: -- Checking status of ntpd service -- ...Done

root@host01: -- Checking vm.min_free_kbytes parameter in /sbin/sysctl -- ...Failed

root@host01: Info! Parameter vm.min_free_kbytes is less than 4096

root@host01: Setting vm.min_free_kbytes to 4096 ...

root@host01: -- Checking maximum number of open file descriptors in /etc/security/limits.conf -- ...Failed

root@host01: Info! The maximum number of open file descriptors is less than 65536

root@host01: Setting open filehandle limit to 65536 ...

root@host02: -- Checking status of ntpd service -- ...Done

root@host02: -- Checking vm.min_free_kbytes parameter in /sbin/sysctl -- ...Failed

root@host02: Info! Parameter vm.min_free_kbytes is less than 4096

root@host02: Setting vm.min_free_kbytes to 4096 ...

root@host02: -- Checking maximum number of open file descriptors in /etc/security/limits.conf -- ...Failed

root@host02: Info! The maximum number of open file descriptors is less than 65536

root@host02: Setting open filehandle limit to 65536 ...

root@host03: -- Checking status of ntpd service -- ...Done

root@host03: -- Checking vm.min_free_kbytes parameter in /sbin/sysctl -- ...Failed

root@host03: Info! Parameter vm.min_free_kbytes is less than 4096

root@host03: Setting vm.min_free_kbytes to 4096 ...

root@host03: -- Checking maximum number of open file descriptors in /etc/security/limits.conf -- ...Failed

root@host03: Info! The maximum number of open file descriptors is less than 65536

root@host03: Setting open filehandle limit to 65536 ...

root@host01: -- Checking dbadmin_ssh directory -- ...Done

root@host01: -- Generating SSH keys for user dbadmin -- ...Done

root@host01: -- Copying root@host01:dbadmin_ssh_keys.tgz file to /tmp/dbadmin_ssh_keys.tgz -- ...Done

Enter password for new UNIX user dbadmin:

Retype new UNIX password for user dbadmin:

root@host01: -- Creating user dbadmin -- ...Done

root@host01: -- Checking /home/dbadmin directory -- ...Done

root@host01: -- Changing the owner of /home/dbadmin directory to dbadmin -- ...Done

root@host01: -- Write check for /home/dbadmin directory -- ...Done

root@host01: -- Copying /tmp/dbadmin_ssh_keys.tgz file to root@host01:dbadmin_ssh_keys.tgz -- ...Done

root@host01: -- Installing ssh keys -- ...Done

root@host02: -- Creating user dbadmin -- ...Done

root@host02: -- Checking /home/dbadmin directory -- ...Done

root@host02: -- Changing the owner of /home/dbadmin directory to dbadmin -- ...Done

root@host02: -- Write check for /home/dbadmin directory -- ...Done

root@host02: -- Copying /tmp/dbadmin_ssh_keys.tgz file to root@host02:dbadmin_ssh_keys.tgz -- ...Done

root@host02: -- Installing ssh keys -- ...Done

root@host03: -- Creating user dbadmin -- ...Done

root@host03: -- Checking /home/dbadmin directory -- ...Done

root@host03: -- Changing the owner of /home/dbadmin directory to dbadmin -- ...Done

root@host03: -- Write check for /home/dbadmin directory -- ...Done

root@host03: -- Copying /tmp/dbadmin_ssh_keys.tgz file to root@host03:dbadmin_ssh_keys.tgz -- ...Done

root@host03: -- Installing ssh keys -- ...Done

===== Site Availability Test ====================================

All sites are available ... ok

===== Testing host01 ============================================

Site availability ... ok

Passwordless SSH access ... ok

Passwordless SSH access to other sites ... ok

Getting various information about the site ... ok

Python is installed ... ok

Enough RAM per CPUs ... ok

Getting information about the ports ... ok

Port availability for Spread ... ok

Port availability for Vertica ... ok

Gathering information about the network ... ok

Sanity of /etc/hosts ... ok

Hostname resolution ... ok

IP configuration ... ok

===== Testing host02 ============================================

Site availability ... ok

Passwordless SSH access ... ok

Passwordless SSH access to other sites ... ok

Getting various information about the site ... ok

Python is installed ... ok

Enough RAM per CPUs ... ok

Getting information about the ports ... ok

Port availability for Spread ... ok

Port availability for Vertica ... ok

Gathering information about the network ... ok

Sanity of /etc/hosts ... ok

Hostname resolution ... ok

IP configuration ... ok

===== Testing host03 ============================================

Site availability ... ok

Passwordless SSH access ... ok

Passwordless SSH access to other sites ... ok

Getting various information about the site ... ok

Python is installed ... ok

Enough RAM per CPUs ... ok

Getting information about the ports ... ok

Port availability for Spread ... ok

Port availability for Vertica ... ok

Gathering information about the network ... ok

Sanity of /etc/hosts ... ok

Hostname resolution ... ok

IP configuration ... ok

===== Consistency Test ==========================================

IP and Netmask consistency ... ok

All sites are on the same subnet ... ok

LANG and TZ environment variables ... ok

===== Network Test ==============================================

Network communication ... ok

root@host03: Test of site host01 (ok)

root@host03: ============================

root@host03:

root@host03: Test of site host02 (ok)

root@host03: ============================

root@host03:

root@host03: Test of site host03 (ok)

root@host03: ============================

root@host03:

root@host03: Consistency Test (ok)

root@host03: =========================

root@host03:

root@host03: Info: The $TZ environment variable is not set on host01

root@host03: Info: The $TZ environment variable is not set on host02

root@host03: Info: The $TZ environment variable is not set on host03

root@host03:

root@host03: Network Test (ok)

root@host03: =====================

root@host03:

root@host03: Network communication (ok)

root@host03: ------------------------------

root@host03:

root@host01: -- Setting up spread daemon -- ...Done

root@host01: -- Copying /opt/vertica/config/vspread.conf file to root@host01:/opt/vertica/config/vspread.conf -- ...Done

root@host01: -- Checking /opt/vertica/config/clusters directory -- ...Done

root@host01: -- Checking /opt/vertica/config directory -- ...Done

root@host01: -- Checking /opt/vertica/config/configInfo directory -- ...Done

root@host01: -- Checking /opt/vertica/config/share directory -- ...Done

root@host01: -- Checking /opt/vertica/config/users directory -- ...Done

root@host01: -- Checking /opt/vertica/config/users/dbadmin directory -- ...Done

root@host01: -- Changing the owner of /opt/vertica/config/users/dbadmin directory to dbadmin -- ...Done

root@host01: -- Write check for /opt/vertica/config/users/dbadmin directory -- ...Done

root@host01: -- Starting spread daemon -- ...Done

root@host01: Creating node node1_host01 definition for host host01 ...Done

root@host02: -- Setting up spread daemon -- ...Done

root@host02: -- Copying /opt/vertica/config/vspread.conf file to root@host02:/opt/vertica/config/vspread.conf -- ...Done

root@host02: -- Checking /opt/vertica/config/clusters directory -- ...Done

root@host02: -- Checking /opt/vertica/config directory -- ...Done

root@host02: -- Checking /opt/vertica/config/configInfo directory -- ...Done

root@host02: -- Checking /opt/vertica/config/share directory -- ...Done

root@host02: -- Checking /opt/vertica/config/users directory -- ...Done

root@host02: -- Checking /opt/vertica/config/users/dbadmin directory -- ...Done

root@host02: -- Changing the owner of /opt/vertica/config/users/dbadmin directory to dbadmin -- ...Done

root@host02: -- Write check for /opt/vertica/config/users/dbadmin directory -- ...Done

root@host02: -- Starting spread daemon -- ...Done

root@host02: Creating node node2_host02 definition for host host02 ...Done

root@host03: -- Setting up spread daemon -- ...Done

root@host03: -- Copying /opt/vertica/config/vspread.conf file to root@host03:/opt/vertica/config/vspread.conf -- ...Done

root@host03: -- Checking /opt/vertica/config/clusters directory -- ...Done

root@host03: -- Checking /opt/vertica/config directory -- ...Done

root@host03: -- Checking /opt/vertica/config/configInfo directory -- ...Done

root@host03: -- Checking /opt/vertica/config/share directory -- ...Done

root@host03: -- Checking /opt/vertica/config/users directory -- ...Done

root@host03: -- Checking /opt/vertica/config/users/dbadmin directory -- ...Done

root@host03: -- Changing the owner of /opt/vertica/config/users/dbadmin directory to dbadmin -- ...Done

root@host03: -- Write check for /opt/vertica/config/users/dbadmin directory -- ...Done

root@host03: -- Starting spread daemon -- ...Done

root@host03: Creating node node3_host03 definition for host host03 ...Done

root@host03: Verifying spread configuration

Installation complete.

To create a database:

1. run /opt/vertica/bin/adminTools as dbadmin

2. select Create Database from the Configuration menu