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
Yes, HAProxy can be used. See http://www.tenfourty.com/tag/teiid/