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)

Adding nodes in Vertica


Before adding nodes, it is very important that we create a full backup of the database, as adding nodes in Vertica is a sensitive process. To add a new node, we will be using the update_vertica script. However, before adding a node to an existing cluster, the following are certain restrictions and prerequisites that have to be kept in mind:

  • Make sure that the database is running.

  • Newly added nodes should be reachable by all the existing nodes in the cluster.

  • If we have a single node cluster that is deployed, without specifying the IP address, hostname, or hostname specified as the local host, it is not possible to expand the cluster. We must reinstall Vertica and specify an IP address or hostname.

  • Generally, it is not needed to shut down the Vertica database for expansion, but a shutdown is necessary if we are expanding it from a single node cluster.

Method

From any node of the cluster, we can run the update_vertica script as follows:

# /opt/vertica/sbin/update_vertica...