Database instance management method and device, medium, electronic equipment and program product

Abstract

A database instance management method and apparatus, a medium, an electronic device and a program product relate to the technical field of computers, the method comprising: a link configuration interface is used for supporting configuration of a synchronization link through a data transmission service, and a task configuration interface is used for supporting configuration of a synchronization task through the data transmission service; determining link parameters and task parameters in response to configuration operations for configuration items in the link configuration interface and the task configuration interface respectively; in response to a triggered generation operation, generating a synchronization link based on the link parameter, and generating a synchronization task based on the task parameter; and executing a synchronization task, wherein the synchronization task is used for synchronizing the data of the main instance represented by the link parameter to the disaster recovery instance represented by the link parameter through the synchronization link. The characteristics of data transmission service are utilized, a more comprehensive and flexible data synchronization solution is provided, the method is suitable for a wider business scene, and more management and monitoring functions are provided.

Description

Technical Field

[0001] The present disclosure relates to the field of computer technology, and in particular, to a database instance management method, device, medium, electronic device and program product. Background Art

[0002] For scenarios with strong demands for business continuity services and data reliability or regulatory requirements, cloud databases provide cross-regional disaster recovery instances to help users improve business continuity service capabilities at a lower cost while improving data reliability. Therefore, how to create a disaster recovery instance that can support business implementation is crucial. Summary of the invention

[0003] 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.

[0004] In a first aspect, the present disclosure provides a database instance management method, comprising: In response to a configuration operation on a link configuration item in a link configuration interface, determining a link parameter corresponding to the link configuration item, the link configuration interface being used to support configuration of a synchronous link through a data transmission service; In response to a task creation operation triggered for the link configuration interface, displaying a task configuration interface, the task configuration interface being used to support configuration of a synchronization task through the data transmission service; In response to a configuration operation on a task configuration item in the task configuration interface, determining a task parameter corresponding to the task configuration item; In response to a triggered generation operation, generating a synchronization link based on the link parameters, and generating a synchronization task based on the task parameters; Execute the synchronization task, which is used to synchronize the data of the main instance represented by the link parameters to the disaster recovery instance represented by the link parameters through the synchronization link, and the disaster recovery instance is used to connect to the application when the main instance and the backup instance corresponding to the main instance are both disconnected from the application.

[0005] In a second aspect, the present disclosure provides a database instance management device, including: A first response module, configured to determine a link parameter corresponding to a link configuration item in a link configuration interface in response to a configuration operation on the link configuration item, wherein the link configuration interface is used to support configuration of a synchronous link through a data transmission service; A second response module, configured to respond to a task creation operation triggered on the link configuration interface and display a task configuration interface, wherein the task configuration interface is used to support configuration of a synchronization task through the data transmission service; A third response module, configured to determine a task parameter corresponding to the task configuration item in response to a configuration operation on the task configuration item in the task configuration interface; a fourth response module, configured to generate a synchronization link based on the link parameters and generate a synchronization task based on the task parameters in response to the triggered generation operation; A synchronization module is used to execute the synchronization task, wherein the synchronization task is used to synchronize the data of the main instance represented by the link parameters to the disaster recovery instance represented by the link parameters through the synchronization link, and the disaster recovery instance is used to connect to the application when the main instance and the backup instance corresponding to the main instance are both disconnected from the application.

[0006] 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.

[0007] 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 in the first aspect.

[0008] In a fifth aspect, the present disclosure provides a computer program product, comprising a computer program, which implements the steps of the method described in the first aspect when executed by a processor.

[0009] Through the above solution, users can configure the synchronization links and synchronization parameters between instances in a visual way. Due to the characteristics of the Data Transmission Service (DTS), the synchronization links and synchronization tasks used to implement database instances can be configured through the Data Transmission Service. This can provide a more comprehensive and flexible data synchronization solution that is suitable for a wider range of business scenarios and provides more management and monitoring functions.

[0010] Other features and advantages of the present disclosure will be described in detail in the following detailed description. BRIEF DESCRIPTION OF THE DRAWINGS

[0011] 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 The present invention is a flowchart of a method for managing a database instance according to an embodiment of the present invention.

[0012] Figure 2 is another flow chart of a database instance management method according to an embodiment of the present disclosure.

[0013] Figure 3 This is an interface diagram of a link configuration interface according to an embodiment of the present disclosure.

[0014] Figure 4 This is an interface diagram of a task configuration interface according to an embodiment of the present disclosure.

[0015] Figure 5 It is a schematic diagram of an example topology diagram according to an embodiment of the present disclosure.

[0016] Figure 6 This is an interface diagram of an example configuration interface shown according to an embodiment of the present disclosure.

[0017] Figure 7 This is an interface diagram of an order interface according to an embodiment of the present disclosure.

[0018] Figure 8 This is an interface diagram for displaying task details according to an embodiment of the present disclosure.

