Book Image

HP Vertica Essentials

By : Rishabh Agrawal
Book Image

HP Vertica Essentials

By: Rishabh Agrawal

Overview of this book

<p>With the rise of Massively Parallel Processing (MPP) and NewSQL databases, many users are confused about which MPP technology to opt for. Today, HP Vertica is gaining a lot of traction as a major MPP technology. Vertica's distributed architecture allows fast query processing, and it is a highly fault-tolerant architecture, thus making it one of the most sought-after MPP databases today.</p> <p>HP Vertica Essentials will help you to learn day-to-day administration activities in a step-by-step format. You will start by learning how to install Vertica, followed by its management and monitoring. You will learn about the different backup and restore techniques, including the concept of projections in Vertica. Finally, you will explore the various techniques to improve performance and bulk loading in Vertica. By the end of this book, you will be able to install, manage, and monitor Vertica efficiently.</p>
Table of Contents (13 chapters)

Chapter 2. Cluster Management

Vertica provides quite an elastic cluster, which can be scaled both up (adding new nodes) and down (removing nodes) without affecting the processes of the running database. The most important task after alteration in a cluster is the rebalancing of data across new as well as old nodes. This is done to ensure that the data remains K-Safe. Please refer to Chapter 5, Performance Improvement, for more information on K-Safe.

Projections are divided into segments, which are small portions of data. After adding a new node, some segments are given to it, while the other segments are exchanged to ensure proper K-safety. During the process of node removal from a cluster, all of the storage containers, which are residing at the node that is being removed, are moved to other existing nodes in the cluster. This method of partitioning data into movable segments turns a Vertica cluster into an elastic cluster.