Database node operation and maintenance method and device, computer device and storage medium

Abstract

The application relates to a database node operation and maintenance method and device, computer equipment and a storage medium. The application relates to the technical field of big data, in particular to the technical field of distribution. The method comprises the following steps: in response to an operation and maintenance requirement of a target application by an operation and maintenance demand party, a database node viewing request of the target application is sent to a management server to instruct the management server to generate a node view according to database node information associated with the target application; the node view is acquired and displayed; according to a node selection operation of the operation and maintenance demand party on the node view, a target node is determined from the database nodes associated with the target application, and an operation and maintenance request including the target node is sent to the management server to instruct the management server to perform operation and maintenance on the target node; wherein the number of target nodes is at least two. By using the method, batch operation and maintenance can be performed on the database nodes under the same application in the dimension of the application, and the operation and maintenance efficiency is improved.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of distribution, in particular to a database node operation and maintenance method and device, computer equipment and storage medium. BACKGROUND

[0002] With the platform transformation of enterprises (such as banks), a distributed database structure that can support massive data and high concurrency access, such as MySQL, is generally selected. When designing a database architecture for different applications in an enterprise system, in order to cope with a large amount of data and ensure the performance of a single node of the database, vertical and horizontal splitting will be used to split the original database into a database array that can be expanded at will. Therefore, an application has up to hundreds of single database nodes that need to be maintained and managed.

[0003] However, the current management method of the database node is that a person queries the database state of a single database node according to the database node identifier recorded when the application environment is built, and further performs operation and maintenance on the database node, which is extremely inefficient. SUMMARY

[0004] Therefore, it is necessary to provide a database node operation and maintenance method and device, computer equipment and storage medium that can batch operation and maintenance of database nodes under the same application in the dimension of the application, thereby improving the operation and maintenance efficiency.

[0005] In a first aspect, the present application provides a database node operation and maintenance method, which comprises:

[0006] In response to the operation and maintenance demand of the target application by the operation and maintenance demand party, a database node viewing request of the target application is sent to the management server to instruct the management server to generate a node view according to the database node information associated with the target application;

[0007] The node view is obtained and displayed;

[0008] According to the node selection operation of the operation and maintenance demand party on the node view, a target node is determined from the database nodes associated with the target application, and an operation and maintenance request including the target node is sent to the management server to instruct the management server to perform operation and maintenance on the target node; wherein the number of target nodes is at least two.

[0009] In one of the embodiments, in response to the operation and maintenance demand of the target application by the operation and maintenance demand party, it comprises:

[0010] In response to the login request of the operation and maintenance demand party, the accessible applications of the operation and maintenance demand party are obtained according to the identifier information of the operation and maintenance demand party in the login request;

[0011] The accessible applications are displayed;

[0012] According to the selection operation of the accessible application by the operation and maintenance demand party, a target application is determined from the accessible application, and a response to the operation and maintenance demand of the target application by the operation and maintenance demand party.

[0013] In one of the embodiments, the node state information of the database node associated with the target application is included in the node view, and the node state information is used for the node selection operation by the operation and maintenance demand party.

[0014] In one of the embodiments, the operation and maintenance request is a node deletion request, and is used to instruct the management server to delete the application data of the target application from the target node.

[0015] In one of the embodiments, the operation and maintenance request is a node addition request, and is used to instruct the management server to add the application data of the target application to the target node.

[0016] In one of the embodiments, the method further includes:

[0017] Obtaining the operation and maintenance result sent by the management server;

[0018] According to the operation and maintenance result, the node view is updated and displayed.

[0019] In a second aspect, the application provides a database node operation and maintenance method, which includes:

[0020] In response to the database node viewing request of the target application sent by the terminal, the database node information associated with the target application is obtained;

[0021] According to the database node information associated with the target application, a node view is generated, and the node view is fed back to the terminal for the terminal to display the node view, according to the node selection operation of the operation and maintenance demand party on the node view, a target node is determined from the database nodes associated with the target application, and an operation and maintenance request including the target node is sent to the management server; wherein the number of target nodes is at least two;

[0022] In response to the operation and maintenance request, the target node is operated and maintained.

[0023] In one of the embodiments, according to the database node information associated with the target application, the node view is generated, including:

[0024] According to the database node information associated with the target application, the node state information of the database node associated with the target application is obtained;

[0025] According to the node state information of the database node associated with the target application, the node view is generated.

[0026] In one embodiment, in response to an operation and maintenance request, operation and maintenance is performed on the target node, including:

[0027] Based on the database node information associated with the target application, obtain the address information of the target node in the operation and maintenance request;

[0028] Based on the address information, perform maintenance on the target node.

[0029] In one embodiment, the maintenance request is a node deletion request. Maintenance is performed on the target node based on the address information, including:

[0030] Based on the address information, a data deletion request for the target application is sent to the target node to request the target node to delete the application data of the target application.

[0031] In one embodiment, the maintenance request is a node addition request. Based on the address information, maintenance is performed on the target node, including:

[0032] Based on the address information, a data addition request for the target application is sent to the target node to request the target node to add application data for the target application.

[0033] In one embodiment, after performing maintenance on the target node, the process further includes:

[0034] Update the database node information associated with the target application.

[0035] Thirdly, this application also provides a database node operation and maintenance device, which includes:

[0036] The first sending module is used to respond to the operation and maintenance needs of the operation and maintenance client for the target application by sending a database node viewing request for the target application to the management server, so as to instruct the management server to generate a node view based on the database node information associated with the target application.

[0037] The view display module is used to obtain and display the node view;

[0038] The second sending module is used to determine the target node from the database nodes associated with the target application based on the node selection operation performed by the operation and maintenance requester on the node view, and send an operation and maintenance request including the target node to the management server to instruct the management server to perform operation and maintenance on the target node; wherein, the number of target nodes is at least two.

[0039] Fourthly, this application also provides a database node operation and maintenance device, which includes:

[0040] The information acquisition module is used to respond to the database node viewing request of the target application sent by the terminal and obtain the database node information associated with the target application.

[0041] The view feedback module is used to generate a node view based on the database node information associated with the target application and to feed the node view back to the terminal for the terminal to display. Based on the node selection operation performed by the operation and maintenance requester on the node view, the target node is determined from the database nodes associated with the target application, and an operation and maintenance request including the target node is sent to the management server; wherein, the number of target nodes is at least two.

[0042] The operations and maintenance module is used to respond to operations and maintenance requests and perform operations and maintenance on the target nodes.

[0043] Fifthly, this application also provides a computer device including a memory and a processor, wherein the memory stores a computer program, and the processor executes the computer program to perform the following steps:

[0044] In response to the maintenance needs of the operation and maintenance client for the target application, a database node viewing request for the target application is sent to the management server to instruct the management server to generate a node view based on the database node information associated with the target application.

[0045] Get and display the node view;

[0046] Based on the node selection operation performed by the operation and maintenance requester on the node view, the target node is determined from the database nodes associated with the target application, and an operation and maintenance request including the target node is sent to the management server to instruct the management server to perform operation and maintenance on the target node; wherein, the number of target nodes is at least two.

