Files
devops/database.md
2025-09-17 16:08:16 +08:00

2.8 KiB
Executable File
Raw Permalink Blame History

数据库

KISS - Keep It Simple & Stupid

数据被快速制造和消费数据看上去更加无秩序或叫非结构化据说超过80%且持续加速增加于是新的非关系型DB/noSQL快速崛起

  • 类型
  • 特点
  • 选型

数据库类型

- Relational DBMS
  - oracle,mysql,postgreSQL,hive
- Key-value stores
  - redis,memcached
- Document stores/document-oriented database
- Graph DBMS
  - neo4j,Microsoft Azure Cosmos DB
- Time Series DBMS
  - InfluxDB,Kdb+,Prometheus,Graphite,RRDtool,OpenTSDB,Druid
- Object oriented DBMS
- RDF stores
- Search engines
  - Elasticsearch,Splunk
- Wide column stores
 - Cassandra,hbase
- Multivalue DBMS
- Native XML DBMS
- Event Stores
- Content stores
- Navigational DBMS

Document stores database

also called document-oriented database systems, are characterized by their schema-free organization of data. Records do not need to have a uniform structure, i.e. different records may have different columns. The types of the values a€?a€?of individual columns can be different for each record. Columns can have more than one value (arrays). Records can have a nested structure. Document stores often use internal notations, which can be processed directly in applications, mostly JSON. JSON documents of course can also be stored as pure text in key-value stores or relational database systems. That would, however, require client-side processing of the structures, which has the disadvantage that the features offered by document stores (such as secondary indexes) are not available.
存储文档数据库,也叫面向文档数据库,主要特点是非结构化、数据的自由组织 纪录可以非结构化比如不同纪录中的可以有不同的列不同列的数据类型也可以不同列的数据可以是多个值比如一个array记录还可以是嵌套结构。 比如方便直接存储JSON数据key-value数据库也可以存储JSON数据但客户需要自己处理数据结构这样就容易失去JSON数据组织的优点比如第二个索引

kafka & redis

消息系统

  • 异步
  • 解耦
  • 顺序

kafka通过zookeeper来存储集群的meta信息

Redis哨兵模式sentinel学习总结及部署记录主从复制、读写分离、主从切换

db trend db trend 24 months

references

  1. db ranking
  2. influxDB vs. openTSDB
  3. openTSDB
  4. 恒丰银行——大数据实时流处理平台