[DISCUSS] CloudStack Connection Pools

2018-03-12 Thread Nicolas Vazquez
Hi all, I would like to introduce a topic for discussion, regarding DB connection pools used in CloudStack, currently Apache Commons DBCP 1.4 (http://commons.apache.org/) is used. I've been investigating this topic as we are having complains of random issues on MySQL connection pool on large

Re: [DISCUSS] CloudStack Connection Pools

2018-03-12 Thread Khosrow Moossavi
Hi Nicolas >From my past experiences, I prefer 1) HikariCP 2) Tomcat Pool 3) C3P0 4) DBCP in that order. Although I don't have any benchmark of my own to provide, and the ones you mentioned are really informative anyway. To me the broader subject is the _one_ who uses the pool, I mean if the tran