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 subscribed.

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

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      |
+---------+----------------+-----------------+-------------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+-----------+