search cancel

Vertica database migration from single node to multiple node cluster

book

Article ID: 186777

calendar_today

Updated On:

Products

CA Infrastructure Management CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

We have an environment with one data repository and we want to migrate to a new environment with three clustered data repositories. Is it possible to migrate our data to the new cluster?

What would be the procedure?

 

Environment

Release : 3.7

Component : IM Reporting / Admin / Configuration

Cause

Vertica database move from single to multiple node cluster for increased availability

Resolution

a) Back up the existing single-node database
b) Create a new node with the valid IP and/or hostname
c) restore the database on the new single node instance
d) then add the two nodes to this new instance

Follow the below-mentioned document to add new nodes

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/performance-management/3-7/administrating/data-repository-administration/add-a-node-to-the-data-repository-cluster.html