Page MenuHomePhabricator

Prepare and check storage layer for diqwiktionary
Closed, ResolvedPublic

Description

The new wiki's visibility will be: Public.

Event Timeline

LSobanski triaged this task as Medium priority.Dec 17 2020, 12:55 PM
LSobanski moved this task from Triage to Blocked on the DBA board.
LSobanski added a subscriber: LSobanski.

Thanks, let us know when the database is created, so we can sanitize it.

Thanks, let us know when the database is created, so we can sanitize it.

That happened a while ago.

Mentioned in SAL (#wikimedia-operations) [2021-01-12T08:40:32Z] <marostegui> Sanitize bclwiktionary diqwiktionary niawiki niawiktionary diqwiktionary on db1124 db2094 db11154 T270280 T270276 T270414 T270410 T271261

Marostegui added subscribers: Bstorm, nskaggs, Marostegui.

Database sanitized, _p database created, and grants given to labsdbuser. check private data came back clean. I also tested the triggers with my user on this wiki and it was ok.
cloud-services-team please create the views on labsdb1009, 1010, 1011 and 1012. Also create them on the new hosts clouddb1016:3315, clouddb1020:3315

Bstorm claimed this task.

All set

MariaDB [diqwiktionary_p]> select * from page limit 2;
+---------+----------------+-----------------+-------------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+-----------+
| page_id | page_namespace | page_title      | page_restrictions | page_is_redirect | page_is_new | page_random    | page_touched   | page_links_updated | page_latest | page_len | page_content_model | page_lang |
+---------+----------------+-----------------+-------------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+-----------+
|       2 |              8 | Sitesupport-url |                   |                0 |           1 | 0.009106786615 | 20210111160933 | 20210111160933     |           2 |      110 | wikitext           | NULL      |
|     266 |             10 | Wt/bcl/t+       |                   |                0 |           0 | 0.174344369852 | 20210111221427 | 20210111223703     |        1684 |      414 | wikitext           | NULL      |
+---------+----------------+-----------------+-------------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+-----------+