Cargando…
HP Vertica essentials : learn how to deploy, administer, and manage HP Vertica, one of the most robust MPP solutions around /
This is a step-by-step guide with an easy-to-follow approach. A variety of diagrams and images support the concepts explored in the book. This book also contains important tips and tricks, thus making it a really useful reference for Vertica administration activities. If you are a Vertica user or DB...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham, UK :
Packt Pub.,
2014.
|
| Colección: | Professional expertise distilled.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Installing Vertica; Understanding preinstallation steps; Swap space; Dynamic CPU frequency scaling; Summary; Chapter 2: Cluster Management; Comprehending the elastic cluster scaling factor; Enabling and disabling an elastic cluster; Viewing and setting 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 nodesAdding nodes using administrative tools; Removing nodes in Vertica; Lowering the K-safety level; Removing nodes using administrative 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
- Chapter 3: Monitoring VerticaMonitoring 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; Chapter 4: Backup and Restore; Requirements for backup hosts; Generating the vbr.py configuration file; Miscellaneous settings
- Database access settingsData 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; Chapter 5: Performance Improvement; Understanding projections
- Looking into high availability and recoveryComprehending unsegmented projections; Comprehending segmented projections; Creating projections using Database Designer; Comprehensive design; Query-specific design; Creating projections manually; Column list and encoding; Base query; Sort order; Segmentation; Keeping K-safety (K-Safe) in mind; 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