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?




Leave a Comment

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