Page MenuHomePhabricator

Setup database on tendril hosts to gather backup statistics
Closed, ResolvedPublic

Description

We will setup an experimental mysql instance alongside tendril, initially to store database backup statistics. This is mostly experimentation needed to have clear the requirements and main blockers of the goal. However, it could also become in the future a source of truth for other tasks, out of the backup scope.

The relationship with prometheus is not yet clear- but this doesn't discard the usage of prometheus entirely, but just complement it (mysql being used to control the current state and prometheus, gather historical statistics?).

Event Timeline

jcrespo triaged this task as Medium priority.Jul 6 2018, 7:27 AM
jcrespo created this task.

Change 444160 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] mariadb: Add new instance to tendril to store statistics

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

Change 444160 abandoned by Jcrespo:
mariadb: Add new instance to tendril to store statistics

Reason:
This doesn't work

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

Change 444177 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] mariadb: Increase buffer pool size of tendril

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

Change 444177 merged by Jcrespo:
[operations/puppet@production] mariadb: Increase buffer pool size of tendril

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

jcrespo claimed this task.

Finally it is being worked on the same instances as tendril.