Research And Implementation Of Database Synchronization Service In Cloud Environment

Cloud Computing technology is the latest trend in IT development, cloud computing technology is widespread concerned by academia and industry. The impact of cloud computing technology has become more and more prominent, among which cloud storage is the most rapid development. Cloud Storage not only featured by its various service patterns, but also garante data security by data backup technology. The current trend is that database systems developed from miniaturization to large-scale ones and from centralized ones to distributed ones. How to synchronize data between databases has become a problem to many companies as data is stored on different nodes in the same network.In order to take advantages of cloud storage for data synchronization, this paper has done the following work:(1) Analyze existing cloud storage technology, database synchronization technology and other related technologies, especially the way database synchronization and synchronization strategies, and made a detail study of database trigger mechanism and the snapshot differential algorithms;(2) After analyzing the common methods and theories for synchronizing data between databases; this paper, based on Hadoop Distributed File System, proposed two data synchronization models:data synchronization model that based on trigger and timestamp, and the snapshot differential data synchronization model; this paper also gives a detail description of the different data capture algorithm. Those two data synchronization models only synchronize the different data, effectively reducing the time cost; We designed and implemented an algorithm based on the NWR model to ensure data consistency;(3) This paper proposed and implemented a "pluggable" synchronization system model, which is divided into two parts:the main application and the plug-in. The main application remains unchanged, all we need to do is to develop different plug-ins according to different database while synchronizeing data between databases, thus we can avoid many repeated development work;Based on the model, we designed and implemented the data synchronization system. Finally, we do some tests on this system in a laboratory environment. Those tests proved that the system works well, it is suitable for data synchronization between databases.