JDBC Connection Load Balancing with Yellowfin
We are using yellowfin to connect to our Vertica database cluster but we are looking to implement some resiliency and load balancing in that connectivity.
We have three Vertica nodes and would like yellowfin to select one of those node to use when a query is issued, or at least when the connection pool is initiated.
Before we buy a load balancer and stick it between our yellowfin servers and vertica servers, is there anything in Yellowfin that supports JDBC connection load balancing. The following page from Vertica suggests how this is used, but I'm assuming that this is something that yellowfin would have to implement (as yellowfin is the "client")
On a second point I assume if there is no JDBC load balancing in Yellowfin that placing a load balancer between yellowfin and Vertica is OK?