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  ... 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?