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:
- 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.
- 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.