Skip to content

Instantly share code, notes, and snippets.

@jeevanullas

jeevanullas/gist:a89fcd7e1f05d3ea6111 Secret

Created May 10, 2015 10:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jeevanullas/a89fcd7e1f05d3ea6111 to your computer and use it in GitHub Desktop.
Save jeevanullas/a89fcd7e1f05d3ea6111 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
# cqlsh 192.168.1.5 9042
Connected to midonet at 192.168.1.5:9042.
[cqlsh 5.0.1 | Cassandra 2.1.5 | CQL spec 3.2.0 | Native protocol v3]
Use HELP for help.
cqlsh> use midonetflowstate;
cqlsh:midonetflowstate> describe schema;
CREATE KEYSPACE midonetflowstate WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '1'} AND durable_writes = true;
CREATE TABLE midonetflowstate.conntrack_by_ingress_port (
port uuid,
proto int,
srcip inet,
srcport int,
dstip inet,
dstport int,
device uuid,
PRIMARY KEY ((port, proto, srcip, srcport, dstip, dstport, device))
) WITH bloom_filter_fp_chance = 0.01
AND caching = '{"keys":"ALL", "rows_per_partition":"NONE"}'
AND comment = ''
AND compaction = {'min_threshold': '4', 'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32'}
AND compression = {'sstable_compression': 'org.apache.cassandra.io.compress.LZ4Compressor'}
AND dclocal_read_repair_chance = 0.1
AND default_time_to_live = 0
AND gc_grace_seconds = 864000
AND max_index_interval = 2048
AND memtable_flush_period_in_ms = 0
AND min_index_interval = 128
AND read_repair_chance = 0.0
AND speculative_retry = '99.0PERCENTILE';
CREATE INDEX conntrack_by_ingress_port_port_idx ON midonetflowstate.conntrack_by_ingress_port (port);
CREATE TABLE midonetflowstate.conntrack_by_egress_port (
port uuid,
proto int,
srcip inet,
srcport int,
dstip inet,
dstport int,
device uuid,
PRIMARY KEY ((port, proto, srcip, srcport, dstip, dstport, device))
) WITH bloom_filter_fp_chance = 0.01
AND caching = '{"keys":"ALL", "rows_per_partition":"NONE"}'
AND comment = ''
AND compaction = {'min_threshold': '4', 'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32'}
AND compression = {'sstable_compression': 'org.apache.cassandra.io.compress.LZ4Compressor'}
AND dclocal_read_repair_chance = 0.1
AND default_time_to_live = 0
AND gc_grace_seconds = 864000
AND max_index_interval = 2048
AND memtable_flush_period_in_ms = 0
AND min_index_interval = 128
AND read_repair_chance = 0.0
AND speculative_retry = '99.0PERCENTILE';
CREATE INDEX conntrack_by_egress_port_port_idx ON midonetflowstate.conntrack_by_egress_port (port);
CREATE TABLE midonetflowstate.nat_by_ingress_port (
port uuid,
type text,
proto int,
srcip inet,
srcport int,
dstip inet,
dstport int,
device uuid,
translateip inet,
translateport int,
PRIMARY KEY ((port, type, proto, srcip, srcport, dstip, dstport, device))
) WITH bloom_filter_fp_chance = 0.01
AND caching = '{"keys":"ALL", "rows_per_partition":"NONE"}'
AND comment = ''
AND compaction = {'min_threshold': '4', 'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32'}
AND compression = {'sstable_compression': 'org.apache.cassandra.io.compress.LZ4Compressor'}
AND dclocal_read_repair_chance = 0.1
AND default_time_to_live = 0
AND gc_grace_seconds = 864000
AND max_index_interval = 2048
AND memtable_flush_period_in_ms = 0
AND min_index_interval = 128
AND read_repair_chance = 0.0
AND speculative_retry = '99.0PERCENTILE';
CREATE INDEX nat_by_ingress_port_port_idx ON midonetflowstate.nat_by_ingress_port (port);
CREATE TABLE midonetflowstate.nat_by_egress_port (
port uuid,
type text,
proto int,
srcip inet,
srcport int,
dstip inet,
dstport int,
device uuid,
translateip inet,
translateport int,
PRIMARY KEY ((port, type, proto, srcip, srcport, dstip, dstport, device))
) WITH bloom_filter_fp_chance = 0.01
AND caching = '{"keys":"ALL", "rows_per_partition":"NONE"}'
AND comment = ''
AND compaction = {'min_threshold': '4', 'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32'}
AND compression = {'sstable_compression': 'org.apache.cassandra.io.compress.LZ4Compressor'}
AND dclocal_read_repair_chance = 0.1
AND default_time_to_live = 0
AND gc_grace_seconds = 864000
AND max_index_interval = 2048
AND memtable_flush_period_in_ms = 0
AND min_index_interval = 128
AND read_repair_chance = 0.0
AND speculative_retry = '99.0PERCENTILE';
CREATE INDEX nat_by_egress_port_port_idx ON midonetflowstate.nat_by_egress_port (port);
cqlsh:midonetflowstate> describe cluster;
Cluster: midonet
Partitioner: Murmur3Partitioner
Range ownership:
-7112734629556744704 [192.168.1.5]
-7947742495025371135 [192.168.1.5]
6469923887533308933 [192.168.1.5]
4599752889491599367 [192.168.1.5]
401020946862578459 [192.168.1.5]
-4183658817373831157 [192.168.1.5]
2105848265846207091 [192.168.1.5]
3117687029009809803 [192.168.1.5]
-7928625559983105522 [192.168.1.5]
8834489704484958637 [192.168.1.5]
-2247722408943575532 [192.168.1.5]
4593721624209278486 [192.168.1.5]
5157213016493747033 [192.168.1.5]
-7365196271665189864 [192.168.1.5]
2568883930755978778 [192.168.1.5]
-8326009701711047653 [192.168.1.5]
9088588441528178716 [192.168.1.5]
2136267151550819871 [192.168.1.5]
-2314860894667025887 [192.168.1.5]
-7897188768032411102 [192.168.1.5]
-1190051676833513381 [192.168.1.5]
4981025619997521957 [192.168.1.5]
-4461451970070700504 [192.168.1.5]
7820869057626910249 [192.168.1.5]
6194392769335543338 [192.168.1.5]
-9173446991238859732 [192.168.1.5]
-5800239097421642194 [192.168.1.5]
6684513760953872432 [192.168.1.5]
3145733439580242995 [192.168.1.5]
6435855948460998199 [192.168.1.5]
-6009148500834703814 [192.168.1.5]
5696068448908391996 [192.168.1.5]
6332085760198476861 [192.168.1.5]
6272181840580012725 [192.168.1.5]
-7171577118400438208 [192.168.1.5]
5592016209273457729 [192.168.1.5]
-3562150504731227582 [192.168.1.5]
-4173249790368135669 [192.168.1.5]
-6803874657728079292 [192.168.1.5]
-3983158373622995386 [192.168.1.5]
3243622300674164295 [192.168.1.5]
1908839888808162379 [192.168.1.5]
8665133461964256098 [192.168.1.5]
4065372055392687885 [192.168.1.5]
3281605638071132171 [192.168.1.5]
6708060776650256977 [192.168.1.5]
-4731836256283933613 [192.168.1.5]
-7854312867878635436 [192.168.1.5]
7420071144530234894 [192.168.1.5]
7376768453140116179 [192.168.1.5]
8188662181544986809 [192.168.1.5]
-8939071192820706460 [192.168.1.5]
-6646308859243547558 [192.168.1.5]
-9202107652472517541 [192.168.1.5]
-4103266703942194084 [192.168.1.5]
8888831721521391200 [192.168.1.5]
8024872103553182817 [192.168.1.5]
7514775103147973218 [192.168.1.5]
2841657511061218407 [192.168.1.5]
8728887097412768067 [192.168.1.5]
776580009626805867 [192.168.1.5]
-1697352207293192596 [192.168.1.5]
9184313448545330801 [192.168.1.5]
-4435722927288904941 [192.168.1.5]
-5184031280306984331 [192.168.1.5]
1533748997292524662 [192.168.1.5]
-7165299896850912137 [192.168.1.5]
-8602218499448059272 [192.168.1.5]
-301014433121527681 [192.168.1.5]
8645634345672384128 [192.168.1.5]
-4849735630244445054 [192.168.1.5]
8614436141944965571 [192.168.1.5]
-3838585986790937976 [192.168.1.5]
-4963743910091478391 [192.168.1.5]
-2397791172033569653 [192.168.1.5]
2222595343566718604 [192.168.1.5]
-2453059979710493043 [192.168.1.5]
388399163469719695 [192.168.1.5]
2378656266799552656 [192.168.1.5]
-9087358768046542312 [192.168.1.5]
-2315195327300648814 [192.168.1.5]
-7745454693738118509 [192.168.1.5]
-3140485913200759658 [192.168.1.5]
-662065452475061991 [192.168.1.5]
172243285494128797 [192.168.1.5]
-8387514907180416352 [192.168.1.5]
-3001522405953910111 [192.168.1.5]
-5058884592929119582 [192.168.1.5]
-4598801780347369309 [192.168.1.5]
2696568553814724260 [192.168.1.5]
-1457133302625721178 [192.168.1.5]
2208576472584468252 [192.168.1.5]
3538513115514518702 [192.168.1.5]
-2376077886500633425 [192.168.1.5]
1186412406166782129 [192.168.1.5]
57325483733066867 [192.168.1.5]
-6021441550907369804 [192.168.1.5]
3576484797576231605 [192.168.1.5]
5949154526124686521 [192.168.1.5]
6348046105248863335 [192.168.1.5]
7052907665943769802 [192.168.1.5]
-1984743646315492674 [192.168.1.5]
-5903126141218121537 [192.168.1.5]
-3457012149024288059 [192.168.1.5]
879489996629173446 [192.168.1.5]
6516843100652316359 [192.168.1.5]
-6118871298523525943 [192.168.1.5]
-4366521803175311158 [192.168.1.5]
3774738664646886263 [192.168.1.5]
-2399253990425106740 [192.168.1.5]
-8071895970267263283 [192.168.1.5]
-1559281585425339697 [192.168.1.5]
7619061855739373264 [192.168.1.5]
5897230696660933240 [192.168.1.5]
-4933235172455919917 [192.168.1.5]
8788710527208036708 [192.168.1.5]
-2128708880441832744 [192.168.1.5]
-7429001948455573798 [192.168.1.5]
5399302910400836319 [192.168.1.5]
-885664536076812064 [192.168.1.5]
2343138377051892961 [192.168.1.5]
6690883235601652770 [192.168.1.5]
8898453398435194084 [192.168.1.5]
8769520597721010405 [192.168.1.5]
8575717003521449190 [192.168.1.5]
4397646880029112273 [192.168.1.5]
8936786522287132904 [192.168.1.5]
4474409812268509929 [192.168.1.5]
-8032112487715398934 [192.168.1.5]
282006411158502636 [192.168.1.5]
2979255781931806958 [192.168.1.5]
-4115966483941389784 [192.168.1.5]
-7088848652927051533 [192.168.1.5]
-5470336344624123656 [192.168.1.5]
8838658571743101482 [192.168.1.5]
3486864354404334846 [192.168.1.5]
-681048539393520379 [192.168.1.5]
4915376784001291016 [192.168.1.5]
3654581711218018569 [192.168.1.5]
1260085908824346893 [192.168.1.5]
3416194870298976472 [192.168.1.5]
-3816298187342717165 [192.168.1.5]
7733387101672319534 [192.168.1.5]
7395341861042647616 [192.168.1.5]
-3244762638001231079 [192.168.1.5]
-1150502628397918949 [192.168.1.5]
-3465026714386841316 [192.168.1.5]
5253924493481319136 [192.168.1.5]
3889586932325890340 [192.168.1.5]
-3197856367318624474 [192.168.1.5]
-7154336540091648719 [192.168.1.5]
-3486222904648889047 [192.168.1.5]
-4854906066208309461 [192.168.1.5]
6607861117138320174 [192.168.1.5]
-5862304766438754001 [192.168.1.5]
-9186418115283461839 [192.168.1.5]
9087601925125950017 [192.168.1.5]
4435353660954270160 [192.168.1.5]
7815427708792775152 [192.168.1.5]
-4069253260332243831 [192.168.1.5]
3852150190700284216 [192.168.1.5]
4342044274801860922 [192.168.1.5]
1240148385712428348 [192.168.1.5]
5895579764780354880 [192.168.1.5]
-3696837950365961919 [192.168.1.5]
-206751114004325749 [192.168.1.5]
174197226526338888 [192.168.1.5]
-5575914755742743223 [192.168.1.5]
-756916869176825524 [192.168.1.5]
-107411749706661043 [192.168.1.5]
-6376188527862319793 [192.168.1.5]
870549507404275026 [192.168.1.5]
-558259667287572141 [192.168.1.5]
3195197052086446422 [192.168.1.5]
3647814021304699735 [192.168.1.5]
-2325547895083912348 [192.168.1.5]
7142936076854141274 [192.168.1.5]
1839739022359254875 [192.168.1.5]
-4067765834158099108 [192.168.1.5]
1727818358665576285 [192.168.1.5]
-1600498547799704226 [192.168.1.5]
-7988527095497260193 [192.168.1.5]
-3143619103412121758 [192.168.1.5]
-8770720551469309084 [192.168.1.5]
96808154154611046 [192.168.1.5]
2015308901190236049 [192.168.1.5]
8304468618401272680 [192.168.1.5]
-4391254472650247830 [192.168.1.5]
-5591521563974304915 [192.168.1.5]
-5114641143587871378 [192.168.1.5]
-3922151871821755024 [192.168.1.5]
-395178922323484303 [192.168.1.5]
-4710232945878930061 [192.168.1.5]
3822209199225915027 [192.168.1.5]
-7516054674144109193 [192.168.1.5]
652785992683912056 [192.168.1.5]
-5137810633663638151 [192.168.1.5]
-226284272627083398 [192.168.1.5]
-8262269311769238145 [192.168.1.5]
3615842883672026688 [192.168.1.5]
8373219512751327111 [192.168.1.5]
4387120282179269160 [192.168.1.5]
2776409796065121687 [192.168.1.5]
1388885105885392780 [192.168.1.5]
2937646519324424770 [192.168.1.5]
1757214139929596305 [192.168.1.5]
4903775234828325699 [192.168.1.5]
4474362093009577424 [192.168.1.5]
-2860639384293581784 [192.168.1.5]
-7933654531779092071 [192.168.1.5]
5307459221911343365 [192.168.1.5]
-3921263922982018658 [192.168.1.5]
-3574038089628044385 [192.168.1.5]
-8595524764924301407 [192.168.1.5]
3339674156330700529 [192.168.1.5]
-8122190805787834966 [192.168.1.5]
7156225926469179308 [192.168.1.5]
6761626495948637170 [192.168.1.5]
-7237169127422684751 [192.168.1.5]
644742648931218354 [192.168.1.5]
3038687808690638824 [192.168.1.5]
4929633518719936438 [192.168.1.5]
-5133895868902025801 [192.168.1.5]
8644758390853705148 [192.168.1.5]
-4911691631892722755 [192.168.1.5]
-6293322641276592193 [192.168.1.5]
5491350939497126851 [192.168.1.5]
-7365721608986170427 [192.168.1.5]
7692866986086506444 [192.168.1.5]
-1218987636659023921 [192.168.1.5]
-7241706774017105456 [192.168.1.5]
-2691985009906988808 [192.168.1.5]
-5154938991819043884 [192.168.1.5]
4776565124678370297 [192.168.1.5]
2463151363323124696 [192.168.1.5]
3342278437820330457 [192.168.1.5]
5953457801209213915 [192.168.1.5]
7709787384139485672 [192.168.1.5]
707207576505927647 [192.168.1.5]
6259441177087125083 [192.168.1.5]
-271576024032367645 [192.168.1.5]
5075172043018685606 [192.168.1.5]
-49810423086219288 [192.168.1.5]
-5323143454680002582 [192.168.1.5]
2456689158345538027 [192.168.1.5]
-4726807196566260756 [192.168.1.5]
-6446952611875327504 [192.168.1.5]
3974599720795823090 [192.168.1.5]
6812325487674660472 [192.168.1.5]
-2864696978982565388 [192.168.1.5]
6484141977526680048 [192.168.1.5]
-5741192564458060298 [192.168.1.5]
-2676768748422281372 [192.168.1.5]
-920570337948861444 [192.168.1.5]
4318441193555440042 [192.168.1.5]
7078702119970578431 [192.168.1.5]
cqlsh:midonetflowstate> describe tables;
conntrack_by_ingress_port nat_by_ingress_port
conntrack_by_egress_port nat_by_egress_port
cqlsh:midonetflowstate> describe keyspaces;
midonetflowstate system system_traces
cqlsh:midonetflowstate> select * from conntrack_by_ingress_port;
port | proto | srcip | srcport | dstip | dstport | device
------+-------+-------+---------+-------+---------+--------
(0 rows)
cqlsh:midonetflowstate> select * from nat_by_ingress_port;
port | type | proto | srcip | srcport | dstip | dstport | device | translateip | translateport
------+------+-------+-------+---------+-------+---------+--------+-------------+---------------
(0 rows)
cqlsh:midonetflowstate> select * from nat_by_egress_port;
port | type | proto | srcip | srcport | dstip | dstport | device | translateip | translateport
------+------+-------+-------+---------+-------+---------+--------+-------------+---------------
(0 rows)
cqlsh:midonetflowstate> exit
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment