HP Vertica Essentials by Agrawal, Rishabh -- Read -- Imperial Library of Trantor

Index

HP Vertica Essentials

Table of Contents HP Vertica Essentials Credits About the Author About the Reviewers www.PacktPub.com

Support files, eBooks, discount offers, and more

Why subscribe? Free access for Packt account holders Instant updates on new Packt books

Preface

What this book covers What you need for this book Who this book is for Conventions Reader feedback Customer support

Errata Piracy Questions

1. Installing Vertica

Understanding the preinstallation steps

Swap space Dynamic CPU frequency scaling Understanding disk space requirements

Steps to install Vertica Summary

2. Cluster Management

Comprehending the elastic cluster scaling factor

Enabling and disabling an elastic cluster Viewing and setting the scaling factor settings Enabling and disabling local segmentation Understanding the best practices in cluster management Monitoring elastic cluster rebalancing

Adding nodes in Vertica

Method

Using the Management Console to add nodes

Adding nodes using administration tools

Removing nodes in Vertica

Lowering the K-safety level Removing nodes using administration tools Removing nodes using the Management Console Removing hosts from a cluster

Replacing nodes

Replacing a node using the same name and IP address Replacing a failed node using a different name and IP address Redistributing configuration files to nodes Using administration tools to replace nodes with different names and IP addresses

Changing the IP addresses of a Vertica cluster Summary

3. Monitoring Vertica

Monitoring through the system tables

Understanding a system table example

Looking at events

Looking at events through logfiles Looking at events through the ACTIVE_EVENTS system table

Monitoring Vertica through the Management Console Retaining monitoring information

Enabling and disabling Data Collector Viewing the current data retention policy Configuring data retention policies

Monitoring data collection components Summary

4. Backup and Restore

Requirements for backup hosts Generating the vbr.py configuration file

Miscellaneous settings Database access settings Data transmission during the backup process Mapping

Creating full and incremental backups

Understanding the requirements Running vbr.py Incremental snapshots Creating schema and table snapshots

Restoring full database snapshots

Restoring from a specific snapshot Restoring from the most recent snapshot Restoring schema and table snapshots Copying a database from one cluster to another

Copying the database

Using database snapshot functions

Creating database snapshots Removing snapshots

Summary

5. Performance Improvement

Understanding projections

Looking into high availability and recovery

Comprehending unsegmented projections Comprehending segmented projections

Creating projections using Database Designer

The comprehensive design The query-specific design

Creating projections manually

Column list and encoding The base query The sort order Segmentation Keeping K-safety (K-Safe) in mind

Creating buddy projections A note on table partitioning

Understanding the storage model in Vertica

Tuple Mover operations

Moveout Mergeout Tuning Tuple Mover

Adding storage locations

Adding a new location Measuring location performance Setting location performance Understanding storage location tweaking functions

Altering Dropping Retiring storage locations Restoring retired storage locations

Summary

6. Bulk Loading

Using the COPY command

Aborting the COPY command

Load methods Data transformation Summary

Index

← Prev
Back
Next →

← Prev
Back
Next →