[0047] Sixthly, this application also provides a computer device including a memory and a processor, wherein the memory stores a computer program, and the processor executes the computer program to perform the following steps:

[0048] In response to a database node viewing request sent by the terminal, obtain the database node information associated with the target application;

[0049] Based on the database node information associated with the target application, a node view is generated and fed back to the terminal for the terminal to display. Based on the node selection operation performed by the operation and maintenance requester on the node view, the target node is determined from the database nodes associated with the target application, and an operation and maintenance request including the target node is sent to the management server; wherein, the number of target nodes is at least two.

[0050] In response to maintenance requests, perform maintenance on the target node.

[0051] Seventhly, this application also provides a computer-readable storage medium having a computer program stored thereon, the computer program performing the following steps when executed by a processor:

[0052] In response to the maintenance needs of the operation and maintenance client for the target application, a database node viewing request for the target application is sent to the management server to instruct the management server to generate a node view based on the database node information associated with the target application.

[0053] Get and display the node view;

[0054] Based on the node selection operation performed by the operation and maintenance requester on the node view, the target node is determined from the database nodes associated with the target application, and an operation and maintenance request including the target node is sent to the management server to instruct the management server to perform operation and maintenance on the target node; wherein, the number of target nodes is at least two.

[0055] Eighthly, this application also provides a computer-readable storage medium having a computer program stored thereon, the computer program performing the following steps when executed by a processor:

[0056] In response to a database node viewing request sent by the terminal, obtain the database node information associated with the target application;

[0057] Based on the database node information associated with the target application, a node view is generated and fed back to the terminal for the terminal to display. Based on the node selection operation performed by the operation and maintenance requester on the node view, the target node is determined from the database nodes associated with the target application, and an operation and maintenance request including the target node is sent to the management server; wherein, the number of target nodes is at least two.

[0058] In response to maintenance requests, perform maintenance on the target node.

[0059] Ninthly, this application also provides a computer program product, which includes a computer program that, when executed by a processor, performs the following steps:

[0060] In response to the maintenance needs of the operation and maintenance client for the target application, a database node viewing request for the target application is sent to the management server to instruct the management server to generate a node view based on the database node information associated with the target application.

[0061] Get and display the node view;

[0062] Based on the node selection operation performed by the operation and maintenance requester on the node view, the target node is determined from the database nodes associated with the target application, and an operation and maintenance request including the target node is sent to the management server to instruct the management server to perform operation and maintenance on the target node; wherein, the number of target nodes is at least two.

[0063] In a tenth aspect, this application also provides a computer program product, comprising a computer program that, when executed by a processor, performs the following steps:

[0064] In response to a database node viewing request sent by the terminal, obtain the database node information associated with the target application;

[0065] Based on the database node information associated with the target application, a node view is generated and fed back to the terminal for the terminal to display. Based on the node selection operation performed by the operation and maintenance requester on the node view, the target node is determined from the database nodes associated with the target application, and an operation and maintenance request including the target node is sent to the management server; wherein, the number of target nodes is at least two.

[0066] In response to maintenance requests, perform maintenance on the target node.

[0067] The aforementioned database node operation and maintenance method, apparatus, computer equipment, and storage medium, in response to the operation and maintenance operation of the target application by the operation and maintenance requester, send a database node viewing request for the target application to the management server; the management server generates a node view based on the database node information associated with the target application and feeds it back to the terminal; the terminal displays the node view to the operation and maintenance requester; furthermore, based on the node selection operation performed by the operation and maintenance requester on the node view, the terminal determines the target node from the database nodes associated with the target application and sends an operation and maintenance request including the target node to the management server; the management server responds to the operation and maintenance request sent by the terminal and performs operation and maintenance on the target node, achieving the effect of batch operation and maintenance of database nodes under the same application at the application level, thus improving operation and maintenance efficiency. Attached Figure Description

[0068] Figure 1 This is an application environment diagram of the database node operation and maintenance method in one embodiment;

[0069] Figure 2 This is a flowchart illustrating the operation and maintenance method of a database node in one embodiment;

[0070] Figure 3 This is a schematic diagram illustrating the process of a terminal responding to an operation and maintenance request from an operation and maintenance requester for a target application in one embodiment.

[0071] Figure 4This is a flowchart illustrating the operation and maintenance method of a database node in another embodiment;

[0072] Figure 5 This is a schematic diagram illustrating the process of server-side operation and maintenance of a target node in one embodiment;

[0073] Figure 6 This is a flowchart illustrating the operation and maintenance method of a database node in another embodiment;

[0074] Figure 7 This is a structural block diagram of the operation and maintenance device for a database node in one embodiment;

[0075] Figure 8 This is a structural block diagram of the operation and maintenance device for the database node in another embodiment;

[0076] Figure 9 This is a structural block diagram of the operation and maintenance device for the database node in another embodiment;

[0077] Figure 10 This is a structural block diagram of the database node operation and maintenance device in another embodiment;

[0078] Figure 11 This is an internal structural diagram of a computer device in one embodiment;

[0079] Figure 12 This is a diagram of the internal structure of a computer device in another embodiment. Detailed Implementation

[0080] To make the objectives, technical solutions, and advantages of this application clearer, the following detailed description is provided in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative and not intended to limit the scope of this application.

[0081] The database node operation and maintenance method provided in this application embodiment can be applied to, for example, Figure 1 In the application environment shown, terminal 102 communicates with management server 104 via a network. A data storage system can store the data that management server 104 needs to process. The data storage system can be integrated onto server 104, or it can be located in the cloud or on other network servers.

[0082] Specifically, in this application, terminal 102 can respond to the maintenance operation of the target application by the maintenance requester and send a database node viewing request for the target application to management server 104. After receiving the database node viewing request from terminal 102, management server 104 generates a node view based on the database node information associated with the target application and feeds it back to terminal 102. After receiving the node view from server 104, terminal 102 displays the node view to the maintenance requester. Further, based on the node selection operation performed by the maintenance requester on the node view, terminal 102 determines the target node from the database nodes associated with the target application and sends a maintenance request including the target node to management server 104. Management server 104 responds to the maintenance request from terminal 102 and performs maintenance on the target node.

[0083] The terminal 102 can be, but is not limited to, various personal computers, laptops, smartphones, tablets, IoT devices, and portable wearable devices. IoT devices can include smart speakers, smart TVs, smart air conditioners, and smart in-vehicle systems. Portable wearable devices can include smartwatches, smart bracelets, and head-mounted devices. The server 104 can be implemented using a standalone server or a server cluster consisting of multiple servers.

[0084] In one embodiment, such as Figure 2 As shown, a method for operating and maintaining a database node is provided, which can be applied to... Figure 1 Taking terminal 102 as an example, the explanation includes the following steps:

[0085] S201, in response to the maintenance request of the maintenance client for the target application, sends a database node viewing request for the target application to the management server, instructing the management server to generate a node view based on the database node information associated with the target application.

