Recommended Play/BoneCP settings

[Ben Developer]

I'm developing a website that will need to scale to ~100K simultaneous users with active DB queries. We code JDBC w/ MySQL. We manually open and close connections, so each connection is tightly held and short-lived. Our logs show ~5 to 20ms per connection, and all requests require a DB connection. 

What are the recommended settings for Play's BoneCP and why? It's difficult to understand their docs regarding partitions, idle age, etc.

Thanks!

[JP Melanson]

DB Pool configuration is environment/app specific, so I don't think there is such thing as "Play recommended settings"

Play's default settings are detailed pretty well here: https://www.playframework.com/documentation/2.3.x/SettingsJDBC

Do you have a more specific question?

As a starting point, I would advice finding how many simultaneous connections your production DB can support.

This depend largely on the dataset and the kind of queries you run.

If you already have a running production system, you can monitor it, otherwise, you'll have to guess from stress testing.

[virtualeyes]

Play should move to HikariCP, BoneCP is practically unmaintained at this point. At minimum development has ground to a halt. Perhaps it's stable enough, don't know, had a lot of issues with it last year in production prior to switching to 0.8.1-SNAPSHOT.

Meanwhile, Hikari is actively developed with a very much present author, insanely performant, and supports Java <= 8 . Given that Play 2.4 is targetting Java 8, it's probably worth giving it a thought since BoneCP + Java 8 aren't happening unless the author re-emerges.

2cents

[Megazord]

Tada!

http://edulify.github.io/play-hikaricp.edulify.com/

Here is a HikariCP plugin for Play. :-)

HTH

[virtualeyes]

Indeed, I know about the Hikari plugin options ;-)

Talking about making Hikari the default pool for Play >= 2.4

[naturallog]

+1 for making Hikari the default pool.

In fact, the author of bonecp was in this mailing list recommending to check out Hikari

https://groups.google.com/d/msg/play-framework/WaVh6IBMmZc/6-xXorrr80QJ

[virtualeyes]

Exactly, BoneCP author has as much as said, folks, don't have time for this project anymore (and github commit history backs this up), use Hikari.

Any Play devs around to chime in on this issue?

[Łukasz Śliwiński]

I copied your words to github play framework issue:

https://github.com/playframework/playframework/issues/2445

Look at comments.