Page MenuHomePhabricator
Create Task
Maniphest T228804

Create keyspaces in Cassandra for PCS endpoints
Closed, ResolvedPublic
Actions

Description

We need to create keyspaces in Cassandra in beta and prod for the endpoints that we are going to store:

  • media-list
  • mobile-html
  • metadata
  • references

Production:

"enwiki_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4"
"enwiki_T_metadata"
"enwiki_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA"
"enwiki_T_references"

"others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4"
"others_T_metadata"
"others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA"
"others_T_references"

"wikipedia_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4"
"wikipedia_T_metadata"
"wikipedia_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA"
"wikipedia_T_references"

P8788 pcs_table_creation_prod
1create_enwiki_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4:
2 statement: |
3 CREATE KEYSPACE IF NOT EXISTS "enwiki_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4" WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
4
5create_meta_enwiki_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4:
6 statement: |
7 CREATE TABLE IF NOT EXISTS "enwiki_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4".meta (
8 key text PRIMARY KEY,
9 value text
10 ) WITH bloom_filter_fp_chance = 0.1
11 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
12 AND comment = ''
13 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
14 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
15 AND crc_check_chance = 1.0
16 AND dclocal_read_repair_chance = 0.1
17 AND default_time_to_live = 0
18 AND gc_grace_seconds = 864000
19 AND max_index_interval = 2048
20 AND memtable_flush_period_in_ms = 0
21 AND min_index_interval = 128
22 AND read_repair_chance = 0.0
23 AND speculative_retry = '99PERCENTILE';
24
25create_data_enwiki_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4:
26 statement:
27 CREATE TABLE IF NOT EXISTS "wikipedia_T_mobileoZCBVtILw5eSrwi0VIGaFVSr2jY".data (
28 "_domain" text,
29 key text,
30 headers text,
31 tid timeuuid,
32 value blob,
33 PRIMARY KEY (("_domain", key))
34 ) WITH bloom_filter_fp_chance = 0.01
35 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
36 AND comment = ''
37 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
38 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
39 AND crc_check_chance = 1.0
40 AND dclocal_read_repair_chance = 0.1
41 AND default_time_to_live = 0
42 AND gc_grace_seconds = 864000
43 AND max_index_interval = 2048
44 AND memtable_flush_period_in_ms = 0
45 AND min_index_interval = 128
46 AND read_repair_chance = 0.0
47 AND speculative_retry = '99PERCENTILE';
48
49
50
51create_enwiki_T_metadata:
52 statement: |
53 CREATE KEYSPACE IF NOT EXISTS "enwiki_T_metadata" WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
54
55create_meta_enwiki_T_metadata:
56 statement: |
57 CREATE TABLE IF NOT EXISTS "enwiki_T_metadata".meta (
58 key text PRIMARY KEY,
59 value text
60 ) WITH bloom_filter_fp_chance = 0.1
61 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
62 AND comment = ''
63 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
64 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
65 AND crc_check_chance = 1.0
66 AND dclocal_read_repair_chance = 0.1
67 AND default_time_to_live = 0
68 AND gc_grace_seconds = 864000
69 AND max_index_interval = 2048
70 AND memtable_flush_period_in_ms = 0
71 AND min_index_interval = 128
72 AND read_repair_chance = 0.0
73 AND speculative_retry = '99PERCENTILE';
74
75create_data_enwiki_T_metadata:
76 statement:
77 CREATE TABLE IF NOT EXISTS "wikipedia_T_mobileoZCBVtILw5eSrwi0VIGaFVSr2jY".data (
78 "_domain" text,
79 key text,
80 headers text,
81 tid timeuuid,
82 value blob,
83 PRIMARY KEY (("_domain", key))
84 ) WITH bloom_filter_fp_chance = 0.01
85 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
86 AND comment = ''
87 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
88 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
89 AND crc_check_chance = 1.0
90 AND dclocal_read_repair_chance = 0.1
91 AND default_time_to_live = 0
92 AND gc_grace_seconds = 864000
93 AND max_index_interval = 2048
94 AND memtable_flush_period_in_ms = 0
95 AND min_index_interval = 128
96 AND read_repair_chance = 0.0
97 AND speculative_retry = '99PERCENTILE';
98
99
100
101create_enwiki_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA:
102 statement: |
103 CREATE KEYSPACE IF NOT EXISTS "enwiki_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA" WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
104
105create_meta_enwiki_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA:
106 statement: |
107 CREATE TABLE IF NOT EXISTS "enwiki_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA".meta (
108 key text PRIMARY KEY,
109 value text
110 ) WITH bloom_filter_fp_chance = 0.1
111 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
112 AND comment = ''
113 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
114 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
115 AND crc_check_chance = 1.0
116 AND dclocal_read_repair_chance = 0.1
117 AND default_time_to_live = 0
118 AND gc_grace_seconds = 864000
119 AND max_index_interval = 2048
120 AND memtable_flush_period_in_ms = 0
121 AND min_index_interval = 128
122 AND read_repair_chance = 0.0
123 AND speculative_retry = '99PERCENTILE';
124
125create_data_enwiki_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA:
126 statement:
127 CREATE TABLE IF NOT EXISTS "wikipedia_T_mobileoZCBVtILw5eSrwi0VIGaFVSr2jY".data (
128 "_domain" text,
129 key text,
130 headers text,
131 tid timeuuid,
132 value blob,
133 PRIMARY KEY (("_domain", key))
134 ) WITH bloom_filter_fp_chance = 0.01
135 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
136 AND comment = ''
137 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
138 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
139 AND crc_check_chance = 1.0
140 AND dclocal_read_repair_chance = 0.1
141 AND default_time_to_live = 0
142 AND gc_grace_seconds = 864000
143 AND max_index_interval = 2048
144 AND memtable_flush_period_in_ms = 0
145 AND min_index_interval = 128
146 AND read_repair_chance = 0.0
147 AND speculative_retry = '99PERCENTILE';
148
149
150
151create_enwiki_T_references:
152 statement: |
153 CREATE KEYSPACE IF NOT EXISTS "enwiki_T_references" WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
154
155create_meta_enwiki_T_references:
156 statement: |
157 CREATE TABLE IF NOT EXISTS "enwiki_T_references".meta (
158 key text PRIMARY KEY,
159 value text
160 ) WITH bloom_filter_fp_chance = 0.1
161 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
162 AND comment = ''
163 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
164 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
165 AND crc_check_chance = 1.0
166 AND dclocal_read_repair_chance = 0.1
167 AND default_time_to_live = 0
168 AND gc_grace_seconds = 864000
169 AND max_index_interval = 2048
170 AND memtable_flush_period_in_ms = 0
171 AND min_index_interval = 128
172 AND read_repair_chance = 0.0
173 AND speculative_retry = '99PERCENTILE';
174
175create_data_enwiki_T_references:
176 statement:
177 CREATE TABLE IF NOT EXISTS "wikipedia_T_mobileoZCBVtILw5eSrwi0VIGaFVSr2jY".data (
178 "_domain" text,
179 key text,
180 headers text,
181 tid timeuuid,
182 value blob,
183 PRIMARY KEY (("_domain", key))
184 ) WITH bloom_filter_fp_chance = 0.01
185 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
186 AND comment = ''
187 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
188 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
189 AND crc_check_chance = 1.0
190 AND dclocal_read_repair_chance = 0.1
191 AND default_time_to_live = 0
192 AND gc_grace_seconds = 864000
193 AND max_index_interval = 2048
194 AND memtable_flush_period_in_ms = 0
195 AND min_index_interval = 128
196 AND read_repair_chance = 0.0
197 AND speculative_retry = '99PERCENTILE';
198
199
200
201create_others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4:
202 statement: |
203 CREATE KEYSPACE IF NOT EXISTS "others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4" WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
204
205create_meta_others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4:
206 statement: |
207 CREATE TABLE IF NOT EXISTS "others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4".meta (
208 key text PRIMARY KEY,
209 value text
210 ) WITH bloom_filter_fp_chance = 0.1
211 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
212 AND comment = ''
213 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
214 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
215 AND crc_check_chance = 1.0
216 AND dclocal_read_repair_chance = 0.1
217 AND default_time_to_live = 0
218 AND gc_grace_seconds = 864000
219 AND max_index_interval = 2048
220 AND memtable_flush_period_in_ms = 0
221 AND min_index_interval = 128
222 AND read_repair_chance = 0.0
223 AND speculative_retry = '99PERCENTILE';
224
225create_data_others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4:
226 statement:
227 CREATE TABLE IF NOT EXISTS "wikipedia_T_mobileoZCBVtILw5eSrwi0VIGaFVSr2jY".data (
228 "_domain" text,
229 key text,
230 headers text,
231 tid timeuuid,
232 value blob,
233 PRIMARY KEY (("_domain", key))
234 ) WITH bloom_filter_fp_chance = 0.01
235 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
236 AND comment = ''
237 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
238 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
239 AND crc_check_chance = 1.0
240 AND dclocal_read_repair_chance = 0.1
241 AND default_time_to_live = 0
242 AND gc_grace_seconds = 864000
243 AND max_index_interval = 2048
244 AND memtable_flush_period_in_ms = 0
245 AND min_index_interval = 128
246 AND read_repair_chance = 0.0
247 AND speculative_retry = '99PERCENTILE';
248
249
250
251create_others_T_metadata:
252 statement: |
253 CREATE KEYSPACE IF NOT EXISTS "others_T_metadata" WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
254
255create_meta_others_T_metadata:
256 statement: |
257 CREATE TABLE IF NOT EXISTS "others_T_metadata".meta (
258 key text PRIMARY KEY,
259 value text
260 ) WITH bloom_filter_fp_chance = 0.1
261 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
262 AND comment = ''
263 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
264 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
265 AND crc_check_chance = 1.0
266 AND dclocal_read_repair_chance = 0.1
267 AND default_time_to_live = 0
268 AND gc_grace_seconds = 864000
269 AND max_index_interval = 2048
270 AND memtable_flush_period_in_ms = 0
271 AND min_index_interval = 128
272 AND read_repair_chance = 0.0
273 AND speculative_retry = '99PERCENTILE';
274
275create_data_others_T_metadata:
276 statement:
277 CREATE TABLE IF NOT EXISTS "wikipedia_T_mobileoZCBVtILw5eSrwi0VIGaFVSr2jY".data (
278 "_domain" text,
279 key text,
280 headers text,
281 tid timeuuid,
282 value blob,
283 PRIMARY KEY (("_domain", key))
284 ) WITH bloom_filter_fp_chance = 0.01
285 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
286 AND comment = ''
287 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
288 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
289 AND crc_check_chance = 1.0
290 AND dclocal_read_repair_chance = 0.1
291 AND default_time_to_live = 0
292 AND gc_grace_seconds = 864000
293 AND max_index_interval = 2048
294 AND memtable_flush_period_in_ms = 0
295 AND min_index_interval = 128
296 AND read_repair_chance = 0.0
297 AND speculative_retry = '99PERCENTILE';
298
299
300
301create_others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA:
302 statement: |
303 CREATE KEYSPACE IF NOT EXISTS "others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA" WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
304
305create_meta_others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA:
306 statement: |
307 CREATE TABLE IF NOT EXISTS "others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA".meta (
308 key text PRIMARY KEY,
309 value text
310 ) WITH bloom_filter_fp_chance = 0.1
311 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
312 AND comment = ''
313 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
314 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
315 AND crc_check_chance = 1.0
316 AND dclocal_read_repair_chance = 0.1
317 AND default_time_to_live = 0
318 AND gc_grace_seconds = 864000
319 AND max_index_interval = 2048
320 AND memtable_flush_period_in_ms = 0
321 AND min_index_interval = 128
322 AND read_repair_chance = 0.0
323 AND speculative_retry = '99PERCENTILE';
324
325create_data_others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA:
326 statement:
327 CREATE TABLE IF NOT EXISTS "wikipedia_T_mobileoZCBVtILw5eSrwi0VIGaFVSr2jY".data (
328 "_domain" text,
329 key text,
330 headers text,
331 tid timeuuid,
332 value blob,
333 PRIMARY KEY (("_domain", key))
334 ) WITH bloom_filter_fp_chance = 0.01
335 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
336 AND comment = ''
337 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
338 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
339 AND crc_check_chance = 1.0
340 AND dclocal_read_repair_chance = 0.1
341 AND default_time_to_live = 0
342 AND gc_grace_seconds = 864000
343 AND max_index_interval = 2048
344 AND memtable_flush_period_in_ms = 0
345 AND min_index_interval = 128
346 AND read_repair_chance = 0.0
347 AND speculative_retry = '99PERCENTILE';
348
349
350
351create_others_T_references:
352 statement: |
353 CREATE KEYSPACE IF NOT EXISTS "others_T_references" WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
354
355create_meta_others_T_references:
356 statement: |
357 CREATE TABLE IF NOT EXISTS "others_T_references".meta (
358 key text PRIMARY KEY,
359 value text
360 ) WITH bloom_filter_fp_chance = 0.1
361 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
362 AND comment = ''
363 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
364 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
365 AND crc_check_chance = 1.0
366 AND dclocal_read_repair_chance = 0.1
367 AND default_time_to_live = 0
368 AND gc_grace_seconds = 864000
369 AND max_index_interval = 2048
370 AND memtable_flush_period_in_ms = 0
371 AND min_index_interval = 128
372 AND read_repair_chance = 0.0
373 AND speculative_retry = '99PERCENTILE';
374
375create_data_others_T_references:
376 statement:
377 CREATE TABLE IF NOT EXISTS "wikipedia_T_mobileoZCBVtILw5eSrwi0VIGaFVSr2jY".data (
378 "_domain" text,
379 key text,
380 headers text,
381 tid timeuuid,
382 value blob,
383 PRIMARY KEY (("_domain", key))
384 ) WITH bloom_filter_fp_chance = 0.01
385 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
386 AND comment = ''
387 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
388 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
389 AND crc_check_chance = 1.0
390 AND dclocal_read_repair_chance = 0.1
391 AND default_time_to_live = 0
392 AND gc_grace_seconds = 864000
393 AND max_index_interval = 2048
394 AND memtable_flush_period_in_ms = 0
395 AND min_index_interval = 128
396 AND read_repair_chance = 0.0
397 AND speculative_retry = '99PERCENTILE';
398
399
400
401create_wikipedia_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4:
402 statement: |
403 CREATE KEYSPACE IF NOT EXISTS "wikipedia_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4" WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
404
405create_meta_wikipedia_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4:
406 statement: |
407 CREATE TABLE IF NOT EXISTS "wikipedia_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4".meta (
408 key text PRIMARY KEY,
409 value text
410 ) WITH bloom_filter_fp_chance = 0.1
411 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
412 AND comment = ''
413 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
414 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
415 AND crc_check_chance = 1.0
416 AND dclocal_read_repair_chance = 0.1
417 AND default_time_to_live = 0
418 AND gc_grace_seconds = 864000
419 AND max_index_interval = 2048
420 AND memtable_flush_period_in_ms = 0
421 AND min_index_interval = 128
422 AND read_repair_chance = 0.0
423 AND speculative_retry = '99PERCENTILE';
424
425create_data_wikipedia_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4:
426 statement:
427 CREATE TABLE IF NOT EXISTS "wikipedia_T_mobileoZCBVtILw5eSrwi0VIGaFVSr2jY".data (
428 "_domain" text,
429 key text,
430 headers text,
431 tid timeuuid,
432 value blob,
433 PRIMARY KEY (("_domain", key))
434 ) WITH bloom_filter_fp_chance = 0.01
435 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
436 AND comment = ''
437 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
438 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
439 AND crc_check_chance = 1.0
440 AND dclocal_read_repair_chance = 0.1
441 AND default_time_to_live = 0
442 AND gc_grace_seconds = 864000
443 AND max_index_interval = 2048
444 AND memtable_flush_period_in_ms = 0
445 AND min_index_interval = 128
446 AND read_repair_chance = 0.0
447 AND speculative_retry = '99PERCENTILE';
448
449
450
451create_wikipedia_T_metadata:
452 statement: |
453 CREATE KEYSPACE IF NOT EXISTS "wikipedia_T_metadata" WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
454
455create_meta_wikipedia_T_metadata:
456 statement: |
457 CREATE TABLE IF NOT EXISTS "wikipedia_T_metadata".meta (
458 key text PRIMARY KEY,
459 value text
460 ) WITH bloom_filter_fp_chance = 0.1
461 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
462 AND comment = ''
463 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
464 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
465 AND crc_check_chance = 1.0
466 AND dclocal_read_repair_chance = 0.1
467 AND default_time_to_live = 0
468 AND gc_grace_seconds = 864000
469 AND max_index_interval = 2048
470 AND memtable_flush_period_in_ms = 0
471 AND min_index_interval = 128
472 AND read_repair_chance = 0.0
473 AND speculative_retry = '99PERCENTILE';
474
475create_data_wikipedia_T_metadata:
476 statement:
477 CREATE TABLE IF NOT EXISTS "wikipedia_T_mobileoZCBVtILw5eSrwi0VIGaFVSr2jY".data (
478 "_domain" text,
479 key text,
480 headers text,
481 tid timeuuid,
482 value blob,
483 PRIMARY KEY (("_domain", key))
484 ) WITH bloom_filter_fp_chance = 0.01
485 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
486 AND comment = ''
487 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
488 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
489 AND crc_check_chance = 1.0
490 AND dclocal_read_repair_chance = 0.1
491 AND default_time_to_live = 0
492 AND gc_grace_seconds = 864000
493 AND max_index_interval = 2048
494 AND memtable_flush_period_in_ms = 0
495 AND min_index_interval = 128
496 AND read_repair_chance = 0.0
497 AND speculative_retry = '99PERCENTILE';
498
499
500
501create_wikipedia_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA:
502 statement: |
503 CREATE KEYSPACE IF NOT EXISTS "wikipedia_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA" WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
504
505create_meta_wikipedia_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA:
506 statement: |
507 CREATE TABLE IF NOT EXISTS "wikipedia_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA".meta (
508 key text PRIMARY KEY,
509 value text
510 ) WITH bloom_filter_fp_chance = 0.1
511 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
512 AND comment = ''
513 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
514 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
515 AND crc_check_chance = 1.0
516 AND dclocal_read_repair_chance = 0.1
517 AND default_time_to_live = 0
518 AND gc_grace_seconds = 864000
519 AND max_index_interval = 2048
520 AND memtable_flush_period_in_ms = 0
521 AND min_index_interval = 128
522 AND read_repair_chance = 0.0
523 AND speculative_retry = '99PERCENTILE';
524
525create_data_wikipedia_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA:
526 statement:
527 CREATE TABLE IF NOT EXISTS "wikipedia_T_mobileoZCBVtILw5eSrwi0VIGaFVSr2jY".data (
528 "_domain" text,
529 key text,
530 headers text,
531 tid timeuuid,
532 value blob,
533 PRIMARY KEY (("_domain", key))
534 ) WITH bloom_filter_fp_chance = 0.01
535 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
536 AND comment = ''
537 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
538 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
539 AND crc_check_chance = 1.0
540 AND dclocal_read_repair_chance = 0.1
541 AND default_time_to_live = 0
542 AND gc_grace_seconds = 864000
543 AND max_index_interval = 2048
544 AND memtable_flush_period_in_ms = 0
545 AND min_index_interval = 128
546 AND read_repair_chance = 0.0
547 AND speculative_retry = '99PERCENTILE';
548
549
550
551create_wikipedia_T_references:
552 statement: |
553 CREATE KEYSPACE IF NOT EXISTS "wikipedia_T_references" WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
554
555create_meta_wikipedia_T_references:
556 statement: |
557 CREATE TABLE IF NOT EXISTS "wikipedia_T_references".meta (
558 key text PRIMARY KEY,
559 value text
560 ) WITH bloom_filter_fp_chance = 0.1
561 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
562 AND comment = ''
563 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
564 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
565 AND crc_check_chance = 1.0
566 AND dclocal_read_repair_chance = 0.1
567 AND default_time_to_live = 0
568 AND gc_grace_seconds = 864000
569 AND max_index_interval = 2048
570 AND memtable_flush_period_in_ms = 0
571 AND min_index_interval = 128
572 AND read_repair_chance = 0.0
573 AND speculative_retry = '99PERCENTILE';
574
575create_data_wikipedia_T_references:
576 statement:
577 CREATE TABLE IF NOT EXISTS "wikipedia_T_mobileoZCBVtILw5eSrwi0VIGaFVSr2jY".data (
578 "_domain" text,
579 key text,
580 headers text,
581 tid timeuuid,
582 value blob,
583 PRIMARY KEY (("_domain", key))
584 ) WITH bloom_filter_fp_chance = 0.01
585 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
586 AND comment = ''
587 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
588 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
589 AND crc_check_chance = 1.0
590 AND dclocal_read_repair_chance = 0.1
591 AND default_time_to_live = 0
592 AND gc_grace_seconds = 864000
593 AND max_index_interval = 2048
594 AND memtable_flush_period_in_ms = 0
595 AND min_index_interval = 128
596 AND read_repair_chance = 0.0
597 AND speculative_retry = '99PERCENTILE';