[0086] In this embodiment, the operation and maintenance request party is any party that needs to perform operation and maintenance on the application. The target application is the application that needs operation and maintenance. The database node viewing request is a request to view the database nodes associated with the target application. Optionally, the database node viewing request may include the application identifier of the target application.

[0087] The database node information associated with the target application refers to the relevant information of the database nodes where the target application-related data is deployed; optionally, the database node information may include, but is not limited to, the application name to which each database node belongs, the address information of each database node, the instance name associated with the target application stored on each database node, and the status information of each database node.

[0088] The node view can include the name of the target application, the address information of each database node under the target application, and the status information of each database node under the target application. Furthermore, the node view can be presented in the form of a list or a tree diagram.

[0089] Optionally, the terminal can be configured with operation and maintenance tools, which can be presented in the form of mini-programs, web pages, or independent apps.

[0090] Subsequently, the operation and maintenance requester initiates an operation and maintenance request for the target application through the operation and maintenance tools. The terminal responds to the operation and maintenance requester's operation and maintenance request for the target application, generates a database node viewing request for the target application, and sends the database node viewing request to the management server. Further, after receiving the database node viewing request, the management server searches for the database node information associated with the target application, and generates a node view under the target application based on the found database node information.

[0091] S202, retrieve and display the node view.

[0092] Specifically, after generating the node view, the management server can send the generated node view back to the terminal. The terminal can then obtain the node view of the target application sent back by the management server and display the node view to the operation and maintenance requester through the operation and maintenance tools, so that the operation and maintenance requester can perform the next operation.

[0093] Alternatively, the terminal can send a node view retrieval request to the management server, instructing the management server to distribute the generated node view to the terminal; then the terminal can obtain the node view and display it to the maintenance requester through maintenance tools, so that the maintenance requester can perform the next operation.

[0094] S203: Based on the node selection operation performed by the operation and maintenance requester on the node view, determine the target node from the database nodes associated with the target application, and send an operation and maintenance request including the target node to the management server to instruct the management server to perform operation and maintenance on the target node.

[0095] The number of target nodes must be at least two. An operation and maintenance request is a request to perform operation and maintenance on the target nodes.

[0096] Specifically, after the node view is displayed to the operation and maintenance requester, the operation and maintenance requester can select the database nodes on the node view according to their needs.

[0097] Optionally, if the node view includes node status information of the database nodes associated with the target application, this node status information can be used by the operations and maintenance (O&M) client to select nodes. In this case, the O&M client can select each database node based on its node status information. For example, if a database node is currently not running, the O&M client can choose to start that database node.

[0098] Alternatively, if the node view includes the instance name associated with the target application, the operations and maintenance client can select each database node based on the instance name associated with the target application.

[0099] Furthermore, the terminal can determine the target node from the database nodes associated with the target application based on the node selection operation performed by the operation and maintenance requester on the node view. That is, the database node selected by the operation and maintenance requester is set as the target node.

[0100] Subsequently, the terminal can generate an operation and maintenance request based on the pre-set operation and maintenance request generation logic, according to the relevant information of the target node, such as the address information of the target node, and the specific operation and maintenance operations to be performed on the target node; and send the operation and maintenance request including the target node to the management server; further, the management server receives the operation and maintenance request sent by the terminal, locks the target node according to the address information of the target node in the operation and maintenance request, and performs operation and maintenance on the target node according to the specific operation and maintenance operations to be performed on the target node in the operation and maintenance request.

[0101] The aforementioned database node operation and maintenance method involves responding to the operation and maintenance requests of the target application by sending a database node viewing request for the target application to the management server. The management server then generates a node view based on the database node information associated with the target application and sends it back to the terminal. The terminal displays the node view to the operation and maintenance requester. Furthermore, based on the node selection operation performed by the operation and maintenance requester on the node view, the terminal determines the target node from the database nodes associated with the target application and sends an operation and maintenance request including the target node to the management server. The management server responds to the operation and maintenance request sent by the terminal and performs operation and maintenance on the target node. This achieves the effect of batch operation and maintenance of database nodes under the same application at the application level, thereby improving operation and maintenance efficiency.

[0102] Optionally, maintenance requests may include node deletion requests and / or node addition requests. Furthermore, different maintenance requests may employ different maintenance methods for the target node.

[0103] Optionally, if the maintenance request is a node deletion request, it is used to instruct the management server to delete the application data of the target application from the target node.

[0104] In this embodiment, a node deletion request is a request to delete a target node or delete data within a target node. Specifically, when the maintenance request is a node deletion request, the terminal sends a maintenance request to the management server, instructing the management server to lock the target node based on the target node's address information included in the maintenance request, and delete the target node, or delete the application data of the target application within the target node.

[0105] Furthermore, if the maintenance request is a node addition request, it is used to instruct the management server to add the application data of the target application to the target node.

[0106] In this embodiment, a node addition request is a request to add data to a target node. The target node can be an existing database node used by the target application, or a blank database node not yet used by the target application. Specifically, when the maintenance request is a node addition request, the terminal sends a maintenance request to the management server, instructing the management server to locate the target node based on the target node's address information included in the maintenance request, and to add the target application's application data to the target node.

[0107] In one implementation, the maintenance request may include both a node deletion request and a node addition request. In this case, it is used to instruct the management server to delete the application data of the target application in some target nodes and add the application data of the target application to other target nodes.

[0108] For example, when an operation and maintenance request includes both a node deletion request and a node addition request, the terminal sends an operation and maintenance request to the management server, instructing the management server to locate the target node based on the target node's address information included in the operation and maintenance request, and then perform deletion or addition operations on the target node. This can be implemented, for example, when an application needs to be upgraded, if the target nodes include database node A and database node B, some application data of the target application in node A can be deleted, and this part of the application data can be added to database node B.

[0109] It is understandable that different operation requests in the operation and maintenance request can be used to perform different operation and maintenance operations on the target node, including deletion operations, addition operations, deletion and addition operations, etc., which can meet the diverse operation and maintenance needs of target nodes under the target application in batches.

[0110] For example, based on the above embodiments, after the management server performs maintenance on the target node, it can send the maintenance results back to the terminal. At this time, the terminal can obtain the maintenance results sent by the management server; based on the maintenance results, it updates and displays the node view. The maintenance results can indicate whether the maintenance of the target node was successful. Specifically, the maintenance result can be either successful or failed.

[0111] Specifically, after receiving the maintenance results from the management server, the terminal updates the node view based on the maintenance results and the maintenance request, and displays the updated node view to the maintenance requester through maintenance tools. For example, if the database node C under the target application was not running before maintenance, then the database node C in the previous node view was not highlighted; if the maintenance request was to start the database node C, and the maintenance result was successful, then after the maintenance was completed, the database node C was in a running state, and the node view was updated, meaning that the database node C in the updated node view was highlighted.

[0112] Understandably, updating the node view based on the operation and maintenance results and displaying it to the operation and maintenance requester allows the requester to intuitively see whether the operation and maintenance was successful, making the operation and maintenance results clearer and improving the accuracy of operation and maintenance of the target application.

[0113] In one embodiment, such as Figure 3 As shown, the above-mentioned S201, which responds to the operation and maintenance requirements of the operation and maintenance requester for the target application, can be further refined and may specifically include the following steps:

