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>
Table of Contents (13 chapters)

Looking at events


There are various events such as Emergency, Alerts, Critical, Errors, Warnings, Notices, Information, and Debugs that are logged by Vertica. Vertica logs these events in one of the following ways:

  • In the Vertica.log file

  • In the ACTIVE_EVENTS system table

  • Using SNMP

  • Using Syslog

This book will cover the usage of the Vertial.log files and the ACTIVE_EVENTS system table for logging events.

The following table lists the events that are logged:

Event name

Event type

Description

Low Disk Space

0

This event is logged either when there is not enough space in the physical disk or when there is a hardware issue.

Read Only File System

1

Vertica uses specific directories for storing Catalog or Data information. When Vertica is unable to create or write to files, this event is logged. Changing access rights may solve the issue.

Loss Of K Safety

2

Vertica defines the minimum number of nodes needed to run a database, particularly in the K-Safe mode. For example, for maintaining K...