Distributed system cache data synchronous configuration method and apparatus

Abstract

The invention discloses a data cache simultaneous configuration method and a device in a distributed system, wherein, the method comprises the following steps: when a datasheet containing cached data changes on a server, the modification information of the datasheet is sent to each sub-server; the latest modification time of the datasheet is updated to the current time; a cached data update information table is enquired at a preset cycle starting time; when the latest modification time of the same data sheet is later than the last update time, the corresponding cached data is updated according to the latest modified datasheet ion the database, and the last update time in the cached data update information table is updated as the latest modification time; the datasheets in the database of each sub-server are updated according to the modification information, and the cached data on each sub-server is also updated through the same method. The invention is independent from the application system and can achieve synchronization update to the cached data in a distributed system, which is simple to be applied and can not easily make a mistake.

Description

technical field [0001] The invention relates to data cache technology, in particular to a method and device for synchronous configuration of cached data in a distributed system, a server and a distributed system. Background technique [0002] Data cache is a temporary container occupied by database data in memory. The temporary container contains a copy of database data in memory and is located between the database and the data access layer. When the application system needs to read database data, it first queries in the cache, which can avoid the performance overhead required for database calls. [0003] A good caching mechanism is particularly important in application systems that require frequent query operations on database data. Distributed cache allows multiple users of different hosts to access and modify the data at the same time, and can perform cache synchronization, which solves the limitation that shared memory can only be used on a single machine, and does not ...

AI Technical Summary

Problems solved by technology

However, at present, when SQL Server and Oracle database systems are deployed in a distributed manner, the synchronization of distributed data caches still cannot be achieved.

Therefore, the data cache used by SQL Server and Oracle database systems can only be used on a single machine, and the cached data cannot be modified during the normal operation of the system, and the distributed update of the data cache cannot be realized.

Images