Free Sample
+ Collection

HP Vertica Essentials

Rishabh Agrawal

Learn to deploy, administer, and manage HP Vertica, one of the most robust MPP solutions around.
RRP $23.99
RRP $39.99
Print + eBook

Want this title & more?

$12.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781782171560
Paperback106 pages

About This Book

  • Learn cluster management and techniques to improve performance in Vertica
  • Deploy local segmentation and get to grips with the concept of projections
  • A simple, step-by-step guide covering the common administration-related activities in HP Vertica

Who This Book Is For

If you are a Vertica user or DBA who wants to perform basic administration and fi ne tuning, then this book is for you. Prior knowledge of Vertica will help you to understand the concepts better, but is not mandatory. Some intermediate knowledge of RDBMS, SQL, Linux, and scripting languages such as Perl or Python will be helpful.

Table of Contents

Chapter 1: Installing Vertica
Understanding the preinstallation steps
Steps to install Vertica
Chapter 2: Cluster Management
Comprehending the elastic cluster scaling factor
Adding nodes in Vertica
Removing nodes in Vertica
Replacing nodes
Changing the IP addresses of a Vertica cluster
Chapter 3: Monitoring Vertica
Monitoring through the system tables
Looking at events
Monitoring Vertica through the Management Console
Retaining monitoring information
Monitoring data collection components
Chapter 4: Backup and Restore
Requirements for backup hosts
Generating the configuration file
Creating full and incremental backups
Restoring full database snapshots
Using database snapshot functions
Chapter 5: Performance Improvement
Understanding projections
Understanding the storage model in Vertica
Chapter 6: Bulk Loading
Using the COPY command
Load methods
Data transformation

What You Will Learn

  • Successfully install Vertica
  • Manage clusters in Vertica
  • Create backups and restore databases
  • Master different techniques to improve performance
  • Understand the concept of projections in Vertica
  • Make effective projections in Vertica
  • Monitor performance in Vertica
  • Get to grips with the concept of bulk loading in Vertica

In Detail

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.

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.


Read More

Recommended for You