Beta:

"others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4"
"others_T_metadata"
"others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA"
"others_T_references"

P8789 create_pcs_tables_beta
1/Users/pchelko/.nvm/versions/node/v10.16.0/bin/node /Users/pchelko/wiki/restbase/sys/action.js
2
3create_others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4:
4 statement: |
5 CREATE KEYSPACE IF NOT EXISTS "others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4" WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
6
7create_meta_others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4:
8 statement: |
9 CREATE TABLE IF NOT EXISTS "others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4".meta (
10 key text PRIMARY KEY,
11 value text
12 ) WITH bloom_filter_fp_chance = 0.1
13 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
14 AND comment = ''
15 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
16 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
17 AND crc_check_chance = 1.0
18 AND dclocal_read_repair_chance = 0.1
19 AND default_time_to_live = 0
20 AND gc_grace_seconds = 864000
21 AND max_index_interval = 2048
22 AND memtable_flush_period_in_ms = 0
23 AND min_index_interval = 128
24 AND read_repair_chance = 0.0
25 AND speculative_retry = '99PERCENTILE';
26
27create_data_others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4:
28 statement:
29 CREATE TABLE IF NOT EXISTS "wikipedia_T_mobileoZCBVtILw5eSrwi0VIGaFVSr2jY".data (
30 "_domain" text,
31 key text,
32 headers text,
33 tid timeuuid,
34 value blob,
35 PRIMARY KEY (("_domain", key))
36 ) WITH bloom_filter_fp_chance = 0.01
37 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
38 AND comment = ''
39 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
40 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
41 AND crc_check_chance = 1.0
42 AND dclocal_read_repair_chance = 0.1
43 AND default_time_to_live = 0
44 AND gc_grace_seconds = 864000
45 AND max_index_interval = 2048
46 AND memtable_flush_period_in_ms = 0
47 AND min_index_interval = 128
48 AND read_repair_chance = 0.0
49 AND speculative_retry = '99PERCENTILE';
50
51
52
53create_others_T_metadata:
54 statement: |
55 CREATE KEYSPACE IF NOT EXISTS "others_T_metadata" WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
56
57create_meta_others_T_metadata:
58 statement: |
59 CREATE TABLE IF NOT EXISTS "others_T_metadata".meta (
60 key text PRIMARY KEY,
61 value text
62 ) WITH bloom_filter_fp_chance = 0.1
63 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
64 AND comment = ''
65 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
66 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
67 AND crc_check_chance = 1.0
68 AND dclocal_read_repair_chance = 0.1
69 AND default_time_to_live = 0
70 AND gc_grace_seconds = 864000
71 AND max_index_interval = 2048
72 AND memtable_flush_period_in_ms = 0
73 AND min_index_interval = 128
74 AND read_repair_chance = 0.0
75 AND speculative_retry = '99PERCENTILE';
76
77create_data_others_T_metadata:
78 statement:
79 CREATE TABLE IF NOT EXISTS "wikipedia_T_mobileoZCBVtILw5eSrwi0VIGaFVSr2jY".data (
80 "_domain" text,
81 key text,
82 headers text,
83 tid timeuuid,
84 value blob,
85 PRIMARY KEY (("_domain", key))
86 ) WITH bloom_filter_fp_chance = 0.01
87 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
88 AND comment = ''
89 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
90 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
91 AND crc_check_chance = 1.0
92 AND dclocal_read_repair_chance = 0.1
93 AND default_time_to_live = 0
94 AND gc_grace_seconds = 864000
95 AND max_index_interval = 2048
96 AND memtable_flush_period_in_ms = 0
97 AND min_index_interval = 128
98 AND read_repair_chance = 0.0
99 AND speculative_retry = '99PERCENTILE';
100
101
102
103create_others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA:
104 statement: |
105 CREATE KEYSPACE IF NOT EXISTS "others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA" WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
106
107create_meta_others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA:
108 statement: |
109 CREATE TABLE IF NOT EXISTS "others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA".meta (
110 key text PRIMARY KEY,
111 value text
112 ) WITH bloom_filter_fp_chance = 0.1
113 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
114 AND comment = ''
115 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
116 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
117 AND crc_check_chance = 1.0
118 AND dclocal_read_repair_chance = 0.1
119 AND default_time_to_live = 0
120 AND gc_grace_seconds = 864000
121 AND max_index_interval = 2048
122 AND memtable_flush_period_in_ms = 0
123 AND min_index_interval = 128
124 AND read_repair_chance = 0.0
125 AND speculative_retry = '99PERCENTILE';
126
127create_data_others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA:
128 statement:
129 CREATE TABLE IF NOT EXISTS "wikipedia_T_mobileoZCBVtILw5eSrwi0VIGaFVSr2jY".data (
130 "_domain" text,
131 key text,
132 headers text,
133 tid timeuuid,
134 value blob,
135 PRIMARY KEY (("_domain", key))
136 ) WITH bloom_filter_fp_chance = 0.01
137 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
138 AND comment = ''
139 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
140 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
141 AND crc_check_chance = 1.0
142 AND dclocal_read_repair_chance = 0.1
143 AND default_time_to_live = 0
144 AND gc_grace_seconds = 864000
145 AND max_index_interval = 2048
146 AND memtable_flush_period_in_ms = 0
147 AND min_index_interval = 128
148 AND read_repair_chance = 0.0
149 AND speculative_retry = '99PERCENTILE';
150
151
152
153create_others_T_references:
154 statement: |
155 CREATE KEYSPACE IF NOT EXISTS "others_T_references" WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
156
157create_meta_others_T_references:
158 statement: |
159 CREATE TABLE IF NOT EXISTS "others_T_references".meta (
160 key text PRIMARY KEY,
161 value text
162 ) WITH bloom_filter_fp_chance = 0.1
163 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
164 AND comment = ''
165 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
166 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
167 AND crc_check_chance = 1.0
168 AND dclocal_read_repair_chance = 0.1
169 AND default_time_to_live = 0
170 AND gc_grace_seconds = 864000
171 AND max_index_interval = 2048
172 AND memtable_flush_period_in_ms = 0
173 AND min_index_interval = 128
174 AND read_repair_chance = 0.0
175 AND speculative_retry = '99PERCENTILE';
176
177create_data_others_T_references:
178 statement:
179 CREATE TABLE IF NOT EXISTS "wikipedia_T_mobileoZCBVtILw5eSrwi0VIGaFVSr2jY".data (
180 "_domain" text,
181 key text,
182 headers text,
183 tid timeuuid,
184 value blob,
185 PRIMARY KEY (("_domain", key))
186 ) WITH bloom_filter_fp_chance = 0.01
187 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
188 AND comment = ''
189 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
190 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
191 AND crc_check_chance = 1.0
192 AND dclocal_read_repair_chance = 0.1
193 AND default_time_to_live = 0
194 AND gc_grace_seconds = 864000
195 AND max_index_interval = 2048
196 AND memtable_flush_period_in_ms = 0
197 AND min_index_interval = 128
198 AND read_repair_chance = 0.0
199 AND speculative_retry = '99PERCENTILE';
200
201
202
203Process finished with exit code 0

