Implement database connection pool monitoring in Centreon

Wajih Zouaoui_t5pzgx

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

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.