[0019] Fig. 9 It is a schematic diagram of a progress interface according to an embodiment of the present disclosure.

[0020] Fig.10 is another schematic diagram of a progress interface according to an embodiment of the present disclosure.

[0021] Fig.11 is another schematic diagram of a progress interface according to an embodiment of the present disclosure.

[0022] Fig.12 is another schematic diagram of a progress interface according to an embodiment of the present disclosure.

[0023] Fig.13 is another schematic diagram of a progress interface according to an embodiment of the present disclosure.

[0024] Fig.14It is a schematic diagram of a confirmation interface according to an embodiment of the present disclosure.

[0025] Fig.15 is another schematic diagram of an example topology diagram according to an embodiment of the present disclosure.

[0026] Fig.16 is another schematic diagram of an example topology diagram according to an embodiment of the present disclosure.

[0027] Fig.17 It is a schematic diagram of an example list according to an embodiment of the present disclosure.

[0028] Fig.18 It is a schematic diagram of a detail page of an example shown according to an embodiment of the present disclosure.

[0029] Fig.19 It is a schematic diagram of an interface for confirming a deletion instance according to an embodiment of the present disclosure.

[0030] Fig. 20 The block diagram is a database instance management device according to an embodiment of the present disclosure.

[0031] Fig.21 It is a schematic diagram of the structure of an electronic device according to an embodiment of the present disclosure. DETAILED DESCRIPTION

[0032] 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.

[0033] 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.

[0034] 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.

[0035] 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.

[0036] 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".

[0037] 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.

[0038] 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.

[0039] 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.

[0040] 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.

[0041] 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.

[0042] 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.

[0043] The master instance is the main database instance that handles daily business requests. All business operations, such as adding, deleting, modifying, and checking data, are performed directly on the master instance. The master instance is responsible for receiving and processing all data write operations. It is the source of data changes, and all new data or updates must first be performed on the master instance.

[0044] The backup instance usually keeps data synchronized with the primary instance so that it can quickly switch to the primary instance when the primary instance fails, continue to provide database services, and reduce the time of business interruption. The data synchronization between the backup instance and the primary instance can be real-time (such as synchronous replication) or with a certain delay (such as asynchronous replication). The backup instance is usually located in the same data center as the primary instance or in a similar network environment to ensure the efficiency and reliability of data synchronization. In addition to switching when the primary instance fails, the backup instance may not be directly used for business queries or other operations under normal circumstances. It is mainly used as a backup and failover backup resource.

[0045] The main purpose of a disaster recovery instance is to respond to disaster events, such as natural disasters such as fire, earthquake, and flood, or major man-made accidents, which cause the main data center (i.e., the primary instance and the backup instance) to be completely unavailable. Disaster recovery instances are usually located in a different geographical location from the primary data center to avoid being affected by the same disaster. There may be a certain delay in data synchronization of disaster recovery instances because the distance of data transmission and network conditions must be taken into account. After a disaster occurs, it may take some time to restore data and start the disaster recovery instance. Disaster recovery instances can not only be used to restore database services, but also serve as a backup for the entire business system to ensure that business operations can be resumed as soon as possible in the event of a disaster.

[0046] In actual applications, the database system is usually built using a primary instance, a backup instance, and a disaster recovery instance to improve data security and business continuity.

[0047] In the related art, the disaster recovery instance of a database is a copy of the primary instance of the database. When the primary instance changes, the log information recording the modification will be copied to the disaster recovery instance, and then the log replay will be used to achieve data synchronization. However, the method of achieving data synchronization by log replay is not flexible and has poor functionality, and cannot be applied to more application scenarios.

[0048] In view of this, embodiments of the present disclosure provide a database instance management method, apparatus, medium, electronic device, and program product.

[0049] The embodiments of the present disclosure are further explained and illustrated below in conjunction with the accompanying drawings.

[0050] Figure 1 The present invention is a flowchart of a database instance management method according to an embodiment of the present invention. The database instance management method can be applied to an electronic device, and the database instance management method can be executed by a database instance management device, wherein the database instance management device can be implemented by software and / or hardware, and the software and / or hardware can be configured in the electronic device. Figure 1 , the database instance management method may include the following steps: Step 110, in response to a configuration operation on a link configuration item in a link configuration interface, determining a link parameter corresponding to the link configuration item, the link configuration interface being used to support configuration of a synchronous link through a data transmission service; Step 120, in response to the task creation operation triggered for the link configuration interface, displaying the task configuration interface, the task configuration interface is used to support the configuration of synchronization tasks through the data transmission service; Step 130, in response to a configuration operation on a task configuration item in the task configuration interface, determining a task parameter corresponding to the task configuration item; Step 140, in response to the triggered generation operation, generating a synchronization link based on the link parameters, and generating a synchronization task based on the task parameters; Step 150, execute a synchronization task, which is used to synchronize the data of the main instance represented by the link parameters to the disaster recovery instance represented by the link parameters through a synchronization link, and the disaster recovery instance is used to connect to the application when the main instance and the backup instance corresponding to the main instance are disconnected from the application.

