CI/CD with two env on Vertica

acrespi

Hi all,
I'm looking for some stuff regarding continuous integration and continuous delivery with two environments on Vertica. Are there any guide could help me?

Regarding DDL and schema speaking, we'll want to use some db migrations software like Flyway + Jenkins.

My biggest worry is about the data, unfortunately we haven't got any pipeline on test environment and the only solution is to bring the data from production every random time, are there any suggestion to achieve this process? keep in mind we are speaking 20+ peta of data.

Thank you

Jim_Knicely

One option is Vertica Replication.

Doc Page:
https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/ReplicatingtoanAlternateCluster.htm

SruthiA

Another option is CopyCluster.. COPYCluster copies entire database including catalog. Please find the details on copy cluster and limitations of replication in the below link.

https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/CopyingTheDatabaseToAnotherCluster.htm
https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/ReplicatingtoanAlternateCluster.htm

siddyash

here is one more option with 3rd Party partner product - Attunity replicate:
https://www.vertica.com/kb/Attunity_Replicate_CDC/Content/Partner/Attunity_Replicate_CDC.htm

acrespi

Thank you for all of suggestions.
We will start to develop something with the Vertica replication, sounds good.
It works properly also on 9.2 version I suppose.
Of course a made an error it wasn't 20 peta but tera