基于Socket的异地数据复制实现

实现异地分布数据库数据的一致性和同步性,一般都是通过数据库之间直接连接来实现数据的复制与更新,并且数据在网络中各节点的复制情况对用户是透明的。但在实际应用中,随着对数据安全性要求的提高,往往需要在网络、操作系统或者数据库之间采取一定的访问控制措施。针对以上情况,提出了一种基于Socket通信技术的异地数据复制方法,该方法通过定时扫描源数据库,筛选需要被同步的数据,然后利用Socket技术实现数据访问控制以及异地数据同步。

Connecting databases directly in different place are often used to realize data of distributed database consistency and synchronism.Data reproduction technology of DBMS can update and replicate data by network nodes which are transparent for users.However,in practical applications,with data security requirements improve,often needs to control access measures in the network,operating system or database.To solve the above problem,this paper describes a use of the socket commu- nications technology about data synchronization in different place.By scaning source database regularly,selecting data which needs to be synchronized,then achieving control of data access,as well as off-site data synchronization based on socket technology.