[0051] Through the above solution, it is convenient for users to configure the synchronization links and synchronization parameters between instances in a visual way. Due to the characteristics of the data transmission service, the synchronization links and synchronization tasks used to implement the database instance can be configured through the data transmission service. A more comprehensive and flexible data synchronization solution can be provided, which is applicable to a wider range of business scenarios and provides more management and monitoring functions. It is worth noting that when the primary instance and the backup instance corresponding to the primary instance are disconnected from the application, it means that the primary instance and the backup instance are affected by sudden natural disasters and other conditions in the area where the primary instance is located and cannot connect to the application. In this case, the connection address of the database can be modified to the connection address of the disaster recovery instance on the application side where the application is located, so as to quickly restore the business access of the application and reduce the impact of sudden natural disasters and other conditions on the services provided by the application.

[0052] Figure 2 is another flow chart of a database instance management method according to an embodiment of the present disclosure. Figure 2 Based on this, the embodiments of the present disclosure are further explained and illustrated.

[0053] Reference Figure 2 After confirming to create the synchronization link, the link configuration interface is displayed. Figure 3 FIG. 1 is an interface diagram of a link configuration interface according to an embodiment of the present disclosure. Figure 3 , the link configuration items may include configuration items belonging to the basic information class and link configuration items belonging to the instance class.

[0054] As an example, the link configuration items belonging to the basic information category include task name, link specification, synchronization topology, billing type, project name, and tag. Among them, the task name can be entered by the user as needed; the link specification is used to configure the transmission rate of the synchronization link and is entered by the user as needed; the synchronization topology supports only one-way communication; the billing type supports only pay-as-you-go billing; the project name defaults to the project name of the main instance, but supports user customization; the tag is used to support classification management and facilitate search, and is customized by the user.

[0055] As an example, the link configuration items belonging to the instance class include instance type, access method, region, instance ID (Identity document), database account and database password. The instance type represents the type of database, which can be MySQL; the access method is the internal platform MySQL; the region is the region where the primary instance or disaster recovery instance is located; the instance ID is the ID of the primary instance or disaster recovery instance; the database account and database password are entered by the user. It is worth noting that the disaster recovery instance is generally configured only as readable, in order to ensure the stability and consistency of data synchronization. Therefore, the disaster recovery instance information does not need to be configured with a database account and database password. If a write operation is required on the disaster recovery instance, it should be performed on the primary instance and the write operation should be implemented through the DTS account, that is, synchronized to the disaster recovery instance through DTS.

[0056] It is worth noting that link parameters are Figure 3 Information obtained by configuring the link configuration items shown.

[0057] In the present disclosure, the task creation operation can be performed by Figure 3 For example, click the control "Next: Configure Disaster Recovery Synchronization" to trigger the task creation operation.

[0058] Figure 4 FIG. 1 is an interface diagram of a task configuration interface according to an embodiment of the present disclosure. Figure 4 , the task configuration items may include synchronization type, migration user, synchronization object, error retry time and full synchronization rate. Among them, synchronization type, migration user, synchronization object, error retry time and full synchronization rate can be input by the user. It is worth noting that the task parameters are Figure 4In a possible manner, before triggering the generation operation for generating synchronization links and synchronization tasks, the above-mentioned database instance management method may also include the following steps: in response to the detection configuration operation triggered in the task configuration interface, display the detection page; in response to the configuration operation for the detection configuration item in the detection page, determine the detection parameters; in response to the detection operation triggered in the detection page, perform a pre-detection on the main instance according to the detection parameters, and display the detection result page after the pre-detection is completed.

[0059] Continue to refer to Figure 4 , you can trigger the detection configuration operation through the control "Next: Pre-detection" in the task configuration interface. For example, click the control "Next: Pre-detection" to trigger the task detection configuration operation.

[0060] As an example, a detection configuration item may include a detection scope.

[0061] Furthermore, the detection result page not only displays the detection results, but also displays the control "Generate". By clicking the control "Generate", the generation operation is triggered. It is worth noting that the generation operation is triggered by Figure 2 The “Confirmed Order” in the Agreement has the same meaning as the “Confirmed Order”.

[0062] Through the above method, before generating the synchronization link and the synchronization task, the primary instance is pre-detected, thereby providing a data basis for the synchronization between the primary instance and the disaster recovery instance.

[0063] In a possible manner, the above-mentioned database instance management method may further include the following steps: displaying an instance topology diagram, the instance topology diagram including a connection relationship between the created database instance and the terminal and a first entry, the first entry being used to add a disaster recovery instance; in response to receiving a trigger operation for the first entry, displaying an instance configuration interface, the instance configuration interface including a first area and a second area, the first area being used to display configuration parameters of configuration items that are the same as the main instance in the disaster recovery instance, and the second area being used to support configuration of private configuration items of the disaster recovery instance; in response to a configuration operation for configuration items in the second area, determining private configuration parameters of the disaster recovery instance; in response to determining a trigger operation to create an instance, creating a disaster recovery instance based on the private configuration parameters of the disaster recovery instance and the configuration parameters of the configuration items that are the same as the main instance in the disaster recovery instance.

