【摘要】 跨域双活数据库能为企业提供灾备能力，但传统的灾备节点仅提供备份功能，无法为主服务器分担读写负载，造成了系统瓶颈。如今分布式数据库领域的数据复制架构、数据库节点间共识协议等，为异地双活数据库的发展提供了理论基础。在跨域双活的场景下提出一种基于多主架构的确定性事务处理方案，在原有的承担灾备的基础上提供客观的负载均衡能力。在该架构中，使用确定性乐观并发控制协议保证跨域双活场景下事务执行的正确性，同时应用异步冲突检测优化与动态批大小设置调整系统负载以适应网络环境的变化。在TPC-C基准测试中验证架构的原型实现系统的性能，在网络利用率与事务吞吐量上均取得了较好的效果，与原始分片方案相比事务处理性能提升18%～23%，网络延迟下降了26%～31%。更多还原

【Abstract】 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%.更多还原