Related Objects
Search...

Event Timeline

• Pchelolo created this task.Jul 23 2019, 8:27 PM
• Pchelolo moved this task from Inbox to Doing(WIP:5) on the Platform Team Workboards (Clinic Duty Team) board.
• Pchelolo moved this task from Doing(WIP:5) to Later on the Platform Team Workboards (Clinic Duty Team) board.
• Pchelolo updated the task description. (Show Details)Jul 23 2019, 8:47 PM
Restricted Application added a subscriber: Sadads. · View Herald TranscriptJul 23 2019, 8:47 PM
• Pchelolo updated the task description. (Show Details)Jul 23 2019, 8:55 PM
• Pchelolo moved this task from Later to Ready (WIP:5) on the Platform Team Workboards (Clinic Duty Team) board.Jul 23 2019, 8:59 PM
Eevans triaged this task as Medium priority.Jul 24 2019, 1:23 PM
Eevans added a comment.Jul 24 2019, 2:00 PM

It looks like some of the table names weren't substituted properly in the output above, so I regenerated.

P8795 pcs.sh
1#!/bin/bash
2
3set -e
4
5KEYSPACES=(
6 # enwiki_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4
7 # enwiki_T_metadata
8 # enwiki_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA
9 # enwiki_T_references
10 # others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4
11 # others_T_metadata
12 # others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA
13 # others_T_references
14 # wikipedia_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4
15 # wikipedia_T_metadata
16 # wikipedia_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA
17 # wikipedia_T_references
18 others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4
19 others_T_metadata
20 others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA
21 others_T_references
22)
23
24for i in ${KEYSPACES[@]}; do
25 cat <<EOF
26create_$i:
27 statement: |
28 CREATE KEYSPACE IF NOT EXISTS "$i"
29 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
30create_$i_meta:
31 statement: |
32 CREATE TABLE IF NOT EXISTS "$i".meta (
33 key text PRIMARY KEY,
34 value text
35 ) WITH bloom_filter_fp_chance = 0.1
36 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
37 AND comment = ''
38 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
39 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
40 AND crc_check_chance = 1.0
41 AND dclocal_read_repair_chance = 0.1
42 AND default_time_to_live = 0
43 AND gc_grace_seconds = 864000
44 AND max_index_interval = 2048
45 AND memtable_flush_period_in_ms = 0
46 AND min_index_interval = 128
47 AND read_repair_chance = 0.0
48 AND speculative_retry = '99PERCENTILE';
49create_$i_data:
50 statement: |
51 CREATE TABLE IF NOT EXISTS "$i".data (
52 "_domain" text,
53 key text,
54 headers text,
55 tid timeuuid,
56 value blob,
57 PRIMARY KEY (("_domain", key))
58 ) WITH bloom_filter_fp_chance = 0.01
59 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
60 AND comment = ''
61 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
62 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
63 AND crc_check_chance = 1.0
64 AND dclocal_read_repair_chance = 0.1
65 AND default_time_to_live = 0
66 AND gc_grace_seconds = 864000
67 AND max_index_interval = 2048
68 AND memtable_flush_period_in_ms = 0
69 AND min_index_interval = 128
70 AND read_repair_chance = 0.0
71 AND speculative_retry = '99PERCENTILE';
72EOF
73done

Please review; If this is OK, I'll apply it to the cluster(s)