[0064] Figure 5 FIG. 1 is a schematic diagram of an example topology diagram according to an embodiment of the present disclosure. Figure 5 The instance topology diagram includes the connection relationship between the created database instance and the terminal, as well as the delay information between nodes, the number of nodes in the instance, etc. Figure 5 , Figure 5The control "Add Disaster Recovery Instance" shown can be used as the first entry. As an example, clicking the control "Add Disaster Recovery Instance" implements the triggering operation of the first entry, and then displays the instance configuration interface.

[0065] Among them, the instance configuration interface can support users to configure private configuration parameters of the disaster recovery instance, and the configuration parameters of the disaster recovery instance that are the same as the main instance are automatically configured based on the information of the main instance, without the need for manual configuration by the user.

[0066] Figure 6 is an interface diagram of an example configuration interface according to an embodiment of the present disclosure. Figure 6 ,exist Figure 6 The first area shown shows the configuration parameters of the disaster recovery instance with the same configuration as the main instance, which may include compatible version, instance type, specification type, storage type, network protocol, table name case, parameter configuration, project, whitelist, and billing method. The compatible version is used to indicate the version of the supported database; the instance type indicates whether the instance supports dual nodes (i.e., primary and standby nodes). The database instance may include a primary node and a standby node, wherein the primary node is in operation, and the connection terminal connects to the database through the primary node. The standby node is usually not working, and it synchronizes data with the primary node to switch to the standby node to work when the primary node fails or is abnormal, to ensure effective access to the database; the specification type is used to indicate whether the computing resources used by the user are completely isolated and exclusive in the cloud service. The whitelist is a security control measure for database connections. Only IP (Internet Protocol) addresses in the whitelist can access the database.

[0067] Continue to refer to Figure 6 , the private configuration parameters of the disaster recovery instance can include Figure 6 The instance name, region, node specifications, storage space, and network information in the . The instance name, region, node specifications, storage space, and network information are all customized by the user. In addition, when configuring the private configuration parameters of the disaster recovery instance, the corresponding prompt can be displayed, such as Figure 6 Add the remaining number of nodes in the prompt and network configuration.

[0068] It is worth noting that the configuration operation for the configuration item in the second area may include input operation, selection operation, click operation and sliding operation. Figure 6 The interface diagram shown is obtained by reasoning.

[0069] Continue to refer to Figure 6 , based on the control "Confirm Creation", the trigger operation for determining the creation of the instance can be triggered.

[0070] Through the above method, the configuration parameters of the same configuration items of the disaster recovery instance and the main instance are automatically configured, and the user does not need to perform configuration operations, thereby reducing the configuration amount and improving configuration efficiency; in addition, additional support is provided for the configuration of private configuration parameters of the disaster recovery instance to support a certain degree of personalized configuration.

[0071] In a possible manner, the above-mentioned step of creating a disaster recovery instance in response to a trigger operation that determines to create an instance, based on private configuration parameters of the disaster recovery instance and configuration parameters of configuration items that are the same as the primary instance, can be implemented in the following manner: in response to a first trigger operation that determines to create an instance, an order interface is displayed; in response to a second trigger operation that determines to create an instance triggered by the order interface, based on the private configuration parameters of the disaster recovery instance and configuration parameters of configuration items that are the same as the primary instance.

[0072] It is worth noting that the first trigger operation can be Figure 6 The control shown "Confirm creation" triggers.

[0073] Figure 7 is an interface diagram of an order interface according to an embodiment of the present disclosure. Figure 7 The order interface displays detailed order information, including the product type, configuration details, specifications, and price of the disaster recovery instance. In addition, the order interface also displays information for obtaining user authorization. After obtaining the relevant authorization information, the order interface further displays a control "Confirm Creation" that supports the second trigger operation of triggering the creation of the instance.

[0074] Through the above method, the summary information is displayed to the user in an order interface, so that the user can intuitively browse all configurations based on the order interface, and a secondary confirmation method for creating an instance is provided to complete the confirmation creation of the disaster recovery instance.

[0075] In a possible manner, the above database instance management method may further include the following steps: in response to a trigger operation of viewing the creation progress, displaying a progress interface, wherein the progress interface includes creation status information.

[0076] It is worth noting that, in the present disclosure, at least a disaster recovery instance and a synchronization link need to be created. Therefore, the disaster recovery instance and the synchronization link each correspond to their own creation status information.

[0077] As an example, the creation situation information may be creation progress information and creation result information. Specific information may refer to the following embodiments.

[0078] By using the above method, the progress information is displayed so that the user can intuitively browse the creation status of the disaster recovery instance and the synchronization link.

