Is there any way we can send services like RDS data to prometheus

Kindly let me know Is there any way we can send services like RDS data to prometheus

There are two ways that I can think of:

  1. Run mysql exporter on some host or container or kube pod that queries the RDS host each time prometheus scrapes. Requires user/pass to exist on the RDS server for the mysql exporter to connect and query stats.
  2. Run cloudwatch exporter that queries RDS stats from CloudWatch. But only do this if you want a VERY LARGE AWS BILL at the end of each month.

In #1 you are querying the data directly from RDS mysql instances and storing them in promtheus time-data series. In #2 you are querying the data from CloudWatch (which also brings a 5+ minute time lag and expensive price tag…again NOT advised.)

If you have multiple RDS instances you want monitored, in kube I would just launch multiple pods, each configured with labels for prometheus to scrape, but each pod is configured to query a different RDS instance. You would want to somehow tie the pod name to the RDS instance you are querying.

ALL OF THIS IS UNTESTED.