Page MenuHomePhabricator
Create Task
Maniphest T145072

Generate instance list of active database hosts to be monitored from prometheus
Closed, ResolvedPublic
Actions

Description

Currently, this is manually maintained on puppet yaml on role/prometheus/files/*, it should be gathered on each mariadb host or instance from exported resources, or querying puppetdb.

Mediawiki configuration cannot be used because there are many databases that can be depooled, or not part of core (mw) databases. However, we should minimize duplication of listings: puppet (hiera), puppet-prometheus-role, dblists, mediawiki-config, tendril, etc

Probably this should live on zarcillo, without being a failure point.

Related Objects
Search...

Event Timeline

jcrespo created this task.Sep 8 2016, 12:38 PM
fgiunchedi mentioned this in T126757: test prometheus mysqld-exporter.Sep 13 2016, 9:45 AM
Dzahn triaged this task as Medium priority.Sep 22 2016, 2:37 AM
fgiunchedi added a comment.Mar 6 2017, 6:29 PM

Update from the monitoring meeting, this can be implemented via puppetdb queries, additionally there's now classes to generate Prometheus config files e.g. with all hosts having a specific class and parameters applied. prometheus::class_config

faidon added a project: observability.Jul 10 2017, 1:07 PM
• 1978Gage2001 moved this task from Triage to In progress on the DBA board.Dec 11 2017, 9:45 AM
• 1978Gage2001 moved this task from Triage to In progress on the DBA board.
• Marostegui moved this task from In progress to Triage on the DBA board.Dec 11 2017, 10:58 AM
jcrespo moved this task from Triage to Backlog on the DBA board.Oct 29 2018, 8:11 AM

I think this should be moved to zarcillo mariadb metadata database, and centralize there the active database control (substituting tendril, puppet, per-section lists and prometheus mysql exported list).

• Phabricator_maintenance moved this task from Backlog to Acknowledged on the SRE board.Jan 26 2019, 8:49 PM
fgiunchedi mentioned this in T177779: Generate instance list of database hosts to be monitored automatically from exported resources.Jun 5 2019, 10:01 AM
jcrespo renamed this task from Create a script to regenerate prometheus mysqld exporter listing that works with puppetdb to Generate instance list of active database hosts to be monitored from prometheus.Jun 5 2019, 10:03 AM
jcrespo merged a task: T177779: Generate instance list of database hosts to be monitored automatically from exported resources.
jcrespo updated the task description. (Show Details)
jcrespo added a subscriber: • Marostegui.
fgiunchedi closed this task as Resolved.Aug 19 2019, 2:03 PM
fgiunchedi claimed this task.

This happened in parent task!

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL