Page MenuHomePhabricator

Prepare and check storage layer for gurwiki
Closed, ResolvedPublic

Description

The new wiki's visibility will be: Public.

Related Objects

Event Timeline

Marostegui moved this task from Triage to Blocked on the DBA board.
Marostegui subscribed.

Let us know when the wiki is created so we can sanitize ir

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

I try to do it but leave it to Manuel to double check as the last time I messed it up.

I think I did it but I'm not sure how to create user and grants (or, I do know how but I don't know which grants should be and don't want to mess it up)

Marostegui added a subscriber: BTullis.

This looks clean and the grants are added GRANT SELECT, SHOW VIEW ON as well as the _p database.
This is ready for the views creation

Mentioned in SAL (#wikimedia-operations) [2023-03-29T12:22:32Z] <btullis@cumin1001> Added views for new wiki: gurwiki T327841

BTullis claimed this task.

I believe that this has now been created, including the row in meta_p.wiki

btullis@tools-sgebastion-10:~$ sql gurwiki
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 953721773
Server version: 10.4.22-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [gurwiki_p]>
MariaDB [meta_p]> SELECT dbname, lang FROM wiki WHERE dbname = 'gurwiki';
+---------+------+
| dbname  | lang |
+---------+------+
| gurwiki | gur  |
+---------+------+
1 row in set (0.002 sec)