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)

Changing the IP addresses of a Vertica cluster


Sometimes, during networking-related maintenance chores, the IP(s) of one or more servers running Vertica changes to some other IP. In these cases, IP changes are needed to be done in Vertica as well. However, before making changes in Vertica, we must make sure that changes are made in /etc/hosts of all nodes, where the hostname is mapped to the IP address. After making system-level changes, proceed with the following steps to change the IP address of one or more nodes in a cluster:

  1. Back up the following three files:

    • /opt/vertica/config/admintools.conf

    • /opt/vertica/config/vspread.conf

    • /etc/sysconfig/spreadd

    It is assumed that Vertica is installed on /opt/vertica. If Vertica is installed on some other location, then we should take backups from that location.

  2. We should stop Vertica on all nodes.

  3. As a root user, we need to stop Spread manually on each node. Spread is the messaging system for distributed systems such as Vertica. We can stop Spread using...