PacktLib: HP Vertica Essentials

HP Vertica Essentials

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

Installing Vertica

Understanding the preinstallation steps

Steps to install Vertica

Summary

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

Monitoring Vertica

Monitoring through the system tables

Looking at events

Monitoring Vertica through the Management Console

Retaining monitoring information

Monitoring data collection components

Summary

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

Performance Improvement

Understanding projections

Understanding the storage model in Vertica

Summary

Bulk Loading

Using the COPY command

Load methods

Data transformation

Summary

Index