+1We 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.
+2Hi,
The copy cluster feature requries that the source and destination cluster have the same number of nodes.
2 TB isn't a whole lot of data to copy. I'd look into the Import/Export feature as a solution!
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.
+2Hi,
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
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