[0114] S301, in response to the login request from the operation and maintenance requester, obtains the accessible applications of the operation and maintenance requester based on the identification information of the operation and maintenance requester in the login request.

[0115] In this embodiment, the login request is the request from the maintenance requester to log in to the maintenance tool. The maintenance requester's identification information is the information that identifies the maintenance requester when logging into the maintenance tool, such as the maintenance requester's mobile phone number, ID card number, etc. Accessible applications are the applications that the maintenance requester can access and perform maintenance on.

[0116] Specifically, the maintenance requester sends a login request, including identification information, to the terminal through maintenance tools. The terminal then responds to the login request by verifying the identification information included in the request. If authentication fails, the maintenance requester is deemed an unauthorized user, and accessible applications cannot be displayed. Optionally, if authentication succeeds, the terminal locates the maintenance requester's accessible applications based on the identification information included in the login request.

[0117] S302, showing accessible applications.

[0118] Specifically, after identifying the accessible applications of the maintenance requester, the maintenance tools are used to display these accessible applications to the requester, allowing them to select a target application and then perform maintenance on the target nodes under that application. The accessible applications can be displayed to the maintenance requester in the form of a list or a tree diagram, etc.

[0119] S303, based on the operation and maintenance requester's selection of accessible applications, determines the target application from the accessible applications and responds to the operation and maintenance requester's operation and maintenance requirements for the target application.

[0120] Specifically, the maintenance requester selects from the available applications displayed through the maintenance tools; then, based on the maintenance requester's selection, the terminal determines the target application from the available applications, that is, the application selected by the maintenance requester is taken as the target application, and at the same time, it triggers the generation of maintenance requests for the target application and responds.

[0121] Understandably, by including the identification information of the operation and maintenance request party in the login request, the accessible applications of the operation and maintenance request party can be obtained and displayed, so that the operation and maintenance request party can perform operation and maintenance operations on the target application, thus achieving the effect of personalized display for different operation and maintenance request parties.

[0122] In one embodiment, such as Figure 4 As shown, a method for operating and maintaining a database node is provided, which can be applied to... Figure 1 Taking management server 104 as an example, the following steps are included:

[0123] S401, in response to the database node viewing request sent by the terminal, obtain the database node information associated with the target application.

[0124] In this embodiment, the database node information associated with the target application is the relevant information of the database node where the target application-related data is deployed; optionally, the database node information may include, but is not limited to, the application name to which each database node belongs, the instance name of the database to which each database node belongs after vertical partitioning according to business, the partition name of the database to which each database node belongs after vertical partitioning according to business and further horizontal partitioning, the address information of each database node, the real address information of the primary database corresponding to each database node, and the real address information of the backup database corresponding to each database node, etc.

[0125] It should be noted that the management server can analyze the data stored in each database node in the database cluster, generate a node information table for each database node, and store it locally; the node information table includes database node information.

[0126] Furthermore, upon receiving a database node viewing request for the target application sent by the terminal, the application identifier of the target application can be extracted from the database node viewing request. Based on the extracted application identifier (which can be the application name), the database node information associated with the target application is found in the locally stored node information tables, and the found database node information is obtained.

[0127] S402: Based on the database node information associated with the target application, generate a node view and feed the node view back to the terminal for the terminal to display. Based on the node selection operation performed by the maintenance requester on the node view, determine the target node from the database nodes associated with the target application and send an maintenance request including the target node to the management server.

[0128] The number of target nodes must be at least two. If multiple target nodes exist, there can be multiple maintenance requests. Maintenance requests can include the address information of the target nodes, as well as the specific maintenance operations performed on those nodes.

[0129] Specifically, after obtaining the database node information associated with the target application, the obtained database node information can be input into a pre-defined model to generate a node view of the target application.

[0130] Alternatively, the node status information of the database nodes associated with the target application can be obtained based on the database node information associated with the target application; a node view can then be generated based on the node status information of the database nodes associated with the target application. In this embodiment, the node status information is the information characterizing the node status, which can be running, not running, or faulty, etc.

[0131] Specifically, when the database node information associated with the target application does not include node status information, after obtaining the database node information associated with the target application, the address information of each database node associated with the target application is extracted from the obtained database node information. Based on the obtained address information, the node status information of each database node associated with the target application is captured. Then, based on the application name of the target application, the address information of each database node associated with the target application, and the node status information of each database node associated with the target application, a node view of the target application is generated. For example, node status information can be represented by indicator lights: not running can be represented by an off light, running can be represented by a green light, and faulty can be represented by a red light.

[0132] Furthermore, the management server feeds back the generated node view to the terminal. The terminal then displays the received node view to the maintenance requester, who selects database nodes based on the displayed node view. According to the node selection operation performed by the maintenance requester on the node view, the target node is determined from the database nodes associated with the target application, and a maintenance request for the target node is sent to the management server.

[0133] S403, in response to an operation and maintenance request, performs operation and maintenance on the target node.

[0134] Specifically, after receiving the maintenance request from the terminal, the target node can be locked based on the relevant information of the target node included in the maintenance request; furthermore, for the target node, maintenance is performed on the target node according to the specific maintenance operations for the target node in the maintenance request.

[0135] In this embodiment, the management server responds to the database node viewing request sent by the terminal, obtains the database node information associated with the target application, generates a node view, and feeds it back to the terminal. The terminal then displays the node view to the maintenance requester and, based on the node selection operation performed by the maintenance requester on the node view, determines the target node from the database nodes associated with the target application, generates maintenance requests for each target node, and sends them to the management server. Furthermore, the management server responds to the maintenance requests sent by the terminal and performs maintenance on the target nodes, achieving the effect of batch maintenance on database nodes under the same application at the application level, thus improving maintenance efficiency.

[0136] Based on the above embodiments, in one embodiment, such as Figure 5 As shown, further detailing the above S403 can specifically include the following steps:

[0137] S501: Based on the database node information associated with the target application, obtain the address information of the target node in the operation and maintenance request.

[0138] The target node's address information is the specific address of the target node. The target node can be located based on the address information, and then the target node can be operated and maintained.

[0139] Specifically, after receiving the maintenance request from the terminal, the system searches for relevant information about the target node in the database node information associated with the target application. Furthermore, it can extract the address information of the target node in the maintenance request from the relevant information of the target node found.

[0140] S502 performs maintenance on the target node based on the address information.

[0141] Specifically, based on the target node's address information, the target node is located from the database nodes associated with the target application; furthermore, the target node is maintained and operated.

[0142] One possible approach is to send a data deletion request for the target application to the target node based on the address information, if the maintenance request is a node deletion request.

[0143] In this embodiment, a node deletion request is a request to delete a target node or to delete data within a target node. Specifically, when the maintenance request is a node deletion request, the target node is located from the database nodes based on its address information. Further, a data deletion request for the target application is sent to the target node, requesting it to delete data within the specified data range outlined in the request. The node deletion request can delete all or part of the data within the target node, or it can delete the entire target node.

