DB2容灾技术探讨

Discussion on DB2 Disaster Recovery Technology

著名咨询公司麦肯锡曾经讲过:“数据,已经渗透到每一个行业和业务职能领域,成为重要的生产因素。”当今时代下,我们日常生活、学习、工作中每时每刻都在产生数据,比如说,日常通勤数据,通过公共交通方式出勤的有上下车刷卡记录,通过私家车出勤的有进出小区、单位的车辆进出数据,哪怕行人走在马路上,无处不在的摄像头也会记录下相关影像数据。又比如说,银行存款、理财账户、支付宝微信余额账户等数据,虽然现在多种多样的付款方式给日常生活带来了便捷,但是这类涉及到金钱的数据一旦丢失后果不堪设想。随着各行各业、各领域对数据依赖性的增强,保护数据安全也成为不可或缺的工作。数据库作为数据的重要存储介质,备份技术、容灾技术无疑是数据库中保护数据安全最常使用、较为成熟的技术。文章将介绍经典老牌数据库IBM DB2的容灾技术——HADR和DPROP。HADR即为High Availabilit y Disaster Recover y,是DB2数据库级别的灾备技术;DPROP即为DataPropagator,又名SQL Replication,它除了在数据库级别,也能在表之间甚至表中某几个字段之间实现数据的复制功能。文章将分别从HADR和DPROP实现容灾的原理、架构、搭建、使用以及两者之间的对比等方面展开介绍。

McKinsey,a famous consulting company,once said:"data has penetrated into every industry and business functional field and become an important production factor."In today's era,data are generated all the time in our daily life,study and work.For example,daily commuting data,card swiping records of getting on and off through public transportation,and vehicle access data of entering and leaving the community and units through private cars.Even if pedestrians walk on the road,ubiquitous cameras will record relevant image data.For example,be unbearable to contemplate the data of bank deposit,financial account,Alipay WeChat balance account,although various payment methods bring convenience to daily life now,but the data that involves money will lose the consequences.With the increasing dependence on data in all walks of life and fields,protecting data security has also become an indispensable work.As an important storage medium of data,database backup technology and disaster recovery technology are undoubtedly the most commonly used and mature technologies to protect data security in database.This paper will introduce the disaster recovery technology of IBM DB2,a classic old database-HADR and dprop.HADR is high availability disaster recovery,which is a DB2 database level disaster recovery technology;Dprop is data propagator,also known as SQL replication.It can replicate data between tables and even between some fields in the table in addition to the database level.This paper will introduce the principle,architecture,construction,use and comparison of HADR and dprop.