[0079] When a disaster recovery instance is being created, the above-mentioned response to the trigger operation of viewing the creation progress and displaying the progress interface includes: responding to the trigger operation of viewing the creation progress and displaying the progress interface, the progress interface includes creation status information, the creation status information includes the creation progress of the disaster recovery instance and related prompt information of the disaster recovery instance.

[0080] The creation progress of the disaster recovery instance may be represented by text information, may be represented by graphic information, or may be represented by a combination of text and graphic.

[0081] Among them, the relevant prompt information of the disaster recovery instance, for example, prompts the user at which location to view the details of the instance that has been created; for example, prompts the user to create a synchronization link as soon as possible after completing the creation of the disaster recovery instance; for example, at which location to view the details of the creation task, which is the task of creating a disaster recovery instance.

[0082] Figure 8 is an interface diagram showing task details according to an embodiment of the present disclosure, referring to Figure 8 The interface displays task details, such as instance ID, task name, task status, creation time, start and end time, task duration, and task execution code. In addition, the interface also supports quick copying of instance ID and task name.

[0083] Fig. 9 1 is a schematic diagram of a progress interface according to an embodiment of the present disclosure. The progress interface includes the creation progress of the disaster recovery instance and related prompt information of the disaster recovery instance. For examples of the creation progress and prompt information of the specific disaster recovery instance, please refer to Fig. 9 When the disaster recovery instance is created, the step of displaying the progress interface in response to the trigger operation of viewing the creation progress may include: displaying the progress interface in response to the trigger operation of viewing the creation progress, the progress interface including creation status information, the creation status information including creation result information, and the creation result information is used to indicate whether the creation of the disaster recovery instance is successful.

[0084] When the creation progress of the disaster recovery instance reaches 100%, the corresponding creation result information is displayed according to the creation result. If the disaster recovery instance is created successfully, the creation result information is used to prompt that the disaster recovery instance is created successfully. In addition, the progress interface can also provide a function for quickly triggering the next configuration, and the next configuration can be the configuration of the synchronization link. Fig.10 is another schematic diagram of a progress interface according to an embodiment of the present disclosure. Fig.10 After the disaster recovery instance is successfully created, the creation result information is used to prompt that the disaster recovery instance is successfully created, and through Fig.10The control "Create Synchronous Link" in can quickly trigger the configuration of the synchronous link. After triggering the control "Create Synchronous Link", the link configuration interface is displayed to complete the configuration of the synchronous link.

[0085] If the disaster recovery instance fails to be created, the step of displaying the progress interface in response to the trigger operation of viewing the creation progress may include: displaying the progress interface in response to the trigger operation of viewing the creation progress, the progress interface including creation status information, the creation status information including creation result information, and the creation result information including the reason for the failure of the disaster recovery instance.

[0086] Fig.11 is another schematic diagram of a progress interface according to an embodiment of the present disclosure. Fig.11 The creation result information is information used to prompt the failure of the disaster recovery instance creation. The information may include the reason for the failure of the disaster recovery instance. In addition, Fig.11 The control "Rebuild Disaster Recovery Instance" in can quickly trigger the re-creation of the disaster recovery instance.

[0087] Through the above method, the reason for the failure of the disaster recovery instance is displayed, which helps users to understand the reason for the failure of the disaster recovery instance.

[0088] During the process of creating a synchronization link, the progress interface can also display the creation result information or creation progress information corresponding to the synchronization link. Fig.12 After the synchronization link is created and successfully, the progress interface can be as follows: Fig.13 shown.

[0089] In a possible manner, after the disaster recovery instance is created and before the synchronization link is successfully created, the first entry in the instance topology map is transformed into a second entry, and the second entry is used to restore the progress interface that triggers the display of the link configuration interface. The above-mentioned database instance management method may also include: in response to receiving a trigger operation for the second entry, displaying a progress interface, the progress interface includes a control for triggering the display of the link configuration interface.

[0090] It is worth mentioning that before the link is successfully created, the user may close the progress page, close the browser, suddenly shut down, or actively click to minimize, thereby triggering the closure of the progress page where the control "Create Synchronous Link" of the link configuration interface is located. Therefore, in order to quickly enter the configuration of the synchronous link, a second entry is directly provided in the instance topology diagram to quickly restore the progress interface used to trigger the display of the link configuration interface, thereby realizing the rapid triggering of the display of the link configuration interface.

[0091] In a possible manner, the above database management method may further include the following steps: in response to executing a target operation, deleting the synchronization link, the target operation including upgrading a disaster recovery instance to a primary instance or deleting an instance, the instance including a primary instance or a disaster recovery instance.

[0092] It is worth noting that after deleting the primary instance or the disaster recovery instance, the synchronization link will no longer be used. Therefore, after upgrading the disaster recovery instance to the primary instance or deleting the instance, delete the synchronization link to reduce resource usage.

