The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Regarding Copy cluster & Rebalancing
hsaxena20
Community Edition User
We have approx 2TB of data and we want to add 5 nodes in our cluster.
The existing cluster has 3 nodes.
Please suggest it is good to use copy cluster or we can add 5 node to existing cluster and rebalance it and then remove the 3 exsiting node to make the 5 node cluster.
Our goal is to make the 5 node cluster.
0
Answers
Hi,
The copy cluster feature requries that the source and destination cluster have the same number of nodes.
See:
https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/CopyingTheDatabaseToAnotherCluster.htm
2 TB isn't a whole lot of data to copy. I'd look into the Import/Export feature as a solution!
See:
https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/AdministratorsGuide/CopyExportData/CopyingAndExportingData.htm
So you can stand up your 5 node cluster indepentanly of the 3 node, then migrate the data from the 3 node cluster, then shutdown the 3 node cluster once your sure you've moved all of the data successfully.
Hi,
If you want to replace the 3 node cluster with a 5 node new cluster, you can set up a 3 node new cluster with the new machines, do a copy cluster from old to new and then extend the new one to 5. That way you can migrate all the users, grants and any specific configurations...
If you want to also go to a newer version with this migration then maybe you can use the COPY FROM VERTICA option as suggested by Jim.
Kind regards