maintenance: update exporters

[raelga]

Several of the current default exporters are quite old, and some of them are currently deprecated.

How?

By reviewing the latest available and maintained version of each exporter, applying any necessary changes to the dashboards, rules and other resources that may be affected.

Exporter	Defaulted version	Active?	Proposed version	URL
cloudwatch	v0.3.0	Yes	v0.16.0	prometheus/cloudwatch_exporter
manticore	6.2.13.0	Yes	6.3.2.0	manticoresoftware/manticoresearch-prometheus
mysql	v0.12.1	Yes	v0.16.0	prometheus/mysqld_exporter
probe	v0.22.0	Yes	v0.25.0	prometheus/blackbox_exporter
sendgrid	0.0.9	No	v0.0.10	chatwork/sendgrid-stats-exporter
es	justwatch/elasticsearch_exporter:1.1.0	No	quay.io/prometheuscommunity/elasticsearch-exporter:v1.8.0	prometheus/elasticsearch_exporter
memcached	v0.6.0	Yes	v0.15.0	prometheus/memcached_exporter
postgresql	wrouesnel/postgres_exporter:v0.8.0	No	quay.io/prometheuscommunity/postgres-exporter:v0.16.0	prometheus/postgres_exporter
redis	v1.44.0	Yes	v1.66.0	oliver006/redis_exporter
sphinx	master	Yes	v0.3.0	foxdalas/sphinx_exporter

Requirements

• [x] Review and test the cloudwatch exporter
• [x] Review and test the manticore exporter
• [ ] Review and test the mysql exporter
• [x] Review and test the probe exporter
• [x] Review and test the sendgrid exporter
• [ ] Review and test the es exporter
• [x] Review and test the memcached exporter
• [ ] Review and test the postgresql exporter
• [x] Review and test the redis exporter
• [x] Review and test the sphinx exporter

Acceptance Criteria

• [ ] Update the default cloudwatch exporter version
• [ ] Update the default manticore exporter version
• [ ] Update the default mysql exporter version
• [ ] Update the default probe exporter version
• [ ] Update the default sendgrid exporter version
• [ ] Update the default es exporter version
• [ ] Update the default memcached exporter version
• [ ] Update the default postgresql exporter version
• [ ] Update the default redis exporter version
• [ ] Update the default sphinx exporter version
• [ ] Make a new prometheus-exporter-operator release with the updated defaults

Notes

/kind feature /priority important-longterm /label size/l

[raelga]

• MySQL Exporter

time=2024-11-15T13:40:46.728Z level=ERROR source=config.go:141 msg="failed to validate config" section=client err="no user specified in section or parent" time=2024-11-15T13:40:46.728Z level=INFO source=mysqld_exporter.go:244 msg="Error parsing host config" file=.my.cnf err="no configuration found"

• PostgreSQL Exporter, complains but works

time=2024-11-15T13:36:14.018Z level=ERROR source=collector.go:201 msg="collector failed" name=wal duration_seconds=0.020048134 err="pq: permission denied for function pg_ls_waldir" time=2024-11-15T13:36:14.035Z level=ERROR source=collector.go:201 msg="collector failed" name=database duration_seconds=0.037425291 err="pq: permission denied for database rdsadmin" t