Help copying the Database to Another Cluster
We have two 10 nodes Vertica environments (version 7.1.1-10). One is production and the other one is for DR.
I want to duplicate the production environment to the DR site.
The DR site was our DEV site, in time the environment became not updated any more (data and structure).
I know there are several ways, what do you think about those two ways:
1. CopyCluser, using vbr.py utility.
2. copy_vertica_database.sh script.
Can anyone recommend on one way than another?
What are the different between those two ways? What is better?
We have differences between the names of the nodes in the two environments (prod environment: node-a1, node-a2, node-a3…. And in the DR environment: node-b1, node-b2, node-b3…), I know it's a problem for the CopyCluster, right?
And I don't know if it is a problem, but we have dbadmin user in booth environment but with a different password, it can be a problem?
Thanks for your help