Method for achieving data caching in database synchronization process

Abstract

The invention discloses a method for achieving data caching in the database synchronization process. The method includes the insertion step and the consumption step. In the insertion step, memory space with a fixed length is developed in a memory and used for storing monitored source database synchronous data; a list is newly established in a database and used for storing the monitored source database synchronous data and newly-added attributes of the synchronous data. In the consumption step, when a data consumption request is received, reading is conducted on the memory space, if reading fails, retrieval is conducted on the list of the database, in the reading process, if no data exist in the memory space, the data are copied to the memory from the list of the database at the moment, and then reading is conducted on the memory. The pressure of the memory space is relieved through database synchronous recording, and the problem that a system breaks down due to the fact that the synchronous data are instantly and rapidly increased is solved; the synchronous data can be restored after the system is restarted.

Description

technical field [0001] The invention relates to the field of database data synchronization, mainly a method for constructing a synchronization data cache in a synchronization system, and in particular to a method for realizing data cache in database synchronization. Background technique [0002] Database data synchronization refers to an important technology to maintain the integrity and unity of data in different databases in distributed data storage. With the development of the Internet, the service scope of the network service system is getting larger and larger, the service load is getting heavier, and the service security requirements are getting higher and higher. The distributed database storage system or the master-slave mode database storage system has become the core of the network system. inevitable choice. In this mode, database synchronization technology emerges as the times require, which keeps data integrity and unity between different databases, and improves...

AI Technical Summary

Problems solved by technology

[0004] The traditional data synchronization cache technology adopts the method of independently opening and managing memory space, which meets the basic needs of data synchronization, but this method has the following defects: 1) When the system encounters a downtime or power failure, the system restarts After startup, the synchronization data cannot be recovered; 2) There is no mechanism to measure the accumulation of data in data synchronization and a feedback mechanism; 3) The memory space is limited, and when the cached data increases sharply, the system stability drops sharply

4) After the synchronization is completed, the synchronization data cannot be viewed and retrieved

Images