Method for updating database hotspot data cache in real time

Abstract

The invention provides a method for updating hotspot data cache of a database in real time, which comprises the following steps of: configuring an independent monitoring thread for the database, monitoring the state of the database in real time, and issuing an update message to a message queue when the update operation of the database is monitored; the message processing program processes the update messages in the message queue one by one; and updating the hotspot cache by adopting the update message Infor. According to the method for updating the database hotspot data cache in real time, a monitoring thread for database change is added, when the database data is changed, if the database data is hotspot data, the hotspot cache can be updated in time, the consistency of the hotspot data in the database and the hotspot cache is guaranteed, and the reliability of the database is improved. The problem that cache information and database information are inconsistent temporarily is solved. In addition, non-hotspot data of the hotspot cache are cleared away in time, the cache amount is reduced, and therefore the hotspot cache space is released in time, and effective use of the hotspot cache is guaranteed.

Description

technical field [0001] The invention belongs to the technical field of computer information processing, and in particular relates to a method for real-time updating hotspot data cache of a database. Background technique [0002] The reading and writing methods of traditional databases and caches are as follows: during read operations: when the upper-layer application program is running, when data needs to be read, first determine whether there is target data to be read in the cache, and if so, directly read from the cache Target data; if not, put the target data in the database into the cache, and then read the target data from the cache. When writing: When data needs to be updated, only the relevant data in the database is updated; while the data in the cache is removed according to its life cycle. [0003] The above database and cache read and write methods have the following problems: For a certain data A, if it is in the cache, and the time in the cache has not reached ...

AI Technical Summary

Problems solved by technology

[0003] The above database and cache read and write methods have the following problems: For a certain data A, if it is in the cache, and the time in the cache has not reached its life cycle; at this time, the database performs an update operation on the data A, for example , delete data A

Therefore, there will be a problem of inconsistency between the database and the cache. In some scenarios, the inconsistency between the database and the cache is unacceptable. Causes the game to be delayed and offline, and an error occurs

Images