Mysql快速全同步复制技术的设计和应用  

Design and Application of Mysql Fast Full Synchronization Replication Technology

作　　者：吴振海 何格新 WU Zhenhai;HE Gexin(School of Mathematics,Southeast University,Nanjing 211189,China;Shangxuan(Shenzhen)Software Technology Co.,Ltd,Shenzhen 518109,China)

机构地区：[1]东南大学数学学院,南京211189 [2]尚选(深圳)软件技术有限公司,深圳518028

出　　处：《湖南工程学院学报（自然科学版）》2023年第2期38-44,66,共8页Journal of Hunan Institute of Engineering(Natural Science Edition)

摘　　要：Mysql半同步复制技术在高性能的数据管理中被广泛采用,但它在可靠性方面却存在不足.本文对半同步复制技术进行优化,提出了一种快速全同步复制技术,通过对半同步数据复制过程中的事务流程设置、线程资源合理应用、批量日志应用等技术手段,在保证数据可靠性的基础上降低复制过程中的性能损失,实现了快速的全同步复制.测试结果表明,快速全同步复制技术可以在性能、可靠性和一致性方面做到很好的均衡,有效提高了Mysql存储集群的业务承载能力.Mysql semi-synchronous replication technology is widely used in high performance data management,but it has some shortcomings in reliability.In this paper,the semi-synchronous replication technology is optimized,and a fast fully synchronous replication technology is proposed.Through the transaction process setting,rational application of thread resources,batch log application and other technical means in the process of semi-synchronous data replication,the performance loss in the process of replication is reduced on the basis of ensuring data reliability,and the fast fully synchronous replication is realized.The test results show that the fast fully synchronous replication technology can achieve a good balance in performance,reliability and consistency,and effectively improve the service carrying capacity of the Mysql storage cluster.

关 键 词：MYSQL 异步复制 半同步复制 全同步复制 

分 类 号：TP311.131[自动化与计算机技术—计算机软件与理论]