Vertica 30 second DR over multiple data centers

"..having nodes in 2 geographically dispersed data centers..."

Bad idea... Atleast for now.

Jim I am sure you know it is difficult to tell a customer who is buying our product "bad idea". They gave us a requirement of 30 second recovery from a DC failure and we must either say "Yes, Vertica can support that and here is how..." or we must say "I am sorry Vertica can not support 30 second recovery, but here is what we recommend for a Vertica architecture to support the fastest Disaster Recovery possible..." Either way I need some help from a Vertica expert who knows - thanks! And - feel free to contact me outside this forum if you wish.

I disagree. We are supposed to be trusted advisors. We can deploy a Vertica Cluster anywhere, but the nodes should be network near one another...

Can you have the a Vertica DB nodes be anywhere? Sure.

We have a "smart' client that deployed Vertica across data centers.

Allot of support cases followed…

Bad idea.

OK Jim I guess you are leaving me with "I am sorry Vertica can not support 30 second recovery across DCs" and will tell them the best DR alternative that ITOM can provide is to use vbr as in https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/CopyingTheDatabaseToAnotherCluster.htm

You can have millisecond fail over with dual load... What database offers 30 second failover? Oh, the one that is already running a DR for you and charging you for it behind the scenes? Vertica can do that with replication for free (well less, infrastructure).

Jim if you are aware that ITOM OPTIC supports dual-load across multiple Verticas, PLEASE do let me know there is no documentation on that. The OPTIC/COSO uses a microbatch loader with attached pulsar UDX library.

Aside from that, I am confused by your "replication for free" comment can you please explain? Please keep in mind I am not arguing with you, nor am I going to argue with the customer's stated requirement - I just need to know how to best reply to them. I am trying to learn from you and represent Vertica in the best possible light.

Check out:

Replicating Objects to an Alternate Cluster

I am not sure if "ITOM OPTIC supports dual-load across multiple Verticas". But if using replication, that wouldn't be an issue as the Database itself is "kind of" doing the dual load for you.

FYI I have confirmed that the DR process for ITOM (documented for OpsB at https://docs.microfocus.com/itom/Containerized_Operations_Bridge:2021.05/ConfigureDisasterRecovery ) involves the customer implementing some scripts that end up executing /opt/vertica/bin/vbr.py --task replicate via crontab on a regular basis. The OPTIC ingestion requires many other steps to switch over in the case of DR, but the underlying standby DB sync does use the built-in functions.