Use your business data to your advantage with the help of Syncfusion’s new data science offerings. Discover how a custom big data solution can provide your company with valuable predictions about key market trends.

HP Vertica Essentials

Learn to deploy, administer, and manage HP Vertica, one of the most robust MPP solutions around.

$23.99

$39.99

RRP $23.99

RRP $39.99

eBook

Print + eBook

Want this title & more?

$21.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

Summary

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

Summary

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

Summary

Chapter 4: Backup and Restore

Requirements for backup hosts

Generating the vbr.py configuration file

Creating full and incremental backups

Restoring full database snapshots

Using database snapshot functions

Summary

Chapter 5: Performance Improvement

Understanding projections

Understanding the storage model in Vertica

Summary

Chapter 6: Bulk Loading

Using the COPY command

Load methods

Data transformation

Summary

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.

Authors

Rishabh Agrawal

Rishabh Agrawal is currently working as a senior database research engineer and consultant at Impetus India. He has been tinkering with databases since 2010 and has gained expertise in a variety of NoSQL, massively parallel processing (MPP), and relational databases in the Big Data domain in a short span of time. A MongoDB Certified DBA, he has working knowledge of more than 20 databases, namely Cassandra, Oracle NoSQL, FoundationDB, Riak, Gemfire, Gemfire XD, HBase, Hive, Shark, HP Vertica, Greenplum, SQL Server 2008 R2, and so on. His primary focus areas are research and evaluation of new and cutting-edge database technologies and consulting with clients on the strategic use of diverse database technologies.

When not at work, he revels in photographing vivid subjects, playing badminton, writing poems, and dancing. You can connect with him on LinkedIn at in.linkedin.com/pub/rishabh-agrawal/15/ab4/186.

Alerts & Offers

Series & Level

We understand your time is important. Uniquely amongst the major publishers, we seek to develop and publish the broadest range of learning and information products on each technology. Every Packt product delivers a specific learning pathway, broadly defined by the Series type. This structured approach enables you to select the pathway which best suits your knowledge level, learning style and task objectives.

Learning

As a new user, these step-by-step tutorial guides will give you all the practical skills necessary to become competent and efficient.

Beginner's Guide

Friendly, informal tutorials that provide a practical introduction using examples, activities, and challenges.

Essentials

Fast paced, concentrated introductions showing the quickest way to put the tool to work in the real world.

Cookbook

A collection of practical self-contained recipes that all users of the technology will find useful for building more powerful and reliable systems.

Blueprints

Guides you through the most common types of project you'll encounter, giving you end-to-end guidance on how to build your specific solution quickly and reliably.

Mastering

Take your skills to the next level with advanced tutorials that will give you confidence to master the tool's most powerful features.

Starting

Accessible to readers adopting the topic, these titles get you into the tool or technology so that you can become an effective user.

Progressing

Building on core skills you already have, these titles share solutions and expertise so you become a highly productive power user.