> For the complete documentation index, see [llms.txt](https://jack-37.gitbook.io/gossip/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://jack-37.gitbook.io/gossip/shu-ju-ku.md).

# 数据库

- [关于mysql的几件小事](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-mysql-de-ji-jian-xiao-shi.md)
- [(一)关于MySQL索引的几件小事](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-mysql-de-ji-jian-xiao-shi/guan-yu-mysql-suo-yin-de-ji-jian-xiao-shi.md)
- [(二)关于mysql事务的几件小事](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-mysql-de-ji-jian-xiao-shi/guan-yu-mysql-shi-wu-de-ji-jian-xiao-shi.md)
- [(三)数据库如何拆分](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-mysql-de-ji-jian-xiao-shi/fen-ku-fen-bu-de-ji-jian-xiao-shi-yi-shu-ju-ku-ru-he-chai-fen.md)
- [(四)如何进行分库分表的数据迁移](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-mysql-de-ji-jian-xiao-shi/fen-ku-fen-bu-de-ji-jian-xiao-shi-er-ru-he-jin-xing-fen-ku-fen-biao-de-shu-ju-qian-yi.md)
- [(五)可以动态扩容缩容的分库分表方案](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-mysql-de-ji-jian-xiao-shi/fen-ku-fen-bu-de-ji-jian-xiao-shi-san-ke-yi-dong-tai-kuo-rong-suo-rong-de-fen-ku-fen-biao-fang-an.md)
- [(六)分库分表的id主键生成](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-mysql-de-ji-jian-xiao-shi/fen-ku-fen-bu-de-ji-jian-xiao-shi-si-fen-ku-fen-biao-de-id-zhu-jian-sheng-cheng.md)
- [(七)MYSQL读写分离](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-mysql-de-ji-jian-xiao-shi/fen-ku-fen-bu-de-ji-jian-xiao-shi-wu-mysql-du-xie-fen-li.md)
- [关于MQ的几件小事](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-mq-de-ji-jian-xiao-shi.md)
- [(一)消息队列的用途、优缺点、技术选型](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-mq-de-ji-jian-xiao-shi/yi-xiao-xi-dui-lie-de-yong-tu-you-que-dian-ji-shu-xuan-xing.md)
- [(二)如何保证消息队列的高可用](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-mq-de-ji-jian-xiao-shi/er-ru-he-bao-zheng-xiao-xi-dui-lie-de-gao-ke-yong.md)
- [(三)如何保证消息不重复消费](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-mq-de-ji-jian-xiao-shi/san-ru-he-bao-zheng-xiao-xi-bu-chong-fu-xiao-fei.md)
- [(四)如何保证消息不丢失](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-mq-de-ji-jian-xiao-shi/si-ru-he-bao-zheng-xiao-xi-bu-diu-shi.md)
- [(五)如何保证消息按顺序执行](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-mq-de-ji-jian-xiao-shi/wu-ru-he-bao-zheng-xiao-xi-an-shun-xu-zhi-xing.md)
- [(六)消息积压在消息队列里怎么办](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-mq-de-ji-jian-xiao-shi/liu-xiao-xi-ji-ya-zai-xiao-xi-dui-lie-li-zen-me-ban.md)
- [(七)如果让你设计一个MQ，你怎么设计](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-mq-de-ji-jian-xiao-shi/qi-ru-guo-rang-ni-she-ji-yi-ge-mq-ni-zen-me-she-ji.md)
- [关于redis的几件小事](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-redis-de-ji-jian-xiao-shi.md)
- [(一)redis的使用目的与问题](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-redis-de-ji-jian-xiao-shi/yi-redis-de-shi-yong-mu-di-yu-wen-ti.md)
- [(二)redis线程模型](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-redis-de-ji-jian-xiao-shi/er-redis-xian-cheng-mo-xing.md)
- [(三)redis的数据类型与使用场景](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-redis-de-ji-jian-xiao-shi/san-redis-de-shu-ju-lei-xing-yu-shi-yong-chang-jing.md)
- [(四)redis的过期策略以及内存淘汰机制](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-redis-de-ji-jian-xiao-shi/si-redis-de-guo-qi-ce-le-yi-ji-nei-cun-tao-tai-ji-zhi.md)
- [(五)redis保证高并发以及高可用](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-redis-de-ji-jian-xiao-shi/wu-redis-bao-zheng-gao-bing-fa-yi-ji-gao-ke-yong.md)
- [(六)redis的持久化](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-redis-de-ji-jian-xiao-shi/liu-redis-de-chi-jiu-hua.md)
- [(七)redis缓存雪崩与穿透](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-redis-de-ji-jian-xiao-shi/qi-redis-huan-cun-xue-beng-yu-chuan-tou.md)
- [(八)缓存与数据库双写时的数据一致性](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-redis-de-ji-jian-xiao-shi/ba-huan-cun-yu-shu-ju-ku-shuang-xie-shi-de-shu-ju-yi-zhi-xing.md)
- [(九)redis的并发竞争问题](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-redis-de-ji-jian-xiao-shi/jiu-redis-de-bing-fa-jing-zheng-wen-ti.md)
- [(十)redis-cluster模式](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-redis-de-ji-jian-xiao-shi/shi-rediscluster-mo-shi.md)
- [(十一)Redis缓存保持数据类型.md](https://jack-37.gitbook.io/gossip/shu-ju-ku/guan-yu-redis-de-ji-jian-xiao-shi/shi-yi-redis-huan-cun-bao-chi-shu-ju-lei-xing--md.md)