Implement database connection pool monitoring in Centreon

[Wajih Zouaoui]

Hello dear community,

please i want to ask if it's doable to implement a monitoring system for the database connection pool in Centreon ?

We are using the built in tool in Jira but we need to add something similar to our dashboards in Centreon .

Thank you in advance.

Best Regards,

Wajih

[meliodas16 · Accepted solution]

Hello @Wajih Zouaoui

In order to be able to monitor the DB connection pool via Centreon, you should use the jvm agent required by Centreon : https://jolokia.org/agent/jvm.html. 

You can download the JVM-Agent listed here : https://jolokia.org/download.html.

Once done, add the following argument to Jira startup arguments and restart Jira : 

-javaagent:<full-path-to-jvm-jollokia-jar>=port=8778

To test if it's functioning you can access:  server-ip:8778/jolokia/

To have the number of idle/active connection :

• NumActive:

http://127.0.0.1:8778/jolokia/read/com.atlassian.jira:type=metrics,category00=db,category01=connection,category02=pool,category03=numActive,name=valuection pool,

• NumIdle:

http://127.0.0.1:8778/jolokia/read/com.atlassian.jira:type=metrics,category00=db,category01=connection,category02=pool,category03=numIdle,name=value

Don't forget to adjust the 127.0.0.1 to your current ip/hostname/domain.

To have the connection set-up on Centreon, please follow this doc: https://docs.centreon.com/pp/integrations/plugin-packs/procedures/applications-jvm-jmx/

Hope it helps !

Kind regards.

[Wajih Zouaoui]

Hello @meliodas16 ,

thank you a lot for your reply, i really appreciated that.

So if i'm really understanding that this agent can use the jmx already exposed like dbconns, users, projects  and it can be linked to Centreon ? is there any documentaions with the full links with other metric slike you have mentioned above ( ex:  com.atlassian.jira:type=metrics,category00=db,category01=connection,category02=pool,category03=numIdle,name=value )

Best Regards,

Wajih

[Wajih Zouaoui]

I think i found it here https://confluence.atlassian.com/adminjiraserver0820/live-monitoring-using-the-jmx-interface-1095777569.html  

Thank you again and much respect for your help

Best Regards,

Wajih

[Wajih Zouaoui]

One more question please, if we have a cluster with multi nodes, do we need to install the agent only in 1 node ?