Cross-site Failover Using the Backup Host List

We have 2 Vertica clusters in 2 faraway locations to provide disaster recovery for each other. Data sync is achieved by dual-loading.

 

I understand that the JDBC connection failover mechanism is meant to allow failover between nodes within a cluster. However, if we let native connection load balancing to take care of failover/load balancing within a cluster, we might use the backup host list to provide a way to fail over between the 2 clusters.

 

So my questions are:

 

1. Is it advisable to use backup host list to allow client applications to fail over automatically between 2 faraway clusters?

2. If not, is there any other recommended way to achieve this goal?

 

Thanks,

Brian

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file