Page MenuHomePhabricator

Setup database logical backups on eqiad
Closed, ResolvedPublic

Description

Mediawiki metadata databases work (using old hardware), taking copies from dbstore200[12] and storing them on es2001. This has full coverage of all s*, x* and m* hosts (except m4).

We should mirror that setup on eqiad. We are, at the moment, missing hardware, but at least 1 or 2 sections could be setup on dbstore1001 as a test, until hardware is available.

Event Timeline

jcrespo triaged this task as Medium priority.Apr 17 2018, 12:32 PM
jcrespo created this task.

Change 427100 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/mediawiki-config@master] mariadb: Depool db1067 for maintenance

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

I am going to setup s1 on dbstore1001.

Change 427100 merged by jenkins-bot:
[operations/mediawiki-config@master] mariadb: Depool db1067 for maintenance

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

Change 427114 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] mariadb: Add dbstore_multiinstance profile to dbstore1001

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

Change 427114 merged by Jcrespo:
[operations/puppet@production] mariadb: Add dbstore_multiinstance profile to dbstore1001

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

Change 427145 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] Add prometheus mysql s1 monitoring to dbstore1001

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

Change 427145 merged by Jcrespo:
[operations/puppet@production] Add prometheus mysql s1 monitoring to dbstore1001

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

Change 436235 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] mariadb-backups: Add misc eqiad missing backups from db1117

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

Change 436235 merged by Jcrespo:
[operations/puppet@production] mariadb-backups: Add misc eqiad missing backups from db1117

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

All misc hosts are backed up (except m4 and tendril), maybe some extra s* hosts could be done, too.

s1 is being backed up, resolving- we will setup the other sections when we have the hardware available.