Cache asynchronous refreshing method and system and computer readable storage medium

Abstract

A cache asynchronous refreshing method comprises the following steps: detecting a refreshing log table of a database cache; when the database data is changed, according to the table name and the indexinformation, matching a record to be processed with an SQL feature table of the database cache, wherein the SQL feature table at least comprises SQL feature information used for maintaining a serviceapplication; when the record is matched with the SQL feature, setting the SQL feature state corresponding to the record to be in refresh; obtaining corresponding data from a database according to thetable name and primary key information in the refreshing log table, and brushing the data into the database cache; after data refreshing is finished, setting the SQL feature state corresponding to the record to be valid, and then deleting the corresponding record in the refreshing log table; and when the record is not matched with the SQL feature, deleting the corresponding record in the refreshing log table. The method has the high availability and high performance, and avoids a large amount of redundant data which is not accessed by the application in the cache.

Description

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

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