是“Tomcat 7 JDBC连接池”吗？足够生产？它与BoneCP相比如何？ [英] Is "Tomcat 7 JDBC Connection Pool" good enough for production? And how is it compare to BoneCP?

问题描述

我们的网站每天大约获得1M PV，我们肯定会使用Tomcat。

Our site get roughly 1M pv/day, and we use Tomcat for sure.

我找不到有关jdbc-pool ，不确定它是否足够稳定以供生产。有人有经验吗？以及任何配置/调整内容供参考？

I couldn't find much information about jdbc-pool, not sure if it's stable enough for production. Anyone got experience on it? and any configuration/tuning stuff for reference?

正如有人提到的， BoneCP 可能是另一种选择。但似乎它已经停止了（太可悲了......）。这是一个更好的选择吗？

As someone mentioned, BoneCP might be another choice. But seems it's discontinued (so sad...). Would it be a better choice?

btw， HikariCP 也是年轻，我会密切关注它，因为它是我发现的最新/最快的CP。

btw, HikariCP is too young, I would keep an eye on it as it's the latest/fastest CP so far I found.

感谢您的任何建议。

推荐答案

我是HikariCP的作者之一。也就是说，新Tomcat池是我们测试过的最好的。它有很多选项，所以如果你打算在生产中使用它，请确保你理解它们以获得可靠的配置。

I'm one of the authors of HikariCP. That said, the "new" Tomcat pool is among the best we've tested. It has a lot of options, so if you plan to use it in production make sure you understand them to get a reliable configuration.

不要将新的Tomcat池与之混淆Apache DBCP，我会避免。

Do not confuse the new Tomcat pool with Apache DBCP, which I would avoid.

我们正在开始滥用测试各个池的过程，包括HikariCP，测试包括在池下弹跳DB并测量结果恢复。在接下来的几周内查看网站的结果。

We are starting the process of abuse testing various pools, including HikariCP, with tests such as bouncing the DB underneath the pool and measuring the resulting recovery. Check out site for results in the coming weeks.

编辑：回复：HikariCP太年轻了。年轻虽然可能已经有数十亿笔交易通过它。与任何事情一样，我建议您在部署前在预生产环境中进行尝试。但是对于您可能选择的任何池都是如此。

Re: HikariCP being too young. Young though it may be it has had several billion transactions run through it. As with anything, I would suggest you try it in a pre-production environment before deployment. But the same goes for any pool you might choose.

更新2015-06-01：我想稍微修改我的声明，似乎Apache Commons DBCP处于活动状态再一次，并接管了专用/分叉的Tomcat DBCP。 Commons DBCP中的重构乍一看似乎是重要的，也是积极的。然而，由于它们的规模，尽管在旧的Commons DBCP标题下，我认为该池的特征还不如HikariCP那么成熟。

UPDATE 2015-06-01: I want to revise my statement above somewhat, it seems that Apache Commons DBCP is active once again, and has taken over for the dedicated/forked Tomcat DBCP. The refactors in Commons DBCP appear at first glance to be significant, and positive. However, due to their magnitude and despite being under the old Commons DBCP banner, I would characterize the pool as less mature than HikariCP at this point.

这篇关于是“Tomcat 7 JDBC连接池”吗？足够生产？它与BoneCP相比如何？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！