Page MenuHomePhabricator

Prepare and check storage layer for bclwiktionary
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.

Wiki was created.

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.

This is done.

MariaDB [bclwiktionary_p]> select page_id,page_namespace,page_title from page limit 2;
+---------+----------------+---------------------+
| page_id | page_namespace | page_title          |
+---------+----------------+---------------------+
|     606 |              0 | A                   |
|     607 |              0 | ABS-CBN_Corporation |
+---------+----------------+---------------------+
2 rows in set (0.00 sec)