P8796 pcs_beta.yaml
1create_others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4:
2 statement: |
3 CREATE KEYSPACE IF NOT EXISTS "others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4"
4 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
5create_:
6 statement: |
7 CREATE TABLE IF NOT EXISTS "others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4".meta (
8 key text PRIMARY KEY,
9 value text
10 ) WITH bloom_filter_fp_chance = 0.1
11 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
12 AND comment = ''
13 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
14 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
15 AND crc_check_chance = 1.0
16 AND dclocal_read_repair_chance = 0.1
17 AND default_time_to_live = 0
18 AND gc_grace_seconds = 864000
19 AND max_index_interval = 2048
20 AND memtable_flush_period_in_ms = 0
21 AND min_index_interval = 128
22 AND read_repair_chance = 0.0
23 AND speculative_retry = '99PERCENTILE';
24create_:
25 statement: |
26 CREATE TABLE IF NOT EXISTS "others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4".data (
27 "_domain" text,
28 key text,
29 headers text,
30 tid timeuuid,
31 value blob,
32 PRIMARY KEY (("_domain", key))
33 ) WITH bloom_filter_fp_chance = 0.01
34 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
35 AND comment = ''
36 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
37 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
38 AND crc_check_chance = 1.0
39 AND dclocal_read_repair_chance = 0.1
40 AND default_time_to_live = 0
41 AND gc_grace_seconds = 864000
42 AND max_index_interval = 2048
43 AND memtable_flush_period_in_ms = 0
44 AND min_index_interval = 128
45 AND read_repair_chance = 0.0
46 AND speculative_retry = '99PERCENTILE';
47create_others_T_metadata:
48 statement: |
49 CREATE KEYSPACE IF NOT EXISTS "others_T_metadata"
50 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
51create_:
52 statement: |
53 CREATE TABLE IF NOT EXISTS "others_T_metadata".meta (
54 key text PRIMARY KEY,
55 value text
56 ) WITH bloom_filter_fp_chance = 0.1
57 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
58 AND comment = ''
59 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
60 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
61 AND crc_check_chance = 1.0
62 AND dclocal_read_repair_chance = 0.1
63 AND default_time_to_live = 0
64 AND gc_grace_seconds = 864000
65 AND max_index_interval = 2048
66 AND memtable_flush_period_in_ms = 0
67 AND min_index_interval = 128
68 AND read_repair_chance = 0.0
69 AND speculative_retry = '99PERCENTILE';
70create_:
71 statement: |
72 CREATE TABLE IF NOT EXISTS "others_T_metadata".data (
73 "_domain" text,
74 key text,
75 headers text,
76 tid timeuuid,
77 value blob,
78 PRIMARY KEY (("_domain", key))
79 ) WITH bloom_filter_fp_chance = 0.01
80 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
81 AND comment = ''
82 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
83 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
84 AND crc_check_chance = 1.0
85 AND dclocal_read_repair_chance = 0.1
86 AND default_time_to_live = 0
87 AND gc_grace_seconds = 864000
88 AND max_index_interval = 2048
89 AND memtable_flush_period_in_ms = 0
90 AND min_index_interval = 128
91 AND read_repair_chance = 0.0
92 AND speculative_retry = '99PERCENTILE';
93create_others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA:
94 statement: |
95 CREATE KEYSPACE IF NOT EXISTS "others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA"
96 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
97create_:
98 statement: |
99 CREATE TABLE IF NOT EXISTS "others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA".meta (
100 key text PRIMARY KEY,
101 value text
102 ) WITH bloom_filter_fp_chance = 0.1
103 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
104 AND comment = ''
105 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
106 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
107 AND crc_check_chance = 1.0
108 AND dclocal_read_repair_chance = 0.1
109 AND default_time_to_live = 0
110 AND gc_grace_seconds = 864000
111 AND max_index_interval = 2048
112 AND memtable_flush_period_in_ms = 0
113 AND min_index_interval = 128
114 AND read_repair_chance = 0.0
115 AND speculative_retry = '99PERCENTILE';
116create_:
117 statement: |
118 CREATE TABLE IF NOT EXISTS "others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA".data (
119 "_domain" text,
120 key text,
121 headers text,
122 tid timeuuid,
123 value blob,
124 PRIMARY KEY (("_domain", key))
125 ) WITH bloom_filter_fp_chance = 0.01
126 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
127 AND comment = ''
128 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
129 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
130 AND crc_check_chance = 1.0
131 AND dclocal_read_repair_chance = 0.1
132 AND default_time_to_live = 0
133 AND gc_grace_seconds = 864000
134 AND max_index_interval = 2048
135 AND memtable_flush_period_in_ms = 0
136 AND min_index_interval = 128
137 AND read_repair_chance = 0.0
138 AND speculative_retry = '99PERCENTILE';
139create_others_T_references:
140 statement: |
141 CREATE KEYSPACE IF NOT EXISTS "others_T_references"
142 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
143create_:
144 statement: |
145 CREATE TABLE IF NOT EXISTS "others_T_references".meta (
146 key text PRIMARY KEY,
147 value text
148 ) WITH bloom_filter_fp_chance = 0.1
149 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
150 AND comment = ''
151 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
152 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
153 AND crc_check_chance = 1.0
154 AND dclocal_read_repair_chance = 0.1
155 AND default_time_to_live = 0
156 AND gc_grace_seconds = 864000
157 AND max_index_interval = 2048
158 AND memtable_flush_period_in_ms = 0
159 AND min_index_interval = 128
160 AND read_repair_chance = 0.0
161 AND speculative_retry = '99PERCENTILE';
162create_:
163 statement: |
164 CREATE TABLE IF NOT EXISTS "others_T_references".data (
165 "_domain" text,
166 key text,
167 headers text,
168 tid timeuuid,
169 value blob,
170 PRIMARY KEY (("_domain", key))
171 ) WITH bloom_filter_fp_chance = 0.01
172 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
173 AND comment = ''
174 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
175 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
176 AND crc_check_chance = 1.0
177 AND dclocal_read_repair_chance = 0.1
178 AND default_time_to_live = 0
179 AND gc_grace_seconds = 864000
180 AND max_index_interval = 2048
181 AND memtable_flush_period_in_ms = 0
182 AND min_index_interval = 128
183 AND read_repair_chance = 0.0
184 AND speculative_retry = '99PERCENTILE';

