跨域双活数据库事务处理的动态优化技术  

Dynamic optimization technology for cross-domain dual-active database transaction processing

作　　者：吴昊亮 危建朋 崔欣宁 张先伟 陈丽 谷峪 WU Haoliang;WEI Jianpeng;CUI Xinning;ZHANG Xianwei;CHEN Li;GU Yu(GanSu Power Exchange Center,Lanzhou Gansu 730050,China;School of Computer Science and Engineering,Northeastern University,Shenyang Liaoning 110169,China;State Grid Gansu Electric Power Company,Lanzhou Gansu 730050,China)

机构地区：[1]甘肃电力交易中心有限公司,兰州730050 [2]东北大学计算机科学与工程学院,沈阳110169 [3]国网甘肃省电力公司,兰州730050

出　　处：《计算机应用》2024年第S01期83-88,共6页journal of Computer Applications

基　　金：国家自然科学基金资助项目(61872070)。

摘　　要：跨域双活数据库能为企业提供灾备能力,但传统的灾备节点仅提供备份功能,无法为主服务器分担读写负载,造成了系统瓶颈。如今分布式数据库领域的数据复制架构、数据库节点间共识协议等,为异地双活数据库的发展提供了理论基础。在跨域双活的场景下提出一种基于多主架构的确定性事务处理方案,在原有的承担灾备的基础上提供客观的负载均衡能力。在该架构中,使用确定性乐观并发控制协议保证跨域双活场景下事务执行的正确性,同时应用异步冲突检测优化与动态批大小设置调整系统负载以适应网络环境的变化。在TPC-C基准测试中验证架构的原型实现系统的性能,在网络利用率与事务吞吐量上均取得了较好的效果,与原始分片方案相比事务处理性能提升18%~23%,网络延迟下降了26%~31%。Cross-domain dual-active databases can provide disaster recovery capabilities for enterprises,but traditional disaster recovery nodes only provide backup functions and cannot share the read-write load for the main server,causing a system bottleneck.The data replication architecture and consensus protocols in the field of distributed databases now provide a theoretical basis for the development of cross-domain dual-active databases.A deterministic transaction processing solution based on a multi-master architecture in the cross-domain active-active scenario was proposed,providing objective load balancing capability on the basis of disaster recovery.In this architecture,a deterministic optimistic concurrency control protocol was used to ensure the correctness of transaction execution in the cross-domain dual-active scenario,while applying asynchronous conflict detection optimization and dynamic batch size setting to adjust system load to adapt to changes in the network environment.The prototype implementation system’s performance of the architecture was validated in TPC-C benchmark,and the prototype system achieved good results in network utilization and transaction throughput.Compared to the original sharding scheme,transaction performance was improved by 18%to 23%,and network latency was decreased by 26%to 31%.

关 键 词：跨域双活数据库 分布式数据库 事务处理 数据复制 

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