All Projects → diguage → Mysql Notes

diguage / Mysql Notes

Licence: other
MySQL 学习笔记

Programming Languages

shell
77523 projects

Projects that are alternatives of or similar to Mysql Notes

Shardingsphere
Build criterion and ecosystem above multi-model databases
Stars: ✭ 14,989 (+6503.08%)
Mutual labels:  distributed-transactions, mysql, distributed-database
Awesome Distributed Systems
Awesome list of distributed systems resources
Stars: ✭ 512 (+125.55%)
Mutual labels:  distributed-database, distributed-storage, distributed-systems
Scalardb
Universal transaction manager
Stars: ✭ 178 (-21.59%)
Mutual labels:  mysql, distributed-database, distributed-systems
Tidb
TiDB is an open source distributed HTAP database compatible with the MySQL protocol
Stars: ✭ 29,871 (+13059.03%)
Mutual labels:  distributed-transactions, mysql, distributed-database
Sfs
The distributed object storage server used by PitchPoint Solutions to securely store billions of large and small files using minimal resources. Object data is stored in replicated volumes implemented like Facebooks Haystack Object Store. Object metadata which essentially maps an object name to a volume position is stored in an elasticsearch index.
Stars: ✭ 78 (-65.64%)
Mutual labels:  distributed-storage, distributed-systems
Eventql
Distributed "massively parallel" SQL query engine
Stars: ✭ 1,121 (+393.83%)
Mutual labels:  distributed-database, distributed-storage
Docker Superset
Repository for Docker Image of Apache-Superset. [Docker Image: https://hub.docker.com/r/abhioncbr/docker-superset]
Stars: ✭ 86 (-62.11%)
Mutual labels:  mysql, distributed-systems
Zookeeper
Apache ZooKeeper
Stars: ✭ 10,061 (+4332.16%)
Mutual labels:  distributed-systems, distributed-database
Kingbus
A distributed MySQL binlog storage system built on Raft
Stars: ✭ 798 (+251.54%)
Mutual labels:  mysql, distributed-systems
Storj
Ongoing Storj v3 development. Decentralized cloud object storage that is affordable, easy to use, private, and secure.
Stars: ✭ 1,278 (+463%)
Mutual labels:  distributed-storage, distributed-systems
Etcd
Distributed reliable key-value store for the most critical data of a distributed system
Stars: ✭ 38,238 (+16744.93%)
Mutual labels:  distributed-database, distributed-systems
Rqlite
The lightweight, distributed relational database built on SQLite
Stars: ✭ 9,147 (+3929.52%)
Mutual labels:  distributed-database, distributed-systems
Finagle
A fault tolerant, protocol-agnostic RPC system
Stars: ✭ 8,126 (+3479.74%)
Mutual labels:  mysql, distributed-systems
Dble Docs Cn
Documents for dble in Chinese
Stars: ✭ 80 (-64.76%)
Mutual labels:  mysql, distributed-database
Blog
my blog, using markdown
Stars: ✭ 25 (-88.99%)
Mutual labels:  mysql, distributed-systems
Antsdb
AntsDB is a low latency, high concurrency, MySQL compliant SQL layer for HBase
Stars: ✭ 99 (-56.39%)
Mutual labels:  mysql, distributed-database
Seaweedfs
SeaweedFS is a fast distributed storage system for blobs, objects, files, and data lake, for billions of files! Blob store has O(1) disk seek, cloud tiering. Filer supports Cloud Drive, cross-DC active-active replication, Kubernetes, POSIX FUSE mount, S3 API, S3 Gateway, Hadoop, WebDAV, encryption, Erasure Coding.
Stars: ✭ 13,380 (+5794.27%)
Mutual labels:  distributed-storage, distributed-systems
Ctlstore
Control Data Store
Stars: ✭ 171 (-24.67%)
Mutual labels:  mysql, distributed-systems
Talent Plan
open source training courses about distributed database and distributed systemes
Stars: ✭ 6,965 (+2968.28%)
Mutual labels:  distributed-database, distributed-systems
Dble
A High Scalability Middle-ware for MySQL Sharding
Stars: ✭ 774 (+240.97%)
Mutual labels:  mysql, distributed-database

= MySQL 学习笔记^Alpha^ D瓜哥 https://www.diguage.com/ v0.1.0, 2016-12-11

ifdef::env-github[] :tip-caption: 💡 :note-caption: ℹ️ :important-caption: ❗️ :caution-caption: 🔥 :warning-caption: ⚠️ endif::[]

D瓜哥的 MySQL 学习笔记。

Github 对 Asciidoctor 的支持不是特别完善,另外很多人可能没有处理 Asciidoc 的工具。所以,D瓜哥把该文档处理后发布出来了。查看该文档内容请看下面官网。

该笔记官网: https://notes.diguage.com/mysql/[^]

该笔记尚未完成,后续还会持续增加新内容。敬请关注!

== 文档来源

本文档可以看作是 D瓜哥 学习《高性能MySQL》时,做的读书笔记。为了让内容更丰富易懂,还参考了《MySQL技术内幕》和《数据库索引设计与优化》。

本文档暂时只关注开发人员眼中的 MySQL。所以,内容暂时只覆盖数据库设计、索引及其数据结构和查询优化三块内容。其他内容视情况再做补充。

== 友情支持

如果您觉得这个笔记对您有所帮助,看在D瓜哥码这么多字的辛苦上,请友情支持一下,D瓜哥感激不尽,😜

[cols="2*^",frame=none] |=== | image:assets/images/alipay.png[title="支付宝", alt="支付宝", width="45%"] | image:assets/images/wxpay.png[title="微信", alt="微信", width="45%"] |===

有些打赏的朋友希望可以加个好友,欢迎关注D瓜哥的微信公众号,这样就可以通过公众号的回复直接给我发信息。

image:assets/images/wx-jike-log.png[align="center",width=90%]

TIP: 公众号的微信号是: jike-log因为众所周知的原因,有时图片加载不出来。如果图片加载不出来可以直接通过搜索微信号来查找我的公众号。

== 亟需完善的内容

. 事务的实现原理 -- OK . 分形树(抱歉,我还没搞懂) . 索引优化实践 . 索引优化实际案例分析 . 分布式数据库 .. 分库分表 .. NewSQL .. 分布式事务

== 免责声明

本文档绝大部分内容是针对 MySQL 5.5 的,随着 MySQL 的发展,部分的内容可能会过时。所以,如有错误之处,还请以相应版本的官方文档为准!

本文档部分的内容可能会过时!

本文档部分的内容可能会过时!

本文档部分的内容可能会过时!

参考使用时,还请格外注意!

由于本文档造成的任何问题以及损失,D瓜哥本人概不负责!

== 参考书籍

更多参考资料,请查看文档最末尾的“参考资料”章节。这里只列出最重要的参考书籍。

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].