Page MenuHomePhabricator

Prepare and check storage layer for skrwiktionary
Closed, ResolvedPublic

Description

The new wiki's visibility will be: Public.

Event Timeline

LSobanski triaged this task as Medium priority.Nov 24 2020, 12:46 PM
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.

And this one got created as well.

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 (skrwiktionary%)
skrwiktionary
skrwiktionary_p
GRANT SELECT, SHOW VIEW ON `skrwiktionary\\_p`.* TO 'labsdbuser'
*****labsdb1010*****
Database (skrwiktionary%)
skrwiktionary
skrwiktionary_p
GRANT SELECT, SHOW VIEW ON `skrwiktionary\\_p`.* TO 'labsdbuser'
*****labsdb1011*****
Database (skrwiktionary%)
skrwiktionary
skrwiktionary_p
GRANT SELECT, SHOW VIEW ON `skrwiktionary\\_p`.* TO 'labsdbuser'
*****labsdb1012*****
Database (skrwiktionary%)
skrwiktionary
skrwiktionary_p
GRANT SELECT, SHOW VIEW ON `skrwiktionary\\_p`.* TO 'labsdbuser'
*****clouddb1016:3315*****
Database (skrwiktionary%)
skrwiktionary
skrwiktionary_p
GRANT SELECT, SHOW VIEW ON `skrwiktionary\\_p`.* TO `labsdbuser`
*****clouddb1020:3315*****
Database (skrwiktionary%)
skrwiktionary
skrwiktionary_p
GRANT SELECT, SHOW VIEW ON `skrwiktionary\\_p`.* TO `labsdbuser`

This is ready for cloud-services-team

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

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 one is all set.

MariaDB [skrwiktionary_p]> select * from page limit 10;
+---------+----------------+-----------------+-------------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+-----------+
| 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 |
+---------+----------------+-----------------+-------------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+-----------+
|       1 |              0 | پہلا_پرت        |                   |                0 |           0 | 0.772856056836 | 20201227084657 | 20201227084653     |       59999 |     2243 | wikitext           | NULL      |
|       2 |              8 | Sitesupport-