[0144] Another possible approach is to send a data addition request for the target application to the target node based on its address information, if the maintenance request is a node addition request. This request requests the addition of application data for the target application to the target node. In the case of a node addition request, the target node is located in the database based on its address information; furthermore, a data addition request for the target application is sent to the target node, requesting it to add the application data added in the data addition request to the target node.

[0145] Furthermore, after performing maintenance on the target node, the database node information associated with the target application is updated.

[0146] Specifically, after performing maintenance on the target node, the database node information associated with the target application is updated based on the maintenance results. Optionally, if the maintenance result is successful, the database node information associated with the target application is updated according to the maintenance requirements; if the maintenance result is a failure, there is no need to update the database node information. Furthermore, the maintenance failure information can be transmitted to the terminal so that the terminal can output the maintenance failure result to the maintenance requester.

[0147] For example, the maintenance request might include changing the instance name of database node D from "User" to "Merchant". Before maintenance, the instance name of database node D under the target application was "User", and after maintenance, the instance name of database node D is changed to "Merchant". That is, in the database node information associated with the target application, the instance name of database node D is changed from "User" to "Merchant".

[0148] For example, if the database node information associated with the target application includes node status information, and if the database node E under the target application was in a non-running state before maintenance, and the database node E is changed to a running state after maintenance, then the status information of the database node E associated with the target application will be updated from a non-running state to a running state.

[0149] Furthermore, the management server sends the operation and maintenance results to the terminal based on the updated database node information; the terminal updates the node view according to the operation and maintenance results sent by the management server and displays it to the operation and maintenance requester.

[0150] In this embodiment, the address information of the target node in the operation and maintenance request is obtained based on the database node information associated with the target application; furthermore, the target node is locked from the database nodes based on the obtained address information of the target node, and then the target node is operated and maintained, which improves the efficiency of locking the target node and enables more accurate and faster operation and maintenance of the target node.

[0151] In one embodiment, an optional example of a method for operating and maintaining a database node through interaction between a terminal and a management server is provided. Combined with... Figure 6 The diagram illustrates the signaling interaction flow of the database node operation and maintenance method. This method can be implemented through the following steps:

[0152] S601, the terminal responds to the login request from the maintenance requester and obtains the accessible applications of the maintenance requester based on the identification information of the maintenance requester in the login request.

[0153] S602, the terminal displays accessible applications.

[0154] S603: Based on the operation and maintenance requester's selection of accessible applications, the terminal determines the target application from the accessible applications and, in response to the operation and maintenance requester's operation and maintenance request for the target application, sends a database node viewing request for the target application to the management server.

[0155] S604, the management server responds to the database node viewing request sent by the terminal to obtain the database node information associated with the target application.

[0156] S605, the management server obtains the node status information of the database nodes associated with the target application based on the database node information associated with the target application.

[0157] S606, the management server generates a node view based on the node status information of the database nodes associated with the target application.

[0158] S607, the management server sends the node view back to the terminal.

[0159] S608, the terminal obtains and displays the node view.

[0160] S609: The terminal determines the target node from the database nodes associated with the target application based on the node selection operation performed by the operation and maintenance requester on the node view.

[0161] S610: The terminal sends an operation and maintenance request, including the target node, to the management server.

[0162] S611, the management server obtains the address information of the target node in the operation and maintenance request based on the database node information associated with the target application.

[0163] S612, the management server performs maintenance on the target node based on the address information.

[0164] S613, the management server sends the operation and maintenance results to the terminal.

[0165] S614, the terminal obtains the operation and maintenance results sent by the management server.

[0166] S615: The terminal updates and displays the node view based on the operation and maintenance results.

[0167] The specific processes of S601-S615 described above can be found in the description of the above method embodiments. Their implementation principles and technical effects are similar, and will not be repeated here.

[0168] It should be understood that although the steps in the flowcharts of the embodiments described above are shown sequentially according to the arrows, these steps are not necessarily executed in the order indicated by the arrows. Unless explicitly stated herein, there is no strict order restriction on the execution of these steps, and they can be executed in other orders. Moreover, at least some steps in the flowcharts of the embodiments described above may include multiple steps or multiple stages. These steps or stages are not necessarily completed at the same time, but can be executed at different times. The execution order of these steps or stages is not necessarily sequential, but can be performed alternately or in turn with other steps or at least some of the steps or stages of other steps.

[0169] Based on the same inventive concept, this application also provides a database node operation and maintenance device for implementing the database node operation and maintenance method described above. The solution provided by this device is similar to the solution described in the above method; therefore, the specific limitations of one or more database node operation and maintenance device embodiments provided below can be found in the limitations of the database node operation and maintenance method described above, and will not be repeated here.

[0170] In one embodiment, such as Figure 7 As shown, a database node operation and maintenance device 1 is provided, including: a first sending module 10, a view display module 11, and a second sending module 12, wherein:

[0171] The first sending module 10 is used to respond to the operation and maintenance needs of the operation and maintenance client for the target application by sending a database node viewing request for the target application to the management server, so as to instruct the management server to generate a node view based on the database node information associated with the target application.

[0172] View display module 11 is used to acquire and display node views;

[0173] The second sending module 12 is used to determine the target node from the database nodes associated with the target application based on the node selection operation performed by the operation and maintenance requester on the node view, and send an operation and maintenance request including the target node to the management server to instruct the management server to perform operation and maintenance on the target node; wherein, the number of target nodes is at least two.

[0174] In one embodiment, in the above Figure 7 On the basis of, such as Figure 8 As shown, the first transmitting module 10 further includes:

[0175] Application acquisition unit 101 is used to respond to the login request of the operation and maintenance request party and obtain the accessible applications of the operation and maintenance request party according to the identification information of the operation and maintenance request party in the login request.

[0176] Application display unit 102 is used to display accessible applications;

[0177] The demand response unit 103 is used to determine the target application from the accessible applications based on the operation and maintenance demander's selection operation of the accessible applications, and respond to the operation and maintenance demander's operation and maintenance demand for the target application.

[0178] In one embodiment, the node view of the aforementioned database node operation and maintenance device 1 includes node status information of the database node associated with the target application. The node status information is used by the operation and maintenance request party to perform node selection operations.

[0179] In one embodiment, the maintenance request of the aforementioned database node maintenance device 1 is a node deletion request, and is used to instruct the management server to delete the application data of the target application from the target node.

[0180] In one embodiment, the maintenance request of the aforementioned database node maintenance device 1 is a node addition request, and is used to instruct the management server to add application data of the target application to the target node.

[0181] In one embodiment, the operation and maintenance device 1 for the aforementioned database node may further include:

[0182] The results acquisition module is used to acquire the operation and maintenance results sent by the management server; based on the operation and maintenance results, the node view is updated and displayed.

[0183] In one embodiment, such as Figure 9 As shown, a database node operation and maintenance device 2 is provided, including: an information acquisition module 20, a view feedback module 21, and an operation and maintenance module 22, wherein:

[0184] The information acquisition module 20 is used to respond to the database node viewing request of the target application sent by the terminal and acquire the database node information associated with the target application.

