[jira] [Commented] (PHOENIX-2388) Support pooling Phoenix connections
[ https://issues.apache.org/jira/browse/PHOENIX-2388?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16358904#comment-16358904 ] James Taylor commented on PHOENIX-2388: --- A PhoenixConnection is meant to be lightweight enough to not require pooling. The underlying connection to the cluster (HConnection) is cached and shared across all PhoenixConnections for the same JVM (per cluster per principal). See https://phoenix.apache.org/#Connection. If you wanted to pool them, you'd need to make sure you clear any state on them when they are put back into the pool: - clear PMetaDataCache (client side cache) - remove any SCN (which was set on URL or through Properties) - remove the ConnectionQueryServices and re-instantiate (unless Properties and principal are the same) - reset tenantId to null - etc. - see member variables on PhoenixConnection I'm not sure there'd be any perf gain, hence it's never been done. If you're finding it expensive to create a new PhoenixConnection, it'd be good to profile this and fix any bottlenecks in the code. > Support pooling Phoenix connections > --- > > Key: PHOENIX-2388 > URL: https://issues.apache.org/jira/browse/PHOENIX-2388 > Project: Phoenix > Issue Type: Bug >Reporter: James Taylor >Priority: Major > Attachments: PHOENIX-2388.patch > > > Frequently user are plugging Phoenix into an ecosystem that pools > connections. It would be possible to implement a pooling mechanism for > Phoenix by creating a delegate Connection that instantiates a new Phoenix > connection when retrieved from the pool and then closes the connection when > returning it to the pool. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (PHOENIX-2388) Support pooling Phoenix connections
[ https://issues.apache.org/jira/browse/PHOENIX-2388?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16356735#comment-16356735 ] Ravichandran commented on PHOENIX-2388: --- [~jamestaylor]Does phoenix support connection pool ..? > Support pooling Phoenix connections > --- > > Key: PHOENIX-2388 > URL: https://issues.apache.org/jira/browse/PHOENIX-2388 > Project: Phoenix > Issue Type: Bug >Reporter: James Taylor >Priority: Major > Attachments: PHOENIX-2388.patch > > > Frequently user are plugging Phoenix into an ecosystem that pools > connections. It would be possible to implement a pooling mechanism for > Phoenix by creating a delegate Connection that instantiates a new Phoenix > connection when retrieved from the pool and then closes the connection when > returning it to the pool. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (PHOENIX-2388) Support pooling Phoenix connections
[ https://issues.apache.org/jira/browse/PHOENIX-2388?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16122707#comment-16122707 ] Jepson commented on PHOENIX-2388: - [~yhxx511] I am ready to patch this pacth code. Then, I'll get back to that later. > Support pooling Phoenix connections > --- > > Key: PHOENIX-2388 > URL: https://issues.apache.org/jira/browse/PHOENIX-2388 > Project: Phoenix > Issue Type: Bug >Reporter: James Taylor > Attachments: PHOENIX-2388.patch > > > Frequently user are plugging Phoenix into an ecosystem that pools > connections. It would be possible to implement a pooling mechanism for > Phoenix by creating a delegate Connection that instantiates a new Phoenix > connection when retrieved from the pool and then closes the connection when > returning it to the pool. -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (PHOENIX-2388) Support pooling Phoenix connections
[ https://issues.apache.org/jira/browse/PHOENIX-2388?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15867327#comment-15867327 ] William Yang commented on PHOENIX-2388: --- Anyone have time to have a look at this? What else shall we implement? > Support pooling Phoenix connections > --- > > Key: PHOENIX-2388 > URL: https://issues.apache.org/jira/browse/PHOENIX-2388 > Project: Phoenix > Issue Type: Bug >Reporter: James Taylor > Attachments: PHOENIX-2388.patch > > > Frequently user are plugging Phoenix into an ecosystem that pools > connections. It would be possible to implement a pooling mechanism for > Phoenix by creating a delegate Connection that instantiates a new Phoenix > connection when retrieved from the pool and then closes the connection when > returning it to the pool. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
