forked from dunwu/db-tutorial
-
Notifications
You must be signed in to change notification settings - Fork 0
Commit
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
- Loading branch information
Showing
21 changed files
with
818 additions
and
190 deletions.
There are no files selected for viewing
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
| Original file line number | Diff line number | Diff line change |
|---|---|---|
| @@ -0,0 +1,24 @@ | ||
| # 持续集成 CI | ||
| # @see https://docs.travis-ci.com/user/tutorial/ | ||
|
|
||
| language: node_js | ||
|
|
||
| sudo: required | ||
|
|
||
| node_js: stable | ||
|
|
||
| branches: | ||
| only: | ||
| - master | ||
|
|
||
| before_install: | ||
| - export TZ=Asia/Shanghai | ||
|
|
||
| script: bash ./scripts/deploy.sh | ||
|
|
||
| notifications: | ||
| email: | ||
| recipients: | ||
| - forbreak@163.com | ||
| on_success: change | ||
| on_failure: always |
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
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
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
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
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
| Original file line number | Diff line number | Diff line change |
|---|---|---|
| @@ -0,0 +1,55 @@ | ||
| # ShardingSphere | ||
|
|
||
| > ShardingSphere 是一套开源的分布式数据库中间件解决方案组成的生态圈，它由 Sharding-JDBC、Sharding-Proxy 和 Sharding-Sidecar（计划中）这 3 款相互独立的产品组成。 他们均提供标准化的数据分片、分布式事务和数据库治理功能，可适用于如 Java 同构、异构语言、云原生等各种多样化的应用场景。 | ||
| ## 架构 | ||
|
|
||
|  | ||
|
|
||
| ### Sharding-JDBC | ||
|
|
||
| 定位为轻量级 Java 框架，在 Java 的 JDBC 层提供的额外服务。 它使用客户端直连数据库，以 jar 包形式提供服务，无需额外部署和依赖，可理解为增强版的 JDBC 驱动，完全兼容 JDBC 和各种 ORM 框架。 | ||
|
|
||
| - 适用于任何基于 Java 的 ORM 框架，如：JPA, Hibernate, Mybatis, Spring JDBC Template 或直接使用 JDBC。 | ||
| - 基于任何第三方的数据库连接池，如：DBCP, C3P0, BoneCP, Druid, HikariCP 等。 | ||
| - 支持任意实现 JDBC 规范的数据库。目前支持 MySQL，Oracle，SQLServer 和 PostgreSQL。 | ||
|
|
||
|  | ||
|
|
||
| ### Sharding-Proxy | ||
|
|
||
| 定位为透明化的数据库代理端，提供封装了数据库二进制协议的服务端版本，用于完成对异构语言的支持。 目前先提供 MySQL/PostgreSQL 版本，它可以使用任何兼容 MySQL/PostgreSQL 协议的访问客户端(如：MySQL Command Client, MySQL Workbench, Navicat 等)操作数据，对 DBA 更加友好。 | ||
|
|
||
| - 向应用程序完全透明，可直接当做 MySQL/PostgreSQL 使用。 | ||
| - 适用于任何兼容 MySQL/PostgreSQL 协议的的客户端。 | ||
|
|
||
|  | ||
|
|
||
| ### Sharding-Sidecar（TODO） | ||
|
|
||
| 定位为 Kubernetes 的云原生数据库代理，以 Sidecar 的形式代理所有对数据库的访问。 通过无中心、零侵入的方案提供与数据库交互的的啮合层，即 Database Mesh，又可称数据网格。 | ||
|
|
||
| Database Mesh 的关注重点在于如何将分布式的数据访问应用与数据库有机串联起来，它更加关注的是交互，是将杂乱无章的应用与数据库之间的交互有效的梳理。使用 Database Mesh，访问数据库的应用和数据库终将形成一个巨大的网格体系，应用和数据库只需在网格体系中对号入座即可，它们都是被啮合层所治理的对象。 | ||
|
|
||
|  | ||
|
|
||
| | _Sharding-JDBC_ | _Sharding-Proxy_ | _Sharding-Sidecar_ | | | ||
| | :-------------- | :--------------- | :----------------- | ------ | | ||
| | 数据库 | 任意 | MySQL | MySQL | | ||
| | 连接消耗数 | 高 | 低 | 高 | | ||
| | 异构语言 | 仅 Java | 任意 | 任意 | | ||
| | 性能 | 损耗低 | 损耗略高 | 损耗低 | | ||
| | 无中心化 | 是 | 否 | 是 | | ||
| | 静态入口 | 无 | 有 | 无 | | ||
|
|
||
| ### 混合架构 | ||
|
|
||
| Sharding-JDBC 采用无中心化架构，适用于 Java 开发的高性能的轻量级 OLTP 应用；Sharding-Proxy 提供静态入口以及异构语言的支持，适用于 OLAP 应用以及对分片数据库进行管理和运维的场景。 | ||
|
|
||
| ShardingSphere 是多接入端共同组成的生态圈。 通过混合使用 Sharding-JDBC 和 Sharding-Proxy，并采用同一注册中心统一配置分片策略，能够灵活的搭建适用于各种场景的应用系统，架构师可以更加自由的调整适合于当前业务的最佳系统架构。 | ||
|
|
||
|  | ||
|
|
||
| ## 参考资料 | ||
|
|
||
| - [shardingsphere](https://github.com/apache/incubator-shardingsphere) |
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
| Original file line number | Diff line number | Diff line change |
|---|---|---|
| @@ -1,22 +1,28 @@ | ||
| # 非关系型数据库 | ||
| # Nosql 数据库 | ||
|
|
||
| ## :memo: 知识点 | ||
| ## 📖 内容 | ||
|
|
||
| ### 非关系型数据库 | ||
| ### 列式数据库 | ||
|
|
||
| - [HBase](hbase.md) | ||
|
|
||
| ### K-V 数据库 | ||
|
|
||
| - [Redis](redis/README.md) | ||
| - [Cassandra](cassandra.md) | ||
|
|
||
| ### 文档数据库 | ||
|
|
||
| - [MongoDB](mongodb) | ||
| - [Cassandra](Cassandra.md) | ||
|
|
||
| ### 非关系型数据库对比 | ||
| ### 搜索引擎数据库 | ||
|
|
||
| - [Elasticsearch](elasticsearch.md) | ||
|
|
||
| | 名称 | 类型 | 数据类型 | 查询类型 | 附加功能 | | ||
| | ------- | ---------------------------- | ------------------------------------------------------------ | -------------------------------------------------- | ------------------------------------------- | | ||
| | Redis | 基于内存存储的非关系型数据库 | String、List、Set、Hash、Sorted Set | 每种数据类型都有自己的专属操作和不完全的事务支持。 | 发布订阅、主从复制、持久化、脚本。 | | ||
| | MongoDB | 基于硬盘存储的文档数据库 | 每个数据库可以包含多个表，每个表可以包含多个无 schema 的 BSON 文档。 | 创建、读取、更新、删除、条件查询命令等。 | map-reduce 操作、主从复制、分片、空间索引。 | | ||
| ### 图数据库 | ||
|
|
||
| ## 📚 学习资源 | ||
| TODO: 待补充 | ||
|
|
||
| ## :door: 传送门 | ||
| ## 🚪 传送门 | ||
|
|
||
| | [我的 Github 博客](https://github.com/dunwu/blog) | [db-tutorial 首页](https://github.com/dunwu/db-tutorial) | | ||
| ◾ 🏠 [DB-TUTORIAL 首页](https://github.com/dunwu/db-tutorial) ◾ 🎯 [我的博客](https://github.com/dunwu/blog) ◾ |
File renamed without changes.
Oops, something went wrong.