[0093] In a possible way, after the target operation is triggered by the control "upgrade to primary instance", a confirmation interface is displayed in the form of a pop-up window. Fig.14 is a schematic diagram of a confirmation interface according to an embodiment of the present disclosure, referring to Fig.14 The confirmation interface displays a prompt message about the impact of upgrading the disaster recovery instance to the primary instance, and provides a confirmation operation for the user to be aware of the impact, as well as a control "OK" to confirm the upgrade and a control "Cancel" to cancel the upgrade.

[0094] In a possible manner, after the data is created and synchronized, the instance topology map is updated, the updated instance topology map includes the disaster recovery instance, and related operations are provided for the disaster recovery instance. The operation may include upgrading the disaster recovery instance to the primary instance and data reconstruction.

[0095] Fig.15 It is another schematic diagram of an example topology diagram according to an embodiment of the present disclosure. The electronic device detects the mouse position in the example topology diagram, and when the mouse position moves to the control "operation", the corresponding operation items "upgrade to main instance" and "data reconstruction" are displayed.

[0096] After the rebuild operation is triggered by the control "Data Rebuild", the disaster recovery instance is rebuilt. At the same time, the instance topology diagram is synchronously updated to display information indicating the reconstruction of the disaster recovery instance. Fig.16 This is another schematic diagram of an instance topology diagram according to an embodiment of the present disclosure. After the reconstruction operation is triggered by the control "Data Reconstruction", the instance topology diagram can display information indicating the reconstruction of the disaster recovery instance, and the operation triggered by the control "Upgrade to Primary Instance" is prohibited. If the control "Upgrade to Primary Instance" is clicked, a prompt message "Try again later" is further displayed.

[0097] In a possible manner, a database (such as MySQL) console may provide instance management. The MySQL console may provide an instance list, and a user may view instances based on the instance list. Fig.17 1 is a schematic diagram of an example list according to an embodiment of the present disclosure. By triggering the view operation, you can enter the details page of the corresponding example. Fig.18 is a schematic diagram of a detail page of an example according to an embodiment of the present disclosure. Fig.18 , you can display various information about the instance, and some information can be configured on the details page. It is worth mentioning that you can click "Connection Management" to enter the connection management page containing the instance topology diagram.

[0098] Continue with Fig.17 For example, the database console supports the deletion of instances. Fig.17 Click the "Delete" operation on the instance to display the interface for confirming the deletion of the instance. Fig.19 FIG. 1 is a schematic diagram of an interface for confirming a deletion instance according to an embodiment of the present disclosure. Fig.19 In this interface, the prompt information for deleting the instance, the instance information of the instance to be deleted, and the backup strategy for the user to choose and the backup name for the user to enter can be displayed to facilitate the user's subsequent retrieval.

[0099] Fig. 20 1 is a block diagram of a database instance management device according to an embodiment of the present disclosure. Fig.19 , the apparatus 2000 may include: A first response module 2001, configured to determine a link parameter corresponding to a link configuration item in a link configuration interface in response to a configuration operation on the link configuration item, wherein the link configuration interface is used to support configuration of a synchronous link through a data transmission service; A second response module 2002 is used to respond to the task creation operation triggered by the link configuration interface and display a task configuration interface, wherein the task configuration interface is used to support configuration of a synchronization task through the data transmission service; The third response module 2003 is used to determine the task parameters corresponding to the task configuration items in response to the configuration operation on the task configuration items in the task configuration interface; A fourth response module 2004, configured to generate a synchronization link based on the link parameters and generate a synchronization task based on the task parameters in response to the triggered generation operation; Synchronization module 2005 is used to execute the synchronization task, which is used to synchronize the data of the main instance represented by the link parameters to the disaster recovery instance represented by the link parameters through the synchronization link, and the disaster recovery instance is used to connect to the application when the main instance and the backup instance corresponding to the main instance are disconnected from the application.

[0100] Optionally, before triggering the generating operation, the apparatus 2000 further includes: A fifth response module, configured to display a detection page in response to a detection configuration operation triggered in the task configuration interface; a sixth response module, configured to determine detection parameters in response to a configuration operation on a detection configuration item in the detection page; The seventh response module is used to respond to the detection operation triggered in the detection page, perform a pre-detection on the main instance according to the detection parameters, and display a detection result page after the pre-detection is completed.

[0101] Optionally, the device 2000 further includes: A display module, used to display an instance topology diagram, wherein the instance topology diagram includes a connection relationship between the created database instance and the terminal and a first entry, wherein the first entry is used to add a disaster recovery instance; an eighth response module, configured to display an instance configuration interface in response to receiving a trigger operation for the first entry, the instance configuration interface comprising a first area and a second area, the first area being used to display configuration parameters of the same configuration items of the disaster recovery instance and the primary instance, and the second area being used to support configuration of private configuration items of the disaster recovery instance; A ninth response module, configured to determine a private configuration parameter of the disaster recovery instance in response to a configuration operation on the configuration item in the second area; A tenth response module is used to create the disaster recovery instance in response to determining a trigger operation to create an instance, based on the private configuration parameters of the disaster recovery instance and the configuration parameters of the configuration items that are the same between the disaster recovery instance and the main instance.

[0102] Optionally, the device 2000 further includes: The eleventh response module is used to display a progress interface in response to a trigger operation of viewing the creation progress, wherein the progress interface includes creation status information.

[0103] Optionally, when the disaster recovery instance is being created, the eleventh response module is further used to: In response to a trigger operation of viewing the creation progress, a progress interface is displayed, wherein the progress interface includes the creation status information, and the creation status information includes the creation progress of the disaster recovery instance and relevant prompt information of the disaster recovery instance.

[0104] Optionally, in the case where the disaster recovery instance fails to be created, the eleventh response module is further used to: In response to a trigger operation of viewing the creation progress, a progress interface is displayed, the progress interface includes creation status information, the creation status information includes creation result information, and the creation result information includes the reason for the failure of the disaster recovery instance.

[0105] Optionally, after the disaster recovery instance is created and before the synchronization link is successfully created, the first entry in the instance topology map is transformed into a second entry, and the second entry is used to restore the progress interface that triggers the display of the link configuration interface, and the device 2000 further includes: The twelfth response module is used to display a progress interface in response to receiving a trigger operation for the second entry, and the progress interface is used to trigger display of the link configuration interface.

[0106] Optionally, the device 2000 further includes: The deletion module is used to delete the synchronization link in response to executing a target operation, wherein the target operation includes upgrading the disaster recovery instance to a primary instance or deleting an instance, wherein the instance includes the primary instance or the disaster recovery instance.

[0107] The implementation of each module in the above-mentioned database instance management device 2000 can refer to the above-mentioned related embodiments, and this embodiment will not be described in detail here.

[0108] Based on the same inventive concept, an embodiment of the present disclosure further provides a computer-readable medium on which a computer program is stored. When the computer program is executed by a processing device, the steps of the above-mentioned database instance management method are implemented.

[0109] Based on the same inventive concept, an embodiment of the present disclosure further provides a computer program product, including a computer program, which implements the steps of the above-mentioned database instance management method when executed by a processor.

[0110] Based on the same inventive concept, the present disclosure also 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 above-mentioned database instance management method.

[0111] Reference below Fig.21 , which shows a schematic diagram of the structure of an electronic device 2100 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, laptop computers, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), vehicle terminals (such as vehicle navigation terminals), etc., and fixed terminals such as digital TVs, desktop computers, etc. Fig.21 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.

[0112] like Fig.21As shown, the electronic device 2100 may include a processing device (e.g., a central processing unit, a graphics processing unit, etc.) 2101, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 2102 or a program loaded from a storage device 2108 to a random access memory (RAM) 2103. In the RAM 2103, various programs and data required for the operation of the electronic device 2100 are also stored. The processing device 2101, the ROM 2102, and the RAM 2103 are connected to each other via a bus 2104. An input / output (I / O) interface 2105 is also connected to the bus 2104.

[0113] Typically, the following devices may be connected to the I / O interface 2105: an input device 2106 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 2107 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, etc.; a storage device 2108 including, for example, a magnetic tape, a hard disk, etc.; and a communication device 2109. The communication device 2109 may allow the electronic device 2100 to communicate with other devices wirelessly or by wire to exchange data. Although Fig.21 The electronic device 2100 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.

[0114] 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 the network through the communication device 2109, or installed from the storage device 2108, or installed from the ROM 2102. When the computer program is executed by the processing device 2101, the above-mentioned functions defined in the method of the embodiment of the present disclosure are executed.

[0115] 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.

[0116] In some embodiments, the electronic devices 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.

[0117] The computer-readable medium may be included in the electronic device, or may exist independently without being incorporated into the electronic device.

[0118] The computer-readable medium carries one or more programs. When the one or more programs are executed by the electronic device, the electronic device: determines the link parameters corresponding to the link configuration items in response to the configuration operation of the link configuration items in the link configuration interface, and the link configuration interface is used to support the configuration of the synchronization link through the data transmission service; displays the task configuration interface in response to the task creation operation triggered on the link configuration interface, and the task configuration interface is used to support the configuration of the synchronization task through the data transmission service; determines the task parameters corresponding to the task configuration items in response to the configuration operation of the task configuration items in the task configuration interface; generates a synchronization link based on the link parameters and generates a synchronization task based on the task parameters in response to the triggered generation operation; executes the synchronization task, and the synchronization task is used to synchronize the data of the main instance represented by the link parameters to the disaster recovery instance represented by the link parameters through the synchronization link, and the disaster recovery instance is used to connect to the application when the main instance and the backup instance corresponding to the main instance are disconnected from the application.

[0119] 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).

[0120] 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.

