Method and device for caching multi-instance data

Abstract

The invention discloses a method and a device for caching multi-instance data. The method comprises the following steps: firstly, establishing and maintaining an active instance list in a memory of a server, and performing updating maintenance only on cache data of all instances existing in the active instance list; when a data request sent by a certain instance is received, if the instance is not found in the active instance list, adding the ID (identity) of the instance to the active instance list, and setting corresponding time T as the time of the current server; moreover, querying the data of the instance from a database, and then, returning the data of the instance to a client which corresponds to the instance. According to the method, not only can the cache data not high in usage rate be prevented from occupying the memory space but also the overhead of a CPU (central processing unit) and unnecessary database connection can be reduced to the greatest extent, so that the pressure on the database is reduced.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a method and device for caching multi-instance data. Background technique [0002] At present, in the real-time data monitoring system, the client needs to query the server-side data frequently. The usual method is that the client sends out query conditions, and the server queries the database after receiving the query conditions, returns the data results and passes them to the client. A server-side program serves multiple instances, and each instance has its own independent database. When multiple instances are queried concurrently, on the one hand, data is continuously written into the database table, which may cause read-write interlocking to compete for resources. On the one hand, multiple instances need to be provided with different data in an application. If the database is queried every time the client requests, the pressure on both the database and the application...

AI Technical Summary

Problems solved by technology

A server-side program serves multiple instances, and each instance has its own independent database. When multiple instances are queried concurrently, on the one hand, data is continuously written into the database table, which may cause read-write interlocking to compete for resources. On the one hand, it is necessary to provide different data to multiple instances in an application program. If the database is queried every time the client requests, the pressure on both the database and the application program will be very high.

[0003] In the existing technical solution, the server regularly updates the cache required by each instance, and the client directly reads the cached data for each request. In the above solution, when there are too many instances, the cached data in the server is also very special. Many, which causes server-side cache pressure and unnecessary database connections

Images