[teiid-issues] [JBoss JIRA] (TEIID-5415) Simplify connection handling
Steven Hawkins (JIRA)
issues at jboss.org
Thu Jul 12 11:47:00 EDT 2018
Steven Hawkins created TEIID-5415:
-------------------------------------
Summary: Simplify connection handling
Key: TEIID-5415
URL: https://issues.jboss.org/browse/TEIID-5415
Project: Teiid
Issue Type: Quality Risk
Components: JDBC Driver
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 11.x
With the removal of TEIID-5411 we can further simplify our notion of connection handling. The current logic maintains a set of logins for known server instances under one logical connection. When a connection is returned to an XA pool (or the client issues special sql) the logical connection will select a new instance using a cached login if possible.
The benefits of the current approach are:
* works just from the hosts listed in the url
* works with XA connection pooling or connection pooling in general with additional setup to provide simple load balancing
The drawbacks are:
* creates a set of logins which may mostly sit idle
* is not load balancer aware - for example when just a load balanced end point is used. And the load balancing is just random, not intelligent.
* requires the client to keep a pool of physical connections
A proposal would be to keep multiple url failover, but removal all of the logic related to maintaining multiple logins under a logical connection.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
More information about the teiid-issues
mailing list