Page MenuHomePhabricator
Create Task
Maniphest T210762

Prepare and check storage layer for nap.wikisource
Closed, ResolvedPublic
Actions

Description

New Wikisource, public wiki.

Related Objects
Search...

Event Timeline

MarcoAurelio created this task.Nov 29 2018, 6:34 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 29 2018, 6:34 PM
jcrespo mentioned this in T210752: Create Wikisource Neapolitan.Nov 29 2018, 6:46 PM
jcrespo moved this task from Triage to Blocked external/Not db team on the DBA board.Nov 29 2018, 6:48 PM
jcrespo subscribed.

Waiting now for the actual creation at T210752 to setup the replication, as no preventive action is needed due to it being public.

MarcoAurelio added a project: cloud-services-team.Nov 30 2018, 9:23 AM
• Banyek claimed this task.Nov 30 2018, 11:18 AM
• Banyek triaged this task as Medium priority.
• Banyek added a project: User-Banyek.
• Banyek subscribed.

When the wiki is created please ping me and I'll do the sanitization

• Banyek moved this task from Backlog to Wait on external on the User-Banyek board.Nov 30 2018, 1:04 PM
• Marostegui mentioned this in T212781: Strategy for how to change the "cu_changes" DB schema.Jan 2 2019, 2:27 PM
Liuxinyu970226 subscribed.Jan 11 2019, 8:17 AM
• Marostegui removed • Banyek as the assignee of this task.Jan 11 2019, 8:37 PM
• Marostegui subscribed.

Once this is done, let us (DBAs) know and will sanitize it
Thanks!

Reedy subscribed.Aug 14 2019, 2:10 PM

It's created

• Marostegui claimed this task.Aug 14 2019, 2:31 PM

Thanks - I will take care of this next week.
Assigning this to me so it is known it is blocked on me before creating the views on the wikireplicas.

jcrespo mentioned this in T230485: Create replica of napwikisource on labs.Aug 16 2019, 10:28 AM
Stashbot added a comment.Aug 19 2019, 7:40 AM

Mentioned in SAL (#wikimedia-operations) [2019-08-19T07:40:32Z] <marostegui> Redact napwikisource on db1124 and db2094 - T210762

• Marostegui added a comment.Aug 19 2019, 8:35 AM

I have sanitized this on db1124 and db2094. I have checked that the new users are being sanitized correctly on the sanitarium and labs hosts.
However, just to be 100% I am running a check_private_data on sanitarium (already successfully finished) and on labsdb1009, labsdb1010 (1011 is still running from the scheduled run) and labsdb1012 just to be fully sure that there is no private data.

• Marostegui removed • Marostegui as the assignee of this task.Aug 19 2019, 12:34 PM
• Marostegui moved this task from Blocked external/Not db team to Done on the DBA board.
• Marostegui edited projects, added Data-Services; removed User-Banyek, Cloud-Services.
• Marostegui added subscribers: bd808, • Bstorm, • JHedden.

All the check data came up clean after the sanitization.
This is ready for cloud-services-team to create the views on the labsdb1009-1012 hosts.

• Marostegui mentioned this in T51195: Drop filejournal table from WMF.Aug 19 2019, 12:39 PM
• Bstorm claimed this task.Aug 26 2019, 5:34 PM
• Bstorm added a comment.EditedAug 26 2019, 5:50 PM

Created the "_p" database and the grant on the replicas, running scripts now to get it all set.

• Bstorm closed this task as Resolved.Aug 26 2019, 5:58 PM

Scripts finished. Validated the the views are reachable in Toolforge.

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL