https://wiki.eofnet.lt/w//index.php?action=history&feed=atom&title=Cassandra 2026-04-19T12:30:18Z Šio puslapio versijų istorija projekte MediaWiki 1.35.1 https://wiki.eofnet.lt/w//index.php?title=Cassandra&diff=8686&oldid=prev 2018-07-18T14:48:03Z

<p></p> <p><b>Naujas puslapis</b></p><div><br /> <br /> == Prisijungimas ==<br /> cqlsh -u cassandra -p cassandra<br /> Auto prisijungimas, pridedam į failą '''~/.cqlshrc'''<br /> [authentication]<br /> username = cassandra<br /> password = cassandra<br /> == DB Sukūrimas/Koregavimas ==<br /> CREATE KEYSPACE IF NOT EXISTS duombaze WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '1'} AND durable_writes = true;<br /> CREATE KEYSPACE IF NOT EXISTS duombaze2 WITH REPLICATION = { 'class' : 'NetworkTopologyStrategy', 'datacenter1' : 3 };<br /> ALTER KEYSPACE system_auth WITH REPLICATION = {'class' : 'NetworkTopologyStrategy', 'dc1' : 3, 'dc2' : 2}; <br /> ALTER KEYSPACE &quot;Excalibur&quot; WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 3 };<br /> <br /> == Lentelės ==<br /> CREATE TABLE cyclist_name ( id UUID PRIMARY KEY, lastname text, firstname text );<br /> <br /> CREATE TABLE person (<br /> id text,<br /> name text,<br /> surname text,<br /> PRIMARY KEY (id));<br /> <br /> CREATE TABLE k1.person (<br /> id text PRIMARY KEY,<br /> name text,<br /> surname text<br /> ) WITH bloom_filter_fp_chance = 0.01<br /> AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}<br /> AND comment = ''<br /> AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}<br /> AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}<br /> AND crc_check_chance = 1.0<br /> AND dclocal_read_repair_chance = 0.1<br /> AND default_time_to_live = 0<br /> AND gc_grace_seconds = 864000<br /> AND max_index_interval = 2048<br /> AND memtable_flush_period_in_ms = 0<br /> AND min_index_interval = 128<br /> AND read_repair_chance = 0.0<br /> AND speculative_retry = '99PERCENTILE';<br /> <br /> SELECT * FROM person;<br /> DESCRIBE person;<br /> <br /> == Select/Insert/Update ==<br /> INSERT INTO person (id, name, surname, email) VALUES ('002', 'John', 'Doe', 'john@example.com');<br /> SELECT * from person;<br /> SELECT name FROM person WHERE id='001';<br /> SELECT name FROM person WHERE id IN ('001', '002');<br /> UPDATE cycling.cyclist_career_teams SET teams = teams + {'Team DSB - Ballast Nedam'} WHERE id = 5b6962dd-3f90-4c93-8f61-eabfa4a803e2;<br /> DELETE teams FROM cycling.cyclist_career_teams WHERE id = 5b6962dd-3f90-4c93-8f61-eabfa4a803e2;<br /> <br /> == Grafiniai administravimo įrankiai ==<br /> <br /> * https://tableplus.io<br /> <br /> {{Template:Distributions}}<br /> [[Category:Duombazės]]<br /> [[Category:DB]]</div>

\dev\null