Research On Remote Data Replication Method Among Multi-data Center

The development of Cloud Computing and Big Data is very quickly and Long Distance Multi-data centers have become the trend of the traditional large data centers.Different from the traditional disaster backup data centers,long distance data centers not only have the disaster recovery capacities,but also have the role of real-time business diversion.Therefore,it puts forward the requirement to build long distance multi-data centers in the construction of a new generation of civil aviation passenger information service system.The key problem of which is to achieve the remote database synchronization mechanism,and based on which the paper conducts the research.The operating modes of typical multi-data centers was firstly investigated,such as a Internet company and a ticket center.The operating mode of multi-data centers which has“one live one backup” data centers in a city,“two live one backup” data centers in two cities,distant double live data centers and long distance multi-data centers is proposed.This mode combines the respective business characteristics,disaster recovery capabilities,consistency level,the role of each data center and how to work with other data centers.Secondly,this paper compares the characteristics and applicable scenarios of these four modes,and establishes the monster-slave synchronous distant double live data centers operating mode and the peer-to-peer synchronous long distance multi-data centers operating mode by combining the different business requirements of the civil aviation passenger service information system.The current remote database synchronization method is inefficient and doesn't support well heterogeneous databases synchronization,so a new remote database synchronization mechanism(a remote database synchronization mechanism by capturing SQL from the database connectivity)is put forward.The method of capturing SQL from the database connectivity is researched,and according to the case that the data may be inconsistent,the consistency algorithm is proposed.Finally,this paper simulates the delay of the network by waiting interval of a thread,the test application program is written,and a large number of synchronous experiments between the isomorphic and heterogeneous databases are done.The experimental results show that the mechanism can improve the synchronization efficiency of the remote database and can support heterogeneous database synchronization,which provides technical support for the construction of the data centers and disaster recovery systems as the time of Big Data.