Page MenuHomePhabricator

Read existing WMF backup workflow documentation already in place relevant to the project
Closed, ResolvedPublic

Assigned To
Authored By
jcrespo
May 19 2021, 2:32 PM
Referenced Files
F34471985: Screenshot from 2021-05-27 15-06-46.png
May 27 2021, 1:09 PM
F34471984: Screenshot from 2021-05-27 15-07-52.png
May 27 2021, 1:09 PM
F34465973: Screenshot from 2021-05-24 13-08-35.png
May 24 2021, 11:26 AM
F34465982: Screenshot from 2021-05-24 13-20-21.png
May 24 2021, 11:26 AM
F34465979: Screenshot from 2021-05-24 13-07-48.png
May 24 2021, 11:26 AM
F34465974: Screenshot from 2021-05-24 13-07-20.png
May 24 2021, 11:26 AM
F34465977: Screenshot from 2021-05-24 13-07-37.png
May 24 2021, 11:26 AM
F34461317: image.png
May 20 2021, 8:11 AM

Description

A list of pointers:

Not all of these are super-relevant, but will help reading them to gather questions before tomorrow's demo.

Some pointers about design (not a priority for this project- functionality is more important!):

As everything we do and use is open source, it is ok to steal borrow and get inspired from other projects :-)

Event Timeline

Thank you @jcrespo
I have had a quick read of the database backups presentation
I think for our project, am I right in thinking that this is the database where the backup metadata is stored? (picture below)
For our demo we could discuss a bit about this data (how it's stored, where it's stored, schema, etc)

image.png (797×721 px, 231 KB)

am I right in thinking that this is the database where the backup metadata is stored? (picture below)

That's correct. The latest version will always live on: https://phabricator.wikimedia.org/diffusion/OSWB/browse/master/sql/dbbackups.sql

I will provide either a copy or a sanitized copy of the current db contents (I need to double check with security) for you to work with.

It is ok to require changes on wmfbackups repo (https://phabricator.wikimedia.org/diffusion/OSWB/) and its schema, but initially we would work with that + any new table needed. We should probably work on a dashboard with its own separate repository, that we should probably request soon.

Do you have any, even if temporary, suggestion for the name of the project to request a new code repo?

Thanks @jcrespo. Sounds good
Ah interesting, good thing I thought of a name yesterday. Let's call it Bernard for now (temporary name -- named after the Switzerland rescue dog)
I'm also open to suggestions as well :if the name is slightly confusing or if doesn't follow any existing codebase/wikimedia guidelines :D

Screenshot from 2021-05-27 15-06-46.png (756×2 px, 193 KB)

Screenshot from 2021-05-27 15-07-52.png (1×2 px, 276 KB)

This is the current (limited) dashboard on icinga: it is mostly green- there are recent backups fore everyone. But m5 grew a lot last week, so it is in a warning state.