Page MenuHomePhabricator

Refactor prometheus-mysqld-exporter to support multi-instance hosts
Closed, ResolvedPublic

Description

Allow for several instances of the exporter running at the same time, monitoring several different mysql instances:

  • Create prometheus-mysqld-exporter@ systemd unit
  • Configure each instance with its own title, port and socket to connect to
  • Implement passwordless socket authentication for the exporter on mysql servers
  • Move to mysql port + 10000 as a listening port (ferm changes?)
  • Generate instance list to be monitored automatically from exported resources

Event Timeline

Change 364396 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] [WIP]prometheus: Convert mysqld-exporter into multi-instance

https://gerrit.wikimedia.org/r/364396

Change 364396 merged by Jcrespo:
[operations/puppet@production] prometheus: Convert mysqld-exporter into multi-instance

https://gerrit.wikimedia.org/r/364396

Change 367408 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] prometheus-mysqld-exporter: Fix dependencies and not auto-start

https://gerrit.wikimedia.org/r/367408

Change 367408 merged by Jcrespo:
[operations/puppet@production] prometheus-mysqld-exporter: Fix dependencies and not auto-start

https://gerrit.wikimedia.org/r/367408

Change 367419 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] prometheus-mysqld-exporter: Fix parameter problems

https://gerrit.wikimedia.org/r/367419

Change 367419 merged by Jcrespo:
[operations/puppet@production] prometheus-mysqld-exporter: Fix parameter problems

https://gerrit.wikimedia.org/r/367419

jcrespo renamed this task from Refactor prometheus-mysqld-exported to support multi-instance hosts to Refactor prometheus-mysqld-exporter to support multi-instance hosts.Jul 25 2017, 10:25 AM

This is now technically done, missing "only" the refactor of all previous instances into the new model, and the automatic label creation.

Change 367660 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] prometheus-mysqld-exporter: Classify dbstores, now they can shard

https://gerrit.wikimedia.org/r/367660

Change 367660 merged by Jcrespo:
[operations/puppet@production] prometheus-mysqld-exporter: Classify dbstores, now they can shard

https://gerrit.wikimedia.org/r/367660

This is done except Generate instance list to be monitored automatically from exported resources, which will be separated on its own task.