数据库架构

• https://zhuanlan.zhihu.com/p/43736857#:~:text=MySQL%E6%98%AF%E4%B8%80%E4%B8%AA%E5%85%B8%E5%9E%8B%E7%9A%84,Client%E8%B4%9F%E8%B4%A3%E8%BF%9E%E6%8E%A5%E5%88%B0Server%E3%80%82
• https://mp.weixin.qq.com/s/zL4QP15W1Zd7HUm_wTbE2Q

InnoDB架构

• innodb架构: https://xie.infoq.cn/article/48544a3041634ca9ce62eaff4

• 缓冲池(buffer pool),这次彻底懂了: https://juejin.cn/post/6844903874172551181

• 自适应哈希: https://www.cnblogs.com/geaozhang/p/7252389.html

• 写缓冲(change buffer),这次彻底懂了: https://its401.com/article/shenjian58/93691224

• log buffer: https://blog.51cto.com/jyjstack/2548512

• double wirte buffer: https://blog.csdn.net/shenjian58/article/details/103501888

• innodb_file_per_table(表空间): https://www.jianshu.com/p/bfee26584746

mysql事务

• mysql事务总结: https://zhuanlan.zhihu.com/p/29166694

InnoDB索引

• InnoDB索引，终于懂了: https://mp.weixin.qq.com/s/39XgTTC2VUVGq0EIlpb3WA

• 数据库索引，为什么设计成这样: https://mp.weixin.qq.com/s/0x5T-wbAoNVHkKTT61lIUQ

• InnoDB并发为何如此高: https://mp.weixin.qq.com/s/fmzaIobOihKKZ7kyZQInTg

• order by: https://mp.weixin.qq.com/s/F2KkRnimpAUnQ4K8qaQJVg

• 联合索引: https://www.cnblogs.com/rjzheng/p/12557314.html

• 缓存: https://mp.weixin.qq.com/s/4oGRpNyD9ZhNvvJuvFOUXQ

  • 数据库、缓存双写一致性: https://www.jianshu.com/p/2936a5c65e6b

• MySQL备份: https://mp.weixin.qq.com/s/9lmuRJY1z87t1c9mAdYqdA

• MyISAM与InnoDB比较: https://segmentfault.com/a/1190000019263351

• mysql高可用方案: https://zhuanlan.zhihu.com/p/25960208

• mysql集群方式: https://zhuanlan.zhihu.com/p/25960208

容灾

• PXB热备份: https://mp.weixin.qq.com/s/HeLcuxBZr4oP_oraMjnIHQ

数据库中间件

• 拆分库
  • 什么时候引入数据库中间件: https://mp.weixin.qq.com/s/fGIXDxe6fIN2bhYbwP5g_A
  • 基因法分库: https://mp.weixin.qq.com/s/H6OENyLu6K7v3OJDWa5klw