P8797 pcs_production.yaml
1create_enwiki_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4:
2 statement: |
3 CREATE KEYSPACE IF NOT EXISTS "enwiki_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4"
4 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
5create_:
6 statement: |
7 CREATE TABLE IF NOT EXISTS "enwiki_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4".meta (
8 key text PRIMARY KEY,
9 value text
10 ) WITH bloom_filter_fp_chance = 0.1
11 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
12 AND comment = ''
13 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
14 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
15 AND crc_check_chance = 1.0
16 AND dclocal_read_repair_chance = 0.1
17 AND default_time_to_live = 0
18 AND gc_grace_seconds = 864000
19 AND max_index_interval = 2048
20 AND memtable_flush_period_in_ms = 0
21 AND min_index_interval = 128
22 AND read_repair_chance = 0.0
23 AND speculative_retry = '99PERCENTILE';
24create_:
25 statement: |
26 CREATE TABLE IF NOT EXISTS "enwiki_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4".data (
27 "_domain" text,
28 key text,
29 headers text,
30 tid timeuuid,
31 value blob,
32 PRIMARY KEY (("_domain", key))
33 ) WITH bloom_filter_fp_chance = 0.01
34 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
35 AND comment = ''
36 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
37 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
38 AND crc_check_chance = 1.0
39 AND dclocal_read_repair_chance = 0.1
40 AND default_time_to_live = 0
41 AND gc_grace_seconds = 864000
42 AND max_index_interval = 2048
43 AND memtable_flush_period_in_ms = 0
44 AND min_index_interval = 128
45 AND read_repair_chance = 0.0
46 AND speculative_retry = '99PERCENTILE';
47create_enwiki_T_metadata:
48 statement: |
49 CREATE KEYSPACE IF NOT EXISTS "enwiki_T_metadata"
50 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
51create_:
52 statement: |
53 CREATE TABLE IF NOT EXISTS "enwiki_T_metadata".meta (
54 key text PRIMARY KEY,
55 value text
56 ) WITH bloom_filter_fp_chance = 0.1
57 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
58 AND comment = ''
59 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
60 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
61 AND crc_check_chance = 1.0
62 AND dclocal_read_repair_chance = 0.1
63 AND default_time_to_live = 0
64 AND gc_grace_seconds = 864000
65 AND max_index_interval = 2048
66 AND memtable_flush_period_in_ms = 0
67 AND min_index_interval = 128
68 AND read_repair_chance = 0.0
69 AND speculative_retry = '99PERCENTILE';
70create_:
71 statement: |
72 CREATE TABLE IF NOT EXISTS "enwiki_T_metadata".data (
73 "_domain" text,
74 key text,
75 headers text,
76 tid timeuuid,
77 value blob,
78 PRIMARY KEY (("_domain", key))
79 ) WITH bloom_filter_fp_chance = 0.01
80 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
81 AND comment = ''
82 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
83 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
84 AND crc_check_chance = 1.0
85 AND dclocal_read_repair_chance = 0.1
86 AND default_time_to_live = 0
87 AND gc_grace_seconds = 864000
88 AND max_index_interval = 2048
89 AND memtable_flush_period_in_ms = 0
90 AND min_index_interval = 128
91 AND read_repair_chance = 0.0
92 AND speculative_retry = '99PERCENTILE';
93create_enwiki_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA:
94 statement: |
95 CREATE KEYSPACE IF NOT EXISTS "enwiki_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA"
96 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
97create_:
98 statement: |
99 CREATE TABLE IF NOT EXISTS "enwiki_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA".meta (
100 key text PRIMARY KEY,
101 value text
102 ) WITH bloom_filter_fp_chance = 0.1
103 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
104 AND comment = ''
105 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
106 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
107 AND crc_check_chance = 1.0
108 AND dclocal_read_repair_chance = 0.1
109 AND default_time_to_live = 0
110 AND gc_grace_seconds = 864000
111 AND max_index_interval = 2048
112 AND memtable_flush_period_in_ms = 0
113 AND min_index_interval = 128
114 AND read_repair_chance = 0.0
115 AND speculative_retry = '99PERCENTILE';
116create_:
117 statement: |
118 CREATE TABLE IF NOT EXISTS "enwiki_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA".data (
119 "_domain" text,
120 key text,
121 headers text,
122 tid timeuuid,
123 value blob,
124 PRIMARY KEY (("_domain", key))
125 ) WITH bloom_filter_fp_chance = 0.01
126 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
127 AND comment = ''
128 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
129 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
130 AND crc_check_chance = 1.0
131 AND dclocal_read_repair_chance = 0.1
132 AND default_time_to_live = 0
133 AND gc_grace_seconds = 864000
134 AND max_index_interval = 2048
135 AND memtable_flush_period_in_ms = 0
136 AND min_index_interval = 128
137 AND read_repair_chance = 0.0
138 AND speculative_retry = '99PERCENTILE';
139create_enwiki_T_references:
140 statement: |
141 CREATE KEYSPACE IF NOT EXISTS "enwiki_T_references"
142 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
143create_:
144 statement: |
145 CREATE TABLE IF NOT EXISTS "enwiki_T_references".meta (
146 key text PRIMARY KEY,
147 value text
148 ) WITH bloom_filter_fp_chance = 0.1
149 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
150 AND comment = ''
151 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
152 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
153 AND crc_check_chance = 1.0
154 AND dclocal_read_repair_chance = 0.1
155 AND default_time_to_live = 0
156 AND gc_grace_seconds = 864000
157 AND max_index_interval = 2048
158 AND memtable_flush_period_in_ms = 0
159 AND min_index_interval = 128
160 AND read_repair_chance = 0.0
161 AND speculative_retry = '99PERCENTILE';
162create_:
163 statement: |
164 CREATE TABLE IF NOT EXISTS "enwiki_T_references".data (
165 "_domain" text,
166 key text,
167 headers text,
168 tid timeuuid,
169 value blob,
170 PRIMARY KEY (("_domain", key))
171 ) WITH bloom_filter_fp_chance = 0.01
172 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
173 AND comment = ''
174 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
175 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
176 AND crc_check_chance = 1.0
177 AND dclocal_read_repair_chance = 0.1
178 AND default_time_to_live = 0
179 AND gc_grace_seconds = 864000
180 AND max_index_interval = 2048
181 AND memtable_flush_period_in_ms = 0
182 AND min_index_interval = 128
183 AND read_repair_chance = 0.0
184 AND speculative_retry = '99PERCENTILE';
185create_others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4:
186 statement: |
187 CREATE KEYSPACE IF NOT EXISTS "others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4"
188 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
189create_:
190 statement: |
191 CREATE TABLE IF NOT EXISTS "others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4".meta (
192 key text PRIMARY KEY,
193 value text
194 ) WITH bloom_filter_fp_chance = 0.1
195 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
196 AND comment = ''
197 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
198 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
199 AND crc_check_chance = 1.0
200 AND dclocal_read_repair_chance = 0.1
201 AND default_time_to_live = 0
202 AND gc_grace_seconds = 864000
203 AND max_index_interval = 2048
204 AND memtable_flush_period_in_ms = 0
205 AND min_index_interval = 128
206 AND read_repair_chance = 0.0
207 AND speculative_retry = '99PERCENTILE';
208create_:
209 statement: |
210 CREATE TABLE IF NOT EXISTS "others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4".data (
211 "_domain" text,
212 key text,
213 headers text,
214 tid timeuuid,
215 value blob,
216 PRIMARY KEY (("_domain", key))
217 ) WITH bloom_filter_fp_chance = 0.01
218 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
219 AND comment = ''
220 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
221 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
222 AND crc_check_chance = 1.0
223 AND dclocal_read_repair_chance = 0.1
224 AND default_time_to_live = 0
225 AND gc_grace_seconds = 864000
226 AND max_index_interval = 2048
227 AND memtable_flush_period_in_ms = 0
228 AND min_index_interval = 128
229 AND read_repair_chance = 0.0
230 AND speculative_retry = '99PERCENTILE';
231create_others_T_metadata:
232 statement: |
233 CREATE KEYSPACE IF NOT EXISTS "others_T_metadata"
234 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
235create_:
236 statement: |
237 CREATE TABLE IF NOT EXISTS "others_T_metadata".meta (
238 key text PRIMARY KEY,
239 value text
240 ) WITH bloom_filter_fp_chance = 0.1
241 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
242 AND comment = ''
243 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
244 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
245 AND crc_check_chance = 1.0
246 AND dclocal_read_repair_chance = 0.1
247 AND default_time_to_live = 0
248 AND gc_grace_seconds = 864000
249 AND max_index_interval = 2048
250 AND memtable_flush_period_in_ms = 0
251 AND min_index_interval = 128
252 AND read_repair_chance = 0.0
253 AND speculative_retry = '99PERCENTILE';
254create_:
255 statement: |
256 CREATE TABLE IF NOT EXISTS "others_T_metadata".data (
257 "_domain" text,
258 key text,
259 headers text,
260 tid timeuuid,
261 value blob,
262 PRIMARY KEY (("_domain", key))
263 ) WITH bloom_filter_fp_chance = 0.01
264 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
265 AND comment = ''
266 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
267 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
268 AND crc_check_chance = 1.0
269 AND dclocal_read_repair_chance = 0.1
270 AND default_time_to_live = 0
271 AND gc_grace_seconds = 864000
272 AND max_index_interval = 2048
273 AND memtable_flush_period_in_ms = 0
274 AND min_index_interval = 128
275 AND read_repair_chance = 0.0
276 AND speculative_retry = '99PERCENTILE';
277create_others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA:
278 statement: |
279 CREATE KEYSPACE IF NOT EXISTS "others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA"
280 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
281create_:
282 statement: |
283 CREATE TABLE IF NOT EXISTS "others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA".meta (
284 key text PRIMARY KEY,
285 value text
286 ) WITH bloom_filter_fp_chance = 0.1
287 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
288 AND comment = ''
289 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
290 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
291 AND crc_check_chance = 1.0
292 AND dclocal_read_repair_chance = 0.1
293 AND default_time_to_live = 0
294 AND gc_grace_seconds = 864000
295 AND max_index_interval = 2048
296 AND memtable_flush_period_in_ms = 0
297 AND min_index_interval = 128
298 AND read_repair_chance = 0.0
299 AND speculative_retry = '99PERCENTILE';
300create_:
301 statement: |
302 CREATE TABLE IF NOT EXISTS "others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA".data (
303 "_domain" text,
304 key text,
305 headers text,
306 tid timeuuid,
307 value blob,
308 PRIMARY KEY (("_domain", key))
309 ) WITH bloom_filter_fp_chance = 0.01
310 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
311 AND comment = ''
312 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
313 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
314 AND crc_check_chance = 1.0
315 AND dclocal_read_repair_chance = 0.1
316 AND default_time_to_live = 0
317 AND gc_grace_seconds = 864000
318 AND max_index_interval = 2048
319 AND memtable_flush_period_in_ms = 0
320 AND min_index_interval = 128
321 AND read_repair_chance = 0.0
322 AND speculative_retry = '99PERCENTILE';
323create_others_T_references:
324 statement: |
325 CREATE KEYSPACE IF NOT EXISTS "others_T_references"
326 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
327create_:
328 statement: |
329 CREATE TABLE IF NOT EXISTS "others_T_references".meta (
330 key text PRIMARY KEY,
331 value text
332 ) WITH bloom_filter_fp_chance = 0.1
333 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
334 AND comment = ''
335 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
336 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
337 AND crc_check_chance = 1.0
338 AND dclocal_read_repair_chance = 0.1
339 AND default_time_to_live = 0
340 AND gc_grace_seconds = 864000
341 AND max_index_interval = 2048
342 AND memtable_flush_period_in_ms = 0
343 AND min_index_interval = 128
344 AND read_repair_chance = 0.0
345 AND speculative_retry = '99PERCENTILE';
346create_:
347 statement: |
348 CREATE TABLE IF NOT EXISTS "others_T_references".data (
349 "_domain" text,
350 key text,
351 headers text,
352 tid timeuuid,
353 value blob,
354 PRIMARY KEY (("_domain", key))
355 ) WITH bloom_filter_fp_chance = 0.01
356 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
357 AND comment = ''
358 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
359 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
360 AND crc_check_chance = 1.0
361 AND dclocal_read_repair_chance = 0.1
362 AND default_time_to_live = 0
363 AND gc_grace_seconds = 864000
364 AND max_index_interval = 2048
365 AND memtable_flush_period_in_ms = 0
366 AND min_index_interval = 128
367 AND read_repair_chance = 0.0
368 AND speculative_retry = '99PERCENTILE';
369create_wikipedia_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4:
370 statement: |
371 CREATE KEYSPACE IF NOT EXISTS "wikipedia_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4"
372 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
373create_:
374 statement: |
375 CREATE TABLE IF NOT EXISTS "wikipedia_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4".meta (
376 key text PRIMARY KEY,
377 value text
378 ) WITH bloom_filter_fp_chance = 0.1
379 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
380 AND comment = ''
381 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
382 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
383 AND crc_check_chance = 1.0
384 AND dclocal_read_repair_chance = 0.1
385 AND default_time_to_live = 0
386 AND gc_grace_seconds = 864000
387 AND max_index_interval = 2048
388 AND memtable_flush_period_in_ms = 0
389 AND min_index_interval = 128
390 AND read_repair_chance = 0.0
391 AND speculative_retry = '99PERCENTILE';
392create_:
393 statement: |
394 CREATE TABLE IF NOT EXISTS "wikipedia_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4".data (
395 "_domain" text,
396 key text,
397 headers text,
398 tid timeuuid,
399 value blob,
400 PRIMARY KEY (("_domain", key))
401 ) WITH bloom_filter_fp_chance = 0.01
402 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
403 AND comment = ''
404 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
405 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
406 AND crc_check_chance = 1.0
407 AND dclocal_read_repair_chance = 0.1
408 AND default_time_to_live = 0
409 AND gc_grace_seconds = 864000
410 AND max_index_interval = 2048
411 AND memtable_flush_period_in_ms = 0
412 AND min_index_interval = 128
413 AND read_repair_chance = 0.0
414 AND speculative_retry = '99PERCENTILE';
415create_wikipedia_T_metadata:
416 statement: |
417 CREATE KEYSPACE IF NOT EXISTS "wikipedia_T_metadata"
418 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
419create_:
420 statement: |
421 CREATE TABLE IF NOT EXISTS "wikipedia_T_metadata".meta (
422 key text PRIMARY KEY,
423 value text
424 ) WITH bloom_filter_fp_chance = 0.1
425 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
426 AND comment = ''
427 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
428 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
429 AND crc_check_chance = 1.0
430 AND dclocal_read_repair_chance = 0.1
431 AND default_time_to_live = 0
432 AND gc_grace_seconds = 864000
433 AND max_index_interval = 2048
434 AND memtable_flush_period_in_ms = 0
435 AND min_index_interval = 128
436 AND read_repair_chance = 0.0
437 AND speculative_retry = '99PERCENTILE';
438create_:
439 statement: |
440 CREATE TABLE IF NOT EXISTS "wikipedia_T_metadata".data (
441 "_domain" text,
442 key text,
443 headers text,
444 tid timeuuid,
445 value blob,
446 PRIMARY KEY (("_domain", key))
447 ) WITH bloom_filter_fp_chance = 0.01
448 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
449 AND comment = ''
450 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
451 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
452 AND crc_check_chance = 1.0
453 AND dclocal_read_repair_chance = 0.1
454 AND default_time_to_live = 0
455 AND gc_grace_seconds = 864000
456 AND max_index_interval = 2048
457 AND memtable_flush_period_in_ms = 0
458 AND min_index_interval = 128
459 AND read_repair_chance = 0.0
460 AND speculative_retry = '99PERCENTILE';
461create_wikipedia_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA:
462 statement: |
463 CREATE KEYSPACE IF NOT EXISTS "wikipedia_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA"
464 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
465create_:
466 statement: |
467 CREATE TABLE IF NOT EXISTS "wikipedia_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA".meta (
468 key text PRIMARY KEY,
469 value text
470 ) WITH bloom_filter_fp_chance = 0.1
471 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
472 AND comment = ''
473 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
474 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
475 AND crc_check_chance = 1.0
476 AND dclocal_read_repair_chance = 0.1
477 AND default_time_to_live = 0
478 AND gc_grace_seconds = 864000
479 AND max_index_interval = 2048
480 AND memtable_flush_period_in_ms = 0
481 AND min_index_interval = 128
482 AND read_repair_chance = 0.0
483 AND speculative_retry = '99PERCENTILE';
484create_:
485 statement: |
486 CREATE TABLE IF NOT EXISTS "wikipedia_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA".data (
487 "_domain" text,
488 key text,
489 headers text,
490 tid timeuuid,
491 value blob,
492 PRIMARY KEY (("_domain", key))
493 ) WITH bloom_filter_fp_chance = 0.01
494 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
495 AND comment = ''
496 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
497 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
498 AND crc_check_chance = 1.0
499 AND dclocal_read_repair_chance = 0.1
500 AND default_time_to_live = 0
501 AND gc_grace_seconds = 864000
502 AND max_index_interval = 2048
503 AND memtable_flush_period_in_ms = 0
504 AND min_index_interval = 128
505 AND read_repair_chance = 0.0
506 AND speculative_retry = '99PERCENTILE';
507create_wikipedia_T_references:
508 statement: |
509 CREATE KEYSPACE IF NOT EXISTS "wikipedia_T_references"
510 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
511create_:
512 statement: |
513 CREATE TABLE IF NOT EXISTS "wikipedia_T_references".meta (
514 key text PRIMARY KEY,
515 value text
516 ) WITH bloom_filter_fp_chance = 0.1
517 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
518 AND comment = ''
519 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
520 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
521 AND crc_check_chance = 1.0
522 AND dclocal_read_repair_chance = 0.1
523 AND default_time_to_live = 0
524 AND gc_grace_seconds = 864000
525 AND max_index_interval = 2048
526 AND memtable_flush_period_in_ms = 0
527 AND min_index_interval = 128
528 AND read_repair_chance = 0.0
529 AND speculative_retry = '99PERCENTILE';
530create_:
531 statement: |
532 CREATE TABLE IF NOT EXISTS "wikipedia_T_references".data (
533 "_domain" text,
534 key text,
535 headers text,
536 tid timeuuid,
537 value blob,
538 PRIMARY KEY (("_domain", key))
539 ) WITH bloom_filter_fp_chance = 0.01
540 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
541 AND comment = ''
542 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
543 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
544 AND crc_check_chance = 1.0
545 AND dclocal_read_repair_chance = 0.1
546 AND default_time_to_live = 0
547 AND gc_grace_seconds = 864000
548 AND max_index_interval = 2048
549 AND memtable_flush_period_in_ms = 0
550 AND min_index_interval = 128
551 AND read_repair_chance = 0.0
552 AND speculative_retry = '99PERCENTILE';

