Load Balancing in DBeaver/MS ODBC

I am trying to set up Load Balancer.  I made the server change, but am unable to get this to work in either DBeaver or using a MS ODBC

In DBeaver I added a user setting ConnectionLoadBalance with a value of 1 and am not seeing where to add that in  ODBC.

Has anyone gotten this to work?

Comments

  • 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
  • Navin_CNavin_C Vertica Customer
    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

  • Navin_CNavin_C Vertica Customer

    Thanks Mitch,

    That worked. :)

Leave a Comment

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