Page MenuHomePhabricator

Prepare and check storage layer for lldwiki
Closed, ResolvedPublic

Description

The new wiki is going to be public.

@Marostegui Which shard do you want this to be?

Event Timeline

Marostegui triaged this task as Medium priority.Aug 3 2020, 5:23 AM
Marostegui moved this task from Triage to Blocked external/Not db team on the DBA board.

Let's go for s5!

@Marostegui The database was just created, and there should be also some users :).

Mentioned in SAL (#wikimedia-operations) [2020-08-17T14:03:07Z] <marostegui> Sanitize lldwiki on db1124:3315 and db2094:3315 T259436

Sanitized correctly on db1124:3315 and db2094:3315.
I created a user after the sanitization and the triggers worked fine.
Running check_private_data now, just to be fully sure before creating the _p database and the grants

Marostegui added subscribers: Bstorm, Andrew, bd808.

lldwiki_p database created
| GRANT SELECT, SHOW VIEW ON lldwiki\_p`.* TO 'labsdbuser'` also applied.

cloud-services-team please go ahead and create the views on labsdb1009, 1010,1011 and 1012.

All scripts run. Seems to work well from Toolforge.