Eevans added a comment.Jul 24 2019, 3:10 PM

It looks like some of the table names weren't substituted properly in the output above, so I regenerated.

Oh boy, I didn't fare much better; Ignore that last comment, these should be OK.

P8798 pcs.sh
1#!/bin/bash
2
3set -e
4
5KEYSPACES=(
6 enwiki_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4
7 enwiki_T_metadata
8 enwiki_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA
9 enwiki_T_references
10 others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4
11 others_T_metadata
12 others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA
13 others_T_references
14 wikipedia_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4
15 wikipedia_T_metadata
16 wikipedia_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA
17 wikipedia_T_references
18 # others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4
19 # others_T_metadata
20 # others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA
21 # others_T_references
22)
23
24for i in ${KEYSPACES[@]}; do
25 cat <<EOF
26create_$i:
27 statement: |
28 CREATE KEYSPACE IF NOT EXISTS "$i"
29 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
30create_$i-meta:
31 statement: |
32 CREATE TABLE IF NOT EXISTS "$i".meta (
33 key text PRIMARY KEY,
34 value text
35 ) WITH bloom_filter_fp_chance = 0.1
36 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
37 AND comment = ''
38 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
39 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
40 AND crc_check_chance = 1.0
41 AND dclocal_read_repair_chance = 0.1
42 AND default_time_to_live = 0
43 AND gc_grace_seconds = 864000
44 AND max_index_interval = 2048
45 AND memtable_flush_period_in_ms = 0
46 AND min_index_interval = 128
47 AND read_repair_chance = 0.0
48 AND speculative_retry = '99PERCENTILE';
49create_$i-data:
50 statement: |
51 CREATE TABLE IF NOT EXISTS "$i".data (
52 "_domain" text,
53 key text,
54 headers text,
55 tid timeuuid,
56 value blob,
57 PRIMARY KEY (("_domain", key))
58 ) WITH bloom_filter_fp_chance = 0.01
59 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
60 AND comment = ''
61 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
62 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
63 AND crc_check_chance = 1.0
64 AND dclocal_read_repair_chance = 0.1
65 AND default_time_to_live = 0
66 AND gc_grace_seconds = 864000
67 AND max_index_interval = 2048
68 AND memtable_flush_period_in_ms = 0
69 AND min_index_interval = 128
70 AND read_repair_chance = 0.0
71 AND speculative_retry = '99PERCENTILE';
72EOF
73done

P8799 pcs_beta.yaml
1create_others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4:
2 statement: |
3 CREATE KEYSPACE IF NOT EXISTS "others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4"
4 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
5create_others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4-meta:
6 statement: |
7 CREATE TABLE IF NOT EXISTS "others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4".meta (
8 key text PRIMARY KEY,
9 value text
10 ) WITH bloom_filter_fp_chance = 0.1
11 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
12 AND comment = ''
13 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
14 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
15 AND crc_check_chance = 1.0
16 AND dclocal_read_repair_chance = 0.1
17 AND default_time_to_live = 0
18 AND gc_grace_seconds = 864000
19 AND max_index_interval = 2048
20 AND memtable_flush_period_in_ms = 0
21 AND min_index_interval = 128
22 AND read_repair_chance = 0.0
23 AND speculative_retry = '99PERCENTILE';
24create_others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4-data:
25 statement: |
26 CREATE TABLE IF NOT EXISTS "others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4".data (
27 "_domain" text,
28 key text,
29 headers text,
30 tid timeuuid,
31 value blob,
32 PRIMARY KEY (("_domain", key))
33 ) WITH bloom_filter_fp_chance = 0.01
34 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
35 AND comment = ''
36 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
37 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
38 AND crc_check_chance = 1.0
39 AND dclocal_read_repair_chance = 0.1
40 AND default_time_to_live = 0
41 AND gc_grace_seconds = 864000
42 AND max_index_interval = 2048
43 AND memtable_flush_period_in_ms = 0
44 AND min_index_interval = 128
45 AND read_repair_chance = 0.0
46 AND speculative_retry = '99PERCENTILE';
47create_others_T_metadata:
48 statement: |
49 CREATE KEYSPACE IF NOT EXISTS "others_T_metadata"
50 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
51create_others_T_metadata-meta:
52 statement: |
53 CREATE TABLE IF NOT EXISTS "others_T_metadata".meta (
54 key text PRIMARY KEY,
55 value text
56 ) WITH bloom_filter_fp_chance = 0.1
57 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
58 AND comment = ''
59 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
60 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
61 AND crc_check_chance = 1.0
62 AND dclocal_read_repair_chance = 0.1
63 AND default_time_to_live = 0
64 AND gc_grace_seconds = 864000
65 AND max_index_interval = 2048
66 AND memtable_flush_period_in_ms = 0
67 AND min_index_interval = 128
68 AND read_repair_chance = 0.0
69 AND speculative_retry = '99PERCENTILE';
70create_others_T_metadata-data:
71 statement: |
72 CREATE TABLE IF NOT EXISTS "others_T_metadata".data (
73 "_domain" text,
74 key text,
75 headers text,
76 tid timeuuid,
77 value blob,
78 PRIMARY KEY (("_domain", key))
79 ) WITH bloom_filter_fp_chance = 0.01
80 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
81 AND comment = ''
82 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
83 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
84 AND crc_check_chance = 1.0
85 AND dclocal_read_repair_chance = 0.1
86 AND default_time_to_live = 0
87 AND gc_grace_seconds = 864000
88 AND max_index_interval = 2048
89 AND memtable_flush_period_in_ms = 0
90 AND min_index_interval = 128
91 AND read_repair_chance = 0.0
92 AND speculative_retry = '99PERCENTILE';
93create_others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA:
94 statement: |
95 CREATE KEYSPACE IF NOT EXISTS "others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA"
96 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
97create_others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA-meta:
98 statement: |
99 CREATE TABLE IF NOT EXISTS "others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA".meta (
100 key text PRIMARY KEY,
101 value text
102 ) WITH bloom_filter_fp_chance = 0.1
103 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
104 AND comment = ''
105 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
106 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
107 AND crc_check_chance = 1.0
108 AND dclocal_read_repair_chance = 0.1
109 AND default_time_to_live = 0
110 AND gc_grace_seconds = 864000
111 AND max_index_interval = 2048
112 AND memtable_flush_period_in_ms = 0
113 AND min_index_interval = 128
114 AND read_repair_chance = 0.0
115 AND speculative_retry = '99PERCENTILE';
116create_others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA-data:
117 statement: |
118 CREATE TABLE IF NOT EXISTS "others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA".data (
119 "_domain" text,
120 key text,
121 headers text,
122 tid timeuuid,
123 value blob,
124 PRIMARY KEY (("_domain", key))
125 ) WITH bloom_filter_fp_chance = 0.01
126 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
127 AND comment = ''
128 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
129 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
130 AND crc_check_chance = 1.0
131 AND dclocal_read_repair_chance = 0.1
132 AND default_time_to_live = 0
133 AND gc_grace_seconds = 864000
134 AND max_index_interval = 2048
135 AND memtable_flush_period_in_ms = 0
136 AND min_index_interval = 128
137 AND read_repair_chance = 0.0
138 AND speculative_retry = '99PERCENTILE';
139create_others_T_references:
140 statement: |
141 CREATE KEYSPACE IF NOT EXISTS "others_T_references"
142 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
143create_others_T_references-meta:
144 statement: |
145 CREATE TABLE IF NOT EXISTS "others_T_references".meta (
146 key text PRIMARY KEY,
147 value text
148 ) WITH bloom_filter_fp_chance = 0.1
149 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
150 AND comment = ''
151 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
152 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
153 AND crc_check_chance = 1.0
154 AND dclocal_read_repair_chance = 0.1
155 AND default_time_to_live = 0
156 AND gc_grace_seconds = 864000
157 AND max_index_interval = 2048
158 AND memtable_flush_period_in_ms = 0
159 AND min_index_interval = 128
160 AND read_repair_chance = 0.0
161 AND speculative_retry = '99PERCENTILE';
162create_others_T_references-data:
163 statement: |
164 CREATE TABLE IF NOT EXISTS "others_T_references".data (
165 "_domain" text,
166 key text,
167 headers text,
168 tid timeuuid,
169 value blob,
170 PRIMARY KEY (("_domain", key))
171 ) WITH bloom_filter_fp_chance = 0.01
172 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
173 AND comment = ''
174 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
175 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
176 AND crc_check_chance = 1.0
177 AND dclocal_read_repair_chance = 0.1
178 AND default_time_to_live = 0
179 AND gc_grace_seconds = 864000
180 AND max_index_interval = 2048
181 AND memtable_flush_period_in_ms = 0
182 AND min_index_interval = 128
183 AND read_repair_chance = 0.0
184 AND speculative_retry = '99PERCENTILE';

