Description
Details
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Duplicate | None | T237771 Make Wikitech a normal wiki | |||
| Duplicate | None | T237772 Move Wikitech's database off of M5 and onto a normal production wiki DB server | |||
| Declined | None | T171570 Rename database 'labswiki' to 'wikitechwiki' | |||
| Resolved | Milimetric | T217792 Add wikitech (labswiki) to the sqoop list | |||
| Resolved | • Marostegui | T167973 Move database for wikitech (labswiki) to a main cluster section | |||
| Resolved | Andrew | T188029 Move labswiki database to m5 | |||
| Resolved | • Marostegui | T282074 Audit labswiki grants | |||
| Resolved | Andrew | T282209 Enable connection from labweb1001/labweb1002 to s6 | |||
| Declined | Andrew | T282573 Move labweb/cloudweb hosts to private IPs | |||
| Resolved | Andrew | T284106 Replicate & sanitize wikitech data | |||
| Resolved | Andrew | T284108 Bring labswiki database tables up to date | |||
| Resolved | Ladsgroup | T269348 wikitech database has almost all of its varbinary fields wrong | |||
| Duplicate | None | T284736 Create views on labswiki on clouddb* hosts | |||
| Resolved | • Bstorm | T287442 Create views for labswiki (wikitech) |
Event Timeline
Future us: this parent/child graph is backwards, the blocking task of moving wikitech to a normal DB cluster is not done.
Oh! Thanks for the reminder, this is now available but not included in the sqoop lists. I'll make a patch, easy enough. labswiki seems to be available in both the analytics replicas and cloud replicas (as labswiki_p in the latter)
Change #1058175 had a related patch set uploaded (by Milimetric; author: Milimetric):
[analytics/refinery@master] Add labswiki (wikitech) to the sqoop list
@VirginiaPoundstone adding this to our sprint because it's basically a no-op and an easy resolution to an old task.
Change #1058175 merged by Milimetric:
[analytics/refinery@master] Add labswiki (wikitech) to the sqoop list
Change #1075238 had a related patch set uploaded (by Joal; author: Joal):
[operations/puppet@production] Remove labswiki from HDFS imported dumps
Change #1075238 merged by Ottomata:
[operations/puppet@production] Remove labswiki from HDFS imported dumps
Now that labswiki is a normal database, on the s6 section, are we able to start dumping it, as per all of the other databases?
It looks like it has been excluded from dumps here: https://github.com/wikimedia/operations-puppet/blob/production/modules/snapshot/manifests/dumps/dblists.pp#L18
If we did that, then we wouldn't have to exclude it from the list of dumps imported to HDFS here: https://gerrit.wikimedia.org/r/c/operations/puppet/+/1075238