tiancheng91 / collection

笔记
https://github.com/tiancheng91/collection/issues
22 stars 1 forks source link

Cassandra / DynamoDB / scylladb #52

Open tiancheng91 opened 3 years ago

tiancheng91 commented 3 years ago

https://www.scylladb.com/open-source-nosql-database/

替代品,高性能, 自己实现了用户态tcp/ip 协议栈

相关资料: https://www.infoq.cn/article/8rleTIWSBo2Y7MpfsMlW

tiancheng91 commented 3 years ago

yugabyte, 多协议类型 YCQL, compatible with Apache Cassandra Query Language (CQL); YEDIS, compatible with Redis; and PostgreSQL (currently incomplete and in beta)

tiancheng91 commented 3 years ago
Cassandra
=========

## Cheatsheet
https://github.com/vrachieru/cheatsheet/blob/master/database/cassandra.cheatsheet

## csqlsh
- DESCRIBE CLUSTER;
- DESCRIBE KEYSPACES; 
- SHOW VERSION;

CREATE KEYSPACE test WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1}; use test;

CREATE TABLE users (username text, nickname text, avatar text, PRIMARY KEY (username)); INSERT INTO users (username, nickname) VALUES ('test01', 'n_test01'); INSERT INTO users (username, nickname) VALUES ('test02', 'n_test02');

// 能写入, 会自动变为update INSERT INTO users (username, nickname) VALUES ('test01', 'n_test02');

DELETE nickname from users where username = 'test01'; DELETE from users where username = 'test01';

// 清空 TRUNCATE users; DROP TABLE users;

// create index

tiancheng91 commented 3 years ago

document api. (https://stargate.io/) https://3e215a55-49f1-4049-b02b-bcce99bd7f43-us-east1.apps.astra.datastax.com/api/rest/swagger-ui/

cassandra 商业化公司 datastax.com

tiancheng91 commented 3 years ago

https://docs.microsoft.com/en-us/azure/hdinsight/

tiancheng91 commented 3 years ago

https://medium.com/jaegertracing/how-to-maximize-span-ingestion-while-limiting-writes-per-second-to-scylla-with-jaeger-3bcda5608841?source=collection_home---6------5-----------------------

tiancheng91 commented 3 years ago

Cassandra_The_Definitive_Guide.pdf