P8800 pcs_production.yaml
1create_enwiki_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4:
2 statement: |
3 CREATE KEYSPACE IF NOT EXISTS "enwiki_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4"
4 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
5create_enwiki_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4-meta:
6 statement: |
7 CREATE TABLE IF NOT EXISTS "enwiki_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4".meta (
8 key text PRIMARY KEY,
9 value text
10 ) WITH bloom_filter_fp_chance = 0.1
11 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
12 AND comment = ''
13 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
14 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
15 AND crc_check_chance = 1.0
16 AND dclocal_read_repair_chance = 0.1
17 AND default_time_to_live = 0
18 AND gc_grace_seconds = 864000
19 AND max_index_interval = 2048
20 AND memtable_flush_period_in_ms = 0
21 AND min_index_interval = 128
22 AND read_repair_chance = 0.0
23 AND speculative_retry = '99PERCENTILE';
24create_enwiki_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4-data:
25 statement: |
26 CREATE TABLE IF NOT EXISTS "enwiki_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4".data (
27 "_domain" text,
28 key text,
29 headers text,
30 tid timeuuid,
31 value blob,
32 PRIMARY KEY (("_domain", key))
33 ) WITH bloom_filter_fp_chance = 0.01
34 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
35 AND comment = ''
36 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
37 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
38 AND crc_check_chance = 1.0
39 AND dclocal_read_repair_chance = 0.1
40 AND default_time_to_live = 0
41 AND gc_grace_seconds = 864000
42 AND max_index_interval = 2048
43 AND memtable_flush_period_in_ms = 0
44 AND min_index_interval = 128
45 AND read_repair_chance = 0.0
46 AND speculative_retry = '99PERCENTILE';
47create_enwiki_T_metadata:
48 statement: |
49 CREATE KEYSPACE IF NOT EXISTS "enwiki_T_metadata"
50 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
51create_enwiki_T_metadata-meta:
52 statement: |
53 CREATE TABLE IF NOT EXISTS "enwiki_T_metadata".meta (
54 key text PRIMARY KEY,
55 value text
56 ) WITH bloom_filter_fp_chance = 0.1
57 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
58 AND comment = ''
59 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
60 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
61 AND crc_check_chance = 1.0
62 AND dclocal_read_repair_chance = 0.1
63 AND default_time_to_live = 0
64 AND gc_grace_seconds = 864000
65 AND max_index_interval = 2048
66 AND memtable_flush_period_in_ms = 0
67 AND min_index_interval = 128
68 AND read_repair_chance = 0.0
69 AND speculative_retry = '99PERCENTILE';
70create_enwiki_T_metadata-data:
71 statement: |
72 CREATE TABLE IF NOT EXISTS "enwiki_T_metadata".data (
73 "_domain" text,
74 key text,
75 headers text,
76 tid timeuuid,
77 value blob,
78 PRIMARY KEY (("_domain", key))
79 ) WITH bloom_filter_fp_chance = 0.01
80 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
81 AND comment = ''
82 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
83 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
84 AND crc_check_chance = 1.0
85 AND dclocal_read_repair_chance = 0.1
86 AND default_time_to_live = 0
87 AND gc_grace_seconds = 864000
88 AND max_index_interval = 2048
89 AND memtable_flush_period_in_ms = 0
90 AND min_index_interval = 128
91 AND read_repair_chance = 0.0
92 AND speculative_retry = '99PERCENTILE';
93create_enwiki_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA:
94 statement: |
95 CREATE KEYSPACE IF NOT EXISTS "enwiki_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA"
96 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
97create_enwiki_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA-meta:
98 statement: |
99 CREATE TABLE IF NOT EXISTS "enwiki_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA".meta (
100 key text PRIMARY KEY,
101 value text
102 ) WITH bloom_filter_fp_chance = 0.1
103 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
104 AND comment = ''
105 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
106 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
107 AND crc_check_chance = 1.0
108 AND dclocal_read_repair_chance = 0.1
109 AND default_time_to_live = 0
110 AND gc_grace_seconds = 864000
111 AND max_index_interval = 2048
112 AND memtable_flush_period_in_ms = 0
113 AND min_index_interval = 128
114 AND read_repair_chance = 0.0
115 AND speculative_retry = '99PERCENTILE';
116create_enwiki_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA-data:
117 statement: |
118 CREATE TABLE IF NOT EXISTS "enwiki_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA".data (
119 "_domain" text,
120 key text,
121 headers text,
122 tid timeuuid,
123 value blob,
124 PRIMARY KEY (("_domain", key))
125 ) WITH bloom_filter_fp_chance = 0.01
126 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
127 AND comment = ''
128 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
129 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
130 AND crc_check_chance = 1.0
131 AND dclocal_read_repair_chance = 0.1
132 AND default_time_to_live = 0
133 AND gc_grace_seconds = 864000
134 AND max_index_interval = 2048
135 AND memtable_flush_period_in_ms = 0
136 AND min_index_interval = 128
137 AND read_repair_chance = 0.0
138 AND speculative_retry = '99PERCENTILE';
139create_enwiki_T_references:
140 statement: |
141 CREATE KEYSPACE IF NOT EXISTS "enwiki_T_references"
142 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
143create_enwiki_T_references-meta:
144 statement: |
145 CREATE TABLE IF NOT EXISTS "enwiki_T_references".meta (
146 key text PRIMARY KEY,
147 value text
148 ) WITH bloom_filter_fp_chance = 0.1
149 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
150 AND comment = ''
151 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
152 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
153 AND crc_check_chance = 1.0
154 AND dclocal_read_repair_chance = 0.1
155 AND default_time_to_live = 0
156 AND gc_grace_seconds = 864000
157 AND max_index_interval = 2048
158 AND memtable_flush_period_in_ms = 0
159 AND min_index_interval = 128
160 AND read_repair_chance = 0.0
161 AND speculative_retry = '99PERCENTILE';
162create_enwiki_T_references-data:
163 statement: |
164 CREATE TABLE IF NOT EXISTS "enwiki_T_references".data (
165 "_domain" text,
166 key text,
167 headers text,
168 tid timeuuid,
169 value blob,
170 PRIMARY KEY (("_domain", key))
171 ) WITH bloom_filter_fp_chance = 0.01
172 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
173 AND comment = ''
174 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
175 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
176 AND crc_check_chance = 1.0
177 AND dclocal_read_repair_chance = 0.1
178 AND default_time_to_live = 0
179 AND gc_grace_seconds = 864000
180 AND max_index_interval = 2048
181 AND memtable_flush_period_in_ms = 0
182 AND min_index_interval = 128
183 AND read_repair_chance = 0.0
184 AND speculative_retry = '99PERCENTILE';
185create_others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4:
186 statement: |
187 CREATE KEYSPACE IF NOT EXISTS "others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4"
188 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
189create_others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4-meta:
190 statement: |
191 CREATE TABLE IF NOT EXISTS "others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4".meta (
192 key text PRIMARY KEY,
193 value text
194 ) WITH bloom_filter_fp_chance = 0.1
195 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
196 AND comment = ''
197 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
198 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
199 AND crc_check_chance = 1.0
200 AND dclocal_read_repair_chance = 0.1
201 AND default_time_to_live = 0
202 AND gc_grace_seconds = 864000
203 AND max_index_interval = 2048
204 AND memtable_flush_period_in_ms = 0
205 AND min_index_interval = 128
206 AND read_repair_chance = 0.0
207 AND speculative_retry = '99PERCENTILE';
208create_others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4-data:
209 statement: |
210 CREATE TABLE IF NOT EXISTS "others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4".data (
211 "_domain" text,
212 key text,
213 headers text,
214 tid timeuuid,
215 value blob,
216 PRIMARY KEY (("_domain", key))
217 ) WITH bloom_filter_fp_chance = 0.01
218 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
219 AND comment = ''
220 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
221 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
222 AND crc_check_chance = 1.0
223 AND dclocal_read_repair_chance = 0.1
224 AND default_time_to_live = 0
225 AND gc_grace_seconds = 864000
226 AND max_index_interval = 2048
227 AND memtable_flush_period_in_ms = 0
228 AND min_index_interval = 128
229 AND read_repair_chance = 0.0
230 AND speculative_retry = '99PERCENTILE';
231create_others_T_metadata:
232 statement: |
233 CREATE KEYSPACE IF NOT EXISTS "others_T_metadata"
234 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
235create_others_T_metadata-meta:
236 statement: |
237 CREATE TABLE IF NOT EXISTS "others_T_metadata".meta (
238 key text PRIMARY KEY,
239 value text
240 ) WITH bloom_filter_fp_chance = 0.1
241 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
242 AND comment = ''
243 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
244 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
245 AND crc_check_chance = 1.0
246 AND dclocal_read_repair_chance = 0.1
247 AND default_time_to_live = 0
248 AND gc_grace_seconds = 864000
249 AND max_index_interval = 2048
250 AND memtable_flush_period_in_ms = 0
251 AND min_index_interval = 128
252 AND read_repair_chance = 0.0
253 AND speculative_retry = '99PERCENTILE';
254create_others_T_metadata-data:
255 statement: |
256 CREATE TABLE IF NOT EXISTS "others_T_metadata".data (
257 "_domain" text,
258 key text,
259 headers text,
260 tid timeuuid,
261 value blob,
262 PRIMARY KEY (("_domain", key))
263 ) WITH bloom_filter_fp_chance = 0.01
264 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
265 AND comment = ''
266 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
267 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
268 AND crc_check_chance = 1.0
269 AND dclocal_read_repair_chance = 0.1
270 AND default_time_to_live = 0
271 AND gc_grace_seconds = 864000
272 AND max_index_interval = 2048
273 AND memtable_flush_period_in_ms = 0
274 AND min_index_interval = 128
275 AND read_repair_chance = 0.0
276 AND speculative_retry = '99PERCENTILE';
277create_others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA:
278 statement: |
279 CREATE KEYSPACE IF NOT EXISTS "others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA"
280 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
281create_others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA-meta:
282 statement: |
283 CREATE TABLE IF NOT EXISTS "others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA".meta (
284 key text PRIMARY KEY,
285 value text
286 ) WITH bloom_filter_fp_chance = 0.1
287 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
288 AND comment = ''
289 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
290 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
291 AND crc_check_chance = 1.0
292 AND dclocal_read_repair_chance = 0.1
293 AND default_time_to_live = 0
294 AND gc_grace_seconds = 864000
295 AND max_index_interval = 2048
296 AND memtable_flush_period_in_ms = 0
297 AND min_index_interval = 128
298 AND read_repair_chance = 0.0
299 AND speculative_retry = '99PERCENTILE';
300create_others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA-data:
301 statement: |
302 CREATE TABLE IF NOT EXISTS "others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA".data (
303 "_domain" text,
304 key text,
305 headers text,
306 tid timeuuid,
307 value blob,
308 PRIMARY KEY (("_domain", key))
309 ) WITH bloom_filter_fp_chance = 0.01
310 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
311 AND comment = ''
312 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
313 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
314 AND crc_check_chance = 1.0
315 AND dclocal_read_repair_chance = 0.1
316 AND default_time_to_live = 0
317 AND gc_grace_seconds = 864000
318 AND max_index_interval = 2048
319 AND memtable_flush_period_in_ms = 0
320 AND min_index_interval = 128
321 AND read_repair_chance = 0.0
322 AND speculative_retry = '99PERCENTILE';
323create_others_T_references:
324 statement: |
325 CREATE KEYSPACE IF NOT EXISTS "others_T_references"
326 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
327create_others_T_references-meta:
328 statement: |
329 CREATE TABLE IF NOT EXISTS "others_T_references".meta (
330 key text PRIMARY KEY,
331 value text
332 ) WITH bloom_filter_fp_chance = 0.1
333 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
334 AND comment = ''
335 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
336 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
337 AND crc_check_chance = 1.0
338 AND dclocal_read_repair_chance = 0.1
339 AND default_time_to_live = 0
340 AND gc_grace_seconds = 864000
341 AND max_index_interval = 2048
342 AND memtable_flush_period_in_ms = 0
343 AND min_index_interval = 128
344 AND read_repair_chance = 0.0
345 AND speculative_retry = '99PERCENTILE';
346create_others_T_references-data:
347 statement: |
348 CREATE TABLE IF NOT EXISTS "others_T_references".data (
349 "_domain" text,
350 key text,
351 headers text,
352 tid timeuuid,
353 value blob,
354 PRIMARY KEY (("_domain", key))
355 ) WITH bloom_filter_fp_chance = 0.01
356 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
357 AND comment = ''
358 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
359 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
360 AND crc_check_chance = 1.0
361 AND dclocal_read_repair_chance = 0.1
362 AND default_time_to_live = 0
363 AND gc_grace_seconds = 864000
364 AND max_index_interval = 2048
365 AND memtable_flush_period_in_ms = 0
366 AND min_index_interval = 128
367 AND read_repair_chance = 0.0
368 AND speculative_retry = '99PERCENTILE';
369create_wikipedia_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4:
370 statement: |
371 CREATE KEYSPACE IF NOT EXISTS "wikipedia_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4"
372 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
373create_wikipedia_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4-meta:
374 statement: |
375 CREATE TABLE IF NOT EXISTS "wikipedia_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4".meta (
376 key text PRIMARY KEY,
377 value text
378 ) WITH bloom_filter_fp_chance = 0.1
379 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
380 AND comment = ''
381 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
382 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
383 AND crc_check_chance = 1.0
384 AND dclocal_read_repair_chance = 0.1
385 AND default_time_to_live = 0
386 AND gc_grace_seconds = 864000
387 AND max_index_interval = 2048
388 AND memtable_flush_period_in_ms = 0
389 AND min_index_interval = 128
390 AND read_repair_chance = 0.0
391 AND speculative_retry = '99PERCENTILE';
392create_wikipedia_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4-data:
393 statement: |
394 CREATE TABLE IF NOT EXISTS "wikipedia_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4".data (
395 "_domain" text,
396 key text,
397 headers text,
398 tid timeuuid,
399 value blob,
400 PRIMARY KEY (("_domain", key))
401 ) WITH bloom_filter_fp_chance = 0.01
402 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
403 AND comment = ''
404 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
405 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
406 AND crc_check_chance = 1.0
407 AND dclocal_read_repair_chance = 0.1
408 AND default_time_to_live = 0
409 AND gc_grace_seconds = 864000
410 AND max_index_interval = 2048
411 AND memtable_flush_period_in_ms = 0
412 AND min_index_interval = 128
413 AND read_repair_chance = 0.0
414 AND speculative_retry = '99PERCENTILE';
415create_wikipedia_T_metadata:
416 statement: |
417 CREATE KEYSPACE IF NOT EXISTS "wikipedia_T_metadata"
418 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
419create_wikipedia_T_metadata-meta:
420 statement: |
421 CREATE TABLE IF NOT EXISTS "wikipedia_T_metadata".meta (
422 key text PRIMARY KEY,
423 value text
424 ) WITH bloom_filter_fp_chance = 0.1
425 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
426 AND comment = ''
427 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
428 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
429 AND crc_check_chance = 1.0
430 AND dclocal_read_repair_chance = 0.1
431 AND default_time_to_live = 0
432 AND gc_grace_seconds = 864000
433 AND max_index_interval = 2048
434 AND memtable_flush_period_in_ms = 0
435 AND min_index_interval = 128
436 AND read_repair_chance = 0.0
437 AND speculative_retry = '99PERCENTILE';
438create_wikipedia_T_metadata-data:
439 statement: |
440 CREATE TABLE IF NOT EXISTS "wikipedia_T_metadata".data (
441 "_domain" text,
442 key text,
443 headers text,
444 tid timeuuid,
445 value blob,
446 PRIMARY KEY (("_domain", key))
447 ) WITH bloom_filter_fp_chance = 0.01
448 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
449 AND comment = ''
450 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
451 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
452 AND crc_check_chance = 1.0
453 AND dclocal_read_repair_chance = 0.1
454 AND default_time_to_live = 0
455 AND gc_grace_seconds = 864000
456 AND max_index_interval = 2048
457 AND memtable_flush_period_in_ms = 0
458 AND min_index_interval = 128
459 AND read_repair_chance = 0.0
460 AND speculative_retry = '99PERCENTILE';
461create_wikipedia_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA:
462 statement: |
463 CREATE KEYSPACE IF NOT EXISTS "wikipedia_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA"
464 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
465create_wikipedia_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA-meta:
466 statement: |
467 CREATE TABLE IF NOT EXISTS "wikipedia_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA".meta (
468 key text PRIMARY KEY,
469 value text
470 ) WITH bloom_filter_fp_chance = 0.1
471 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
472 AND comment = ''
473 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
474 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
475 AND crc_check_chance = 1.0
476 AND dclocal_read_repair_chance = 0.1
477 AND default_time_to_live = 0
478 AND gc_grace_seconds = 864000
479 AND max_index_interval = 2048
480 AND memtable_flush_period_in_ms = 0
481 AND min_index_interval = 128
482 AND read_repair_chance = 0.0
483 AND speculative_retry = '99PERCENTILE';
484create_wikipedia_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA-data:
485 statement: |
486 CREATE TABLE IF NOT EXISTS "wikipedia_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA".data (
487 "_domain" text,
488 key text,
489 headers text,
490 tid timeuuid,
491 value blob,
492 PRIMARY KEY (("_domain", key))
493 ) WITH bloom_filter_fp_chance = 0.01
494 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
495 AND comment = ''
496 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
497 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
498 AND crc_check_chance = 1.0
499 AND dclocal_read_repair_chance = 0.1
500 AND default_time_to_live = 0
501 AND gc_grace_seconds = 864000
502 AND max_index_interval = 2048
503 AND memtable_flush_period_in_ms = 0
504 AND min_index_interval = 128
505 AND read_repair_chance = 0.0
506 AND speculative_retry = '99PERCENTILE';
507create_wikipedia_T_references:
508 statement: |
509 CREATE KEYSPACE IF NOT EXISTS "wikipedia_T_references"
510 WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
511create_wikipedia_T_references-meta:
512 statement: |
513 CREATE TABLE IF NOT EXISTS "wikipedia_T_references".meta (
514 key text PRIMARY KEY,
515 value text
516 ) WITH bloom_filter_fp_chance = 0.1
517 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
518 AND comment = ''
519 AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
520 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
521 AND crc_check_chance = 1.0
522 AND dclocal_read_repair_chance = 0.1
523 AND default_time_to_live = 0
524 AND gc_grace_seconds = 864000
525 AND max_index_interval = 2048
526 AND memtable_flush_period_in_ms = 0
527 AND min_index_interval = 128
528 AND read_repair_chance = 0.0
529 AND speculative_retry = '99PERCENTILE';
530create_wikipedia_T_references-data:
531 statement: |
532 CREATE TABLE IF NOT EXISTS "wikipedia_T_references".data (
533 "_domain" text,
534 key text,
535 headers text,
536 tid timeuuid,
537 value blob,
538 PRIMARY KEY (("_domain", key))
539 ) WITH bloom_filter_fp_chance = 0.01
540 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
541 AND comment = ''
542 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
543 AND compression = {'chunk_length_in_kb': '32', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
544 AND crc_check_chance = 1.0
545 AND dclocal_read_repair_chance = 0.1
546 AND default_time_to_live = 0
547 AND gc_grace_seconds = 864000
548 AND max_index_interval = 2048
549 AND memtable_flush_period_in_ms = 0
550 AND min_index_interval = 128
551 AND read_repair_chance = 0.0
552 AND speculative_retry = '99PERCENTILE';

Eevans added a comment.Jul 24 2019, 3:15 PM

This has been applied to deployment-prep.

eevans@deployment-restbase01:~/cassandra-schema-nodejs$ node bin/mkschema --without-ssl -u xxxxxxxxxxx -p xxxxxxxxxxx -H deployment-restbase01 ../pcs_beta.yaml 
[2019-07-24T15:12:44.883Z]  Applying 'create_others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4'...
[2019-07-24T15:12:46.164Z]  Verifying schema agreement (attempt #1)...
[2019-07-24T15:12:46.517Z]  Successfully applied 'create_others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4'
[2019-07-24T15:12:46.517Z]  Applying 'create_others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4-meta'...
[2019-07-24T15:12:48.118Z]  Verifying schema agreement (attempt #1)...
[2019-07-24T15:12:48.414Z]  Successfully applied 'create_others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4-meta'
[2019-07-24T15:12:48.414Z]  Applying 'create_others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4-data'...
[2019-07-24T15:12:49.511Z]  Verifying schema agreement (attempt #1)...
[2019-07-24T15:12:49.809Z]  Successfully applied 'create_others_T_mediaEKhjXRLvi0_47tdHyL7nahpjtY4-data'
[2019-07-24T15:12:49.809Z]  Applying 'create_others_T_metadata'...
[2019-07-24T15:12:51.379Z]  Verifying schema agreement (attempt #1)...
[2019-07-24T15:12:51.625Z]  Successfully applied 'create_others_T_metadata'
[2019-07-24T15:12:51.626Z]  Applying 'create_others_T_metadata-meta'...
[2019-07-24T15:12:53.221Z]  Verifying schema agreement (attempt #1)...
[2019-07-24T15:12:53.512Z]  Successfully applied 'create_others_T_metadata-meta'
[2019-07-24T15:12:53.512Z]  Applying 'create_others_T_metadata-data'...
[2019-07-24T15:12:54.616Z]  Verifying schema agreement (attempt #1)...
[2019-07-24T15:12:54.869Z]  Successfully applied 'create_others_T_metadata-data'
[2019-07-24T15:12:54.869Z]  Applying 'create_others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA'...
[2019-07-24T15:12:56.458Z]  Verifying schema agreement (attempt #1)...
[2019-07-24T15:12:56.751Z]  Successfully applied 'create_others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA'
[2019-07-24T15:12:56.751Z]  Applying 'create_others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA-meta'...
[2019-07-24T15:12:58.346Z]  Verifying schema agreement (attempt #1)...
[2019-07-24T15:12:58.607Z]  Successfully applied 'create_others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA-meta'
[2019-07-24T15:12:58.607Z]  Applying 'create_others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA-data'...
[2019-07-24T15:13:00.206Z]  Verifying schema agreement (attempt #1)...
[2019-07-24T15:13:00.508Z]  Successfully applied 'create_others_T_mobileVuV78NVnWlTWLhDwwr5v2FMH2wA-data'
[2019-07-24T15:13:00.509Z]  Applying 'create_others_T_references'...
[2019-07-24T15:13:01.560Z]  Verifying schema agreement (attempt #1)...
[2019-07-24T15:13:01.789Z]  Successfully applied 'create_others_T_references'
[2019-07-24T15:13:01.789Z]  Applying 'create_others_T_references-meta'...
[2019-07-24T15:13:03.391Z]  Verifying schema agreement (attempt #1)...
[2019-07-24T15:13:03.726Z]  Successfully applied 'create_others_T_references-meta'
[2019-07-24T15:13:03.726Z]  Applying 'create_others_T_references-data'...
[2019-07-24T15:13:05.331Z]  Verifying schema agreement (attempt #1)...
[2019-07-24T15:13:05.631Z]  Successfully applied 'create_others_T_references-data'
eevans@deployment-restbase01:~/cassandra-schema-nodejs$

@Pchelolo Can you review the YAML for production and/or what was created on deployment-prep before I continue?

LGoto moved this task from Needs triage to Tracking on the Product-Infrastructure-Team-Backlog-Deprecated board.Jul 24 2019, 3:37 PM
Stashbot added a comment.Jul 24 2019, 6:13 PM

Mentioned in SAL (#wikimedia-operations) [2019-07-24T18:13:00Z] <urandom> creating new restbase keyspaces -- T228804

Eevans closed this task as Resolved.Jul 24 2019, 6:20 PM

Complete.

WDoranWMF moved this task from Ready (WIP:5) to Done on the Platform Team Workboards (Clinic Duty Team) board.Jul 30 2019, 2:42 PM
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