多点多跳的数据表实时备份方法  

Multi-point and multi-level real-time backup method for database table

作　　者：王玉稳[1] 刘晓洁[1] 李涛[1] 卢正添[1] 罗祖脉[1] 张丁[1] 

机构地区：[1]四川大学计算机学院,四川成都610065

出　　处：《计算机工程与设计》2008年第10期2665-2667,2670,共4页Computer Engineering and Design

基　　金：国家自然科学基金项目(60573130;60502011);国家863高技术研究发展计划基金项目(2006AA01z435);教育部新世纪优秀人才计划基金项目(NCET-04-0870);教育部博士点基金项目(20030610003)

摘　　要：设计并实现了一种多点多跳的数据表实时备份方法,该设计包括实时监控模块、通信模块和远程重放模块。实时监控模块负责监控主数据库的数据变化,并将截获的内容封装成重做记录。通信模块负责把重做记录发送给远程重放模块,通过数据加密、数据缓存及差错控制保证实时备份的安全性和数据一致性。远程重放模块解析并优化重做记录,完成重放操作。实验结果表明,该方法具有良好的性能。A multi-point and multi-level real-time backup method for database table is designed and implemented. It consists of several components including real-time monitor module, communication module and remote redo module. The real-time monitor module takes charge of monitoring the data changes on the local primary database server, and encapsulates the captured data into series of redo records. The communication module is responsible for sendingthe records to remote redo module. The security and data consistency of real-time backup is ensured by encrypting data, data cache and error detecting. The remote redo module redoes the operations by analyzing and optimizing the records. Experiment shows it has high performance.

关 键 词：实时 备份 容灾系统 大对象 多点多跳 

分 类 号：TP393.08[自动化与计算机技术—计算机应用技术] TP309.3[自动化与计算机技术—计算机科学与技术]