[0121] The modules involved in the embodiments described in the present disclosure may be implemented by software or hardware, wherein the name of a module does not, in some cases, limit the module itself.

[0122] 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.

[0123] 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.

[0124] 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.

[0125] 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.

[0126] 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 instance management method, characterized in that: include: In response to a configuration operation on a link configuration item in a link configuration interface, determining a link parameter corresponding to the link configuration item, the link configuration interface being used to support configuration of a synchronous link through a data transmission service; In response to a task creation operation triggered for the link configuration interface, displaying a task configuration interface, the task configuration interface being used to support configuration of a synchronization task through the data transmission service; In response to a configuration operation on a task configuration item in the task configuration interface, determining a task parameter corresponding to the task configuration item; In response to a triggered generation operation, generating a synchronization link based on the link parameters, and generating a synchronization task based on the task parameters; Execute the synchronization task, which is used to synchronize the data of the main instance represented by the link parameters to the disaster recovery instance represented by the link parameters through the synchronization link, and the disaster recovery instance is used to connect to the application when the main instance and the backup instance corresponding to the main instance are both disconnected from the application.

2. The method according to claim 1, characterized in that Before triggering the generating operation, the method further includes: In response to a detection configuration operation triggered in the task configuration interface, displaying a detection page; In response to a configuration operation on a detection configuration item in the detection page, determining a detection parameter; In response to the detection operation triggered in the detection page, a pre-detection is performed on the main instance according to the detection parameters, and a detection result page is displayed after the pre-detection is completed.

3. The method according to claim 1 or 2, characterized in that: The method further comprises: Display an instance topology diagram, wherein the instance topology diagram includes a connection relationship between the created database instance and the terminal and a first entry, wherein the first entry is used to add a disaster recovery instance; In response to receiving a trigger operation for the first entry, displaying an instance configuration interface, the instance configuration interface comprising a first area and a second area, the first area being used to display configuration parameters of the same configuration items of the disaster recovery instance and the primary instance, and the second area being used to support configuration of private configuration items of the disaster recovery instance; In response to a configuration operation on a configuration item in the second area, determining a private configuration parameter of the disaster recovery instance; In response to determining a trigger operation for creating an instance, the disaster recovery instance is created based on the private configuration parameters of the disaster recovery instance and the configuration parameters of the configuration items that are the same between the disaster recovery instance and the primary instance.

4. The method according to claim 3, characterized in that The method further comprises: In response to a trigger operation of viewing the creation progress, a progress interface is displayed, wherein the progress interface includes creation status information.

5. The method according to claim 4, characterized in that In the case where the disaster recovery instance is being created, the display of the progress interface in response to the trigger operation of viewing the creation progress includes: In response to a trigger operation of viewing the creation progress, a progress interface is displayed, wherein the progress interface includes the creation status information, and the creation status information includes the creation progress of the disaster recovery instance and relevant prompt information of the disaster recovery instance.

6. The method according to claim 4, characterized in that In the case where the disaster recovery instance fails to be created, the display of the progress interface in response to the trigger operation of viewing the creation progress includes: In response to a trigger operation of viewing the creation progress, a progress interface is displayed, the progress interface includes creation status information, the creation status information includes creation result information, and the creation result information includes the reason for the failure of the disaster recovery instance.

7. The method according to claim 4, characterized in that After the disaster recovery instance is created and before the synchronization link is successfully created, the first entry in the instance topology map is transformed into a second entry, and the second entry is used to restore the progress interface that triggers the display of the link configuration interface, and the method further includes: In response to receiving a trigger operation for the second entry, a progress interface is displayed, where the progress interface is used to trigger display of the link configuration interface.

8. The method according to claim 3, characterized in that The method further comprises: In response to executing a target operation, the synchronization link is deleted. The target operation includes an operation of upgrading the disaster recovery instance to a primary instance or an operation of deleting an instance, wherein the instance includes the primary instance or the disaster recovery instance.

9. A database instance management device, characterized in that: include: A first response module, configured to determine a link parameter corresponding to a link configuration item in a link configuration interface in response to a configuration operation on the link configuration item, wherein the link configuration interface is used to support configuration of a synchronous link through a data transmission service; A second response module, configured to respond to a task creation operation triggered on the link configuration interface and display a task configuration interface, wherein the task configuration interface is used to support configuration of a synchronization task through the data transmission service; A third response module, configured to determine a task parameter corresponding to the task configuration item in response to a configuration operation on the task configuration item in the task configuration interface; a fourth response module, configured to generate a synchronization link based on the link parameters and generate a synchronization task based on the task parameters in response to the triggered generation operation; A synchronization module is used to execute the synchronization task, wherein the synchronization task is used to synchronize the data of the main instance represented by the link parameters to the disaster recovery instance represented by the link parameters through the synchronization link, and the disaster recovery instance is used to connect to the application when the main instance and the backup instance corresponding to the main instance are both disconnected from the application.

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.

Images