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.

Tuesday, July 21, 2015

HP Vertica Building Blocks

HP vertica the physical architecture is designed to distribute physical storage and to allow parallel query execution over a potentially large collection of computing resources.
The most important terms to understand are instance, node, cluster, and data:
NODE: a node is a machine configure to run vertica
Instance: Its the vertica instance installed on the node
Cluster: A cluster consists of collection of nodes
data: Data is the data in the vertica database distributed across the nodes

Vertica platform is build ground up. there are 6 important vertica features:

Columnar Orientation: Data is stored in columns instead of rows, thus saving memory and I /O
Advance Compression:Operates on compressed and encoded data delivers superior performance on a smaller storage footprint    and reduced capital expense

High availability: Vertica is designed for high availability. to achieve this vertica uses projections or copy of projections stored in different nodes. number of projections are based on  K-Safety=1 
K-Safety is the measure of fault tolerance of the database. it support values 0,1,2. inorder to enable K-Safety there should be minimum of 3 nodes in the cluster

Automatic Database design: The database designer allows you to optimize, tune and control your database without shutting down the database

Application integration: Using standard SQL, there is seamless integration with robust and ever growing analytical solutions

Massively Parallel Processing:automatic,limitless, linear scaling of peer to peer nodes, each processing an allocated subset of data

Featured Post

Amazon Route 53

Amazon Route 53 is a highly available and scalable Domain Name System (DNS) web service.Route 53  perform three main functions in any...