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.