Liveness checking for DB

[susanta-mukhopadhyay]

How are we checking liveness of database? Do we have any implementation for that?

[thadguidry]

Most monitoring solutions (Sensu, Nagios, etc.) do a DB liveness check by simply attempting a login connect to the DB with blunt "user=user ; password=pass".
Example: https://github.com/sensu-plugins/sensu-plugins-postgres/blob/master/bin/check-postgres-alive.rb

But liveness check is not the only thing often needed in monitoring a DB (locks, stats, replication, dbsize, connections, are often needed to be quickly checked or looked at when slow queries or long timeouts start occurring).

But DB monitoring itself is not something DB2Rest concerns itself about or should. That's for other open-source monitoring solutions to provide and already do quite well.

[susanta-mukhopadhyay]

Yes, true, DB monitoring may be separate concern. I was thinking of we only have some mechanism to check whether application would not hang-up due to unavailability of DB.

[kdhrubo]

DB2REST actuator should show the metrics related to database. Hikari may provide additional checks as part of configuration

…

On Sun, Dec 22, 2024, 11:42 PM Thad Guidry ***@***.***> wrote: Most monitoring solutions (Sensu, Nagios, etc.) do a DB liveness check by simply attempting a login connect to the DB with blunt "user=user ; password=pass". Example: https://github.com/sensu-plugins/sensu-plugins-postgres/blob/master/bin/check-postgres-alive.rb But liveness check is not the only thing often needed in monitoring a DB (locks, stats, replication, dbsize, connections, are often needed to be quickly checked or looked at when slow queries or long timeouts start occurring). But DB monitoring itself is not something DB2Rest concerns itself about or should. That's for other open-source monitoring solutions to provide and already do quite well. — Reply to this email directly, view it on GitHub <#837 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAISPRA25FV7362DNBDLWR32G6PDXAVCNFSM6AAAAABUCNC7FSVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCNRUG4YDKMI> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[susanta-mukhopadhyay]

Yes, I think Hikari supports timeout to check DB. If it is configured, it will prevent hang-up of the application.

[kdhrubo]

It will error out. As pool will complain

…

On Mon, Dec 23, 2024, 12:40 AM Susant (Susanta Mukhopadhyay) < ***@***.***> wrote: Yes, true, DB monitoring may be separate concern. I was thinking of we only have some mechanism to check whether application would not hang-up due to unavailability of DB. — Reply to this email directly, view it on GitHub <#837 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAISPRDL54GCXQO5UBK6QTD2G6V4TAVCNFSM6AAAAABUCNC7FSVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCNRUG4ZTKOA> . You are receiving this because you commented.Message ID: ***@***.***>

[kdhrubo]

Closing this as actuator is turned on.