本文已被：浏览 1711次 下载 3380次
Received:July 08, 2011 Revised:August 17, 2011
Received:July 08, 2011 Revised:August 17, 2011
中文摘要: 设计并实现了基于DB2 大型数据库的实时复制软件。采用模块化设计,本软件主要包括5 个模块：客户端,服务器端,全同步模块,增量同步模块,加载模块。这5 个模块相互协调,由客户端发出请求,服务端统一调度。在实现该软件的过程中,使用了实时分析数据库日志的方法来抓取源端数据库的变化。本软件没有调用任何DB2 数据库的备份接口,完全从底层自主研发。所以在功能和效率上比一般产品要优良。在操作系统为LINUX,CPU 为酷睿2.4GHz,内存为2GB 的测试环境下,本软件全同步,加载,增量同步运行效果良好。
Abstract:This paper presents the process for research and implementation a real-time duplicate software in DB2 database. This software used the modular design, and has 5 major modules: Client, Server, Full synchronizing, Increase synchronizing, Load. While the software running, the 5 modules coherent on with another. The client call the server, and the server schedules all task. In the process of the implementation, we grap the database's log real-time to gain the change. This software doesn't use any DB2 database's backup interface, so it well done in the function and efficiency. The test environment is OS:LINUX, CPU:Core 2.4 GHz ,Memory: 2 GB. Under such a test environ-ment, this software worked well.
keywords: DB2database tolerant backup real-time duplicate log analysis
文章编号： 中图分类号： 文献标志码：
基金项目:安徽省教育厅自然科学基金(2005KJ004ZD)
引用文本：
屈志毅,王涛,李建旭.DB2 大型数据库容灾备份实时复制系统.计算机系统应用,2012,21(3):198-201
QU Zhi-Yi,WANG Tao,LI Jian-Xu.Real-time Duplicate Software in DB2 Large Database.COMPUTER SYSTEMS APPLICATIONS,2012,21(3):198-201
屈志毅,王涛,李建旭.DB2 大型数据库容灾备份实时复制系统.计算机系统应用,2012,21(3):198-201
QU Zhi-Yi,WANG Tao,LI Jian-Xu.Real-time Duplicate Software in DB2 Large Database.COMPUTER SYSTEMS APPLICATIONS,2012,21(3):198-201
