1 Reply Latest reply on Dec 5, 2014 9:14 AM by Ramesh Reddy

    Server selection load balancing without using multiple hosts separated by comma

    Bruno Machado Newbie

      Is there any way to configure a load balancer from client to teiid server? I saw I could use multiple hosts separating them by comma jdbc:teiid:<vdb-name>@mm://host1:31000,host1:31001,host2:31000;version=2 [1] ... but if there are hundreds of clients it's not effective. When I add a new host it would be needed to update all clients with the new host.

       

      Maybe using a software load balancer in front of them, like HAProxy or something like it could be a way to reach this feature. Do you guys know any other way to do it?

       

      [1] Using Multiple Hosts - Teiid 8.9 - Project Documentation Editor