Sunday, July 26, 2015

Installing Vertica Analytics and Management Console




In this blog we will  learn how to install vertica analytic  and management console.

Before we install vertica, we need to understand the cluster configuration for vertica. each node in cluster has unique ip address, they dont share common storage.
Each hosts has a file /etc/hosts so that hosts can identify each other.




there are also dedicated ports that need to be left opened for vertica communications like 5434, 5444,5450...

besides root user, 2 more users need to be created.:
1) dbadmin: for vertica database
2) mcadmin for management console

root users install vertica analytics and management console on each host in the cluster.

on of the host create a directory,to hold vertica database and manaegment console installation files.

On all of the host create a directory for vertica database.

Vertica support following unix OS.
'


To install vertica, you just need to unzip vertica rpm file . Once that is done, it will create a directory /opt/vertica.

The vertica directory contains many sub directory




Now we need to install vertica


here node is the ip address of the different machines. t will install vertica on all hosts. Now hosts become nodes.

for licensing vertica, we now need to login as dbadmin. run the command admintools.  a pop will be there for you to define full path of licensing file



Now we will install management console.

run the installation command

Now open the browser and type the URL, https://node1:5450   here node1 is the nodename.  accept the license agreement

create administrative user for management console.






and its done.

1 comment:

Featured Post

Ichimoku cloud

Here how you read a ichimoku cloud 1) Blue Converse line: It measures short term trend. it also shows minor support or resistance. Its ve...