Skip to main content

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


Popular posts from this blog

Data Center Migration

Note: This blog is written with the help of my friend Rajanikanth
Data Center Migrations / Data Center Consolidations
Data Center Consolidations, Migrations are complex projects which impact entire orgnization they support. They usually dont happen daily but once in a decade or two. It is imperative to plan carefully, leverage technology improvements, virtualization, optimizations.
The single most important factor for any migration project is to have high caliber, high performing, experienced technical team in place. You are migrating business applications from one data center to another and there is no scope for failure or broken application during migration. So testing startegy should be in place for enterprise business applications to be migrated.
Typical DCC and Migrations business objectives
Business Drivers
·Improve utilization of IT assets ·DC space & power peaked out - business growth impacted ·Improve service levels and responsiveness to new applications ·Reduce support complexi…

HP CSA Implementation

I know the above picture is little confusing but don’t worry I break it down and explain in detail. By the time I am done explaining you all will be happy. HARDWARE AND SOFTWARE REQUIREMENTS 1.VMware vSphere infrastructure / Microsoft Hyper V: For the sake of Simplicity we will use VMware vSphere. We Need vSphere 4.0 /5/5.5 and above and vCenter 4.0 and above ready and installed. This is the first step. 2.We need Software medias for HP Cloud Service Automation, 2.00, HP Server Automation, 9.02, HP Operations Orchestration (OO)9.00.04, HP Universal CMDB 9.00.02, HP Software Site Scope, 11.01,HP Insight Software6.2 Update 1 3.DNS, DHCP and NTP systems are already installed and configured. NTP information should be part of VM templates 4.SQL Server 2005 or Microsoft® SQL Server 2008 or Microsoft® SQL Server 2012 , Oracle 11g, both 32-bit and 64-bit versions may be used for CSA database.
5.We will install  HP Cloud Service Automation, 2.00, HP Server Automation, 9.02, HP Operations Orchestra…

Openstack- Its importance in Cloud. The HP Helion Boost

Every enterprise expects few things from cloud computing, mainly:

· Auto scaling: The workload should increase and decrease as needed by the IT environment.

· Automatic repair: If there is any fault or crash of the application or the server, it automatically fix it

· Fault tolerant: The application or underlying technology is intelligent enough to make itself fault torrent

· Integrated lifecycle: It should have integrated lifecycle

· Unified management: Its easy to manage all different aspects of technology

· Less cost

· Speed


Its year 2014. till now only 5% to 7% enterprises are using cloud computing. Such a small number. Its a huge opportunity and a vast majority for anyone who is interested in providing cloud computing services.
Current IT environment is very complex. You just cant solve all your problems with cloud computing.
There are legacy systems, databases, data processors, different hardware and software. You name it , there are so many technology available in just o…