摘要： 数据同步是实现异地双活数据中心的关键技术,但现有远程数据库同步机制效率较低,并且不能满足异构数据库之间的同步要求。针对上述问题,设计一种新的远程数据库同步机制。分析应用程序操作数据库的过程,研究从数据库连接驱动中捕获SQL的方法,并提出一致性校验算法进行数据验证。实验结果表明,该机制能提高远程数据库同步效率,同时支持异构数据库同步,可为大数据时代多数据中心和灾备系统建设提供技术支持。
关键词:
数据同步,
SQL捕获,
一致性,
异地双活数据中心,
异构数据库,
Java数据库连接
Abstract: Data synchronization is the key technology for the implementation of distant double live data center.As current remote database synchronization mechanisms have low efficiency and there is no good solution for the synchronization of heterogeneous databases,this paper presents a new remote database synchronization mechanism.It analyzes the procedure of an application manipulating the database,researches the method of capturing SQL from the database connection driver,and designs a consistency algorithm for data verification.Experimental result shows that this mechanism can improve the efficiency of remote database synchronization and support the synchronization of heterogeneous databases,which provides technical support for the construction of multi-data center and disaster recovery system in the age of big data.
Key words:
data synchronization,
SQL capture,
consistency,
distant double live data center,
heterogeneous database,
Java Database Connectivity(JDBC)
中图分类号: