Distributed database SQL auditing and intercepting method and device based on agent mode

Abstract

The invention discloses a distributed database SQL auditing and intercepting method and device based on an agent mode, and the device comprises an auditing agent unit, a statement auditing and judging unit, an agent statement intercepting unit, an agent statement transparent transmission unit and the like. The above units are subjected to product fusion, and finally, when a user can execute distributed database operation through a common database client, statements which do not conform to auditing specifications cannot be executed in a target database, and illegal content is fed back according to a database protocol. If the statement meets the standard, the statement is not intercepted, the proxy node transmits the statement to the target distributed database in a transparent mode and feeds back the statement execution result of the client side, and the whole process is transparent for the user. According to the method, zero embedding and automatic operation and maintenance are achieved, the use convenience of a user can be greatly improved, the software project SQL statement auditing efficiency is improved, the situation that the user cannot execute violation statements in the target database is fundamentally limited, and therefore safe and stable operation of the distributed database is guaranteed.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a distributed database SQL audit interception method and device based on a proxy mode. Background technique [0002] As enterprises promote digital transformation, more and more enterprises are shifting from traditional architectures to distributed cloud architectures. For access to large-scale multi-node distributed databases, irregular database operations can easily lead to operational errors, transaction response timeouts, and database failures. Faults and other issues directly affect the availability of the entire application. In order to reduce the above adverse effects, before the SQL statement is executed in the distributed database, it is necessary to review the standardization of the SQL statement, and timely intercept the statement with poor execution efficiency or irregularity. The current common database audit SQL technology is an audit mode based on work orders, c...

AI Technical Summary

Problems solved by technology

The current common database audit SQL technology is an audit mode based on work orders, custom execution commands, and custom program interfaces, and is mainly aimed at non-distributed databases. On the one hand, this technical mode is more suitable for a small number of databases. Operation, when encountering large-volume and frequent data operations, it will expose the short version of its operational availability, which cannot meet the needs of high-frequency interaction scenarios, and customize the interaction mode, resulting in users needing to switch frequently or unable to use common database clients On the other hand, based on the original audit mode, the efficiency is low. Taking the most commonly used inception as an example, each statement needs to establish a short audit connection, which increases the database connection overhead and affects the database audit efficiency.

Images