DB-backed storage service: testing database pool status?

[Cantor, Scott]

On 8/28/14, 11:51 AM, "Wessel, Keith" <kwessel at illinois.edu> wrote:

>I was planning on adding some validation parameters. Right now, my setup
>is truly minimal.

You definitely need some stuff to make pooling work. With dbcp, I've
generally used the validate on get model, I think, and a validation query.
I'll double check my settings. But I only use this now with MySQL local to
the box, so it's not much of a risky scenario.

>As for what type of pooling, I'm not sure exactly what you're asking
>there. Let me try to answer that: it's  a container resource that looks
>like:
><Resource name="jdbc/idp"
>Auth="Container"
>Type="javax.sql.DataSource"
>. />
>In addition, it has my Oracle driver, connection params, and a maxWait of
>10,000 ms.

That means you're not pooling, or you're using something from Oracle
inside the driver, and it's probably broken. You want to wrap that driver
in a dbcp data source object. I'll post what I use when I have a chance.

>I'm planning to add a validation query. I suspect that'll do the trick,
>but it'd certainly be good to monitor it somehow. Maybe Scott's right and
>we should just have the SLBs and service monitoring perform a full login.

I would think you'd want that anyway, for monitoring at least. webisoget
is your friend. I don't have the SLBs doing much other than an HTTP GET at
this point though.

-- Scott