Skip to main content
Question

CI/CD with two env on Vertica

  • August 11, 2020
  • 4 replies
  • 14 views

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

4 replies

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • August 11, 2020

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • August 11, 2020

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
Forum|alt.badge.img
  • Participating Frequently
  • August 11, 2020

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
  • Author
  • New Participant
  • September 2, 2020

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 ;)