MIgrate data from Version 5 cluster to Version 7 cluster
We recently purchased new cluster in which we installed Vertica Version 7. We have an old cluster in Vertica Version 5.1 which we want to retire.
What is the best way to move data across two cluster. Note that copy cluster will not work since they are different version. The way we can think of is to download data as text files and move across the system. Is there a effecient or faster way of doing this.
What is the best way to move data across two cluster. Note that copy cluster will not work since they are different version. The way we can think of is to download data as text files and move across the system. Is there a effecient or faster way of doing this.
0
Comments
You can follow below strategy for this:
1. Upgrade your old cluster from
- HP Vertica 6.0 to 7.0
https://my.vertica.com/docs/6.1.x/HTML/index.htm#10461.htm2. Create a new cluster wit same number of nodes & install vertica 7.0 on that.
3. Then copy using copycluster from old cluster to new one, keeping in mind the prerequisites for copy cluster as described in below documentation.
https://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/AdministratorsGuide/BackupRestore/Copying...
I hope it will solve your purpose.
Regards'
Abhishek