Page MenuHomePhabricator

Prepare and check storage layer for bclwiktionary
Closed, ResolvedPublic

Description

The new wiki's visibility will be: Public.

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptDec 16 2020, 12:48 PM
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 moved this task from Blocked to In progress on the DBA board.Tue, Jan 12, 8:38 AM
Marostegui moved this task from In progress to Done on the DBA board.Tue, Jan 12, 9:43 AM
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 moved this task from Backlog to Wiki replicas on the Data-Services board.
Bstorm moved this task from Inbox to Clinic Duty on the cloud-services-team (Kanban) board.
Bstorm closed this task as Resolved.Fri, Jan 15, 10:20 PM
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)