[0185] The view feedback module 21 is used to generate a node view based on the database node information associated with the target application, and to feed the node view back to the terminal for the terminal to display the node view. Based on the node selection operation performed by the operation and maintenance requester on the node view, the target node is determined from the database nodes associated with the target application, and an operation and maintenance request including the target node is sent to the management server; wherein, the number of target nodes is at least two.

[0186] The operation and maintenance module 22 is used to respond to operation and maintenance requests and perform operation and maintenance on the target node.

[0187] In one embodiment, the view feedback module 21 described above can be specifically used for:

[0188] Based on the database node information associated with the target application, obtain the node status information of the database nodes associated with the target application; based on the node status information of the database nodes associated with the target application, generate a node view.

[0189] In one embodiment, in the above Figure 9 On the basis of, such as Figure 10 As shown, the above-mentioned operation and maintenance module 22 also includes:

[0190] Address acquisition unit 221 is used to acquire the address information of the target node in the operation and maintenance request based on the database node information associated with the target application.

[0191] The operation and maintenance unit 222 is used to perform operation and maintenance on the target node based on the address information.

[0192] In one embodiment, if the maintenance request is a node deletion request, then the aforementioned maintenance unit 222 can be specifically used for:

[0193] Based on the address information, a data deletion request for the target application is sent to the target node to request the target node to delete the application data of the target application.

[0194] In one embodiment, if the maintenance request is a node addition request, then the aforementioned maintenance unit 222 can also be used for:

[0195] Based on the address information, a data addition request for the target application is sent to the target node to request the target node to add application data for the target application.

[0196] In one embodiment, after the target node is maintained, the aforementioned database node maintenance device 2 may further include:

[0197] The information update module is used to update the database node information associated with the target application.

[0198] The modules in the aforementioned database node operation and maintenance device can be implemented entirely or partially through software, hardware, or a combination thereof. These modules can be embedded in the processor of a computer device in hardware form or independent of it, or stored in the memory of the computer device in software form, so that the processor can call and execute the operations corresponding to each module.

[0199] In one embodiment, a computer device is provided, which may be a server, and its internal structure diagram may be as follows: Figure 11 As shown, the computer device includes a processor, memory, and a network interface connected via a system bus. The processor provides computing and control capabilities. The memory includes non-volatile storage media and internal memory. The non-volatile storage media stores the operating system, computer programs, and a database. The internal memory provides an environment for the operation of the operating system and computer programs stored in the non-volatile storage media. The database stores data such as database node information. The network interface communicates with external terminals via a network connection. When the computer program is executed by the processor, it implements a database node operation and maintenance method.

[0200] In one embodiment, a computer device is provided, which may be a terminal, and its internal structure diagram may be as follows: Figure 12As shown, the computer device includes a processor, memory, communication interface, display screen, and input devices connected via a system bus. The processor provides computing and control capabilities. The memory includes non-volatile storage media and internal memory. The non-volatile storage media stores the operating system and computer programs. The internal memory provides an environment for the operation of the operating system and computer programs stored in the non-volatile storage media. The communication interface is used for wired or wireless communication with external terminals; wireless communication can be achieved through Wi-Fi, mobile cellular networks, NFC (Near Field Communication), or other technologies. When the computer program is executed by the processor, it implements a database operation and maintenance method. The display screen can be an LCD screen or an e-ink screen. The input devices can be a touch layer covering the display screen, buttons, a trackball, or a touchpad on the computer device casing, or an external keyboard, touchpad, or mouse.

[0201] Those skilled in the art will understand that Figure 11 , Figure 12 The structure shown is merely a block diagram of a portion of the structure related to the present application and does not constitute a limitation on the computer device to which the present application is applied. Specific computer devices may include more or fewer components than those shown in the figure, or combine certain components, or have different component arrangements.

[0202] In one embodiment, a computer device is provided, including a memory and a processor, wherein the memory stores a computer program, and the processor executes the computer program to perform the following steps:

[0203] In response to the maintenance needs of the operation and maintenance client for the target application, a database node viewing request for the target application is sent to the management server to instruct the management server to generate a node view based on the database node information associated with the target application.

[0204] Get and display the node view;

[0205] Based on the node selection operation performed by the operation and maintenance requester on the node view, the target node is determined from the database nodes associated with the target application, and an operation and maintenance request including the target node is sent to the management server to instruct the management server to perform operation and maintenance on the target node; wherein, the number of target nodes is at least two.

[0206] In one embodiment, when the processor executes the logic of a computer program responding to the maintenance needs of the maintenance requester for the target application, it further implements the following steps:

[0207] In response to the login request from the maintenance requester, the system obtains the accessible applications of the maintenance requester based on the identification information of the maintenance requester in the login request; displays the accessible applications; determines the target application from the accessible applications based on the maintenance requester's selection operation of the accessible applications, and responds to the maintenance requester's maintenance requirements for the target application.

[0208] In one embodiment, when the processor executes a computer program, the node view includes node status information of the database nodes associated with the target application, and the node status information is used by the operation and maintenance request party to perform node selection operations.

[0209] In one embodiment, when the processor executes a computer program, the maintenance request is a node deletion request, which instructs the management server to delete the application data of the target application from the target node.

[0210] In one embodiment, when the processor executes a computer program, the maintenance request is a node addition request and is used to instruct the management server to add application data of the target application to the target node.

[0211] In one embodiment, when the processor executes a computer program, it also performs the following steps:

[0212] Retrieve the operation and maintenance results sent by the management server; update the node view based on the operation and maintenance results, and display it.

[0213] In one embodiment, a computer-readable storage medium is provided having a computer program stored thereon, the computer program performing the following steps when executed by a processor:

[0214] In response to the maintenance needs of the operation and maintenance client for the target application, a database node viewing request for the target application is sent to the management server to instruct the management server to generate a node view based on the database node information associated with the target application.

[0215] Get and display the node view;

[0216] Based on the node selection operation performed by the operation and maintenance requester on the node view, the target node is determined from the database nodes associated with the target application, and an operation and maintenance request including the target node is sent to the management server to instruct the management server to perform operation and maintenance on the target node; wherein, the number of target nodes is at least two.

[0217] In one embodiment, when the logic of a computer program responding to an operational request from an operational requester for a target application is executed by a processor, the following steps are implemented:

[0218] In response to the login request from the maintenance requester, the system obtains the accessible applications of the maintenance requester based on the identification information of the maintenance requester in the login request; displays the accessible applications; determines the target application from the accessible applications based on the maintenance requester's selection operation of the accessible applications, and responds to the maintenance requester's maintenance requirements for the target application.

[0219] In one embodiment, when a computer program is executed by a processor, the node view includes node status information of the database nodes associated with the target application. This node status information is used by the operation and maintenance request party to perform node selection operations.

[0220] In one embodiment, when the computer program is executed by the processor, the maintenance request is a node deletion request, which instructs the management server to delete the application data of the target application from the target node.

[0221] In one embodiment, when the computer program is executed by the processor, the maintenance request is a node addition request and is used to instruct the management server to add application data of the target application to the target node.

[0222] In one embodiment, when the computer program is executed by the processor, it also performs the following steps:

