Vertica database migration from single node to multiple node cluster
Article ID: 186777
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
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
Feedback
Yes
No
Powered by
