Database management method and device, medium, equipment and computer program product
By displaying the connection relationship diagram in database management, responding to user operation requests and scheduling database operations, the problem of inconvenient database connection management in the existing technology is solved, visual management and efficient operation of the database are realized, and user experience and system stability are improved. .
Patent Information
- Application Number
- CN202411204385.3
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-29
- Publication Date
- 2024-11-15
AI Technical Summary
In the prior art, database connection management requires command line operation, which makes it difficult for users to operate and visual management of database instances to be realized, resulting in low management efficiency and high technical difficulty.
Provide a database management method and device, which displays the connection relationship diagram between database instances, connection terminals and proxy services through the display interface, responds to user operation requests, determines the target node based on proxy services and schedules operation requests, and supports multi-node management and configuration. , realize the visual management of databases, high availability and high performance.
It improves the efficiency of database management, reduces the technical difficulty of user management, ensures the stability and security of database operations, and improves the user experience.
Smart Images

Figure CN118964332A_ABST
Abstract
Description
Technical Field
[0001] The present disclosure relates to the field of computer technology, and in particular, to a database management method, apparatus, medium, device and computer program product. Background Art
[0002] In computer systems, data processing is inseparable from access to databases. How to efficiently manage and utilize database resources is the key to improving application performance. Database connection management is the management, allocation, and release of various database connections. Its goal is to ensure that the database can meet the various connection requirements of user requests.
[0003] The connection terminal is a network proxy service located between the database and the application, and is used to proxy all requests when the application accesses the database. In the related art, the connection terminal usually requires the use of a command line to connect to and manage the database, which is inconvenient for users to use. Summary of the invention
[0004] This summary is provided to introduce concepts in a brief form that will be described in detail in the detailed description below. This summary is not intended to identify key features or essential features of the claimed technical solution, nor is it intended to limit the scope of the claimed technical solution.
[0005] In a first aspect, the present disclosure provides a database management method, the method comprising: In response to receiving an operation to create an instance of a database, a connection relationship diagram corresponding to the created database instance and a target connection terminal is displayed in a display interface, wherein the database instance includes a primary node and a backup node, and the target connection terminal is one of the virtual terminals that establish a connection with the database instance; If it is determined that the database starts the proxy service, a connection relationship diagram corresponding to the database instance, the proxy service and the target connection terminal is displayed in the display interface, wherein the target connection terminal is connected to a node of the database instance through the proxy service; In response to receiving an operation request for the database instance, a target node corresponding to the operation request is determined based on the proxy service, and the operation request is dispatched to the target node.
[0006] In a second aspect, the present disclosure provides a database management device, the device comprising: A first display module is used for displaying a connection relationship diagram corresponding to the created database instance and the target connection terminal in a display interface in response to receiving an instance creation operation for the database, wherein the database instance includes a primary node and a backup node, and the target connection terminal is one of the virtual terminals connected to the database instance; A second display module is used to display a connection relationship diagram corresponding to the database instance, the proxy service and the target connection terminal in the display interface if it is determined that the database starts the proxy service, wherein the target connection terminal is connected to the node of the database instance through the proxy service; The first processing module is used to, in response to receiving an operation request for the database instance, determine a target node corresponding to the operation request based on the proxy service, and schedule the operation request to the target node.
[0007] In a third aspect, the present disclosure provides a computer-readable medium having a computer program stored thereon, which implements the steps of the method described in the first aspect when the computer program is executed by a processing device.
[0008] In a fourth aspect, the present disclosure provides an electronic device, including: a storage device having a computer program stored thereon; A processing device is used to execute the computer program in the storage device to implement the steps of the method described in the first aspect.
[0009] In a fifth aspect, the present disclosure provides a computer program product, including a computer program, which implements the steps of the method described in the first aspect when executed by a processor.
[0010] Through the above technical solution, the connection relationship between the connection terminal, proxy service and database instance can be displayed in the display interface to achieve visual management of the database, effectively improve the efficiency of database management and reduce the technical difficulty of user management. In addition, the database instance can contain multiple nodes, and management through the proxy service can improve the uniformity of node management and configuration, while also providing data support for the high availability and high performance of the database instance, ensuring the stability and security of database operations based on the database instance, and improving the user experience.
[0011] Other features and advantages of the present disclosure will be described in detail in the following detailed description. BRIEF DESCRIPTION OF THE DRAWINGS
[0012] The above and other features, advantages and aspects of the embodiments of the present disclosure will become more apparent with reference to the following detailed description in conjunction with the accompanying drawings. Throughout the drawings, the same or similar reference numerals represent the same or similar elements. It should be understood that the drawings are schematic and the originals and elements are not necessarily drawn to scale. In the drawings: Figure 1 It is a flowchart of a database management method provided according to an embodiment of the present disclosure.
[0013] Figure 2 It is a schematic diagram of a display interface provided according to an embodiment of the present disclosure.
[0014] Figure 3 It is a schematic diagram of a display interface provided according to another embodiment of the present disclosure.
[0015] Figure 4 is a schematic diagram of an example configuration interface provided according to another embodiment of the present disclosure.
[0016] Figure 5 It is a schematic diagram of a display interface provided according to another embodiment of the present disclosure.
[0017] Figure 6 It is a schematic diagram of a display interface provided according to another embodiment of the present disclosure.
[0018] Figure 7 It is a schematic diagram of a display interface provided according to another embodiment of the present disclosure.
[0019] Figure 8 It is a block diagram of a database management device provided according to an embodiment of the present disclosure.
[0020] Fig. 9 A schematic diagram of the structure of an electronic device suitable for implementing the embodiments of the present disclosure is shown. DETAILED DESCRIPTION
[0021] Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although certain embodiments of the present disclosure are shown in the accompanying drawings, it should be understood that the present disclosure can be implemented in various forms and should not be construed as being limited to the embodiments described herein, which are instead provided for a more thorough and complete understanding of the present disclosure. It should be understood that the drawings and embodiments of the present disclosure are only for exemplary purposes and are not intended to limit the scope of protection of the present disclosure.
[0022] It should be understood that the various steps described in the method embodiments of the present disclosure may be performed in different orders and / or in parallel. In addition, the method embodiments may include additional steps and / or omit the steps shown. The scope of the present disclosure is not limited in this respect.
[0023] The term "including" and its variations used herein are open inclusions, i.e., "including but not limited to". The term "based on" means "based at least in part on". The term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one additional embodiment"; the term "some embodiments" means "at least some embodiments". The relevant definitions of other terms will be given in the following description.
[0024] It should be noted that the concepts such as "first" and "second" mentioned in the present disclosure are only used to distinguish different devices, modules or units, and are not used to limit the order or interdependence of the functions performed by these devices, modules or units.
[0025] It should be noted that the modifications of "one" and "plurality" mentioned in the present disclosure are illustrative rather than restrictive, and those skilled in the art should understand that unless otherwise clearly indicated in the context, it should be understood as "one or more".
[0026] The names of the messages or information exchanged between multiple devices in the embodiments of the present disclosure are only used for illustrative purposes and are not used to limit the scope of these messages or information.
[0027] It is understandable that before using the technical solutions disclosed in the embodiments of the present disclosure, the types, scope of use, usage scenarios, etc. of the personal information involved in the present disclosure should be informed to the user and the user's authorization should be obtained in an appropriate manner in accordance with relevant laws and regulations.
[0028] For example, in response to receiving an active request from a user, a prompt message is sent to the user to clearly prompt the user that the operation requested to be performed will require obtaining and using the user's personal information. Thus, the user can autonomously choose whether to provide personal information to software or hardware such as an electronic device, application, server, or storage medium that performs the operation of the technical solution of the present disclosure according to the prompt message.
[0029] As an optional but non-limiting implementation, in response to receiving an active request from the user, the prompt information may be sent to the user in the form of a pop-up window, in which the prompt information may be presented in text form. In addition, the pop-up window may also carry a selection control for the user to choose "agree" or "disagree" to provide personal information to the electronic device.
[0030] It is understandable that the above notification and the process of obtaining user authorization are merely illustrative and do not constitute a limitation on the implementation of the present disclosure. Other methods that meet the relevant laws and regulations may also be applied to the implementation of the present disclosure.
[0031] At the same time, it is understandable that the data involved in this technical solution (including but not limited to the data itself, the acquisition or use of the data) shall comply with the requirements of relevant laws, regulations and relevant provisions.
[0032] Figure 1 As shown, it is a flowchart of a database management method provided according to an embodiment of the present disclosure, as shown in Figure 1 As shown, the method may include: In step 11, in response to receiving an instance creation operation for a database, a connection relationship diagram corresponding to the created database instance and the target connection terminal is displayed in a display interface, wherein the database instance includes a primary node and a backup node, and the target connection terminal is one of the virtual terminals that establish a connection with the database instance.
[0033] Among them, an instance of a database can be used to load and open the database, so as to access and modify the data in the database. The instance creation operation of the database can be configured based on the configuration interface, such as configuring at least part of the instance name, instance type, node specification, storage space, whitelist, etc. of the database. The instance type can be used to indicate whether the instance supports dual nodes (i.e., active and standby nodes). The storage space can be configured by the user based on the actual application scenario. The node specification is used to indicate the node information contained in the database instance. The whitelist is a security control method for database connection. Only IP addresses in the whitelist can access the database. For example, after the database instance is created, it will not be bound to any whitelist, and all IP addresses are prohibited from accessing the instance by default. Therefore, whether the instance is accessed through the VPC (Virtual Private Cloud) intranet or through the public network connection, the instance whitelist must be configured first to ensure that the instance can be connected to ensure the security of data access in the database. A database instance may include a master node and a standby node, wherein the master node is in operation, and the connection terminal realizes the connection to the database through the master node, and the standby node is usually not working, and it realizes data synchronization with the master node, so as to switch to the standby node to work when the master node fails or is abnormal, so as to ensure effective access to the database. Accordingly, after the instance is configured, the terminal can realize data access to the database through the nodes in the instance.
[0034] In this embodiment, in order to ensure the clarity of database management, the connection relationship between the created database instance and the connection terminal can be displayed in the display interface. It should be noted that after the database instance is created, it may correspond to a default terminal, and the target connection terminal is the default terminal in the initial case. As an example, the connection relationship diagram generated in this scenario is as follows: Figure 2As shown, the connection relationship includes a direct connection relationship between the connection terminal C and the node N (N0, N1...) in the database instance, so as to realize the terminal access to the database.
[0035] In step 12, if it is determined that the database starts the proxy service, a connection relationship diagram corresponding to the database instance, the proxy service and the target connection terminal is displayed in the display interface, wherein the target connection terminal is connected to the node of the database instance through the proxy service.
[0036] The database can display a proxy service configuration control when configuring, and the user can enable the proxy service by selecting the control. The proxy service is used to manage the connection relationship between the connection terminal and the node and distribute the operation request of the connection terminal to the database.
[0037] Therefore, in this embodiment, if the proxy service is turned on, the connection terminal C is connected to the node N (N0, N1...) in the database instance through the proxy service D, rather than directly connecting to the node. The connection relationship diagram in this scenario is as follows: Figure 3 shown.
[0038] In step 13, in response to receiving an operation request for a database instance, a target node corresponding to the operation request is determined based on a proxy service, and the operation request is dispatched to the target node.
[0039] As an example, the connection terminal can send an operation request, which may include a read operation request, a write operation request, a read-write operation request, etc., and then the target node corresponding to the operation request can be determined based on the configuration proxy service to achieve centralized multi-node scheduling of the operation request.
[0040] Therefore, through the above technical solution, the connection relationship between the connection terminal, the proxy service and the database instance can be displayed in the display interface to achieve visual management of the database, effectively improve the efficiency of database management and reduce the technical difficulty of user management. In addition, the database instance can contain multiple nodes, and management through the proxy service can improve the uniformity of node management and configuration, while also providing data support for the high availability and high performance of the database instance, ensuring the stability and security of database operations based on the database instance, and improving the user experience.
[0041] In a possible embodiment, the method may further include: In response to receiving a node configuration change operation for the database instance, an instance configuration interface is displayed, wherein the instance configuration interface displays a plurality of instance attributes to be changed, such as instance type, node specification, etc.
[0042] In response to receiving a node adding operation in the instance configuration interface, configuration items corresponding to the newly added node are displayed in the instance configuration interface, and the configuration items include node specifications and node areas.
[0043] Among them, a node adding control can be displayed at the same time as each node is displayed in the node specification, and the user can trigger the node adding operation by clicking the node adding control. The node adding control is as follows: Figure 4 When receiving the node adding operation, the configuration items corresponding to the newly added node can be displayed in the instance configuration interface, such as Figure 4 As shown in , it includes configuration items such as node specification P1 and node region P2. Users can select and input the corresponding configuration items to configure the configuration items. The configuration items of the node specification can be used to indicate the number of CPUs and memory resources corresponding to the node, and the configuration items of the node region are used to indicate the geographical area to which the node belongs. For example, in order to ensure the read and write efficiency of nodes in the database instance and avoid node write conflicts, the node type of the newly added node can be set to read-only type by default.
[0044] In response to receiving a configuration operation on the configuration item, a new node of the database instance is generated, and the new node is displayed in the connection relationship diagram.
[0045] For example, the user can make a selection from the node specification P1. If the user clicks P1, multiple candidate specifications can be displayed, such as 1 core 1GB, 1 core 2GB, etc. Among them, 1 core 1GB is used to represent 1 CPU core and 1GB of memory resources. In addition, the user can click P2 to display multiple candidate regions, such as the East China region, the North China region, etc. The multiple candidate regions and specifications can be pre-configured based on the actual application scenario for the user to choose. After the user makes the corresponding selection, the newly added node can be generated based on the node specification for use by the database instance. At the same time, the newly added node can be displayed in the connection relationship diagram so that the user can perceive the newly added node configured.
[0046] As an example, after the user's configuration operation is submitted and before the new node of the database instance is generated, a configuration comparison interface can be displayed. In the configuration comparison interface, the configuration information of the database instance before the current configuration operation is submitted and the configuration information of the database instance after the current configuration operation takes effect can be displayed respectively, so that the user can clearly understand the impact of the current configuration operation on the database instance. After the user confirms the configuration change, the new node of the database instance can be generated and displayed in the connection relationship diagram for the user to confirm again to ensure the accuracy of the generation of the new node.
[0047] Therefore, through the above technical solution, the configuration of the database instance can be changed so that the database instance matches the user's usage requirements, and the user can understand the specific configuration of the database instance in real time through the visualization of the instance node, so as to subsequently match the association relationship between the connection terminal and the node, and provide support for the subsequent improvement of the high performance and load balancing of the database instance.
[0048] As an example, if the number of nodes in the display interface is greater than the size of the display area in the display interface, a vertical sliding operation can be performed to implement sliding display of the display area so that the user can browse each node in the database instance.
[0049] In a possible embodiment, the method may further include: In response to receiving the terminal adding operation, a terminal configuration interface is displayed, in which the terminal attributes to be configured are displayed, and the terminal attributes include terminal type, read / write mode, and associated nodes.
[0050] As an example, when displaying the connected terminals in the display interface, a terminal adding control can be displayed, and the user can trigger the terminal adding operation by clicking the terminal adding control, such as Figure 3 After that, the terminal configuration interface may be displayed, which may include the terminal properties to be configured, for example, the terminal type may include a proxy type and a direct connection type, wherein the proxy type terminal needs to go through a proxy service to connect to the database, and the direct connection type terminal can directly connect to the database without going through a proxy service, and the proxy type terminal can use the relevant configuration of the proxy service.
[0051] The read-write mode can be used to indicate the type of operation request of the terminal to the database. The read-write mode can include the read-write type, which means that the operation request of the terminal to the database can include read request and write request, that is, the terminal can read, write and modify the data in the database. The read-write mode can also include the read-only type, which means that the operation request of the terminal to the database only includes read request, that is, the terminal can only read the data in the database. During configuration, the user can select and configure the above configuration items based on actual usage requirements.
[0052] The associated node is used to represent the node associated with the terminal in the database instance. During configuration, all valid nodes in the database instance can be displayed. The user can then select at least one from the displayed nodes for association, thereby determining the associated node corresponding to the terminal, wherein the terminal accesses data in the database through its associated node.
[0053] As another example, if the user selects a proxy-type terminal, the connection pool configuration items can be further displayed in the terminal configuration interface, and the user can select a transaction-level connection pool or close the connection pool. The transaction-level connection pool can support connection reuse, thereby reducing the number of connections directly connected to the database and reducing the load caused by frequent connection establishment in scenarios with more short connections. In a transaction-level connection pool, the same client can use connections from multiple database proxies.
[0054] Afterwards, in response to receiving a configuration operation on the terminal attribute, a newly added connection terminal is generated.
[0055] The newly added connected terminal is displayed in the terminal list in the display interface.
[0056] After the user performs corresponding configuration based on the above configuration items, a new connection terminal can be generated based on the user's configuration and displayed so that the user can promptly perceive that the creation of the terminal is completed and can view the specific information of the newly added connection terminal. Figure 3 As shown, the terminal list L in the display interface may include various connection terminals that have a connection relationship with the database instance, so as to facilitate the user to uniformly manage various connection terminals and improve the effectiveness and efficiency of database management.
[0057] In a possible embodiment, the method may further include: In response to receiving a switching operation on a connection terminal, candidate terminals are displayed, wherein the candidate terminals include a plurality of connection terminals connected to the database instance.
[0058] When displaying a connection relationship diagram in the display interface, a switch control is displayed at a target position corresponding to a target connection terminal in the connection relationship diagram to switch the target connection terminal. The user can trigger the switching operation by clicking the switch control, and then the candidate terminal can be displayed in the form of a drop-down menu at the target position. For example, each connection terminal in the list described above can be displayed.
[0059] Afterwards, in response to the received selection operation on the candidate terminal, the terminal type of the selected candidate terminal is determined.
[0060] Among them, in the embodiment of the present disclosure, the connection terminal may include a proxy type terminal and a direct connection type terminal, and the corresponding connection relationship diagrams are displayed in different ways. In this step, the terminal type of the selected candidate terminal can be determined, which can be determined based on the configuration information of the selected candidate terminal.
[0061] If the terminal type is a proxy type, the connection relationship diagram corresponding to the database instance, the proxy service and the selected candidate terminal is displayed in the display interface. In this scenario, the proxy type terminal needs to connect to the node through the proxy service, and its corresponding connection relationship diagram is the same as Figure 3 The above is similar to what is shown, and will not be repeated here.
[0062] If the terminal type is a direct connection type, the connection relationship diagram corresponding to the database instance and the selected candidate terminal is displayed in the display interface. In this scenario, the direct connection type terminal is directly connected to the node, and its corresponding connection relationship diagram is the same as Figure 2 The above is similar to what is shown, and will not be repeated here.
[0063] Therefore, through the above technical solution, the information of multiple terminals can be comprehensively displayed in the connection relationship diagram in the display interface, and the connection relationship diagram can be displayed by terminal, so that the user can view the connection relationship between the specific connection terminal and the database by switching the terminal, effectively simplifying the complexity of the connection relationship diagram, and the database instance, proxy service and connection terminal can complete the creation, connection and switching operations in the visual interface, so as to effectively simplify the user's database management operations.
[0064] In a possible embodiment, the method may further include: Detecting the position of the mouse in the display interface.
[0065] The detection may be performed by a common mouse position detection method in the art, and the present disclosure does not limit this.
[0066] In response to detecting that the mouse position moves to a hovering element in the connection relationship diagram, hovering information configured for the hovering element is displayed.
[0067] In this embodiment, the element that needs to be hovered and its hovering information can be pre-set based on the actual application scenario requirements as the hovering element. When the mouse moves to the hovering element during the display of the connection relationship diagram, the corresponding hovering information can be displayed to prompt the user.
[0068] Therefore, through the above technical solution, while the direct or proxy connection relationship between the connection terminal and the node is displayed through the connection relationship diagram, the user can also view specific node or terminal information from the connection relationship diagram by moving the mouse, thereby further improving the comprehensiveness of the information in the connection relationship diagram displayed to the user and enhancing the user experience.
[0069] As an example, the displaying of the hover information of the hover element configuration may include: If the hovering element is a connected terminal, terminal information of the connected terminal is displayed, and the terminal information includes at least one of a terminal identifier, a terminal operating status, a terminal type, and a connected network address.
[0070] The connection network address may include a public network address and a private network address, which may be specifically configured by the user and is not limited in this disclosure.
[0071] like Figure 5 As shown, when the mouse position moves to the area corresponding to the connected terminal, the terminal information of the connected terminal can be displayed, wherein the terminal information to be displayed can be set based on the actual application scenario. For example, in this example, the terminal identification 61, terminal operation status 62, terminal type 63, public network 64 and private network 65 in the connected network address can be displayed to prompt the user so that the user can quickly understand the detailed information of the connected terminal.
[0072] If the hovering element is a node other than a standby node, node information of the node is displayed, where the node information includes at least one of a node identifier, a number of nodes associated with the node, and a node operating status.
[0073] If the hovering element is a node other than a standby node, that is, the hovering element can be a master node or a read-only node, then in this scenario Figure 6 As shown, the information of the node can be displayed. For example, the node identification 71, the number of nodes associated with the terminal 72, and the node operation status 73 can be displayed. When the user selects the number of nodes associated with the terminal 72, each terminal associated with the node can be further displayed, such as Figure 6 As shown in 74.
[0074] If the hovering element is a standby node, node information and operation information of the standby node are displayed, and the operation information is used to switch the standby node to a master node.
[0075] If the hovering element is a standby node, the user can switch it to the main node for use based on his needs in the actual application scenario. In this embodiment, Figure 7 As shown, the node information and operation information 81 of the standby node can be displayed. When the user selects the operation information 81, the standby node can be switched to the master node, and the original master node can be used as the standby node to achieve node switching.
[0076] Therefore, through the above technical solution, the relevant information of nodes and terminals can be prompted in the relationship connection diagram, so that users can understand the information of specific nodes or terminals while viewing the overall relationship diagram of database connections, thereby improving the comprehensiveness of user information viewing and enhancing user experience.
[0077] As an example, the hovering element is a read-only node or a backup node. The node information may also include a delay status, which can be used to indicate the delay in data synchronization of the node from the primary node. The delay status can be determined by the usual delay calculation method in the art based on the data synchronization transmission volume and bandwidth, etc., which will not be elaborated here.
[0078] In a possible embodiment, when configuring the connection terminal, if the user selects a proxy type, then when configuring the proxy type terminal, the terminal attributes may also include a read-write separation configuration, wherein the read-write separation is used to indicate that read operations and write operations on the database are distributed to different nodes.
[0079] If the operation request is a write operation request, the master node may be used as the target node corresponding to the operation request, so that the master node responds to and processes the write operation request.
[0080] The operation request is a read operation request, and in response to receiving the operation request for the database instance, determining a target node corresponding to the operation request based on the proxy service may include: In response to receiving an operation request for the database instance, a connection terminal corresponding to the operation request is determined. In this embodiment, when an operation request is received, the connection terminal can be determined from the request information of the operation request.
[0081] If the connection terminal corresponding to the operation request is a proxy type terminal and the data read-write separation mode of the connection terminal is turned on, the target node is determined from the read-only type nodes in the database instance based on the proxy service and the scheduling policy pre-configured for the connection terminal.
[0082] Among them, for the terminal of the proxy type, it can be pre-configured whether the data read-write separation mode of the connection terminal is turned on. When the operation request of the connection terminal is received, the type of the connection terminal and whether the data read-write separation mode is turned on can be determined based on the configuration information of the connection terminal. When the data read-write separation mode is turned on, the read operation request will be sent to the read-only type node for response processing. And when configuring the data read-write separation mode, the corresponding scheduling strategy can also be configured at the same time. For example, load scheduling and polling scheduling can be displayed during configuration. Among them, load scheduling can be sending the read operation request to the associated read-only node with lower load, and polling scheduling is based on the read request weight of each read-only node. The read operation request is polled and scheduled to the associated node. For example, the database instance has 3 read-only nodes, and the read request weights are 100, 200 and 200 respectively, which means that the 3 read-only nodes process the read operation request in a ratio of 1:2:2.
[0083] In this embodiment, the distribution and processing of read operation requests can be implemented based on the proxy service to ensure the load balancing of each node during database access, improve the security and stability of database access, and support data reading and writing separation, which can effectively avoid write conflicts in write operation requests and avoid read operations occupying the bandwidth of the main node, thereby improving the utilization rate of database resources.
[0084] If the connection terminal corresponding to the operation request is a proxy type terminal and the data read-write separation mode of the connection terminal is not turned on, the target node is determined from the read-only type nodes and the master node of the database instance based on the scheduling policy pre-configured by the proxy service and the connection terminal.
[0085] In this scenario, the proxy service can be scheduled based on the nodes associated with the connection terminal, wherein the configuration and application of the scheduling strategy are similar to the steps described above and will not be repeated here.
[0086] Therefore, through the above technical solution, the strategy of read operation request can be scheduled from multiple nodes of the database instance based on the proxy service and the pre-configured scheduling strategy, thereby ensuring high performance of database access and improving user experience.
[0087] As another example, if the connection terminal corresponding to the operation request is a direct connection terminal, when the direct connection terminal is a read-write type terminal, the target node corresponding to its operation request is the master node; when the direct connection terminal is a read-only type terminal, the target node corresponding to its operation request is a read-only node, so that after receiving the operation request, it is distributed based on the rule to enable the direct connection terminal to access the database.
[0088] In a possible embodiment, the method may further include: Determine data connection weight information corresponding to each node of the database instance, wherein the data connection weight information is used to represent the relationship between the amount of data in the node and the data capacity of the node.
[0089] As an example, the data connection weight information is used to represent the ratio of the amount of data in the node to the data capacity of the node. The data of the standby node and the read-only node are synchronized from the master node. Normally, the memory resource amount, that is, the data capacity, of each node is the same. Then, the data connection weight information of the standby node and the read-only node is less than or equal to the data connection weight information of the master node. When it is equal to the data connection weight information of the master node, it indicates that the node has completed data synchronization from the master node.
[0090] The data connection weight information corresponding to each of the nodes is displayed in the connection relationship diagram.
[0091] As an example, the connection relationship diagram of the display interface may also include data connection weight information of each node in the database instance, so that the status of data synchronization can be displayed in the connection relationship diagram. Furthermore, the data synchronization delay information can be displayed while displaying the data connection weight information to further enable the user to perceive the delay of data synchronization between different nodes. Among them, the data synchronization delay information between different nodes can be determined based on the data synchronization amount and the transmission bandwidth, such as based on the delay calculation method in the art, and the present disclosure does not limit this.
[0092] In a possible embodiment, the method may further include: generating a disaster recovery instance corresponding to the database instance based on the configuration operation of the user, wherein the instance may be added through the adding control X1 in the connection relationship diagram, such as Figure 3 The two are usually located in different computer rooms, so that when the database instance encounters a failure due to force majeure, a database data solution is provided based on the disaster recovery instance to improve the disaster recovery capability of the database. The disaster recovery instance can also be displayed in the connection relationship diagram.
[0093] Based on the same inventive concept, the present disclosure also provides a database management device, such as Figure 8 As shown, the device 10 comprises: A first display module 100 is used to display a connection relationship diagram corresponding to the created database instance and the target connection terminal in a display interface in response to receiving an instance creation operation for the database, wherein the database instance includes a primary node and a backup node, and the target connection terminal is one of the virtual terminals connected to the database instance; The second display module 200 is used to display a connection relationship diagram corresponding to the database instance, the proxy service and the target connection terminal in the display interface if it is determined that the database starts the proxy service, wherein the target connection terminal is connected to the node of the database instance through the proxy service; The first processing module 300 is configured to, in response to receiving an operation request for the database instance, determine a target node corresponding to the operation request based on the proxy service, and schedule the operation request to the target node.
[0094] Optionally, the device further comprises: A third display module, configured to display an instance configuration interface in response to receiving a node configuration change operation on the database instance; A fourth display module, configured to display configuration items corresponding to the newly added node in the instance configuration interface in response to receiving a node addition operation in the instance configuration interface, wherein the configuration items include node specifications and node regions; The second processing module is used to generate a new node of the database instance in response to receiving a configuration operation on the configuration item, and display the new node in the connection relationship diagram.
[0095] Optionally, the device further comprises: A fifth display module, configured to display a terminal configuration interface in response to receiving a terminal addition operation, wherein the terminal configuration interface displays terminal attributes to be configured, wherein the terminal attributes include terminal type, read / write mode, and associated nodes; A generating module, configured to generate a newly added connection terminal in response to receiving a configuration operation on the terminal attribute; The sixth display module is used to display the newly added connection terminal in the terminal list in the display interface.
[0096] Optionally, the device further comprises: a seventh display module, configured to display candidate terminals in response to receiving a switching operation on a connection terminal, wherein the candidate terminals include a plurality of connection terminals connected to the database instance; A first determining module, configured to determine a terminal type of a selected candidate terminal in response to a selection operation on a candidate terminal received; The eighth display module is used to display the connection relationship diagram corresponding to the database instance, the proxy service and the selected candidate terminal in the display interface if the terminal type is a proxy type; if the terminal type is a direct connection type, then the connection relationship diagram corresponding to the database instance and the selected candidate terminal is displayed in the display interface.
[0097] Optionally, the device further comprises: A detection module, used to detect the position of the mouse in the display interface; A ninth display module is used to display the hovering information configured for the hovering element in response to detecting that the mouse position moves to the hovering element in the connection relationship diagram.
[0098] Optionally, the ninth display module includes: A first display submodule, configured to display terminal information of the connected terminal if the hovering element is a connected terminal, wherein the terminal information includes at least one of a terminal identifier, a terminal operation status, a terminal type, and a connected network address; A second display submodule, configured to display node information of the node if the hovering element is a node other than a standby node, wherein the node information includes at least one of a node identifier, a number of nodes associated with the node, and a node operation status; The third display submodule is used to display node information and operation information of the standby node if the hovering element is a standby node, wherein the operation information is used to switch the standby node to a master node.
[0099] Optionally, the operation request is a read operation request, and the first processing module includes: A first determining submodule, configured to, in response to receiving an operation request for the database instance, determine a connection terminal corresponding to the operation request; A first processing submodule is configured to determine the target node from the read-only type nodes in the database instance based on the proxy service and a scheduling policy pre-configured for the connection terminal if the connection terminal corresponding to the operation request is a proxy type terminal and the data read-write separation mode of the connection terminal is turned on; The second processing sub-module is used to determine the target node from the read-only type nodes and the master node of the database instance based on the proxy service and the scheduling strategy pre-configured for the connection terminal if the connection terminal corresponding to the operation request is a proxy type terminal and the data read-write separation mode of the connection terminal is not turned on.
[0100] Optionally, the device further comprises: A second determination module is used to determine data connection weight information corresponding to each node of the database instance, wherein the data connection weight information is used to represent the relationship between the amount of data in the node and the data capacity of the node; The tenth display module is used to display the data connection weight information corresponding to each of the nodes in the connection relationship diagram.
[0101] Reference below Fig. 9 , which shows a schematic diagram of the structure of an electronic device (such as a terminal device or a server) 600 suitable for implementing the embodiment of the present disclosure. The terminal device in the embodiment of the present disclosure may include but is not limited to mobile terminals such as mobile phones, notebook computers, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), vehicle-mounted terminals (such as vehicle-mounted navigation terminals), etc., and fixed terminals such as digital TVs, desktop computers, etc. Fig. 9 The electronic device shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present disclosure.
[0102] like Fig. 9As shown, the electronic device 600 may include a processing device (e.g., a central processing unit, a graphics processing unit, etc.) 601, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 602 or a program loaded from a storage device 608 into a random access memory (RAM) 603. In the RAM 603, various programs and data required for the operation of the electronic device 600 are also stored. The processing device 601, the ROM 602, and the RAM 603 are connected to each other via a bus 604. An input / output (I / O) interface 605 is also connected to the bus 604.
[0103] Typically, the following devices may be connected to the I / O interface 605: an input device 606 including, for example, a touch screen, a touch pad, a keyboard, a mouse, a camera, a microphone, an accelerometer, a gyroscope, etc.; an output device 607 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, etc.; a storage device 608 including, for example, a magnetic tape, a hard disk, etc.; and a communication device 609. The communication device 609 may allow the electronic device 600 to communicate with other devices wirelessly or by wire to exchange data. Although Fig. 9 The electronic device 600 is shown with various devices, but it should be understood that it is not required to implement or possess all the devices shown. More or fewer devices may be implemented or possessed instead.
[0104] In particular, according to an embodiment of the present disclosure, the process described above with reference to the flowchart can be implemented as a computer software program. For example, an embodiment of the present disclosure includes a computer program product, which includes a computer program carried on a non-transitory computer-readable medium, and the computer program contains program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from a network through a communication device 609, or installed from a storage device 608, or installed from a ROM 602. When the computer program is executed by the processing device 601, the above-mentioned functions defined in the method of the embodiment of the present disclosure are executed.
[0105] It should be noted that the computer-readable medium mentioned above in the present disclosure may be a computer-readable signal medium or a computer-readable storage medium or any combination of the above two. The computer-readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present disclosure, a computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in combination with an instruction execution system, device or device. In the present disclosure, a computer-readable signal medium may include a data signal propagated in a baseband or as part of a carrier wave, which carries a computer-readable program code. This propagated data signal may take a variety of forms, including but not limited to an electromagnetic signal, an optical signal, or any suitable combination of the above. Computer readable signal media may also be any computer readable medium other than computer readable storage media, which may send, propagate or transmit a program for use by or in conjunction with an instruction execution system, apparatus or device. The program code contained on the computer readable medium may be transmitted using any appropriate medium, including but not limited to: wires, optical cables, RF (radio frequency), etc., or any suitable combination of the above.
[0106] In some embodiments, the client and the server may communicate using any currently known or future developed network protocol such as HTTP (HyperText Transfer Protocol), and may be interconnected with any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), an internet (e.g., the Internet), and a peer-to-peer network (e.g., an ad hoc peer-to-peer network), as well as any currently known or future developed network.
[0107] The computer-readable medium may be included in the electronic device, or may exist independently without being incorporated into the electronic device.
[0108] The computer-readable medium carries one or more programs. When the one or more programs are executed by the electronic device, the electronic device: in response to receiving an instance creation operation for a database, displays a connection relationship diagram corresponding to the created database instance and the target connection terminal in a display interface, wherein the database instance includes a primary node and a backup node, and the target connection terminal is one of the virtual terminals that establish a connection with the database instance; if it is determined that the database starts a proxy service, displays a connection relationship diagram corresponding to the database instance, the proxy service and the target connection terminal in the display interface, wherein the target connection terminal is connected to the node of the database instance through the proxy service; in response to receiving an operation request for the database instance, determines the target node corresponding to the operation request based on the proxy service, and schedules the operation request to the target node.
[0109] Computer program code for performing the operations of the present disclosure may be written in one or more programming languages or a combination thereof, including, but not limited to, object-oriented programming languages, such as Java, Smalltalk, C++, and conventional procedural programming languages, such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., through the Internet using an Internet service provider).
[0110] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present disclosure. In this regard, each square box in the flow chart or block diagram can represent a module, a program segment or a part of a code, and the module, the program segment or a part of the code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some implementations as replacements, the functions marked in the square box can also occur in a sequence different from that marked in the accompanying drawings. For example, two square boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each square box in the block diagram and / or flow chart, and the combination of the square boxes in the block diagram and / or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.
[0111] The modules involved in the embodiments described in the present disclosure may be implemented by software or hardware. The name of the module does not limit the module itself in some cases. For example, the first display module may also be described as "a module that displays the connection relationship diagram corresponding to the created database instance and the target connection terminal in the display interface in response to receiving an instance creation operation for the database".
[0112] The functions described above herein may be performed at least in part by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), complex programmable logic devices (CPLDs), and the like.
[0113] In the context of the present disclosure, a machine-readable medium may be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, device, or equipment. A machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or device, or any suitable combination of the foregoing. A more specific example of a machine-readable storage medium may include an electrical connection based on one or more lines, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
[0114] According to one or more embodiments of the present disclosure, Example 1 provides a database management method, wherein the method includes: In response to receiving an operation to create an instance of a database, a connection relationship diagram corresponding to the created database instance and a target connection terminal is displayed in a display interface, wherein the database instance includes a primary node and a backup node, and the target connection terminal is one of the virtual terminals that establish a connection with the database instance; If it is determined that the database starts the proxy service, a connection relationship diagram corresponding to the database instance, the proxy service and the target connection terminal is displayed in the display interface, wherein the target connection terminal is connected to a node of the database instance through the proxy service; In response to receiving an operation request for the database instance, a target node corresponding to the operation request is determined based on the proxy service, and the operation request is dispatched to the target node.
[0115] According to one or more embodiments of the present disclosure, Example 2 provides the method of Example 1, wherein the method further includes: In response to receiving a node configuration change operation on the database instance, displaying an instance configuration interface; In response to receiving a node adding operation in the instance configuration interface, displaying configuration items corresponding to the newly added node in the instance configuration interface, the configuration items including node specifications and node regions; In response to receiving a configuration operation on the configuration item, a new node of the database instance is generated, and the new node is displayed in the connection relationship diagram.
[0116] According to one or more embodiments of the present disclosure, Example 3 provides the method of Example 1, wherein the method further includes: In response to receiving the terminal adding operation, displaying a terminal configuration interface, wherein the terminal configuration interface displays terminal attributes to be configured, wherein the terminal attributes include terminal type, read / write mode, and associated nodes; In response to receiving a configuration operation on the terminal attribute, generating a newly added connection terminal; The newly added connected terminal is displayed in the terminal list in the display interface.
[0117] According to one or more embodiments of the present disclosure, Example 4 provides the method of Example 3, wherein the method further includes: In response to receiving a switching operation on a connection terminal, displaying candidate terminals, wherein the candidate terminals include a plurality of connection terminals connected to the database instance; In response to receiving a selection operation on a candidate terminal, determining a terminal type of the selected candidate terminal; If the terminal type is a proxy type, a connection relationship diagram corresponding to the database instance, the proxy service and the selected candidate terminal is displayed in the display interface; If the terminal type is a direct connection type, a connection relationship diagram corresponding to the database instance and the selected candidate terminal is displayed in the display interface.
[0118] According to one or more embodiments of the present disclosure, Example 5 provides the method of Example 1, wherein the method further includes: Detecting a mouse position in the display interface; In response to detecting that the mouse position moves to a hovering element in the connection relationship diagram, hovering information configured for the hovering element is displayed.
[0119] According to one or more embodiments of the present disclosure, Example 6 provides the method of Example 5, wherein the displaying the hover information of the hover element configuration includes: If the hovering element is a connected terminal, terminal information of the connected terminal is displayed, wherein the terminal information includes at least one of a terminal identifier, a terminal operation status, a terminal type, and a connected network address; If the hovering element is a node other than a standby node, display node information of the node, where the node information includes at least one of a node identifier, a number of nodes associated with the node, and a node operation status; If the hovering element is a standby node, node information and operation information of the standby node are displayed, and the operation information is used to switch the standby node to a master node.
[0120] According to one or more embodiments of the present disclosure, Example 7 provides the method of Example 1, wherein the operation request is a read operation request, and in response to receiving the operation request for the database instance, determining a target node corresponding to the operation request based on the proxy service includes: In response to receiving an operation request for the database instance, determining a connection terminal corresponding to the operation request; If the connection terminal corresponding to the operation request is a proxy type terminal, and the data read-write separation mode of the connection terminal is turned on, then based on the proxy service and the scheduling policy pre-configured for the connection terminal, determine the target node from the read-only type nodes in the database instance; If the connection terminal corresponding to the operation request is a proxy type terminal and the data read-write separation mode of the connection terminal is not turned on, the target node is determined from the read-only type nodes and the master node of the database instance based on the scheduling policy pre-configured by the proxy service and the connection terminal.
[0121] According to one or more embodiments of the present disclosure, Example 8 provides the method of Example 1, wherein the method further includes: Determine data connection weight information corresponding to each node of the database instance, wherein the data connection weight information is used to represent the relationship between the amount of data in the node and the data capacity of the node; The data connection weight information corresponding to each of the nodes is displayed in the connection relationship diagram.
[0122] According to one or more embodiments of the present disclosure, Example 9 provides a database management device, the device comprising: A first display module is used for displaying a connection relationship diagram corresponding to the created database instance and the target connection terminal in a display interface in response to receiving an instance creation operation for the database, wherein the database instance includes a primary node and a backup node, and the target connection terminal is one of the virtual terminals connected to the database instance; A second display module is used to display a connection relationship diagram corresponding to the database instance, the proxy service and the target connection terminal in the display interface if it is determined that the database starts the proxy service, wherein the target connection terminal is connected to the node of the database instance through the proxy service; The first processing module is used to, in response to receiving an operation request for the database instance, determine a target node corresponding to the operation request based on the proxy service, and schedule the operation request to the target node.
[0123] According to one or more embodiments of the present disclosure, Example 10 provides a computer-readable medium having a computer program stored thereon, and when the computer program is executed by a processing device, the steps of the method described in any one of Examples 1-8 are implemented.
[0124] According to one or more embodiments of the present disclosure, Example 11 provides an electronic device, including: a storage device having a computer program stored thereon; A processing device is used to execute the computer program in the storage device to implement the steps of any one of the methods described in Examples 1-8.
[0125] According to one or more embodiments of the present disclosure, Example 12 provides a computer program product, including a computer program, which implements the steps of any one of the methods of Examples 1-8 when executed by a processor.
[0126] The above description is only a preferred embodiment of the present disclosure and an explanation of the technical principles used. Those skilled in the art should understand that the scope of disclosure involved in the present disclosure is not limited to the technical solutions formed by a specific combination of the above technical features, but should also cover other technical solutions formed by any combination of the above technical features or their equivalent features without departing from the above disclosed concept. For example, the above features are replaced with the technical features with similar functions disclosed in the present disclosure (but not limited to) by each other to form a technical solution.
[0127] In addition, although each operation is described in a specific order, this should not be understood as requiring these operations to be performed in the specific order shown or in a sequential order. Under certain circumstances, multitasking and parallel processing may be advantageous. Similarly, although some specific implementation details are included in the above discussion, these should not be interpreted as limiting the scope of the present disclosure. Some features described in the context of a separate embodiment can also be implemented in a single embodiment in combination. On the contrary, the various features described in the context of a single embodiment can also be implemented in multiple embodiments individually or in any suitable sub-combination mode.
[0128] Although the subject matter has been described in language specific to structural features and / or method logic actions, it should be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or actions described above. On the contrary, the specific features and actions described above are merely example forms of implementing the claims. Regarding the device in the above embodiment, the specific manner in which each module performs the operation has been described in detail in the embodiment related to the method, and will not be elaborated here.
Claims
1. A database management method, characterized in that: The method comprises: In response to receiving an operation to create an instance of a database, a connection relationship diagram corresponding to the created database instance and a target connection terminal is displayed in a display interface, wherein the database instance includes a primary node and a backup node, and the target connection terminal is one of the virtual terminals that establish a connection with the database instance; If it is determined that the database starts the proxy service, a connection relationship diagram corresponding to the database instance, the proxy service and the target connection terminal is displayed in the display interface, wherein the target connection terminal is connected to a node of the database instance through the proxy service; In response to receiving an operation request for the database instance, a target node corresponding to the operation request is determined based on the proxy service, and the operation request is dispatched to the target node.
2. The method according to claim 1, characterized in that The method further comprises: In response to receiving a node configuration change operation on the database instance, displaying an instance configuration interface; In response to receiving a node adding operation in the instance configuration interface, displaying configuration items corresponding to the newly added node in the instance configuration interface, the configuration items including node specifications and node regions; In response to receiving a configuration operation on the configuration item, a new node of the database instance is generated, and the new node is displayed in the connection relationship diagram.
3. The method according to claim 1, characterized in that The method further comprises: In response to receiving the terminal adding operation, displaying a terminal configuration interface, wherein the terminal configuration interface displays terminal attributes to be configured, wherein the terminal attributes include terminal type, read / write mode, and associated nodes; In response to receiving a configuration operation on the terminal attribute, generating a newly added connection terminal; The newly added connected terminal is displayed in the terminal list in the display interface.
4. The method according to claim 3, characterized in that: The method further comprises: In response to receiving a switching operation on a connection terminal, displaying candidate terminals, wherein the candidate terminals include a plurality of connection terminals connected to the database instance; In response to receiving a selection operation on a candidate terminal, determining a terminal type of the selected candidate terminal; If the terminal type is a proxy type, a connection relationship diagram corresponding to the database instance, the proxy service and the selected candidate terminal is displayed in the display interface; If the terminal type is a direct connection type, a connection relationship diagram corresponding to the database instance and the selected candidate terminal is displayed in the display interface.
5. The method according to claim 1, characterized in that The method further comprises: Detecting a mouse position in the display interface; In response to detecting that the mouse position moves to a hovering element in the connection relationship diagram, hovering information configured for the hovering element is displayed.
6. The method according to claim 5, characterized in that The displaying of the hover information of the hover element configuration includes: If the hovering element is a connected terminal, terminal information of the connected terminal is displayed, wherein the terminal information includes at least one of a terminal identifier, a terminal operation status, a terminal type, and a connected network address; If the hovering element is a node other than a standby node, display node information of the node, where the node information includes at least one of a node identifier, a number of nodes associated with the node, and a node operation status; If the hovering element is a standby node, node information and operation information of the standby node are displayed, and the operation information is used to switch the standby node to a master node.
7. The method according to claim 1, characterized in that The operation request is a read operation request, and in response to receiving the operation request for the database instance, determining a target node corresponding to the operation request based on the proxy service includes: In response to receiving an operation request for the database instance, determining a connection terminal corresponding to the operation request; If the connection terminal corresponding to the operation request is a proxy type terminal, and the data read-write separation mode of the connection terminal is turned on, then based on the proxy service and the scheduling policy pre-configured for the connection terminal, determine the target node from the read-only type nodes in the database instance; If the connection terminal corresponding to the operation request is a proxy type terminal and the data read-write separation mode of the connection terminal is not turned on, the target node is determined from the read-only type nodes and the master node of the database instance based on the scheduling policy pre-configured by the proxy service and the connection terminal.
8. The method according to claim 1, characterized in that The method further comprises: Determine data connection weight information corresponding to each node of the database instance, wherein the data connection weight information is used to represent the relationship between the amount of data in the node and the data capacity of the node; The data connection weight information corresponding to each of the nodes is displayed in the connection relationship diagram.
9. A database management device, characterized in that: The device comprises: A first display module is used for displaying a connection relationship diagram corresponding to the created database instance and the target connection terminal in a display interface in response to receiving an instance creation operation for the database, wherein the database instance includes a primary node and a backup node, and the target connection terminal is one of the virtual terminals connected to the database instance; A second display module is used to display a connection relationship diagram corresponding to the database instance, the proxy service and the target connection terminal in the display interface if it is determined that the database starts the proxy service, wherein the target connection terminal is connected to the node of the database instance through the proxy service; The first processing module is used to, in response to receiving an operation request for the database instance, determine a target node corresponding to the operation request based on the proxy service, and schedule the operation request to the target node.
10. A computer readable medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processing device, the steps of the method according to any one of claims 1 to 8 are implemented.
11. An electronic device, characterized in that: include: a storage device having a computer program stored thereon; A processing device, configured to execute the computer program in the storage device to implement the steps of the method according to any one of claims 1 to 8.
12. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 8 are implemented.
Citation Information
Patent Citations
Device, system and method for displaying database cluster architecture diagram, and storage medium
CN108959391A
Database access method, database access device and computer readable storage medium
CN117216138A
Debugging method and device for application program interaction and electronic equipment
CN117873872A
