monitoring database connection pool

[Avner Sternheim]

Hi,

I would like to know how can I monitor database connection pool in microprofile ?

Since not all of the implementors support JMX. 

any ideas?

thanks,

Avner

[Don Bourne]

Hi Avner,

Database connection pool metrics are not part of the MicroProfile Metrics spec, but implementers are free to provide vendor metrics to help you monitor your connection pools.

As an example, see the vendor_connectionpool_* metrics from Open Liberty at https://openliberty.io/docs/ref/general/#metrics-catalog.html

Like any other MicroProfile Metric, you can query the current vendor metrics by calling the /metrics endpoint on your MicroProfile Metrics enabled server.

Regards,

Don

[Rudy De Busscher]

Hi Avner,

Another reason why there are no Metrics for connection Pool is also that MicroProfile has no spec related to Connection Pools.

As mentioned by Don, several vendors have a solution in there implementation like Payara where you can expose any JMX value through the metrics endpoint (https://blog.payara.fish/expose-jxm-bean-values-through-microprofile-metrics)

Regards

Rudy

[Avner Sternheim]

Thank you, but is there a spec to support JMX? and if not, why? 

[Rudy De Busscher]

I guess because remote JMX is not HTTP friendly.

[Alasdair Nottingham]

We build an http based connector for JMX in Open Liberty. 

Alasdair Nottingham

On Dec 19, 2019, at 5:48 AM, Rudy De Busscher <rdebu...@gmail.com> wrote:



--
You received this message because you are subscribed to the Google Groups "Eclipse MicroProfile" group.
To unsubscribe from this group and stop receiving emails from it, send an email to microprofile...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/microprofile/951ad656-ca22-48c8-9e39-97c9b4455dfd%40googlegroups.com.

[Markus Eisele]

Nobody ever heard about this little gem from Roland Huß?

It still works great. https://jolokia.org/

M

To view this discussion on the web visit https://groups.google.com/d/msgid/microprofile/897008C2-BE87-4190-93B7-8C29715C85AC%40gmail.com.

[John Clingan]

See the "Motiviation" section in the spec, which discussions the non-friendliness of remote JMX. In addition, MP Metrics includes metadata like Units and Description, not to mention an easy-to-use annotation-based developer API (influenced by Dropwizard).

I love that I can add a circuit-breaker Fault Tolerance annotation, and with the Fault Tolerance integration with the Metrics spec auto-generating metrics, quickly and easily graph it in Grafana with near zero effort. The specification integration is quite nice, IMHO.