部署
1.1 centos yum安装mysql
https://blog.csdn.net/z13615480737/article/details/78906598
1.2 centos 编译安装mysql
https://www.cnblogs.com/piaoyang2087/articles/7908795.html
1.3 my.cnf关键配置项
https://yq.aliyun.com/articles/687911?spm=a2c4e.11163080.searchblog.62.4bc92ec1J2Dqlh
1.4 mysql 主从配置 & 半同步配置
https://yq.aliyun.com/articles/689732?spm=a2c4e.11163080.searchblog.9.54302ec1Wc2V6C
备份
2.1 XtraBackup完成对mysql全量、增量备份与恢复
https://yq.aliyun.com/articles/689691?spm=a2c4e.11163080.searchblog.9.79992ec1qds0Ul
2.2 xtrabackup 最佳实践
https://yq.aliyun.com/articles/673518?spm=a2c4e.11163080.searchblog.40.79992ec1vfYblo
2.3 xtrabackup原理
https://yq.aliyun.com/articles/544739?spm=a2c4e.11163080.searchblog.36.7aca2ec1NxzbnR
高可用
3.1 MHA高可用搭建
https://yq.aliyun.com/articles/576204?spm=a2c4e.11163080.searchblog.12.57fe2ec1d7meqZ
3.2 MGR搭建
https://yq.aliyun.com/articles/578598?spm=a2c4e.11163080.searchblog.119.64462ec1IFBU9Q
3.3 MGR添加节点
https://yq.aliyun.com/articles/253245?spm=a2c4e.11163080.searchblog.66.64462ec1WcpPLn
3.4 MGR复制原理
https://yq.aliyun.com/articles/223593?spm=a2c4e.11163080.searchblog.60.68cc2ec1Ckx1UB
3.5 数据库异地双活实践
https://yq.aliyun.com/articles/313844?spm=a2c4e.11163080.searchblog.65.33f62ec17az5P6