Page MenuHomePhabricator
Create Task
Maniphest T155116

Develop a backup strategy for campaigns/tasks/labels
Closed, ResolvedPublic
Actions

Description

Currently, backups are done manually. Labs should have a real backup solution, but for now, we need a real backup solution.

Related Objects

Event Timeline

Halfak created this task.Jan 11 2017, 8:03 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJan 11 2017, 8:03 PM
Halfak updated the task description. (Show Details)Jan 19 2017, 3:27 PM

Related: T56401: Backups systems for userDBs hosted on replicas

Halfak added a comment.Jan 19 2017, 3:29 PM

If the postgres server had it's own backup scheme, that'd be fine.

Halfak triaged this task as Medium priority.Jan 19 2017, 3:30 PM
Halfak moved this task from Unsorted to Maintenance/cleanup on the Machine-Learning-Team board.
Ladsgroup claimed this task.Dec 3 2017, 12:39 PM
Ladsgroup edited projects, added Machine-Learning-Team (Active Tasks); removed Machine-Learning-Team.
Restricted Application added a project: User-Ladsgroup. · View Herald TranscriptDec 3 2017, 12:39 PM
Ladsgroup added a comment.Dec 18 2017, 12:16 PM

Okay I made wikilabels-dumps.wmflabs.org/psql_dumps/ and documented the steps in https://wikitech.wikimedia.org/wiki/Nova_Resource:Wikilabels/Backups. I'd love to see a puppetized node but that might be too much work for too little gain.

What do you think?

Ladsgroup moved this task from Parked to Review on the Machine-Learning-Team (Active Tasks) board.Dec 18 2017, 12:16 PM
Halfak added a subscriber: Andrew.Dec 19 2017, 4:35 PM

I think this is done when we can confirm that wikilabels-dumps is on different physical hardware than the postgres server. @Andrew could probably help us with that.

Ladsgroup moved this task from Incoming to Blocked on others on the User-Ladsgroup board.Dec 28 2017, 11:08 PM
awight subscribed.EditedJan 23 2018, 5:38 PM

ping @Andrew
We need help mapping hosts to physical hardware. Can you confirm that these two instances are on separate hardware?
wikilabels-backups.wikilabels.eqiad.wmflabs
and
pgsql.eqiad.wmnet

I'm 99% sure just because one is labs and the other production, but please let us know.

Ladsgroup added a comment.Jan 23 2018, 5:45 PM

pgsql.eqiad.wmnet is an alias for labsdb1004.eqiad.wmnet which some sorta is in labs. Not knowing this fact actually wasted lots of my time a while ago.

Andrew added a comment.Jan 24 2018, 5:00 PM

wikilabels-backup is a VM, currently (but not permanently) hosted on labvirt1015. pgsql.eqiad.wmnet is, as Ladsgroup says, a cname for labsdb1004. So they are definitely on different hardware but are in the same datacenter.

Ladsgroup moved this task from Review to Completed on the Machine-Learning-Team (Active Tasks) board.Jan 24 2018, 10:54 PM
awight mentioned this in Blog Post: Status Update (January 30, 2018).Jan 30 2018, 7:03 PM
Halfak closed this task as Resolved.Jan 30 2018, 8:32 PM
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 · Credits