Prepare and check storage layer for kcgwiki
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Maintenance_bot
	Apr 1 2022, 11:31 PM

Description

The new wiki's visibility will be: Public.

	Subject	Repo	Branch	Lines +/-
	Add kcgwiki to the sqoop list	analytics/refinery	master	+1 -0

		Status	Subtype	Assigned	Task
		Resolved		Urbanecm	T305279 Create Wikipedia Tyap
		Resolved		BTullis	T305280 Prepare and check storage layer for kcgwiki

Zabe changed the edit policy from "Custom Policy" to "All Users".Apr 3 2022, 1:36 AM

Thanks, let us know when the database is created, so we can sanitize it.

In T305280#7827935, @LSobanski wrote:

Thanks, let us know when the database is created, so we can sanitize it.

Hello, I've created the database yesterday. Can you please do the sanitizing? Thanks!

Database sanitized, created kcgwiki_p and granted labsdbuser all the grants.
Tested a new user and it gets created with all the fields sanitized.

This is ready for views creation.

Change 806244 had a related patch set uploaded (by Milimetric; author: Milimetric):

[analytics/refinery@master] Add kcgwiki to the sqoop list

I have executed sudo maintain-views --databases kcgwiki on clouddb1016 and clouddb1020 which are the two clouddb replicas for s5.

I believe that the database can now be added to the sqoop list @Milimetric

Change 806244 merged by Milimetric:

[analytics/refinery@master] Add kcgwiki to the sqoop list

@BTullis you also need to run it on clouddb1021:3315 as that is the analytics cloud host

Thanks @Marostegui - I have now executed sudo maintain-views --databases kcgwiki on clouddb1021 as well.

Thanks!

Mentioned in SAL (#wikimedia-operations) [2023-03-29T11:51:27Z] <btullis@cumin1001> Added views for new wiki: kcgwiki T305280