[0223] Retrieve the operation and maintenance results sent by the management server; update the node view based on the operation and maintenance results, and display it.

[0224] In one embodiment, a computer program product is provided, including a computer program that, when executed by a processor, performs the following steps:

[0225] In response to the maintenance needs of the operation and maintenance client for the target application, a database node viewing request for the target application is sent to the management server to instruct the management server to generate a node view based on the database node information associated with the target application.

[0226] Get and display the node view;

[0227] Based on the node selection operation performed by the operation and maintenance requester on the node view, the target node is determined from the database nodes associated with the target application, and an operation and maintenance request including the target node is sent to the management server to instruct the management server to perform operation and maintenance on the target node; wherein, the number of target nodes is at least two.

[0228] In one embodiment, when the logic of a computer program responding to an operational request from an operational requester for a target application is executed by a processor, the following steps are implemented:

[0229] In response to the login request from the maintenance requester, the system obtains the accessible applications of the maintenance requester based on the identification information of the maintenance requester in the login request; displays the accessible applications; determines the target application from the accessible applications based on the maintenance requester's selection operation of the accessible applications, and responds to the maintenance requester's maintenance requirements for the target application.

[0230] In one embodiment, when a computer program is executed by a processor, the node view includes node status information of the database nodes associated with the target application. This node status information is used by the operation and maintenance request party to perform node selection operations.

[0231] In one embodiment, when the computer program is executed by the processor, the maintenance request is a node deletion request, which instructs the management server to delete the application data of the target application from the target node.

[0232] In one embodiment, when the computer program is executed by the processor, the maintenance request is a node addition request and is used to instruct the management server to add application data of the target application to the target node.

[0233] In one embodiment, when the computer program is executed by the processor, it also performs the following steps:

[0234] Retrieve the operation and maintenance results sent by the management server; update the node view based on the operation and maintenance results, and display it.

[0235] In one embodiment, a computer device is provided, including a memory and a processor, wherein the memory stores a computer program, and the processor executes the computer program to perform the following steps:

[0236] In response to a database node viewing request sent by the terminal, obtain the database node information associated with the target application;

[0237] Based on the database node information associated with the target application, a node view is generated and fed back to the terminal for the terminal to display. Based on the node selection operation performed by the operation and maintenance requester on the node view, the target node is determined from the database nodes associated with the target application, and an operation and maintenance request including the target node is sent to the management server; wherein, the number of target nodes is at least two.

[0238] In response to maintenance requests, perform maintenance on the target node.

[0239] In one embodiment, when the processor executes the logic of a computer program to generate a node view based on database node information associated with the target application, it also implements the following steps:

[0240] Based on the database node information associated with the target application, obtain the node status information of the database nodes associated with the target application; based on the node status information of the database nodes associated with the target application, generate a node view.

[0241] In one embodiment, when the processor executes the logic of a computer program performing maintenance on a target node in response to an maintenance request, it also implements the following steps:

[0242] Based on the database node information associated with the target application, obtain the address information of the target node in the operation and maintenance request; based on the address information, perform operation and maintenance on the target node.

[0243] In one embodiment, when the processor executes the logic of performing maintenance on the target node based on the address information in a computer program, the maintenance request is a node deletion request, and the processor also implements the following steps:

[0244] Based on the address information, a data deletion request for the target application is sent to the target node to request the target node to delete the application data of the target application.

[0245] In one embodiment, when the processor executes the logic in the computer program to add a new node for maintenance requests and to perform maintenance on the target node based on the address information, it also implements the following steps:

[0246] Based on the address information, a data addition request for the target application is sent to the target node to request the target node to add application data for the target application.

[0247] In one embodiment, after the processor executes a computer program to perform maintenance on the target node, it also performs the following steps:

[0248] Update the database node information associated with the target application.

[0249] In one embodiment, a computer-readable storage medium is provided having a computer program stored thereon, the computer program performing the following steps when executed by a processor:

[0250] In response to a database node viewing request sent by the terminal, obtain the database node information associated with the target application;

[0251] Based on the database node information associated with the target application, a node view is generated and fed back to the terminal for the terminal to display. Based on the node selection operation performed by the operation and maintenance requester on the node view, the target node is determined from the database nodes associated with the target application, and an operation and maintenance request including the target node is sent to the management server; wherein, the number of target nodes is at least two.

[0252] In response to maintenance requests, perform maintenance on the target node.

[0253] In one embodiment, when the logic of a computer program generating a node view based on database node information associated with a target application is executed by a processor, the following steps are implemented:

[0254] Based on the database node information associated with the target application, obtain the node status information of the database nodes associated with the target application; based on the node status information of the database nodes associated with the target application, generate a node view.

[0255] In one embodiment, when the logic for performing maintenance on the target node in response to an operation and maintenance request is executed by the processor, the following steps are implemented:

[0256] Based on the database node information associated with the target application, obtain the address information of the target node in the operation and maintenance request; based on the address information, perform operation and maintenance on the target node.

[0257] In one embodiment, the maintenance request in the computer program is a node deletion request. When the logic for performing maintenance on the target node based on the address information is executed by the processor, the following steps are implemented:

[0258] Based on the address information, a data deletion request for the target application is sent to the target node to request the target node to delete the application data of the target application.

[0259] In one embodiment, when the maintenance request in the computer program is a node addition request, and the logic for performing maintenance on the target node based on the address information is executed by the processor, the following steps are implemented:

[0260] Based on the address information, a data addition request for the target application is sent to the target node to request the target node to add application data for the target application.

[0261] In one embodiment, when the logic following the computer program's maintenance of the target node is executed by the processor, the following steps are implemented:

[0262] Update the database node information associated with the target application.

[0263] In one embodiment, a computer program product is provided, including a computer program that, when executed by a processor, performs the following steps:

[0264] In response to a database node viewing request sent by the terminal, obtain the database node information associated with the target application;

[0265] Based on the database node information associated with the target application, a node view is generated and fed back to the terminal for the terminal to display. Based on the node selection operation performed by the operation and maintenance requester on the node view, the target node is determined from the database nodes associated with the target application, and an operation and maintenance request including the target node is sent to the management server; wherein, the number of target nodes is at least two.

[0266] In response to maintenance requests, perform maintenance on the target node.

[0267] In one embodiment, when the logic of a computer program generating a node view based on database node information associated with a target application is executed by a processor, the following steps are implemented:

[0268] Based on the database node information associated with the target application, obtain the node status information of the database nodes associated with the target application; based on the node status information of the database nodes associated with the target application, generate a node view.

[0269] In one embodiment, when the logic for performing maintenance on the target node in response to an operation and maintenance request is executed by the processor, the following steps are implemented:

[0270] Based on the database node information associated with the target application, obtain the address information of the target node in the operation and maintenance request; based on the address information, perform operation and maintenance on the target node.

[0271] In one embodiment, the maintenance request in the computer program is a node deletion request. When the logic for performing maintenance on the target node based on the address information is executed by the processor, the following steps are implemented:

