Regarding Copy cluster & Rebalancing

hsaxena20

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.

Jim_Knicely

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.

chaima

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