-
-
Save philip-doctor/1362a1fdd95adcf73cc9 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
cqlsh> describe KEYSPACE "OpsCenter"; | |
CREATE KEYSPACE "OpsCenter" WITH replication = { | |
'class': 'SimpleStrategy', | |
'replication_factor': '1' | |
}; | |
USE "OpsCenter"; | |
CREATE TABLE backup_reports ( | |
week text, | |
event_time timestamp, | |
backup_id text, | |
type text, | |
destination text, | |
deleted_at timestamp, | |
full_status text, | |
keyspaces text, | |
status text, | |
PRIMARY KEY ((week), event_time, backup_id, type, destination) | |
) WITH CLUSTERING ORDER BY (event_time DESC, backup_id ASC, type ASC, destination ASC) AND | |
bloom_filter_fp_chance=0.010000 AND | |
caching='KEYS_ONLY' AND | |
comment='{"info": "OpsCenter management data.", "version": [5, 2, 0]}' AND | |
dclocal_read_repair_chance=0.100000 AND | |
gc_grace_seconds=864000 AND | |
index_interval=128 AND | |
read_repair_chance=0.000000 AND | |
replicate_on_write='true' AND | |
populate_io_cache_on_flush='false' AND | |
default_time_to_live=0 AND | |
speculative_retry='99.0PERCENTILE' AND | |
memtable_flush_period_in_ms=0 AND | |
compaction={'class': 'SizeTieredCompactionStrategy'} AND | |
compression={'sstable_compression': 'LZ4Compressor'}; | |
CREATE TABLE bestpractice_results ( | |
key text, | |
column1 varint, | |
value blob, | |
PRIMARY KEY ((key), column1) | |
) WITH COMPACT STORAGE AND | |
CLUSTERING ORDER BY (column1 DESC) AND | |
bloom_filter_fp_chance=0.010000 AND | |
caching='KEYS_ONLY' AND | |
comment='{"info": "OpsCenter management data.", "version": [5, 2, 0]}' AND | |
dclocal_read_repair_chance=0.100000 AND | |
gc_grace_seconds=0 AND | |
index_interval=128 AND | |
read_repair_chance=0.250000 AND | |
replicate_on_write='true' AND | |
populate_io_cache_on_flush='false' AND | |
default_time_to_live=0 AND | |
speculative_retry='99.0PERCENTILE' AND | |
memtable_flush_period_in_ms=0 AND | |
compaction={'min_threshold': '4', 'class': 'SizeTieredCompactionStrategy', 'max_threshold': '32'} AND | |
compression={'sstable_compression': 'LZ4Compressor'}; | |
CREATE TABLE events ( | |
key text, | |
action bigint, | |
api_source_ip text, | |
column_family text, | |
event_source text, | |
"keyspace" text, | |
level bigint, | |
message text, | |
source_node text, | |
success boolean, | |
target_node text, | |
time bigint, | |
user text, | |
PRIMARY KEY ((key)) | |
) WITH COMPACT STORAGE AND | |
bloom_filter_fp_chance=0.010000 AND | |
caching='KEYS_ONLY' AND | |
comment='{"info": "OpsCenter management data.", "version": [5, 2, 0]}' AND | |
dclocal_read_repair_chance=0.100000 AND | |
gc_grace_seconds=864000 AND | |
index_interval=128 AND | |
read_repair_chance=0.250000 AND | |
replicate_on_write='true' AND | |
populate_io_cache_on_flush='false' AND | |
default_time_to_live=0 AND | |
speculative_retry='99.0PERCENTILE' AND | |
memtable_flush_period_in_ms=0 AND | |
compaction={'min_threshold': '8', 'class': 'SizeTieredCompactionStrategy', 'max_threshold': '12'} AND | |
compression={'sstable_compression': 'LZ4Compressor'}; | |
CREATE TABLE events_timeline ( | |
key text, | |
column1 bigint, | |
value blob, | |
PRIMARY KEY ((key), column1) | |
) WITH COMPACT STORAGE AND | |
bloom_filter_fp_chance=0.010000 AND | |
caching='KEYS_ONLY' AND | |
comment='{"info": "OpsCenter management data.", "version": [5, 2, 0]}' AND | |
dclocal_read_repair_chance=0.100000 AND | |
gc_grace_seconds=864000 AND | |
index_interval=128 AND | |
read_repair_chance=0.250000 AND | |
replicate_on_write='true' AND | |
populate_io_cache_on_flush='false' AND | |
default_time_to_live=0 AND | |
speculative_retry='99.0PERCENTILE' AND | |
memtable_flush_period_in_ms=0 AND | |
compaction={'min_threshold': '4', 'class': 'SizeTieredCompactionStrategy', 'max_threshold': '8'} AND | |
compression={'sstable_compression': 'LZ4Compressor'}; | |
CREATE TABLE pdps ( | |
key text, | |
column1 text, | |
value blob, | |
PRIMARY KEY ((key), column1) | |
) WITH COMPACT STORAGE AND | |
bloom_filter_fp_chance=0.010000 AND | |
caching='KEYS_ONLY' AND | |
comment='{"info": "OpsCenter management data.", "version": [5, 2, 0]}' AND | |
dclocal_read_repair_chance=0.100000 AND | |
gc_grace_seconds=0 AND | |
index_interval=128 AND | |
read_repair_chance=0.250000 AND | |
replicate_on_write='true' AND | |
populate_io_cache_on_flush='false' AND | |
default_time_to_live=0 AND | |
speculative_retry='99.0PERCENTILE' AND | |
memtable_flush_period_in_ms=0 AND | |
compaction={'min_threshold': '4', 'class': 'SizeTieredCompactionStrategy', 'max_threshold': '32'} AND | |
compression={'sstable_compression': 'LZ4Compressor'}; | |
CREATE TABLE rollups300 ( | |
key text, | |
"timestamp" varint, | |
value blob, | |
PRIMARY KEY ((key), "timestamp") | |
) WITH COMPACT STORAGE AND | |
bloom_filter_fp_chance=0.010000 AND | |
caching='KEYS_ONLY' AND | |
comment='{"info": "OpsCenter management data.", "version": [5, 2, 0]}' AND | |
dclocal_read_repair_chance=0.100000 AND | |
gc_grace_seconds=0 AND | |
index_interval=128 AND | |
read_repair_chance=0.250000 AND | |
replicate_on_write='true' AND | |
populate_io_cache_on_flush='false' AND | |
default_time_to_live=0 AND | |
speculative_retry='99.0PERCENTILE' AND | |
memtable_flush_period_in_ms=0 AND | |
compaction={'min_threshold': '4', 'class': 'SizeTieredCompactionStrategy', 'max_threshold': '16'} AND | |
compression={'sstable_compression': 'LZ4Compressor'}; | |
CREATE TABLE rollups60 ( | |
key text, | |
"timestamp" varint, | |
value blob, | |
PRIMARY KEY ((key), "timestamp") | |
) WITH COMPACT STORAGE AND | |
bloom_filter_fp_chance=0.010000 AND | |
caching='KEYS_ONLY' AND | |
comment='{"info": "OpsCenter management data.", "version": [5, 2, 0]}' AND | |
dclocal_read_repair_chance=0.100000 AND | |
gc_grace_seconds=0 AND | |
index_interval=128 AND | |
read_repair_chance=0.250000 AND | |
replicate_on_write='true' AND | |
populate_io_cache_on_flush='false' AND | |
default_time_to_live=0 AND | |
speculative_retry='99.0PERCENTILE' AND | |
memtable_flush_period_in_ms=0 AND | |
compaction={'min_threshold': '4', 'class': 'SizeTieredCompactionStrategy', 'max_threshold': '32'} AND | |
compression={'sstable_compression': 'LZ4Compressor'}; | |
CREATE TABLE rollups7200 ( | |
key text, | |
"timestamp" varint, | |
value blob, | |
PRIMARY KEY ((key), "timestamp") | |
) WITH COMPACT STORAGE AND | |
bloom_filter_fp_chance=0.010000 AND | |
caching='KEYS_ONLY' AND | |
comment='{"info": "OpsCenter management data.", "version": [5, 2, 0]}' AND | |
dclocal_read_repair_chance=0.100000 AND | |
gc_grace_seconds=0 AND | |
index_interval=128 AND | |
read_repair_chance=0.250000 AND | |
replicate_on_write='true' AND | |
populate_io_cache_on_flush='false' AND | |
default_time_to_live=0 AND | |
speculative_retry='99.0PERCENTILE' AND | |
memtable_flush_period_in_ms=0 AND | |
compaction={'min_threshold': '2', 'class': 'SizeTieredCompactionStrategy', 'max_threshold': '8'} AND | |
compression={'sstable_compression': 'LZ4Compressor'}; | |
CREATE TABLE rollups86400 ( | |
key text, | |
"timestamp" varint, | |
value blob, | |
PRIMARY KEY ((key), "timestamp") | |
) WITH COMPACT STORAGE AND | |
bloom_filter_fp_chance=0.010000 AND | |
caching='KEYS_ONLY' AND | |
comment='{"info": "OpsCenter management data.", "version": [5, 2, 0]}' AND | |
dclocal_read_repair_chance=0.100000 AND | |
gc_grace_seconds=0 AND | |
index_interval=128 AND | |
read_repair_chance=0.250000 AND | |
replicate_on_write='true' AND | |
populate_io_cache_on_flush='false' AND | |
default_time_to_live=0 AND | |
speculative_retry='99.0PERCENTILE' AND | |
memtable_flush_period_in_ms=0 AND | |
compaction={'min_threshold': '2', 'class': 'SizeTieredCompactionStrategy', 'max_threshold': '8'} AND | |
compression={'sstable_compression': 'LZ4Compressor'}; | |
CREATE TABLE settings ( | |
key blob, | |
column1 blob, | |
value blob, | |
PRIMARY KEY ((key), column1) | |
) WITH COMPACT STORAGE AND | |
bloom_filter_fp_chance=0.010000 AND | |
caching='KEYS_ONLY' AND | |
comment='{"info": "OpsCenter management data.", "version": [5, 2, 0]}' AND | |
dclocal_read_repair_chance=0.100000 AND | |
gc_grace_seconds=864000 AND | |
index_interval=128 AND | |
read_repair_chance=1.000000 AND | |
replicate_on_write='true' AND | |
populate_io_cache_on_flush='false' AND | |
default_time_to_live=0 AND | |
speculative_retry='99.0PERCENTILE' AND | |
memtable_flush_period_in_ms=0 AND | |
compaction={'min_threshold': '8', 'class': 'SizeTieredCompactionStrategy', 'max_threshold': '12'} AND | |
compression={'sstable_compression': 'LZ4Compressor'}; | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment