Drop old mobile-sections keyspaces
Closed, ResolvedPublic0 Estimated Story Points
Actions

Assigned To

Authored By

	• mobrovac
	Apr 21 2019, 8:35 PM

Description

The following keyspaces need to be dropped:

"commons_T_mobile__ng3HeqOXXmkYfPizz4RPUR4OLXLds"
"commons_T_mobile__ng_lead"
"commons_T_mobile__ngR6XB1sh6_FFo_mfX4oZA56vpD_w"
"commons_T_mobile__ng_remaining"
"enwiki_T_mobile__ng3HeqOXXmkYfPizz4RPUR4OLXLds"
"enwiki_T_mobile__ng_lead"
"enwiki_T_mobile__ngR6XB1sh6_FFo_mfX4oZA56vpD_w"
"enwiki_T_mobile__ng_remaining"
"others_T_mobile__ng3HeqOXXmkYfPizz4RPUR4OLXLds"
"others_T_mobile__ng_lead"
"others_T_mobile__ngR6XB1sh6_FFo_mfX4oZA56vpD_w"
"others_T_mobile__ng_remaining"
"wikipedia_T_mobile__ng3HeqOXXmkYfPizz4RPUR4OLXLd"
"wikipedia_T_mobile__ng_lead"
"wikipedia_T_mobile__ngR6XB1sh6_FFo_mfX4oZA56vpD_"
"wikipedia_T_mobile__ng_remaining"

Related Objects
Search...

Status	Assigned	Task
Resolved	WDoranWMF	T220449 Split RESTBase in two services: storage service and API router/proxy
Resolved	• mobrovac	T220461 Simplify storage semantics
Resolved	• Pchelolo	T215960 Simplify MCS storage model
Resolved	Eevans	T221530 Drop old mobile-sections keyspaces

Event Timeline

• mobrovac triaged this task as Medium priority.Apr 21 2019, 8:35 PM

• mobrovac created this task.

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptApr 21 2019, 8:35 PM

• mobrovac added a parent task: T215960: Simplify MCS storage model.Apr 21 2019, 8:36 PM

Here are the statements:

P8424 Drop old mobile-sections tables

1	###
2	## `commons` STORAGE GROUP BLOCK
3	###
4
5	drop_commons_T_mobile__ng3HeqOXXmkYfPizz4RPUR4OLXLds:
6	statement: \|
7	DROP KEYSPACE IF EXISTS "commons_T_mobile__ng3HeqOXXmkYfPizz4RPUR4OLXLds";
8
9	drop_commons_T_mobile__ng_lead:
10	statement: \|
11	DROP KEYSPACE IF EXISTS "commons_T_mobile__ng_lead";
12
13	drop_commons_T_mobile__ngR6XB1sh6_FFo_mfX4oZA56vpD_w:
14	statement: \|
15	DROP KEYSPACE IF EXISTS "commons_T_mobile__ngR6XB1sh6_FFo_mfX4oZA56vpD_w";
16
17	drop_commons_T_mobile__ng_remaining:
18	statement: \|
19	DROP KEYSPACE IF EXISTS "commons_T_mobile__ng_remaining";
20
21
22	###
23	## `enwiki` STORAGE GROUP BLOCK
24	###
25
26	drop_enwiki_T_mobile__ng3HeqOXXmkYfPizz4RPUR4OLXLds:
27	statement: \|
28	DROP KEYSPACE IF EXISTS "enwiki_T_mobile__ng3HeqOXXmkYfPizz4RPUR4OLXLds";
29
30	drop_enwiki_T_mobile__ng_lead:
31	statement: \|
32	DROP KEYSPACE IF EXISTS "enwiki_T_mobile__ng_lead";
33
34	drop_enwiki_T_mobile__ngR6XB1sh6_FFo_mfX4oZA56vpD_w:
35	statement: \|
36	DROP KEYSPACE IF EXISTS "enwiki_T_mobile__ngR6XB1sh6_FFo_mfX4oZA56vpD_w";
37
38	drop_enwiki_T_mobile__ng_remaining:
39	statement: \|
40	DROP KEYSPACE IF EXISTS "enwiki_T_mobile__ng_remaining";
41
42
43	###
44	## `others` STORAGE GROUP BLOCK
45	###
46
47	drop_others_T_mobile__ng3HeqOXXmkYfPizz4RPUR4OLXLds:
48	statement: \|
49	DROP KEYSPACE IF EXISTS "others_T_mobile__ng3HeqOXXmkYfPizz4RPUR4OLXLds";
50
51	drop_others_T_mobile__ng_lead:
52	statement: \|
53	DROP KEYSPACE IF EXISTS "others_T_mobile__ng_lead";
54
55	drop_others_T_mobile__ngR6XB1sh6_FFo_mfX4oZA56vpD_w:
56	statement: \|
57	DROP KEYSPACE IF EXISTS "others_T_mobile__ngR6XB1sh6_FFo_mfX4oZA56vpD_w";
58
59	drop_others_T_mobile__ng_remaining:
60	statement: \|
61	DROP KEYSPACE IF EXISTS "others_T_mobile__ng_remaining";
62
63
64	###
65	## `wikipedia` STORAGE GROUP BLOCK
66	###
67
68	drop_wikipedia_T_mobile__ng3HeqOXXmkYfPizz4RPUR4OLXLd:
69	statement: \|
70	DROP KEYSPACE IF EXISTS "wikipedia_T_mobile__ng3HeqOXXmkYfPizz4RPUR4OLXLd";
71
72	drop_wikipedia_T_mobile__ng_lead:
73	statement: \|
74	DROP KEYSPACE IF EXISTS "wikipedia_T_mobile__ng_lead";
75
76	drop_wikipedia_T_mobile__ngR6XB1sh6_FFo_mfX4oZA56vpD_:
77	statement: \|
78	DROP KEYSPACE IF EXISTS "wikipedia_T_mobile__ngR6XB1sh6_FFo_mfX4oZA56vpD_";
79
80	drop_wikipedia_T_mobile__ng_remaining:
81	statement: \|
82	DROP KEYSPACE IF EXISTS "wikipedia_T_mobile__ng_remaining";

Please review.

I cannot speak to the keyspaces being dropped, but the statements LGTM!

Dev environment {{done}}

Mentioned in SAL (#wikimedia-operations) [2019-04-23T20:26:04Z] <urandom> dropping disused restbase keyspaces -- T221530

Production environment {{done}}

• mobrovac edited projects, added Services (done), Platform Team Workboards (Done with CPT); removed Platform Team Legacy (Next), Services (next).Apr 24 2019, 1:14 AM

Drop old mobile-sections keyspacesClosed, ResolvedPublic0 Estimated Story PointsActions

Description

Related ObjectsSearch...

Event Timeline

Drop old mobile-sections keyspaces
Closed, ResolvedPublic0 Estimated Story Points
Actions

Related Objects
Search...