Implement DB Health checks with scheduled triggers

[mvkrishna86]

Is your feature request related to a problem? Please describe. For the scheduled triggers, probably we can add the DB checks like, whether mongodb is reachable and execute a sample query with configured credentials. If its failed or taking more time, then send a notification. Same goes with postgres, mysql, elasticsearch, kafka, etc.

[aantn]

It's a cool idea - I like it.

Ideally we'd find an example that is annoying/impossible to do with liveness checks and/or Prometheus alerts.

Alternatively, we can take an existing Prometheus alert for something like this and add an enricher to make the alert more informative and actionable.

Any ideas?

[kitarp29]

Hi @aantn I would love to take on this issue. I think Prometheus alerts will be a good way to go in this.

[aantn]

Cool, thank you! @mvkrishna86 is there a specific Prometheus alert that @kitarp29 can work on enriching via Robusta?