Page MenuHomePhabricator

Prepare and check storage layer for yuewiktionary
Closed, ResolvedPublic

Description

The new wiki will be public.

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

Please ping me (or anybody in the persistance team) when the wiki is created, and I can do the sanitzation

Banyek triaged this task as Medium priority.Sep 28 2018, 2:39 PM
Marostegui changed the task status from Open to Stalled.Oct 3 2018, 8:34 AM
Marostegui claimed this task.
Marostegui subscribed.

We are doing some maintenance on s3, moving wikis around - please ask DBA before creating this wikis (if they will be created before the switch back to eqiad - which is scheduled for 10th Oct)
Assigning it to me, to indicate it is blocked on me/DBA

Marostegui changed the task status from Stalled to Open.Oct 11 2018, 6:10 AM
Marostegui removed Marostegui as the assignee of this task.

This can now proceed whenver you guys want.

Banyek added subscribers: Bstorm, bd808, GTirloni.

ready for the views creation

@Banyek did GRANT this wiki into the labsdb user role grants? If not, the views will fail to be created

I GRANT'ed:

MariaDB [(none)]> set session sql_log_bin=0; create database yuewiktionary_p;
Query OK, 0 rows affected (0.01 sec)

Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> set session sql_log_bin=0; GRANT SELECT, SHOW VIEW ON `yuewiktionary\_p`.* TO 'labsdbuser';
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.06 sec)

@Bstorm you can work with this

Bstorm claimed this task.

views, indexes, dns, etc. all set. Tested from toolforge.