Page MenuHomePhabricator

Prepare and check storage layer for wawikisource
Closed, ResolvedPublic

Description

The new wiki's visibility will be: Public.

Event Timeline

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

LSobanski triaged this task as Medium priority.Dec 7 2020, 11:32 AM
LSobanski moved this task from Triage to Blocked on the DBA board.

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

DB just got created.

Marostegui moved this task from Blocked to In progress on the DBA board.

This has been sanitized. I have tested the triggers creating my user.
I am now running a check data on labsdb1009, 1010, 1011, 1012 as well as clouddb1020:3315 and clouddb1016:3315

After that still pending:

  • _p database creation
  • grants for labsdbuser role for that database.
  • Private data check was clean
  • _p database created
  • Grants added
*****labsdb1009*****
Database (wawikisource%)
wawikisource
wawikisource_p
GRANT SELECT, SHOW VIEW ON `wawikisource\\_p`.* TO 'labsdbuser'
*****labsdb1010*****
Database (wawikisource%)
wawikisource
wawikisource_p
GRANT SELECT, SHOW VIEW ON `wawikisource\\_p`.* TO 'labsdbuser'
*****labsdb1011*****
Database (wawikisource%)
wawikisource
wawikisource_p
GRANT SELECT, SHOW VIEW ON `wawikisource\\_p`.* TO 'labsdbuser'
*****labsdb1012*****
Database (wawikisource%)
wawikisource
wawikisource_p
GRANT SELECT, SHOW VIEW ON `wawikisource\\_p`.* TO 'labsdbuser'
*****clouddb1016:3315*****
Database (wawikisource%)
wawikisource
wawikisource_p
GRANT SELECT, SHOW VIEW ON `wawikisource\\_p`.* TO `labsdbuser`
*****clouddb1020:3315*****
Database (wawikisource%)
wawikisource
wawikisource_p
GRANT SELECT, SHOW VIEW ON `wawikisource\\_p`.* TO `labsdbuser`

This is ready for cloud-services-team

Marostegui moved this task from In progress to Done on the DBA board.
Marostegui added a subscriber: Marostegui.

Reminder, the views need to be created on the new hosts too, so this would be:

labsdb1009 labsdb1010 labsdb1011 labsdb1012 clouddb1016:3315 clouddb1020:3315

@nskaggs this wiki needs the views too - pinging in case it was missed as there was a bunch of new wiki related tickets lately

Bstorm claimed this task.

This is done.

MariaDB [wawikisource_p]> select page_id,page_namespace,page_title from page limit 2;
+---------+----------------+---------------------------------------+
| page_id | page_namespace | page_title                            |
+---------+----------------+---------------------------------------+
|      11 |              0 | 45_noveles_ey_ene_binde_d_imådjes    |
|      16 |              0 | A-propos                              |
+---------+----------------+---------------------------------------+
2 rows in set (0.01 sec)