CN116303363A - Multi-node-based database maintenance processing method and device - Google Patents
Multi-node-based database maintenance processing method and device Download PDFInfo
- Publication number
- CN116303363A CN116303363A CN202310293423.6A CN202310293423A CN116303363A CN 116303363 A CN116303363 A CN 116303363A CN 202310293423 A CN202310293423 A CN 202310293423A CN 116303363 A CN116303363 A CN 116303363A
- Authority
- CN
- China
- Prior art keywords
- database
- node
- nodes
- service
- processing
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000012423 maintenance Methods 0.000 title claims abstract description 75
- 238000003672 processing method Methods 0.000 title claims abstract description 9
- 238000012545 processing Methods 0.000 claims abstract description 64
- 238000000034 method Methods 0.000 claims abstract description 24
- 238000012550 audit Methods 0.000 claims abstract description 19
- 238000000586 desensitisation Methods 0.000 claims abstract description 18
- 238000007726 management method Methods 0.000 claims description 43
- 230000004044 response Effects 0.000 claims description 14
- 238000005516 engineering process Methods 0.000 abstract description 7
- 238000010586 diagram Methods 0.000 description 5
- 230000008569 process Effects 0.000 description 4
- 238000004590 computer program Methods 0.000 description 3
- 230000006870 function Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000005856 abnormality Effects 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000003247 decreasing effect Effects 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/50—Allocation of resources, e.g. of the central processing unit [CPU]
- G06F9/5005—Allocation of resources, e.g. of the central processing unit [CPU] to service a request
- G06F9/5027—Allocation of resources, e.g. of the central processing unit [CPU] to service a request the resource being a machine, e.g. CPUs, Servers, Terminals
- G06F9/505—Allocation of resources, e.g. of the central processing unit [CPU] to service a request the resource being a machine, e.g. CPUs, Servers, Terminals considering the load
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/50—Allocation of resources, e.g. of the central processing unit [CPU]
- G06F9/5061—Partitioning or combining of resources
- G06F9/5072—Grid computing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application discloses a database maintenance processing method and device based on multiple nodes, wherein the method comprises the following steps: receiving a database processing message; obtaining a plurality of nodes configured for the database, wherein each node is configured with a database maintenance service, and the database maintenance service comprises at least one of the following: database agent, database audit, database data desensitization, database security protection, wherein the same database maintenance service is configured in the plurality of nodes; determining a node from the plurality of nodes; and sending the database processing message to the determined node. The method and the device solve the problem that the database access is affected due to the fact that the workload of the database maintenance service of a single-machine version possibly exists in the related technology is relatively large, so that the stability of the database maintenance service is improved, and the safety of the database is further guaranteed.
Description
Technical Field
The present application relates to the field of databases, and in particular, to a method and apparatus for maintaining and processing a database based on multiple nodes.
Background
With the development of internet technology, more and more software products have been transferred onto networks and provided with services to users through the networks. Services provided to users over a network can generate large amounts of data that can be stored in a database. Therefore, the database is now the basis of network services, and once the database is in a problem, the database has a great influence on the network services, even the normal operation of the network services is affected, and the loss is caused to users.
In order to secure the use of databases, database maintenance services are used in the related art, which include services such as database auditing, a firewall provided for the database (for security protection of the database), database encryption, and data desensitization of the database data, which are provided to users in the form of a standalone version in the related art.
Fig. 1 is a schematic diagram of a single-node maintenance database according to the related art, and as shown in fig. 1, a database maintenance service generally uses one computer, and then the database maintenance service is installed on the computer (the computer is also referred to as a node). After a user initiates a database access request, the access request may first go through a database maintenance service, for example, the database maintenance service is configured to copy a copy of the database access request and send the copy to an audit service, where the audit service audits the database access request; for another example, the database maintenance service user may determine whether the access request is legitimate, should be intercepted, etc., i.e., the database is secured. After processing by the database maintenance service, the access request is sent to the database for processing. After the database processes the access request, an access result may be a data set returned by the database, and the access result may also be sent to a database maintenance service first, for example, the database maintenance service performs data desensitization on the data set in the access result, and then the database maintenance service sends the processed data set to the user.
In the scenario shown in fig. 1, the single-machine version database maintenance service takes on a large amount of database maintenance work, and if the data in the database maintained by the single-machine version database maintenance service is relatively large and the access request is relatively large, the single-machine version database maintenance service can be relatively large in load, the access efficiency of the database is affected, and even the stopping of the database maintenance service can be caused, so that the database is hidden safely.
Disclosure of Invention
The embodiment of the application provides a database maintenance processing method and device based on multiple nodes, which at least solve the problem that the database access is influenced due to the fact that the workload of a single-machine version database maintenance service possibly exists in the related technology is relatively large.
According to one aspect of the present application, there is provided a database maintenance processing method based on multiple nodes, including: receiving a database processing message, wherein the database processing request comprises a database access request message for accessing the database and/or a response message carrying a result, and the result is returned by the database in response to the database access request message; obtaining a plurality of nodes configured for the database, wherein each node is configured with a database maintenance service, and the database maintenance service comprises at least one of the following: database agent, database audit, database data desensitization, database security protection, wherein the same database maintenance service is configured in the plurality of nodes; determining a node from the plurality of nodes; and sending the database processing message to the determined node.
Further, determining a node from the plurality of nodes comprises: acquiring the processing load of each node in the plurality of nodes; selecting one node with the minimum processing load from the plurality of nodes as one node determined from the plurality of nodes; or, according to the weight of each node in the plurality of nodes, wherein the weight is used for indicating the ratio of the number of database processing messages processed by the node in the plurality of nodes to the total number of database processing messages received by the plurality of nodes; the one node is determined according to the weight of each node and the database processing message which is allocated to each node.
Further, the plurality of nodes configured for the database are all in the same domain, wherein the plurality of nodes in the same domain all monitor the same network port service, and the nodes in different domains monitor different network port services.
Further, the plurality of nodes are managed by the management node, and the management node is used for acquiring the running states of the plurality of nodes managed by the management node.
According to another aspect of the present application, there is also provided a database maintenance processing apparatus based on multiple nodes, including: the receiving module is used for receiving a database processing message, wherein the database processing request comprises a database access request message for accessing the database and/or a response message carrying a result, and the result is returned by the database in response to the database access request message; the acquisition module is used for acquiring a plurality of nodes configured for the database, wherein each node is configured with a database maintenance service, and the database maintenance service comprises at least one of the following: database agent, database audit, database data desensitization, database security protection, wherein the same database maintenance service is configured in the plurality of nodes; a determining module for determining a node from the plurality of nodes; and the sending module is used for sending the database processing message to the determined node.
Further, the determining module is configured to: acquiring the processing load of each node in the plurality of nodes; selecting one node with the minimum processing load from the plurality of nodes as one node determined from the plurality of nodes; or, according to the weight of each node in the plurality of nodes, wherein the weight is used for indicating the ratio of the number of database processing messages processed by the node in the plurality of nodes to the total number of database processing messages received by the plurality of nodes; the one node is determined according to the weight of each node and the database processing message which is allocated to each node.
Further, the plurality of nodes configured for the database are all in the same domain, wherein the plurality of nodes in the same domain all monitor the same network port service, and the nodes in different domains monitor different network port services.
Further, the plurality of nodes are managed by the management node, and the management node is used for acquiring the running states of the plurality of nodes managed by the management node.
According to another aspect of the present application, there is also provided an electronic device including a memory and a processor; wherein the memory is configured to store one or more computer instructions, wherein the one or more computer instructions are executed by the processor to perform the method steps described above.
According to another aspect of the present application, there is also provided a readable storage medium having stored thereon computer instructions which when executed by a processor perform the above-mentioned method steps.
In the embodiment of the application, the method comprises the steps of receiving a database processing message, wherein a database processing request comprises a database access request message for accessing the database and/or a response message carrying a result, and the result is returned by the database in response to the database access request message; obtaining a plurality of nodes configured for the database, wherein each node is configured with a database maintenance service, and the database maintenance service comprises at least one of the following: database agent, database audit, database data desensitization, database security protection, wherein the same database maintenance service is configured in the plurality of nodes; determining a node from the plurality of nodes; and sending the database processing message to the determined node. The method and the device solve the problem that the database access is affected due to the fact that the workload of the database maintenance service of a single-machine version possibly exists in the related technology is relatively large, so that the stability of the database maintenance service is improved, and the safety of the database is further guaranteed.
Drawings
The accompanying drawings, which are included to provide a further understanding of the application, illustrate and explain the application and are not to be construed as limiting the application. In the drawings:
FIG. 1 is a schematic diagram of a single node maintenance database according to the related art;
FIG. 2 is a flow chart of a multi-node based database maintenance processing method according to an embodiment of the present application; the method comprises the steps of,
FIG. 3 is a system diagram of a multi-node maintenance database according to an embodiment of the present application.
Detailed Description
It should be noted that, in the case of no conflict, the embodiments and features in the embodiments may be combined with each other. The present application will be described in detail below with reference to the accompanying drawings in conjunction with embodiments.
It should be noted that the steps illustrated in the flowcharts of the figures may be performed in a computer system such as a set of computer executable instructions, and that although a logical order is illustrated in the flowcharts, in some cases the steps illustrated or described may be performed in an order other than that illustrated herein.
In the following embodiments, a database maintenance service is referred to, and the database maintenance service may include at least one of the following: database auditing, database data desensitization, database security protection (which may also be referred to as a firewall), database encryption and decryption services, etc., database agents. The database audit is used for auditing SQL sentences involved in the access request for accessing the database so as to determine whether the SQL sentences have risks or not; data desensitization is used for desensitizing sensitive data, for example, replacing a few numbers in an identity card number in user information with a number, etc.; the safety protection of the database is used for judging whether an access request to the database brings risk to the database and processing the access request; the database encryption and decryption service is used for providing encryption and decryption service of data for part or all of the data in the database; the database agent is used for processing the access request of the database and then transmitting the access request to the database.
As shown in fig. 1, services such as database auditing, database firewall, and database desensitization may be installed on a node (also referred to as a business node or service node, a node may be understood to be a computer or a virtual machine). For example, if database a requires a database audit and database desensitization service, a node may be configured to run the services such as database audit and database desensitization on the node at the same time, and if the node receives a large number of database access requests, the load of the database audit and database desensitization service on the node may be large, so that an abnormality occurs, and the use of the database is affected. For another example, if database a requires a database audit and database desensitization service, a node may be configured to run a database proxy and a database desensitization service, and then a node may be configured to perform the database audit, where the database proxy may send a database access request to be audited to the database audit service, where the pressure of the database maintenance service can be reduced to some extent, but problems may still occur when the database access request is relatively large.
In order to solve the above-mentioned problems, in the following embodiments, a multi-node-based database maintenance processing method is provided, and fig. 2 is a flowchart of the multi-node-based database maintenance processing method according to an embodiment of the present application, as shown in fig. 2, and the steps involved in the method in fig. 2 are described below.
Step S202, a database processing message is received, wherein the database processing request comprises a database access request message for accessing the database and/or a response message carrying a result returned by the database in response to the database access request message.
Step S204, obtaining a plurality of nodes configured for the database, where each node is configured with a database maintenance service, and the database maintenance service includes at least one of the following: database agent, database audit, database data desensitization, database security protection, wherein the same database maintenance service is configured in the plurality of nodes.
Step S206, determining a node from the plurality of nodes.
There are a variety of ways to determine the nodes in this step, for example, to obtain the processing load of each of the plurality of nodes; selecting one node with the minimum processing load from the plurality of nodes as one node determined from the plurality of nodes; for another example, the weight of each of the plurality of nodes may be based on a ratio of a number of database processing messages processed by the node in the plurality of nodes to a total number of database processing messages received by the plurality of nodes; the one node is determined according to the weight of each node and the database processing message which is allocated to each node.
And step S208, the database processing message is sent to the determined node.
In the above steps, a plurality of nodes for providing database maintenance service are configured for the database, the influence of the arrival of the disconnection of a certain node can be prevented through the plurality of nodes, and the pressure of each node can be relieved through load balancing, so that the problem that the database access is influenced due to the fact that the workload of a single-machine version database maintenance service possibly exists in the related technology is relatively large is solved through the above steps, the stability of the database maintenance service is improved, and the safety of the database is further guaranteed.
In an alternative embodiment, a domain concept may be introduced, that is, a plurality of nodes configured for the database are all in the same domain, where a plurality of nodes in the same domain all monitor the same network port service, and nodes in different domains monitor different network port services.
In order to manage the plurality of nodes, a management node may be further provided, where the plurality of nodes are managed by the management node, and the management node is configured to obtain an operation state of the plurality of nodes managed by the management node. The management node is described below in connection with an alternative embodiment. Fig. 3 is a schematic diagram of a system for maintaining a database by multiple nodes according to an embodiment of the present application, and as shown in fig. 3, a management node, a service node 1, a service node 2, a service node 3, and a service node 4 are provided, where the management node manages the service node 1, the service node 2, the service node 3, and the service node 4. It may provide a WEB service for the management node, where the WEB service is used to provide a WEB page that can be accessed by a user, and in this WEB page, the state of a service node managed by the management node, for example, the use condition of a computing resource of the service node, the service processing condition of the service node, etc., may be viewed, and in this WEB page, each service node may be configured, for example, weights of different service nodes in the same domain (for example, weights of service node 1 and service node 2) may be configured, so that the load balancing module may allocate services to different service nodes in the same domain according to the configured weights. The page provided by the management node may further configure the area to which the service node belongs, for example, the service node 1 may be deleted from the area 1, or the service node 1 may be added to the area 2, or an area may be newly created, or an area may be deleted, etc. The management node can maintain the area, wherein the maintenance comprises the deletion and the new creation of the area, the adjustment of the service nodes in the area and the like.
Of the four service nodes shown in fig. 3, service node 1 and service node 2 are configured as area 1, service node 3 and service node 4 are configured as area 2, service node 1 is used to provide maintenance service to database 1 (i.e., DB 1) and database 2 (i.e., DB 2), service node 2 is used to provide maintenance service to database 1 and database 2, it should be noted that service node 1 and service node 2 are running the same database maintenance service, e.g., service node 1 and service node 2 are both used for database audit, and service node 2 may continue to operate when a problem occurs in service node 1 operation. Since there are two service nodes, in the system shown in fig. 3 a load balancing module (i.e. SLB) may be used for distributing database access requests to service node 1 and service node 2 according to the load situation in service node 1 and service node 2. In the area 2, a service node 3 and a service node 4 are configured, which are used for providing maintenance services for the database 3 (i.e. DB 3), and as with the service node 1 and the service node 2, the service node 3 and the service node 4 can also be load-balanced by a load balancing module.
As can be seen from fig. 3, the management node may configure DB1 and DB2 under the area 1, and DB3 under the area 2, wherein the service node 1 and the node 2 are configured under the area 1, and process the services of DB1 and DB2, and similarly, the node 3 and the node 4 process the services of DB 3. Traffic accessing DB1 can be distributed to service node 1 and service node 2 by SLB, and the traffic nodes can be increased or decreased according to traffic, so that flexibility is provided. If one of the nodes is down, the user traffic will flow to the other node without interruption because the other traffic node exists under the area.
In the above alternative embodiment, the services running on the single board are separated, the service node mainly runs specific services, for example, proxy monitoring, protocol running analysis and the like, and the management node is mainly responsible for data storage, configuration issuing, service node running state management, page operation and the like. And thus will be managed uniformly by the management node in case the service node is deployed in plurality.
The service nodes can divide the areas, the areas are independent, the nodes in the areas monitor the same port service, and the different areas monitor different port services, so that the protected database can be distributed to different areas according to the access quantity. Since a listening service will have multiple nodes listening, to meet the pressure sharing requirement, external load balancing (e.g. by SLB or haproxy) can be performed to share pressure to each service node.
The management node may also assume more management functions and in an alternative embodiment may implement automatic configuration of the service node. The network protocol (IP) address of the management node may be configured in advance for the service node, after the service node is started, the registration is performed to the management node according to the IP address of the management node, where the registration message carries a token that is preconfigured to the service node by the management node, after the management node verifies the token, it is determined that the token is a legal token, then the management node determines that the service node is on line, and determines a database maintenance service provided by the service node and a database maintained by the service node. And if the token is an illegal token, the management node refuses the service node to be on line, and the service node cannot provide database maintenance service for the database.
The management node can also acquire the version of the software installed on the service node, then acquire the version of the database maintained by the service node, the management node determines whether the version of the software on the service node is matched with the version of the database, and under the condition of no match, the management node acquires the software matched with the version of the database and sends the software to the service node, and the service node upgrades the software installed by itself after receiving the version from the management software. After the upgrade is successful, an upgrade success message is sent to the management node, and after the upgrade success message is received, the key node determines that the service node is online and starts to maintain the database.
The management node may also obtain the running state of the service nodes, for example, the management node may obtain the service volume which is not repaired in the service nodes, if the service volume to be processed by one service node exceeds a threshold value, the service volume which is not processed by the node is distributed to other service nodes in the same domain for processing, if the service volume to be processed by all the nodes in one domain exceeds the threshold value, whether there is an idle node in other domain may be obtained, if there is an idle node, the idle node is adjusted from other domain to the domain, and corresponding software is installed for the adjusted node according to the maintenance performed in the domain, and after the software is installed, the node is online.
In this embodiment, there is provided an electronic device including a memory in which a computer program is stored, and a processor configured to run the computer program to perform the method in the above embodiment.
The above-described programs may be run on a processor or may also be stored in memory (or referred to as computer-readable media), including both permanent and non-permanent, removable and non-removable media, and information storage may be implemented by any method or technique. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of storage media for a computer include, but are not limited to, phase change memory (PRAM), static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape disk storage or other magnetic storage devices, or any other non-transmission medium, which can be used to store information that can be accessed by a computing device.
These computer programs may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart block or blocks and/or block diagram block or blocks, and corresponding steps may be implemented in different modules.
Such an apparatus or system is provided in this embodiment. The device is called a multi-node-based database maintenance processing device, and comprises: the receiving module is used for receiving a database processing message, wherein the database processing request comprises a database access request message for accessing the database and/or a response message carrying a result, and the result is returned by the database in response to the database access request message; the acquisition module is used for acquiring a plurality of nodes configured for the database, wherein each node is configured with a database maintenance service, and the database maintenance service comprises at least one of the following: database agent, database audit, database data desensitization, database security protection, wherein the same database maintenance service is configured in the plurality of nodes; a determining module for determining a node from the plurality of nodes; and the sending module is used for sending the database processing message to the determined node.
The system or the device is used for realizing the functions of the method in the above embodiment, and each module in the system or the device corresponds to each step in the method, which has been described in the method, and will not be described herein.
Optionally, the determining module is configured to: acquiring the processing load of each node in the plurality of nodes; selecting one node with the minimum processing load from the plurality of nodes as one node determined from the plurality of nodes; or, according to the weight of each node in the plurality of nodes, wherein the weight is used for indicating the ratio of the number of database processing messages processed by the node in the plurality of nodes to the total number of database processing messages received by the plurality of nodes; the one node is determined according to the weight of each node and the database processing message which is allocated to each node.
Optionally, the plurality of nodes configured for the database are all in the same domain, wherein the plurality of nodes in the same domain all monitor the same network port service, and the nodes in different domains monitor different network port services.
Optionally, the plurality of nodes are managed by the management node, and the management node is used for acquiring the running states of the plurality of nodes managed by the management node.
The problem that the database access is influenced due to the fact that the workload of the database maintenance service of a single version possibly exists in the related technology is solved through the alternative implementation mode, so that the stability of the database maintenance service is improved, and the safety of the database is further guaranteed.
The foregoing is merely exemplary of the present application and is not intended to limit the present application. Various modifications and changes may be made to the present application by those skilled in the art. Any modifications, equivalent substitutions, improvements, etc. which are within the spirit and principles of the present application are intended to be included within the scope of the claims of the present application.
Claims (10)
1. A multi-node based database maintenance processing method, comprising:
receiving a database processing message, wherein the database processing request comprises a database access request message for accessing the database and/or a response message carrying a result, and the result is returned by the database in response to the database access request message;
obtaining a plurality of nodes configured for the database, wherein each node is configured with a database maintenance service, and the database maintenance service comprises at least one of the following: database agent, database audit, database data desensitization, database security protection, wherein the same database maintenance service is configured in the plurality of nodes;
determining a node from the plurality of nodes;
and sending the database processing message to the determined node.
2. The method of claim 1, wherein determining a node from the plurality of nodes comprises:
acquiring the processing load of each node in the plurality of nodes; selecting one node with the minimum processing load from the plurality of nodes as one node determined from the plurality of nodes; or,
according to the weight of each node in the plurality of nodes, wherein the weight is used for indicating the ratio of the number of database processing messages processed by the node in the plurality of nodes to the total number of database processing messages received by the plurality of nodes; the one node is determined according to the weight of each node and the database processing message which is allocated to each node.
3. The method of claim 1, wherein a plurality of nodes configured for the database are in a same domain, wherein a plurality of nodes in a same domain each monitor a same network port service, and wherein nodes in different domains monitor different network port services.
4. A method according to any one of claims 1 to 3, wherein the plurality of nodes are managed by the management node, the management node being adapted to obtain the operational status of the plurality of nodes it manages.
5. A multi-node based database maintenance processing apparatus, comprising:
the receiving module is used for receiving a database processing message, wherein the database processing request comprises a database access request message for accessing the database and/or a response message carrying a result, and the result is returned by the database in response to the database access request message;
the acquisition module is used for acquiring a plurality of nodes configured for the database, wherein each node is configured with a database maintenance service, and the database maintenance service comprises at least one of the following: database agent, database audit, database data desensitization, database security protection, wherein the same database maintenance service is configured in the plurality of nodes;
a determining module for determining a node from the plurality of nodes;
and the sending module is used for sending the database processing message to the determined node.
6. The apparatus of claim 5, wherein the means for determining is configured to:
acquiring the processing load of each node in the plurality of nodes; selecting one node with the minimum processing load from the plurality of nodes as one node determined from the plurality of nodes; or,
according to the weight of each node in the plurality of nodes, wherein the weight is used for indicating the ratio of the number of database processing messages processed by the node in the plurality of nodes to the total number of database processing messages received by the plurality of nodes; the one node is determined according to the weight of each node and the database processing message which is allocated to each node.
7. The apparatus of claim 5, wherein a plurality of nodes configured for the database are in a same domain, wherein a plurality of nodes in a same domain each monitor a same network port service, and wherein nodes in different domains monitor different network port services.
8. The apparatus according to any one of claims 5 to 7, wherein the plurality of nodes are managed by the management node, the management node being configured to obtain the operating states of the plurality of nodes it manages.
9. An electronic device includes a memory and a processor; wherein the memory is for storing one or more computer instructions, wherein the one or more computer instructions are executed by the processor to implement the method steps of any of claims 1 to 4.
10. A readable storage medium having stored thereon computer instructions which, when executed by a processor, implement the method steps of any of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310293423.6A CN116303363A (en) | 2023-03-23 | 2023-03-23 | Multi-node-based database maintenance processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310293423.6A CN116303363A (en) | 2023-03-23 | 2023-03-23 | Multi-node-based database maintenance processing method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116303363A true CN116303363A (en) | 2023-06-23 |
Family
ID=86819958
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310293423.6A Pending CN116303363A (en) | 2023-03-23 | 2023-03-23 | Multi-node-based database maintenance processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116303363A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN118316876A (en) * | 2024-06-12 | 2024-07-09 | 天津安华金和科技有限公司 | Plug-in flow processing method and system in database audit |
-
2023
- 2023-03-23 CN CN202310293423.6A patent/CN116303363A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN118316876A (en) * | 2024-06-12 | 2024-07-09 | 天津安华金和科技有限公司 | Plug-in flow processing method and system in database audit |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110910138B (en) | Block chain data supervision method and device | |
| US10778645B2 (en) | Firewall configuration manager | |
| US10798218B2 (en) | Environment isolation method and device | |
| US8078754B2 (en) | Group access privatization in clustered computer system | |
| JP2013532394A (en) | System and method for remote maintenance in an electronic network having multiple clients | |
| US7584195B2 (en) | Decomposing installation of distributed services | |
| CN103810444A (en) | Method and system for multi-tenant application isolation in cloud computing platform | |
| CN110245031B (en) | AI service opening middle platform and method | |
| CN108053088A (en) | A kind of Subscriber Management System, method and apparatus | |
| CN116303363A (en) | Multi-node-based database maintenance processing method and device | |
| CN110839023B (en) | Electric power marketing multi-channel customer service system | |
| CN112468539A (en) | Method, device and equipment for calling K8S cluster user resources and readable medium | |
| CN115934202A (en) | Data management method, system, data service gateway and storage medium | |
| CN113765871B (en) | Method and device for managing fort machine | |
| KR20210064058A (en) | A method and apparatus for log verification between heterogeneous operators in edge cloud system | |
| CN115037693B (en) | Distributed current limiting method and distributed current limiting device based on token bucket | |
| CN106357704A (en) | Method and device for invoking service on basis of development environments | |
| CN116614318B (en) | Network security protection method and system based on firewall | |
| US10476947B1 (en) | Methods for managing web applications and devices thereof | |
| CN117093639B (en) | Socket connection processing method and system based on audit service | |
| CN114143087B (en) | Virtual machine migration system and method | |
| US20240259391A1 (en) | Enforcing governance and data sovereignty policies on a computing device using a distributed ledger | |
| CN114285646B (en) | Method and device for preventing data leakage based on SMB protocol | |
| US12132702B2 (en) | IP address control system | |
| KR20200071787A (en) | Method and system for managing integrated storages of on-premise and cloud |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |