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)

Generating the vbr.py configuration file


To invoke vbr.py to set up a configuration file, we should use the following command:

> vbr.py --setupconfig

The script prompts us to answer the following questions for parameters marked with an asterisk, *. For setting all the advanced options, we need to answer the last question with a "yes" during initial setup or change the configuration file manually. A configuration file contains various parameters categorized under various headers. The upcoming sections explain the headers and corresponding parameters present in the configuration file.

Miscellaneous settings

The following table shows the parameters present in the Miscellaneous [Misc] section of the file:

Parameters

Default

Description

snapshotName*

snapshotName

This value provides the prefix of the directory that will contain the snapshot. The characters in the value of snapshotName can include the following:

  • Aa-Zz

  • 0-9

  • Period (.), hyphen (-), and underscore (_)

tempDir

/tmp

The vbr.py...