Load Balancing in DBeaver/MS ODBC

Hi John,

I take it you are trying to set up the Native Load Balancer provided with the Vertica 7.0 client drivers. Can you confirm that you can connect to the DB without using the load balancer?

It sounds like you have the correct parameter set in your JDBC settings in DBeaver.

For an ODBC connection, you will want to add the same line to your DSN entry or connection string. You can find more info on this feature here in the documentation:

https://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/AdministratorsGuide/LoadBalancing/Enablin...

- Mitch

Hi Mitch ,

I am bit unclear on this.
I have implemented the setting in my ADO.NET Driver, but I want the Load Balancing to be active using my Squirrel SQL IDE.

I tried to find some driver settings to set this property, but it seems it just ask for driver,url,class,username and password 

Any method to implement this for SQL IDE's

Hi Navin,

Good to hear you are using the Native Load Balancer! In SQuirreL, which uses JDBC, you will need to enable the "connectionloadbalance" driver property in Driver Properties tab of the Alias properties window. You will see a list of supported properties, simply check the "specify" box and enter true in the value field.

Once this is done, you should be able to make multiple connections to the DB and use the following query to see which node you are being connected to:

SELECT NODE_NAME FROM V_MONITOR.CURRENT_SESSION;

- Mitch

Thanks Mitch,

That worked.