Cache asynchronous refresh method, system and computer-readable storage medium

Abstract

A cache asynchronous refresh method, comprising: detecting a refresh log table of a database cache; when database data is changed, according to the table name and index information, matching the record to be processed with the SQL feature table of the database cache, Wherein the SQL feature table includes at least the SQL feature information used for maintaining business applications; when the record matches the SQL feature, the SQL feature state corresponding to the record is set as being refreshed; according to the table name and primary key information in the refresh log table Obtain the corresponding data from the database, and flush the data into the database cache; when the data refresh is completed, set the SQL feature state corresponding to the record to take effect, and then delete the corresponding record in the refresh log table; If the record does not match the SQL feature, delete the corresponding record in the refresh log table. This method has high availability, high performance, and avoids the existence of a large number of redundant data in the cache that the application does not access.

Description

technical field [0001] The invention belongs to the technical field of database cache, and in particular relates to a cache asynchronous refresh method, device, electronic device and computer-readable storage medium. Background technique [0002] Entering the era of big data, with the exponential increase in the amount of user data, the scale of business applications also increases, and the traditional high-performance single-host system gradually evolves into a distributed system. With the change of the business application deployment architecture, the database resources that the application depends on must also be deployed separately from the application host. When a large number of applications access the database remotely and frequently, from the perspective of the application side, the high network latency occupied by the remote access will seriously reduce the processing efficiency of the system; from the perspective of the database, with the high concurrent operation ...

AI Technical Summary

Problems solved by technology

On the one hand, this solution cannot guarantee that the data to be refreshed is the data that already exists in the cache, that is, there are a large number of invalid operations in data refresh; on the other hand, the application cannot quickly check whether the cache data used is being refreshed, that is, the application accesses the cache validity cannot be guaranteed

[0006] In the prior art, the cache data change refresh method usually refreshes the data in the dimension of the table, but once some data in a table changes frequently (the rest of the data remains unchanged), the table cannot actually use the cache, which seriously reduces the speed. The availability of the cache; in addition, this method loads the full table data when the cache is started, avoiding a large number of invalid operations in data refresh, but also introduces a large amount of redundant data, which is not accessed or never accessed by the application Will access, actually waste a lot of host memory

Images