| route-pattern | /:user_id/:repository |
| route-controller | files |
| route-action | disambiguate |
| fetch-nonce | v2:6400904a-89ff-6282-7b18-93203ddeb249 |
| current-catalog-service-hash | f3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb |
| request-id | B53A:1752D1:99ED2D:CC6358:69716858 |
| html-safe-nonce | 3d11d7e651746dd9f1154dd51602fb9eeef958763494e55a642f8ec569e1fe76 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCNTNBOjE3NTJEMTo5OUVEMkQ6Q0M2MzU4OjY5NzE2ODU4IiwidmlzaXRvcl9pZCI6IjU2Mjk3MDYwMzM3MTQ3ODQzNDUiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | 3b893d2602af360b45dc867b9aec47823374d5f3e14f9a2e2f13f4dc7e4199b9 |
| hovercard-subject-tag | repository:912831220 |
| github-keyboard-shortcuts | repository,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | // |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/whyils/db-tutorial |
| twitter:image | https://opengraph.githubassets.com/2cde68bbf74db0002ea3bb104a2f65f1ad5a9e258c5c6a410979732fc238c0b8/whyils/db-tutorial |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/2cde68bbf74db0002ea3bb104a2f65f1ad5a9e258c5c6a410979732fc238c0b8/whyils/db-tutorial |
| og:image:alt | 📚 后端程序员应该掌握的主流数据库知识. Contribute to whyils/db-tutorial development by creating an account on GitHub. |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| hostname | github.com |
| expected-hostname | github.com |
| None | 873364ab8c3892d45b3a7f6c012702ee84934662b47c9312d99f8b31dd9c2668 |
| turbo-cache-control | no-preview |
| go-import | github.com/whyils/db-tutorial git https://github.com/whyils/db-tutorial.git |
| octolytics-dimension-user_id | 193909409 |
| octolytics-dimension-user_login | whyils |
| octolytics-dimension-repository_id | 912831220 |
| octolytics-dimension-repository_nwo | whyils/db-tutorial |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | true |
| octolytics-dimension-repository_parent_id | 99658622 |
| octolytics-dimension-repository_parent_nwo | dunwu/db-tutorial |
| octolytics-dimension-repository_network_root_id | 99658622 |
| octolytics-dimension-repository_network_root_nwo | dunwu/db-tutorial |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | fa6ed180534301da051f8e5cb00f3a1dfab789ec |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| Skip to content | https://patch-diff.githubusercontent.com/whyils/db-tutorial#start-of-content |
|
| https://patch-diff.githubusercontent.com/ |
|
Sign in
| https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Fwhyils%2Fdb-tutorial |
| GitHub CopilotWrite better code with AI | https://github.com/features/copilot |
| GitHub SparkBuild and deploy intelligent apps | https://github.com/features/spark |
| GitHub ModelsManage and compare prompts | https://github.com/features/models |
| MCP RegistryNewIntegrate external tools | https://github.com/mcp |
| ActionsAutomate any workflow | https://github.com/features/actions |
| CodespacesInstant dev environments | https://github.com/features/codespaces |
| IssuesPlan and track work | https://github.com/features/issues |
| Code ReviewManage code changes | https://github.com/features/code-review |
| GitHub Advanced SecurityFind and fix vulnerabilities | https://github.com/security/advanced-security |
| Code securitySecure your code as you build | https://github.com/security/advanced-security/code-security |
| Secret protectionStop leaks before they start | https://github.com/security/advanced-security/secret-protection |
| Why GitHub | https://github.com/why-github |
| Documentation | https://docs.github.com |
| Blog | https://github.blog |
| Changelog | https://github.blog/changelog |
| Marketplace | https://github.com/marketplace |
| View all features | https://github.com/features |
| Enterprises | https://github.com/enterprise |
| Small and medium teams | https://github.com/team |
| Startups | https://github.com/enterprise/startups |
| Nonprofits | https://github.com/solutions/industry/nonprofits |
| App Modernization | https://github.com/solutions/use-case/app-modernization |
| DevSecOps | https://github.com/solutions/use-case/devsecops |
| DevOps | https://github.com/solutions/use-case/devops |
| CI/CD | https://github.com/solutions/use-case/ci-cd |
| View all use cases | https://github.com/solutions/use-case |
| Healthcare | https://github.com/solutions/industry/healthcare |
| Financial services | https://github.com/solutions/industry/financial-services |
| Manufacturing | https://github.com/solutions/industry/manufacturing |
| Government | https://github.com/solutions/industry/government |
| View all industries | https://github.com/solutions/industry |
| View all solutions | https://github.com/solutions |
| AI | https://github.com/resources/articles?topic=ai |
| Software Development | https://github.com/resources/articles?topic=software-development |
| DevOps | https://github.com/resources/articles?topic=devops |
| Security | https://github.com/resources/articles?topic=security |
| View all topics | https://github.com/resources/articles |
| Customer stories | https://github.com/customer-stories |
| Events & webinars | https://github.com/resources/events |
| Ebooks & reports | https://github.com/resources/whitepapers |
| Business insights | https://github.com/solutions/executive-insights |
| GitHub Skills | https://skills.github.com |
| Documentation | https://docs.github.com |
| Customer support | https://support.github.com |
| Community forum | https://github.com/orgs/community/discussions |
| Trust center | https://github.com/trust-center |
| Partners | https://github.com/partners |
| GitHub SponsorsFund open source developers | https://github.com/sponsors |
| Security Lab | https://securitylab.github.com |
| Maintainer Community | https://maintainers.github.com |
| Accelerator | https://github.com/accelerator |
| Archive Program | https://archiveprogram.github.com |
| Topics | https://github.com/topics |
| Trending | https://github.com/trending |
| Collections | https://github.com/collections |
| Enterprise platformAI-powered developer platform | https://github.com/enterprise |
| GitHub Advanced SecurityEnterprise-grade security features | https://github.com/security/advanced-security |
| Copilot for BusinessEnterprise-grade AI features | https://github.com/features/copilot/copilot-business |
| Premium SupportEnterprise-grade 24/7 support | https://github.com/premium-support |
| Pricing | https://github.com/pricing |
| Search syntax tips | https://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax |
| documentation | https://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax |
|
Sign in
| https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Fwhyils%2Fdb-tutorial |
|
Sign up
| https://patch-diff.githubusercontent.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E&source=header-repo&source_repo=whyils%2Fdb-tutorial |
| Reload | https://patch-diff.githubusercontent.com/whyils/db-tutorial |
| Reload | https://patch-diff.githubusercontent.com/whyils/db-tutorial |
| Reload | https://patch-diff.githubusercontent.com/whyils/db-tutorial |
|
whyils
| https://patch-diff.githubusercontent.com/whyils |
| db-tutorial | https://patch-diff.githubusercontent.com/whyils/db-tutorial |
| dunwu/db-tutorial | https://patch-diff.githubusercontent.com/dunwu/db-tutorial |
|
Notifications
| https://patch-diff.githubusercontent.com/login?return_to=%2Fwhyils%2Fdb-tutorial |
|
Fork
0
| https://patch-diff.githubusercontent.com/login?return_to=%2Fwhyils%2Fdb-tutorial |
|
Star
0
| https://patch-diff.githubusercontent.com/login?return_to=%2Fwhyils%2Fdb-tutorial |
| dunwu.github.io/db-tutorial/ | https://dunwu.github.io/db-tutorial/ |
|
CC-BY-SA-4.0 license
| https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/LICENSE |
|
0
stars
| https://patch-diff.githubusercontent.com/whyils/db-tutorial/stargazers |
|
647
forks
| https://patch-diff.githubusercontent.com/whyils/db-tutorial/forks |
|
Branches
| https://patch-diff.githubusercontent.com/whyils/db-tutorial/branches |
|
Tags
| https://patch-diff.githubusercontent.com/whyils/db-tutorial/tags |
|
Activity
| https://patch-diff.githubusercontent.com/whyils/db-tutorial/activity |
|
Star
| https://patch-diff.githubusercontent.com/login?return_to=%2Fwhyils%2Fdb-tutorial |
|
Notifications
| https://patch-diff.githubusercontent.com/login?return_to=%2Fwhyils%2Fdb-tutorial |
|
Code
| https://patch-diff.githubusercontent.com/whyils/db-tutorial |
|
Pull requests
0
| https://patch-diff.githubusercontent.com/whyils/db-tutorial/pulls |
|
Actions
| https://patch-diff.githubusercontent.com/whyils/db-tutorial/actions |
|
Projects
0
| https://patch-diff.githubusercontent.com/whyils/db-tutorial/projects |
|
Security
Uh oh!
There was an error while loading. Please reload this page.
| https://patch-diff.githubusercontent.com/whyils/db-tutorial/security |
| Please reload this page | https://patch-diff.githubusercontent.com/whyils/db-tutorial |
|
Insights
| https://patch-diff.githubusercontent.com/whyils/db-tutorial/pulse |
|
Code
| https://patch-diff.githubusercontent.com/whyils/db-tutorial |
|
Pull requests
| https://patch-diff.githubusercontent.com/whyils/db-tutorial/pulls |
|
Actions
| https://patch-diff.githubusercontent.com/whyils/db-tutorial/actions |
|
Projects
| https://patch-diff.githubusercontent.com/whyils/db-tutorial/projects |
|
Security
| https://patch-diff.githubusercontent.com/whyils/db-tutorial/security |
|
Insights
| https://patch-diff.githubusercontent.com/whyils/db-tutorial/pulse |
| Branches | https://patch-diff.githubusercontent.com/whyils/db-tutorial/branches |
| Tags | https://patch-diff.githubusercontent.com/whyils/db-tutorial/tags |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial/branches |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial/tags |
| 231 Commits | https://patch-diff.githubusercontent.com/whyils/db-tutorial/commits/master/ |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial/commits/master/ |
| .github/workflows | https://patch-diff.githubusercontent.com/whyils/db-tutorial/tree/master/.github/workflows |
| .github/workflows | https://patch-diff.githubusercontent.com/whyils/db-tutorial/tree/master/.github/workflows |
| assets/elasticsearch | https://patch-diff.githubusercontent.com/whyils/db-tutorial/tree/master/assets/elasticsearch |
| assets/elasticsearch | https://patch-diff.githubusercontent.com/whyils/db-tutorial/tree/master/assets/elasticsearch |
| codes | https://patch-diff.githubusercontent.com/whyils/db-tutorial/tree/master/codes |
| codes | https://patch-diff.githubusercontent.com/whyils/db-tutorial/tree/master/codes |
| docs | https://patch-diff.githubusercontent.com/whyils/db-tutorial/tree/master/docs |
| docs | https://patch-diff.githubusercontent.com/whyils/db-tutorial/tree/master/docs |
| scripts | https://patch-diff.githubusercontent.com/whyils/db-tutorial/tree/master/scripts |
| scripts | https://patch-diff.githubusercontent.com/whyils/db-tutorial/tree/master/scripts |
| utils | https://patch-diff.githubusercontent.com/whyils/db-tutorial/tree/master/utils |
| utils | https://patch-diff.githubusercontent.com/whyils/db-tutorial/tree/master/utils |
| .babelrc | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/.babelrc |
| .babelrc | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/.babelrc |
| .editorconfig | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/.editorconfig |
| .editorconfig | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/.editorconfig |
| .gitattributes | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/.gitattributes |
| .gitattributes | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/.gitattributes |
| .gitignore | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/.gitignore |
| .gitignore | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/.gitignore |
| LICENSE | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/LICENSE |
| LICENSE | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/LICENSE |
| README.md | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/README.md |
| README.md | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/README.md |
| package.json | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/package.json |
| package.json | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/package.json |
| prettier.config.js | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/prettier.config.js |
| prettier.config.js | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/prettier.config.js |
| README | https://patch-diff.githubusercontent.com/whyils/db-tutorial |
| License | https://patch-diff.githubusercontent.com/whyils/db-tutorial |
|
| https://dunwu.github.io/db-tutorial/ |
|
| https://github.com/dunwu/db-tutorial |
|
| https://github.com/dunwu/db-tutorial |
|
| https://github.com/dunwu/db-tutorial/commits/master |
|
| https://creativecommons.org/licenses/by-nc-sa/4.0/deed.zh |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#db-tutorial |
| Github | https://github.com/dunwu/db-tutorial/ |
| Gitee | https://gitee.com/turnon/db-tutorial/ |
| Github Pages | https://dunwu.github.io/db-tutorial/ |
| Gitee Pages | https://turnon.gitee.io/db-tutorial/ |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#数据库综合 |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#分布式存储原理 |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#分布式理论 |
| 分布式一致性 | https://dunwu.github.io/blog/pages/dac0e2/ |
| 深入剖析共识性算法 Paxos | https://dunwu.github.io/blog/pages/874539/ |
| 深入剖析共识性算法 Raft | https://dunwu.github.io/blog/pages/e40812/ |
| 分布式算法 Gossip | https://dunwu.github.io/blog/pages/d15993/ |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#分布式关键技术 |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#流量调度 |
| 流量控制 | https://dunwu.github.io/blog/pages/282676/ |
| 负载均衡 | https://dunwu.github.io/blog/pages/98a1c1/ |
| 服务路由 | https://dunwu.github.io/blog/pages/d04ece/ |
| 分布式会话基本原理 | https://dunwu.github.io/blog/pages/3e66c2/ |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#数据调度 |
| 缓存基本原理 | https://dunwu.github.io/blog/pages/471208/ |
| 读写分离基本原理 | https://dunwu.github.io/blog/pages/7da6ca/ |
| 分库分表基本原理 | https://dunwu.github.io/blog/pages/103382/ |
| 分布式 ID 基本原理 | https://dunwu.github.io/blog/pages/0b2e59/ |
| 分布式事务基本原理 | https://dunwu.github.io/blog/pages/910bad/ |
| 分布式锁基本原理 | https://dunwu.github.io/blog/pages/69360c/ |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#其他 |
| Nosql 技术选型 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/01.%E6%95%B0%E6%8D%AE%E5%BA%93%E7%BB%BC%E5%90%88/01.Nosql%E6%8A%80%E6%9C%AF%E9%80%89%E5%9E%8B.md |
| 数据结构与数据库索引 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/01.%E6%95%B0%E6%8D%AE%E5%BA%93%E7%BB%BC%E5%90%88/02.%E6%95%B0%E6%8D%AE%E7%BB%93%E6%9E%84%E4%B8%8E%E6%95%B0%E6%8D%AE%E5%BA%93%E7%B4%A2%E5%BC%95.md |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#数据库中间件 |
| ShardingSphere 简介 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/02.%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E9%97%B4%E4%BB%B6/01.Shardingsphere/01.ShardingSphere%E7%AE%80%E4%BB%8B.md |
| ShardingSphere Jdbc | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/02.%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E9%97%B4%E4%BB%B6/01.Shardingsphere/02.ShardingSphereJdbc.md |
| 版本管理中间件 Flyway | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/02.%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E9%97%B4%E4%BB%B6/02.Flyway.md |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#关系型数据库 |
| 关系型数据库 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/03.%E5%85%B3%E7%B3%BB%E5%9E%8B%E6%95%B0%E6%8D%AE%E5%BA%93 |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#关系型数据库综合 |
| 关系型数据库面试总结 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/03.%E5%85%B3%E7%B3%BB%E5%9E%8B%E6%95%B0%E6%8D%AE%E5%BA%93/01.%E7%BB%BC%E5%90%88/01.%E5%85%B3%E7%B3%BB%E5%9E%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E9%9D%A2%E8%AF%95.md |
| SQL 语法基础特性 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/03.%E5%85%B3%E7%B3%BB%E5%9E%8B%E6%95%B0%E6%8D%AE%E5%BA%93/01.%E7%BB%BC%E5%90%88/02.SQL%E8%AF%AD%E6%B3%95%E5%9F%BA%E7%A1%80%E7%89%B9%E6%80%A7.md |
| SQL 语法高级特性 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/03.%E5%85%B3%E7%B3%BB%E5%9E%8B%E6%95%B0%E6%8D%AE%E5%BA%93/01.%E7%BB%BC%E5%90%88/03.SQL%E8%AF%AD%E6%B3%95%E9%AB%98%E7%BA%A7%E7%89%B9%E6%80%A7.md |
| 扩展 SQL | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/03.%E5%85%B3%E7%B3%BB%E5%9E%8B%E6%95%B0%E6%8D%AE%E5%BA%93/01.%E7%BB%BC%E5%90%88/03.%E6%89%A9%E5%B1%95SQL.md |
| SQL Cheat Sheet | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/03.%E5%85%B3%E7%B3%BB%E5%9E%8B%E6%95%B0%E6%8D%AE%E5%BA%93/01.%E7%BB%BC%E5%90%88/99.SqlCheatSheet.md |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#mysql |
| https://raw.githubusercontent.com/dunwu/images/master/snap/20200716103611.png |
| Mysql 应用指南 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/03.%E5%85%B3%E7%B3%BB%E5%9E%8B%E6%95%B0%E6%8D%AE%E5%BA%93/02.Mysql/01.Mysql%E5%BA%94%E7%94%A8%E6%8C%87%E5%8D%97.md |
| Mysql 工作流 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/03.%E5%85%B3%E7%B3%BB%E5%9E%8B%E6%95%B0%E6%8D%AE%E5%BA%93/02.Mysql/02.MySQL%E5%B7%A5%E4%BD%9C%E6%B5%81.md |
| Mysql 事务 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/03.%E5%85%B3%E7%B3%BB%E5%9E%8B%E6%95%B0%E6%8D%AE%E5%BA%93/02.Mysql/03.Mysql%E4%BA%8B%E5%8A%A1.md |
| Mysql 锁 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/03.%E5%85%B3%E7%B3%BB%E5%9E%8B%E6%95%B0%E6%8D%AE%E5%BA%93/02.Mysql/04.Mysql%E9%94%81.md |
| Mysql 索引 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/03.%E5%85%B3%E7%B3%BB%E5%9E%8B%E6%95%B0%E6%8D%AE%E5%BA%93/02.Mysql/05.Mysql%E7%B4%A2%E5%BC%95.md |
| Mysql 性能优化 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/03.%E5%85%B3%E7%B3%BB%E5%9E%8B%E6%95%B0%E6%8D%AE%E5%BA%93/02.Mysql/06.Mysql%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96.md |
| Mysql 运维 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/03.%E5%85%B3%E7%B3%BB%E5%9E%8B%E6%95%B0%E6%8D%AE%E5%BA%93/02.Mysql/20.Mysql%E8%BF%90%E7%BB%B4.md |
| Mysql 配置 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/03.%E5%85%B3%E7%B3%BB%E5%9E%8B%E6%95%B0%E6%8D%AE%E5%BA%93/02.Mysql/21.Mysql%E9%85%8D%E7%BD%AE.md |
| Mysql 问题 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/03.%E5%85%B3%E7%B3%BB%E5%9E%8B%E6%95%B0%E6%8D%AE%E5%BA%93/02.Mysql/99.Mysql%E5%B8%B8%E8%A7%81%E9%97%AE%E9%A2%98.md |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#其他-1 |
| PostgreSQL 应用指南 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/03.%E5%85%B3%E7%B3%BB%E5%9E%8B%E6%95%B0%E6%8D%AE%E5%BA%93/99.%E5%85%B6%E4%BB%96/01.PostgreSQL.md |
| H2 应用指南 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/03.%E5%85%B3%E7%B3%BB%E5%9E%8B%E6%95%B0%E6%8D%AE%E5%BA%93/99.%E5%85%B6%E4%BB%96/02.H2.md |
| SqLite 应用指南 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/03.%E5%85%B3%E7%B3%BB%E5%9E%8B%E6%95%B0%E6%8D%AE%E5%BA%93/99.%E5%85%B6%E4%BB%96/03.Sqlite.md |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#文档数据库 |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#mongodb |
| MongoDB 应用指南 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/04.%E6%96%87%E6%A1%A3%E6%95%B0%E6%8D%AE%E5%BA%93/01.MongoDB/01.MongoDB%E5%BA%94%E7%94%A8%E6%8C%87%E5%8D%97.md |
| MongoDB 的 CRUD 操作 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/04.%E6%96%87%E6%A1%A3%E6%95%B0%E6%8D%AE%E5%BA%93/01.MongoDB/02.MongoDB%E7%9A%84CRUD%E6%93%8D%E4%BD%9C.md |
| MongoDB 聚合操作 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/04.%E6%96%87%E6%A1%A3%E6%95%B0%E6%8D%AE%E5%BA%93/01.MongoDB/03.MongoDB%E7%9A%84%E8%81%9A%E5%90%88%E6%93%8D%E4%BD%9C.md |
| MongoDB 事务 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/04.%E6%96%87%E6%A1%A3%E6%95%B0%E6%8D%AE%E5%BA%93/01.MongoDB/04.MongoDB%E4%BA%8B%E5%8A%A1.md |
| MongoDB 建模 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/04.%E6%96%87%E6%A1%A3%E6%95%B0%E6%8D%AE%E5%BA%93/01.MongoDB/05.MongoDB%E5%BB%BA%E6%A8%A1.md |
| MongoDB 建模示例 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/04.%E6%96%87%E6%A1%A3%E6%95%B0%E6%8D%AE%E5%BA%93/01.MongoDB/06.MongoDB%E5%BB%BA%E6%A8%A1%E7%A4%BA%E4%BE%8B.md |
| MongoDB 索引 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/04.%E6%96%87%E6%A1%A3%E6%95%B0%E6%8D%AE%E5%BA%93/01.MongoDB/07.MongoDB%E7%B4%A2%E5%BC%95.md |
| MongoDB 复制 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/04.%E6%96%87%E6%A1%A3%E6%95%B0%E6%8D%AE%E5%BA%93/01.MongoDB/08.MongoDB%E5%A4%8D%E5%88%B6.md |
| MongoDB 分片 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/04.%E6%96%87%E6%A1%A3%E6%95%B0%E6%8D%AE%E5%BA%93/01.MongoDB/09.MongoDB%E5%88%86%E7%89%87.md |
| MongoDB 运维 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/04.%E6%96%87%E6%A1%A3%E6%95%B0%E6%8D%AE%E5%BA%93/01.MongoDB/20.MongoDB%E8%BF%90%E7%BB%B4.md |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#kv-数据库 |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#redis |
| https://raw.githubusercontent.com/dunwu/images/master/snap/20200713105627.png |
| Redis 面试总结 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/05.KV%E6%95%B0%E6%8D%AE%E5%BA%93/01.Redis/01.Redis%E9%9D%A2%E8%AF%95%E6%80%BB%E7%BB%93.md |
| Redis 应用指南 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/05.KV%E6%95%B0%E6%8D%AE%E5%BA%93/01.Redis/02.Redis%E5%BA%94%E7%94%A8%E6%8C%87%E5%8D%97.md |
| Redis 数据类型和应用 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/05.KV%E6%95%B0%E6%8D%AE%E5%BA%93/01.Redis/03.Redis%E6%95%B0%E6%8D%AE%E7%B1%BB%E5%9E%8B%E5%92%8C%E5%BA%94%E7%94%A8.md |
| Redis 持久化 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/05.KV%E6%95%B0%E6%8D%AE%E5%BA%93/01.Redis/04.Redis%E6%8C%81%E4%B9%85%E5%8C%96.md |
| Redis 复制 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/05.KV%E6%95%B0%E6%8D%AE%E5%BA%93/01.Redis/05.Redis%E5%A4%8D%E5%88%B6.md |
| Redis 哨兵 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/05.KV%E6%95%B0%E6%8D%AE%E5%BA%93/01.Redis/06.Redis%E5%93%A8%E5%85%B5.md |
| Redis 集群 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/05.KV%E6%95%B0%E6%8D%AE%E5%BA%93/01.Redis/07.Redis%E9%9B%86%E7%BE%A4.md |
| Redis 实战 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/05.KV%E6%95%B0%E6%8D%AE%E5%BA%93/01.Redis/08.Redis%E5%AE%9E%E6%88%98.md |
| Redis 运维 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/05.KV%E6%95%B0%E6%8D%AE%E5%BA%93/01.Redis/20.Redis%E8%BF%90%E7%BB%B4.md |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#列式数据库 |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#hbase |
| HBase 快速入门 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/06.%E5%88%97%E5%BC%8F%E6%95%B0%E6%8D%AE%E5%BA%93/01.HBase/01.HBase%E5%BF%AB%E9%80%9F%E5%85%A5%E9%97%A8.md |
| HBase 数据模型 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/06.%E5%88%97%E5%BC%8F%E6%95%B0%E6%8D%AE%E5%BA%93/01.HBase/02.HBase%E6%95%B0%E6%8D%AE%E6%A8%A1%E5%9E%8B.md |
| HBase Schema 设计 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/06.%E5%88%97%E5%BC%8F%E6%95%B0%E6%8D%AE%E5%BA%93/01.HBase/03.HBaseSchema%E8%AE%BE%E8%AE%A1.md |
| HBase 架构 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/06.%E5%88%97%E5%BC%8F%E6%95%B0%E6%8D%AE%E5%BA%93/01.HBase/04.HBase%E6%9E%B6%E6%9E%84.md |
| HBase Java API 基础特性 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/06.%E5%88%97%E5%BC%8F%E6%95%B0%E6%8D%AE%E5%BA%93/01.HBase/10.HBaseJavaApi%E5%9F%BA%E7%A1%80%E7%89%B9%E6%80%A7.md |
| HBase Java API 高级特性之过滤器 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/06.%E5%88%97%E5%BC%8F%E6%95%B0%E6%8D%AE%E5%BA%93/01.HBase/11.HBaseJavaApi%E9%AB%98%E7%BA%A7%E7%89%B9%E6%80%A7%E4%B9%8B%E8%BF%87%E6%BB%A4%E5%99%A8.md |
| HBase Java API 高级特性之协处理器 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/06.%E5%88%97%E5%BC%8F%E6%95%B0%E6%8D%AE%E5%BA%93/01.HBase/12.HBaseJavaApi%E9%AB%98%E7%BA%A7%E7%89%B9%E6%80%A7%E4%B9%8B%E5%8D%8F%E5%A4%84%E7%90%86%E5%99%A8.md |
| HBase Java API 其他高级特性 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/06.%E5%88%97%E5%BC%8F%E6%95%B0%E6%8D%AE%E5%BA%93/01.HBase/13.HBaseJavaApi%E5%85%B6%E4%BB%96%E9%AB%98%E7%BA%A7%E7%89%B9%E6%80%A7.md |
| HBase 运维 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/06.%E5%88%97%E5%BC%8F%E6%95%B0%E6%8D%AE%E5%BA%93/01.HBase/21.HBase%E8%BF%90%E7%BB%B4.md |
| HBase 命令 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/06.%E5%88%97%E5%BC%8F%E6%95%B0%E6%8D%AE%E5%BA%93/01.HBase/22.HBase%E5%91%BD%E4%BB%A4.md |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#搜索引擎数据库 |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#elasticsearch |
| Elasticsearch 面试总结 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/07.%E6%90%9C%E7%B4%A2%E5%BC%95%E6%93%8E%E6%95%B0%E6%8D%AE%E5%BA%93/01.Elasticsearch/01.Elasticsearch%E9%9D%A2%E8%AF%95%E6%80%BB%E7%BB%93.md |
| Elasticsearch 快速入门 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/07.%E6%90%9C%E7%B4%A2%E5%BC%95%E6%93%8E%E6%95%B0%E6%8D%AE%E5%BA%93/01.Elasticsearch/02.Elasticsearch%E5%BF%AB%E9%80%9F%E5%85%A5%E9%97%A8.md |
| Elasticsearch 简介 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/07.%E6%90%9C%E7%B4%A2%E5%BC%95%E6%93%8E%E6%95%B0%E6%8D%AE%E5%BA%93/01.Elasticsearch/03.Elasticsearch%E7%AE%80%E4%BB%8B.md |
| Elasticsearch 索引 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/07.%E6%90%9C%E7%B4%A2%E5%BC%95%E6%93%8E%E6%95%B0%E6%8D%AE%E5%BA%93/01.Elasticsearch/04.Elasticsearch%E7%B4%A2%E5%BC%95.md |
| Elasticsearch 查询 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/07.%E6%90%9C%E7%B4%A2%E5%BC%95%E6%93%8E%E6%95%B0%E6%8D%AE%E5%BA%93/01.Elasticsearch/05.Elasticsearch%E6%9F%A5%E8%AF%A2.md |
| Elasticsearch 高亮 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/07.%E6%90%9C%E7%B4%A2%E5%BC%95%E6%93%8E%E6%95%B0%E6%8D%AE%E5%BA%93/01.Elasticsearch/06.Elasticsearch%E9%AB%98%E4%BA%AE.md |
| Elasticsearch 排序 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/07.%E6%90%9C%E7%B4%A2%E5%BC%95%E6%93%8E%E6%95%B0%E6%8D%AE%E5%BA%93/01.Elasticsearch/07.Elasticsearch%E6%8E%92%E5%BA%8F.md |
| Elasticsearch 聚合 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/07.%E6%90%9C%E7%B4%A2%E5%BC%95%E6%93%8E%E6%95%B0%E6%8D%AE%E5%BA%93/01.Elasticsearch/08.Elasticsearch%E8%81%9A%E5%90%88.md |
| Elasticsearch 分析器 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/07.%E6%90%9C%E7%B4%A2%E5%BC%95%E6%93%8E%E6%95%B0%E6%8D%AE%E5%BA%93/01.Elasticsearch/09.Elasticsearch%E5%88%86%E6%9E%90%E5%99%A8.md |
| Elasticsearch 性能优化 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/07.%E6%90%9C%E7%B4%A2%E5%BC%95%E6%93%8E%E6%95%B0%E6%8D%AE%E5%BA%93/01.Elasticsearch/10.Elasticsearch%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96.md |
| Elasticsearch Rest API | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/07.%E6%90%9C%E7%B4%A2%E5%BC%95%E6%93%8E%E6%95%B0%E6%8D%AE%E5%BA%93/01.Elasticsearch/11.ElasticsearchRestApi.md |
| ElasticSearch Java API 之 High Level REST Client | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/07.%E6%90%9C%E7%B4%A2%E5%BC%95%E6%93%8E%E6%95%B0%E6%8D%AE%E5%BA%93/01.Elasticsearch/12.ElasticsearchHighLevelRestJavaApi.md |
| Elasticsearch 集群和分片 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/07.%E6%90%9C%E7%B4%A2%E5%BC%95%E6%93%8E%E6%95%B0%E6%8D%AE%E5%BA%93/01.Elasticsearch/13.Elasticsearch%E9%9B%86%E7%BE%A4%E5%92%8C%E5%88%86%E7%89%87.md |
| Elasticsearch 运维 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/07.%E6%90%9C%E7%B4%A2%E5%BC%95%E6%93%8E%E6%95%B0%E6%8D%AE%E5%BA%93/01.Elasticsearch/20.Elasticsearch%E8%BF%90%E7%BB%B4.md |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#elastic |
| Elastic 快速入门 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/07.%E6%90%9C%E7%B4%A2%E5%BC%95%E6%93%8E%E6%95%B0%E6%8D%AE%E5%BA%93/02.Elastic/01.Elastic%E5%BF%AB%E9%80%9F%E5%85%A5%E9%97%A8.md |
| Elastic 技术栈之 Filebeat | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/07.%E6%90%9C%E7%B4%A2%E5%BC%95%E6%93%8E%E6%95%B0%E6%8D%AE%E5%BA%93/02.Elastic/02.Elastic%E6%8A%80%E6%9C%AF%E6%A0%88%E4%B9%8BFilebeat.md |
| Filebeat 运维 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/07.%E6%90%9C%E7%B4%A2%E5%BC%95%E6%93%8E%E6%95%B0%E6%8D%AE%E5%BA%93/02.Elastic/03.Filebeat%E8%BF%90%E7%BB%B4.md |
| Elastic 技术栈之 Kibana | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/07.%E6%90%9C%E7%B4%A2%E5%BC%95%E6%93%8E%E6%95%B0%E6%8D%AE%E5%BA%93/02.Elastic/04.Elastic%E6%8A%80%E6%9C%AF%E6%A0%88%E4%B9%8BKibana.md |
| Kibana 运维 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/07.%E6%90%9C%E7%B4%A2%E5%BC%95%E6%93%8E%E6%95%B0%E6%8D%AE%E5%BA%93/02.Elastic/05.Kibana%E8%BF%90%E7%BB%B4.md |
| Elastic 技术栈之 Logstash | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/07.%E6%90%9C%E7%B4%A2%E5%BC%95%E6%93%8E%E6%95%B0%E6%8D%AE%E5%BA%93/02.Elastic/06.Elastic%E6%8A%80%E6%9C%AF%E6%A0%88%E4%B9%8BLogstash.md |
| Logstash 运维 | https://patch-diff.githubusercontent.com/whyils/db-tutorial/blob/master/docs/12.%E6%95%B0%E6%8D%AE%E5%BA%93/07.%E6%90%9C%E7%B4%A2%E5%BC%95%E6%93%8E%E6%95%B0%E6%8D%AE%E5%BA%93/02.Elastic/07.Logstash%E8%BF%90%E7%BB%B4.md |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#资料- |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#数据库综合资料 |
| DB-Engines | https://db-engines.com/en/ranking |
| 《数据密集型应用系统设计》 | https://book.douban.com/subject/30329536/ |
| CMU 15445 数据库基础课程 | https://15445.courses.cs.cmu.edu/fall2019/schedule.html |
| CMU 15721 数据库高级课程 | https://15721.courses.cs.cmu.edu/spring2020/schedule.html |
| 检索技术核心 20 讲 | https://time.geekbang.org/column/intro/100048401 |
| 后端存储实战课 | https://time.geekbang.org/column/intro/100046801 |
| Efficiency in the Columbia Database Query Optimizer | https://15721.courses.cs.cmu.edu/spring2018/papers/15-optimizer1/xu-columbia-thesis1998.pdf |
| How Good Are Query Optimizers, Really? | http://www.vldb.org/pvldb/vol9/p204-leis.pdf |
| Architecture of a Database System | https://dsf.berkeley.edu/papers/fntdb07-architecture.pdf |
| Data Structures for Databases | https://www.cise.ufl.edu/~mschneid/Research/papers/HS05BoCh.pdf |
| Data Structures and Algorithms for Big Databases | https://people.csail.mit.edu/bradley/BenderKuszmaul-tutorial-xldb12.pdf |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#关系型数据库资料 |
| 《数据库的索引设计与优化》 | https://book.douban.com/subject/26419771/ |
| 《SQL 必知必会》 | https://book.douban.com/subject/35167240/ |
| 《Oracle Database 9i/10g/11g 编程艺术》 | https://book.douban.com/subject/5402711/ |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#mysql-资料 |
| Mysql 官网 | https://www.mysql.com/ |
| Mysql 官方文档 | https://dev.mysql.com/doc/ |
| How to Analyze and Tune MySQL Queries for Better Performance | https://www.mysql.com/cn/why-mysql/presentations/tune-mysql-queries-performance/ |
| MySQL Performance Tuning 101 | https://www.mysql.com/cn/why-mysql/presentations/mysql-performance-tuning101/ |
| MySQL Performance Schema & Sys Schema | https://www.mysql.com/cn/why-mysql/presentations/mysql-performance-sys-schema/ |
| MySQL Performance: Demystified Tuning & Best Practices | https://www.mysql.com/cn/why-mysql/presentations/mysql-performance-tuning-best-practices/ |
| MySQL Security Best Practices | https://www.mysql.com/cn/why-mysql/presentations/mysql-security-best-practices/ |
| MySQL Cluster Deployment Best Practices | https://www.mysql.com/cn/why-mysql/presentations/mysql-cluster-deployment-best-practices/ |
| MySQL High Availability with InnoDB Cluster | https://www.mysql.com/cn/why-mysql/presentations/mysql-high-availability-innodb-cluster/ |
| 《高性能 MySQL》 | https://book.douban.com/subject/23008813/ |
| 《MySQL 技术内幕:InnoDB 存储引擎》 | https://book.douban.com/subject/24708143/ |
| 《MySQL 必知必会》 | https://book.douban.com/subject/3354490/ |
| runoob.com MySQL 教程 | http://www.runoob.com/mysql/mysql-tutorial.html |
| mysql-tutorial | https://github.com/jaywcjlove/mysql-tutorial |
| MySQL 索引背后的数据结构及算法原理 | http://blog.codinglabs.org/articles/theory-of-mysql-index.html |
| Some study on database storage internals | https://medium.com/@kousiknath/data-structures-database-storage-internals-1f5ed3619d43 |
| Sharding Pinterest: How we scaled our MySQL fleet | https://medium.com/@Pinterest_Engineering/sharding-pinterest-how-we-scaled-our-mysql-fleet-3f341e96ca6f |
| Guide to MySQL High Availability | https://www.mysql.com/cn/why-mysql/white-papers/mysql-guide-to-high-availability-solutions/ |
| Choosing MySQL High Availability Solutions | https://dzone.com/articles/choosing-mysql-high-availability-solutions |
| High availability with MariaDB TX: The definitive guide | https://mariadb.com/sites/default/files/content/Whitepaper_High_availability_with_MariaDB-TX.pdf |
| Booking.com: Evolution of MySQL System Design | https://www.percona.com/live/mysql-conference-2015/sessions/bookingcom-evolution-mysql-system-design |
| Tracking the Money - Scaling Financial Reporting at Airbnb | https://medium.com/airbnb-engineering/tracking-the-money-scaling-financial-reporting-at-airbnb-6d742b80f040 |
| Why Uber Engineering Switched from Postgres to MySQL | https://eng.uber.com/mysql-migration/ |
| Monitoring Delayed Replication, With A Focus On MySQL | https://engineering.imvu.com/2013/01/09/monitoring-delayed-replication-with-a-focus-on-mysql/ |
| Mitigating replication lag and reducing read load with freno | https://githubengineering.com/mitigating-replication-lag-and-reducing-read-load-with-freno/ |
| Better Parallel Replication for MySQL | https://medium.com/booking-com-infrastructure/better-parallel-replication-for-mysql-14e2d7857813 |
| Evaluating MySQL Parallel Replication Part 2: Slave Group Commit | https://medium.com/booking-com-infrastructure/evaluating-mysql-parallel-replication-part-2-slave-group-commit-459026a141d2 |
| Evaluating MySQL Parallel Replication Part 3: Benchmarks in Production | https://medium.com/booking-com-infrastructure/evaluating-mysql-parallel-replication-part-3-benchmarks-in-production-db5811058d74 |
| Evaluating MySQL Parallel Replication Part 4: More Benchmarks in Production | https://medium.com/booking-com-infrastructure/evaluating-mysql-parallel-replication-part-4-more-benchmarks-in-production-49ee255043ab |
| Evaluating MySQL Parallel Replication Part 4, Annex: Under the Hood | https://medium.com/booking-com-infrastructure/evaluating-mysql-parallel-replication-part-4-annex-under-the-hood-eb456cf8b2fb |
| StackOverflow: MySQL sharding approaches? | https://stackoverflow.com/questions/5541421/mysql-sharding-approaches |
| Why you don’t want to shard | https://www.percona.com/blog/2009/08/06/why-you-dont-want-to-shard/ |
| https://www.percona.com/sites/default/files/presentations/How | https://www.percona.com/sites/default/files/presentations/How |
| MySQL Sharding with ProxySQL | https://www.percona.com/blog/2016/08/30/mysql-sharding-with-proxysql/ |
| MailChimp: Using Shards to Accommodate Millions of Users | https://devs.mailchimp.com/blog/using-shards-to-accommodate-millions-of-users/ |
| Uber: Code Migration in Production: Rewriting the Sharding Layer of Uber’s Schemaless Datastore | https://eng.uber.com/schemaless-rewrite/ |
| Sharding & IDs at Instagram | https://instagram-engineering.com/sharding-ids-at-instagram-1cf5a71e5a5c |
| Airbnb: How We Partitioned Airbnb’s Main Database in Two Weeks | https://medium.com/airbnb-engineering/how-we-partitioned-airbnb-s-main-database-in-two-weeks-55f7e006ff21 |
| awesome-mysql | https://github.com/jobbole/awesome-mysql-cn |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#nosql-数据库综合 |
| Introduction To NoSQL | https://youtu.be/qI_g07C_Q5I |
| NoSQL Distilled - NoSQL 精粹 | https://book.douban.com/subject/25662138/ |
| NoSQL Databases: a Survey and Decision Guidance | https://medium.com/baqend-blog/nosql-databases-a-survey-and-decision-guidance-ea7823a822d#.nhzop4d23 |
| Distribution, Data, Deployment: Software Architecture Convergence in Big Data Systems | https://resources.sei.cmu.edu/asset_files/WhitePaper/2014_019_001_90915.pdf |
| No Relation: The Mixed Blessings of Non-Relational Databases | http://ianvarley.com/UT/MR/Varley_MastersReport_Full_2009-08-07.pdf |
| NoSQL Data Modeling Techniques | https://highlyscalable.wordpress.com/2012/03/01/nosql-data-modeling-techniques/ |
| NoSQL 数据建模技术 | https://coolshell.cn/articles/7270.htm |
| MongoDB - Data Modeling Introduction | https://docs.mongodb.com/manual/core/data-modeling-introduction/ |
| Firebase - Structure Your Database | https://firebase.google.com/docs/database/android/structure-data |
| Visual Guide to NoSQL Systems | http://blog.nahurst.com/visual-guide-to-nosql-systems |
| SQL vs. NoSQL Databases: What’s the Difference? | https://www.upwork.com/hiring/data/sql-vs-nosql-databases-whats-the-difference/ |
| Salesforce: SQL or NoSQL | https://engineering.salesforce.com/sql-or-nosql-9eaf1d92545b |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#列式数据库资料 |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#cassandra-资料 |
| Avoid Pitfalls in Scaling Cassandra Cluster at Walmart | https://medium.com/walmartlabs/avoid-pitfalls-in-scaling-your-cassandra-cluster-lessons-and-remedies-a71ca01f8c04 |
| Storing Images in Cassandra at Walmart | https://medium.com/walmartlabs/building-object-store-storing-images-in-cassandra-walmart-scale-a6b9c02af593 |
| Yelp: How We Scaled Our Ad Analytics with Apache Cassandra | https://engineeringblog.yelp.com/2016/08/how-we-scaled-our-ad-analytics-with-cassandra.html |
| Discord: How Discord Stores Billions of Messages | https://blog.discordapp.com/how-discord-stores-billions-of-messages-7fa6ec7ee4c7 |
| Cassandra at Instagram | https://www.slideshare.net/DataStax/cassandra-at-instagram-2016 |
| Netflix: Benchmarking Cassandra Scalability on AWS - Over a million writes per second | https://medium.com/netflix-techblog/benchmarking-cassandra-scalability-on-aws-over-a-million-writes-per-second-39f45f066c9e |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#hbase-资料 |
| Imgur Notification: From MySQL to HBASE | https://medium.com/imgur-engineering/imgur-notifications-from-mysql-to-hbase-9dba6fc44183 |
| Pinterest: Improving HBase Backup Efficiency | https://medium.com/@Pinterest_Engineering/improving-hbase-backup-efficiency-at-pinterest-86159da4b954 |
| IBM : Tuning HBase performance | https://www.ibm.com/support/knowledgecenter/en/SSPT3X_2.1.2/com.ibm.swg.im.infosphere.biginsights.analyze.doc/doc/bigsql_TuneHbase.html |
| HBase File Locality in HDFS | http://www.larsgeorge.com/2010/05/hbase-file-locality-in-hdfs.html |
| Apache Hadoop Goes Realtime at Facebook | http://borthakur.com/ftp/RealtimeHadoopSigmod2011.pdf |
| Storage Infrastructure Behind Facebook Messages: Using HBase at Scale | http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.294.8459&rep=rep1&type=pdf |
| GitHub: Awesome HBase | https://github.com/rayokota/awesome-hbase |
| HBase 实战 | https://book.douban.com/subject/25706541/ |
| HBase 权威指南 | https://book.douban.com/subject/10748460/ |
| The Apache HBase™ Reference Guide | http://hbase.apache.org/0.94/book/book.html |
| ClickHouse - Open Source Distributed Column Database at Yandex | https://clickhouse.yandex/ |
| Scaling Redshift without Scaling Costs at GIPHY | https://engineering.giphy.com/scaling-redshift-without-scaling-costs/ |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#kv-数据库资料 |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#redis-资料 |
| Redis 官网 | https://redis.io/ |
| Redis github | https://github.com/antirez/redis |
| Redis 官方文档中文版 | http://redis.cn/ |
| Redis 命令参考 | http://redisdoc.com/ |
| 《Redis 实战》 | https://item.jd.com/11791607.html |
| 《Redis 设计与实现》 | https://item.jd.com/11486101.html |
| 《Redis 实战》配套 Python 源码 | https://github.com/josiahcarlson/redis-in-action |
| awesome-redis | https://github.com/JamzyWang/awesome-redis |
| spring-data-redis 官方文档 | https://docs.spring.io/spring-data/redis/docs/1.8.13.RELEASE/reference/html/ |
| redisson 官方文档(中文,略有滞后) | https://github.com/redisson/redisson/wiki/%E7%9B%AE%E5%BD%95 |
| redisson 官方文档(英文) | https://github.com/redisson/redisson/wiki/Table-of-Content |
| CRUG | Redisson PRO vs. Jedis: Which Is Faster? 翻译 | https://www.jianshu.com/p/82f0d5abb002 |
| redis 分布锁 Redisson 性能测试 | https://blog.csdn.net/everlasting_188/article/details/51073505 |
| Learn Redis the hard way (in production) at Trivago | http://tech.trivago.com/2017/01/25/learn-redis-the-hard-way-in-production/ |
| Twitter: How Twitter Uses Redis To Scale - 105TB RAM, 39MM QPS, 10,000+ Instances | http://highscalability.com/blog/2014/9/8/how-twitter-uses-redis-to-scale-105tb-ram-39mm-qps-10000-ins.html |
| Slack: Scaling Slack’s Job Queue - Robustly Handling Billions of Tasks in Milliseconds Using Kafka and Redis | https://slack.engineering/scaling-slacks-job-queue-687222e9d100 |
| GitHub: Moving persistent data out of Redis at GitHub | https://githubengineering.com/moving-persistent-data-out-of-redis/ |
| Instagram: Storing Hundreds of Millions of Simple Key-Value Pairs in Redis | https://engineering.instagram.com/storing-hundreds-of-millions-of-simple-key-value-pairs-in-redis-1091ae80f74c |
| Redis in Chat Architecture of Twitch (from 27:22) | https://www.infoq.com/presentations/twitch-pokemon |
| Deliveroo: Optimizing Session Key Storage in Redis | https://deliveroo.engineering/2016/10/07/optimising-session-key-storage.html |
| Deliveroo: Optimizing Redis Storage | https://deliveroo.engineering/2017/01/19/optimising-membership-queries.html |
| GitHub: Awesome Redis | https://github.com/JamzyWang/awesome-redis |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#文档数据库资料 |
| Couchbase Ecosystem at LinkedIn | https://engineering.linkedin.com/blog/2017/12/couchbase-ecosystem-at-linkedin |
| SimpleDB at Zendesk | https://medium.com/zendesk-engineering/resurrecting-amazon-simpledb-9404034ec506 |
| Data Points - What the Heck Are Document Databases? | https://msdn.microsoft.com/en-us/magazine/hh547103.aspx |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#mongodb-资料 |
| MongoDB 官网 | https://www.mongodb.com/ |
| MongoDB Github | https://github.com/mongodb/mongo |
| MongoDB 官方免费教程 | https://university.mongodb.com/ |
| MongoDB 教程 | https://www.runoob.com/mongodb/mongodb-tutorial.html |
| MongoDB 高手课 | https://time.geekbang.org/course/intro/100040001 |
| mongodb-json-files | https://github.com/ozlerhakan/mongodb-json-files |
| Introduction to MongoDB | https://www.slideshare.net/mdirolf/introduction-to-mongodb |
| eBay: Building Mission-Critical Multi-Data Center Applications with MongoDB | https://www.mongodb.com/blog/post/ebay-building-mission-critical-multi-data-center-applications-with-mongodb |
| The AWS and MongoDB Infrastructure of Parse: Lessons Learned | https://medium.baqend.com/parse-is-gone-a-few-secrets-about-their-infrastructure-91b3ab2fcf71 |
| Migrating Mountains of Mongo Data | https://medium.com/build-addepar/migrating-mountains-of-mongo-data-63e530539952 |
| Github: Awesome MongoDB | https://github.com/ramnes/awesome-mongodb |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#搜索引擎数据库资料 |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#elasticsearch-1 |
| Elasticsearch 官网 | https://www.elastic.co/cn/products/elasticsearch |
| Elasticsearch Github | https://github.com/elastic/elasticsearch |
| Elasticsearch 官方文档 | https://www.elastic.co/guide/en/elasticsearch/reference/current/index.html |
| Elasticsearch: The Definitive Guide | https://www.elastic.co/guide/en/elasticsearch/guide/master/index.html |
| 《Elasticsearch 实战》 | https://book.douban.com/subject/30380439/ |
| ELK Stack 权威指南 | https://github.com/chenryn/logstash-best-practice-cn |
| Elasticsearch 教程 | https://www.knowledgedict.com/tutorial/elasticsearch-intro.html |
| Elasticsearch+Logstash+Kibana 教程 | https://www.cnblogs.com/xing901022/p/4704319.html |
| ELK(Elasticsearch、Logstash、Kibana)安装和配置 | https://github.com/judasn/Linux-Tutorial/blob/master/ELK-Install-And-Settings.md |
| Elasticsearch Performance Tuning Practice at eBay | https://www.ebayinc.com/stories/blogs/tech/elasticsearch-performance-tuning-practice-at-ebay/ |
| Elasticsearch at Kickstarter | https://kickstarter.engineering/elasticsearch-at-kickstarter-db3c487887fc |
| 9 tips on ElasticSearch configuration for high performance | https://www.loggly.com/blog/nine-tips-configuring-elasticsearch-for-high-performance/ |
| Elasticsearch In Production - Deployment Best Practices | https://medium.com/@abhidrona/elasticsearch-deployment-best-practices-d6c1323b25d7 |
| GitHub: Awesome ElasticSearch | https://github.com/dzharii/awesome-elasticsearch |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#图数据库 |
| Intro to graph databases, Part 1, Graph databases and the CRUD operations | https://www.ibm.com/developerworks/library/cl-graph-database-1/cl-graph-database-1-pdf.pdf |
| Intro to graph databases, Part 2, Building a recommendation engine with a graph database | https://www.ibm.com/developerworks/library/cl-graph-database-2/cl-graph-database-2-pdf.pdf |
| Graph Database | http://graphdatabases.com |
| Handling Billions of Edges in a Graph Database | https://www.infoq.com/presentations/graph-database-scalability |
| Neo4j case studies with Walmart, eBay, AirBnB, NASA, etc | https://neo4j.com/customers/ |
| FlockDB: Distributed Graph Database for Storing Adjacency Lists at Twitter | https://blog.twitter.com/engineering/en_us/a/2010/introducing-flockdb.html |
| JanusGraph: Scalable Graph Database backed by Google, IBM and Hortonworks | https://architecht.io/google-ibm-back-new-open-source-graph-database-project-janusgraph-1d74fb78db6b |
| Amazon Neptune | https://aws.amazon.com/neptune/ |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#时序数据库 |
| What is Time-Series Data & Why We Need a Time-Series Database | https://blog.timescale.com/what-the-heck-is-time-series-data-and-why-do-i-need-a-time-series-database-dcf3b1b18563 |
| Time Series Data: Why and How to Use a Relational Database instead of NoSQL | https://blog.timescale.com/time-series-data-why-and-how-to-use-a-relational-database-instead-of-nosql-d0cd6975e87c |
| Beringei: High-performance Time Series Storage Engine @Facebook | https://code.facebook.com/posts/952820474848503/beringei-a-high-performance-time-series-storage-engine/ |
| Introducing Atlas: Netflix’s Primary Telemetry Platform @Netflix | https://medium.com/netflix-techblog/introducing-atlas-netflixs-primary-telemetry-platform-bd31f4d8ed9a |
| Building a Scalable Time Series Database on PostgreSQL | https://blog.timescale.com/when-boring-is-awesome-building-a-scalable-time-series-database-on-postgresql-2900ea453ee2 |
| Scaling Time Series Data Storage - Part I @Netflix | https://medium.com/netflix-techblog/scaling-time-series-data-storage-part-i-ec2b6d44ba39 |
| Design of a Cost Efficient Time Series Store for Big Data | https://medium.com/@leventov/design-of-a-cost-efficient-time-series-store-for-big-data-88c5dc41af8e |
| GitHub: Awesome Time-Series Database | https://github.com/xephonhq/awesome-time-series-database |
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#传送- |
| 钝悟的 IT 知识图谱 | https://dunwu.github.io/waterdrop/ |
| 钝悟的博客 | https://dunwu.github.io/blog/ |
| dunwu.github.io/db-tutorial/ | https://dunwu.github.io/db-tutorial/ |
|
Readme
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#readme-ov-file |
|
CC-BY-SA-4.0 license
| https://patch-diff.githubusercontent.com/whyils/db-tutorial#CC-BY-SA-4.0-1-ov-file |
| Please reload this page | https://patch-diff.githubusercontent.com/whyils/db-tutorial |
|
Activity | https://patch-diff.githubusercontent.com/whyils/db-tutorial/activity |
|
0
stars | https://patch-diff.githubusercontent.com/whyils/db-tutorial/stargazers |
|
0
watching | https://patch-diff.githubusercontent.com/whyils/db-tutorial/watchers |
|
0
forks | https://patch-diff.githubusercontent.com/whyils/db-tutorial/forks |
|
Report repository
| https://patch-diff.githubusercontent.com/contact/report-content?content_url=https%3A%2F%2Fgithub.com%2Fwhyils%2Fdb-tutorial&report=whyils+%28user%29 |
| Releases | https://patch-diff.githubusercontent.com/whyils/db-tutorial/releases |
| Packages
0 | https://patch-diff.githubusercontent.com/users/whyils/packages?repo_name=db-tutorial |
|
| https://github.com |
| Terms | https://docs.github.com/site-policy/github-terms/github-terms-of-service |
| Privacy | https://docs.github.com/site-policy/privacy-policies/github-privacy-statement |
| Security | https://github.com/security |
| Status | https://www.githubstatus.com/ |
| Community | https://github.community/ |
| Docs | https://docs.github.com/ |
| Contact | https://support.github.com?tags=dotcom-footer |