Database access management method and system, electronic equipment and storage medium

Abstract

The invention provides a database access management method and system, electronic equipment and a storage medium, which are used for solving the problem that database access cannot be monitored in a unified manner. The access management method is executed by a proxy service and comprises the following steps: receiving an access request initiated by an application, and analyzing a key carried by the access request; transmitting the access request carrying the configured key to a database, and returning response data of the database; establishing a key value set by taking each key as an index; monitoring the key value set of each key, obtaining a key which is not configured with expiration time and has access interval time exceeding a first interval threshold, and adding the key to a deletion queue; and according to the sequence of the deletion queue, sequentially marking the keys of which the access interval time exceeds a second interval threshold value as expired keys, and sending a deletion request carrying each expired key to the database. According to the invention, unified monitoring of database access by each application is realized through access interaction of the proxy service proxy application and the database.

Description

technical field [0001] The present application relates to the technical field of data processing, in particular, to a database access management method, system, electronic equipment and storage medium. Background technique [0002] Redis is a high-performance non-relational Key-Value (key-value) database, which can act as a cache container in the system, reduce access to the database, ensure system stability, and improve system response time. Thousands of requests. [0003] The performance of Redis is very high, but there are often problems in its use. For example, if the expiration time of the key is not set, the key will occupy memory for a long time and cause waste; use very performance-consuming commands, such as deleting a large key; the name of the key is arbitrary, resulting in an error After the problem, the corresponding responsible person cannot be found, and the problem cannot be dealt with in the first time, etc. [0004] In response to these problems, some Red...

AI Technical Summary

Problems solved by technology

[0005] 1. Each application needs to be configured separately, which not only takes a long time and is inefficient, but also cannot be monitored uniformly. When there is a problem with Redis, it is difficult to quickly locate it;

[0006] 2. It is impossible to monitor whether the application is configured with a usage monitoring scheme. When some applications that are not configured with a usage monitoring scheme have problems after they go online, it is easy to affect other applications associated with Redis, and the stability is poor;

[0007] 3. Some applications configure their usage monitoring scheme to use long-time commands at will, which greatly affects other applications that share the same Redis;

[0008] 4. Some keys without an expiration time occupy Redis memory, but only memory growth can be found at the Redis level, and it is impossible to locate the memory growth caused by which application system

Images