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>

Related Content you might be interested in

Current Title:

Small book image
HP Vertica Essentials
Rishabh Agrawal
May, 2014 | 106 pages
No titles found
Table of Contents (13 chapters)
HP Vertica Essentials
HP Vertica Essentials
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Installing Vertica
Installing Vertica
Understanding the preinstallation steps
Steps to install Vertica
Summary
2
Cluster Management
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
3
Monitoring Vertica
Monitoring Vertica
Monitoring through the system tables
Looking at events
Monitoring Vertica through the Management Console
Retaining monitoring information
Monitoring data collection components
Summary
4
Backup and Restore
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
5
Performance Improvement
Performance Improvement
Understanding projections
Understanding the storage model in Vertica
Summary
6
Bulk Loading
Bulk Loading
Using the COPY command
Load methods
Data transformation
Summary
Index
Index

Creating full and incremental backups

In this section, you will learn about the process of creating full and incremental backups. But first, let's understand the requirements.

Understanding the requirements

Before we create a snapshot, we must check the following:

  • The database is up and running.

  • All of the backup hosts are up and available to the cluster.

  • The user account has all permissions to the target directories on the backup node.

  • By default, the vbr.py utility searches for the config file at /opt/vertica/config/vbr.ini, and if it is not found, the utility exits with an error. We can supply the config file using the --config-file parameter with vbr.py.

It should be noted that if some nodes are down but the database is running in K-Safe mode, then the backup will still be created.

Running vbr.py

To run the vbr.py utility, use the following command:

> vbr.py --task backup --config-file myconfig.ini 
Copying... 
xxxxxx out of xxxxxx, 100% 
All child processes terminated successfully. 
Committing...
Previous Section
End of Section 4
Next Section