[0272] Based on the address information, a data deletion request for the target application is sent to the target node to request the target node to delete the application data of the target application.

[0273] In one embodiment, when the maintenance request in the computer program is a node addition request, and the logic for performing maintenance on the target node based on the address information is executed by the processor, the following steps are implemented:

[0274] Based on the address information, a data addition request for the target application is sent to the target node to request the target node to add application data for the target application.

[0275] In one embodiment, when the logic following the computer program's maintenance of the target node is executed by the processor, the following steps are implemented:

[0276] Update the database node information associated with the target application.

[0277] It should be noted that the user information (including but not limited to the identification information of the operation and maintenance request party) and data (including but not limited to database node information) involved in this application are all information and data authorized by the user or fully authorized by all parties.

[0278] Those skilled in the art will understand that all or part of the processes in the methods of the above embodiments can be implemented by a computer program instructing related hardware. The computer program can be stored in a non-volatile computer-readable storage medium, and when executed, it can include the processes of the embodiments of the above methods. Any references to memory, databases, or other media used in the embodiments provided in this application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetic random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM). The databases involved in the embodiments provided in this application may include at least one type of relational database and non-relational database. Non-relational databases may include, but are not limited to, blockchain-based distributed databases. The processors involved in the embodiments provided in this application may be general-purpose processors, central processing units, graphics processing units, digital signal processors, programmable logic devices, quantum computing-based data processing logic devices, etc., and are not limited to these.

[0279] The technical features of the above embodiments can be combined in any way. For the sake of brevity, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0280] The embodiments described above are merely illustrative of several implementation methods of this application, and while the descriptions are specific and detailed, they should not be construed as limiting the scope of this patent application. It should be noted that those skilled in the art can make various modifications and improvements without departing from the concept of this application, and these all fall within the protection scope of this application. Therefore, the protection scope of this application should be determined by the appended claims.

Claims

1. A method for operating and maintaining a database node, characterized in that, The method includes: In response to the maintenance requirements of the maintenance client for the target application, a database node viewing request for the target application is sent to the management server to instruct the management server to generate a node view based on the database node information associated with the target application. Obtain and display the node view; Based on the node selection operation performed by the operation and maintenance requester on the node view, a target node is determined from the database nodes associated with the target application, and an operation and maintenance request including the target node is sent to the management server to instruct the management server to perform operation and maintenance on the target node; wherein, the number of target nodes is at least two. The maintenance request is a node deletion request, used to instruct the management server to lock the target node based on the address information of the target node included in the maintenance request, and to delete the application data of the target application from the target node, or The maintenance request is a node addition request, and is used to instruct the management server to find the target node based on the address information of the target node included in the maintenance request, and add the application data of the target application to the target node.

2. The method according to claim 1, characterized in that, The response to the maintenance requirements of the maintenance requester for the target application includes: In response to the login request from the operation and maintenance requester, the accessible applications of the operation and maintenance requester are obtained based on the identification information of the operation and maintenance requester in the login request. Show the accessible applications; Based on the operation and maintenance requester's selection operation of the accessible application, the target application is determined from the accessible application, and the operation and maintenance requester's operation and maintenance request for the target application is responded to.

3. The method according to claim 1, characterized in that, The node view includes node status information of the database nodes associated with the target application, and the node status information is used by the operation and maintenance requester to perform node selection operations.

4. The method according to claim 1, characterized in that, The method further includes: Obtain the operation and maintenance results sent by the management server; Based on the maintenance results, the node view is updated and displayed.

5. A method for operating and maintaining a database node, characterized in that, The method includes: In response to a database node viewing request sent by the terminal, obtain the database node information associated with the target application; Based on the database node information associated with the target application, a node view is generated and fed back to the terminal for the terminal to display. Based on the node selection operation performed by the maintenance requester on the node view, a target node is determined from the database nodes associated with the target application, and an maintenance request including the target node is sent to the management server; wherein, the number of target nodes is at least two. In response to the maintenance request, perform maintenance on the target node; The maintenance request is a node deletion request. Based on the address information, maintenance is performed on the target node, including: Based on the address information, a data deletion request for the target application is sent to the target node to request the target node to delete the application data of the target application, or The maintenance request is a node addition request. Based on the address information, maintenance is performed on the target node, including: Based on the address information, a data addition request for the target application is sent to the target node to request the target node to add application data for the target application.

6. The method according to claim 5, characterized in that, The step of generating a node view based on the database node information associated with the target application includes: Based on the database node information associated with the target application, obtain the node status information of the database node associated with the target application; A node view is generated based on the node status information of the database nodes associated with the target application.

7. The method according to claim 5, characterized in that, The operation and maintenance of the target node in response to the operation and maintenance request includes: Based on the database node information associated with the target application, obtain the address information of the target node in the operation and maintenance request; Based on the address information, the target node is operated and maintained.

8. The method according to claim 5, characterized in that, After performing maintenance on the target node, the process also includes: Update the database node information associated with the target application.

9. A database node operation and maintenance device, characterized in that, The device includes: The first sending module is used to respond to the operation and maintenance needs of the operation and maintenance client for the target application and send a database node viewing request of the target application to the management server, so as to instruct the management server to generate a node view based on the database node information associated with the target application. The view display module is used to acquire and display the node view; The second sending module is used to determine the target node from the database nodes associated with the target application based on the node selection operation performed by the operation and maintenance requester on the node view, and send an operation and maintenance request including the target node to the management server to instruct the management server to perform operation and maintenance on the target node; wherein the number of target nodes is at least two. The maintenance request is a node deletion request, used to instruct the management server to lock the target node based on the address information of the target node included in the maintenance request, and to delete the application data of the target application from the target node, or The maintenance request is a node addition request, and is used to instruct the management server to find the target node based on the address information of the target node included in the maintenance request, and add the application data of the target application to the target node.

10. A database node operation and maintenance device, characterized in that, The device includes: The information acquisition module is used to respond to a database node viewing request sent by the terminal and acquire the database node information associated with the target application. The view feedback module is used to generate a node view based on the database node information associated with the target application, and to feed the node view back to the terminal for the terminal to display. Based on the node selection operation performed by the operation and maintenance requester on the node view, the module determines the target node from the database nodes associated with the target application and sends an operation and maintenance request including the target node to the management server; wherein, the number of target nodes is at least two. The operation and maintenance module is used to perform operation and maintenance on the target node in response to the operation and maintenance request; The maintenance request is a node deletion request. Specifically, the maintenance module is used to send a data deletion request for the target application to the target node based on the address information, requesting the target node to delete the application data of the target application. The maintenance request is a node addition request. Specifically, the maintenance module is used to send a data addition request for the target application to the target node based on the address information, so as to request the target node to add the application data of the target application.

11. A computer device comprising a memory and a processor, wherein the memory stores a computer program, characterized in that, When the processor executes the computer program, it implements the steps of the method according to any one of claims 1 to 8.

12. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by a processor, it implements the steps of the method according to any one of claims 1 to 8.

13. A computer program product, comprising a computer program, characterized in that, When the computer program is executed by a processor, it implements the steps of the method according to any one of claims 1 to 8.

Images