Method and system for batch installation of databases based on cloud platform

By batch creating container nodes on the cloud platform and quickly forming database clusters, the problems of excessive database deployment time and lack of batch installation functions in the existing technology are solved, efficient database deployment and highly available database clusters are achieved, and the efficiency and reliability of database services are significantly improved.

CN119814541APending Publication Date: 2025-04-11CHINA CITIC BANK CO LTD
View PDF 1 Cites 0 Cited by

Patent Information

Application Number
CN202411784324.9
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-12-06
Publication Date
2025-04-11

AI Technical Summary

Technical Problem

When deploying databases on cloud platforms, the existing technology cannot effectively shorten the database deployment time, lacks the function of batch installation of databases, and has shortcomings in resource management, monitoring and alarms and configuration management, which limits the flexibility and scalability of cloud platform database services.

Method used

Through the cloud platform, each container node that meets the specifications is created in batches, and a database control platform is used to quickly form a database cluster based on the database networking information obtained from the interface, so as to realize the installation of multiple databases in batches, reduce the total time-consuming database installation, and improve database installation efficiency.

Benefits of technology

It significantly shortens the time-consuming of database deployment, improves deployment efficiency, ensures high availability and stability of database clusters, reduces the work burden of operation and maintenance personnel, and improves the availability and response speed of databases.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119814541A_ABST
    Figure CN119814541A_ABST
Patent Text Reader

Abstract

In order to solve the problem of long time consumption of database installation, the invention provides a method for batch installation of databases based on a cloud platform, comprising the following steps: an application side initiates a resource application of a database through a database cloud management platform; the database cloud management platform calls interfaces from the PaaS platform according to the resource application and creates containers in batches; making a component mirror image of the database, calling an interface to install database components in batches, and calling scripts to establish a database cluster; the database management and control platform monitors the operation state of the database and dynamically manages the creation container, the function of installing the database in batches is achieved, and the database installation efficiency is remarkably improved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of databases in the software information technology industry, and in particular to a method and system for batch installing databases based on a cloud platform. Background Art

[0002] CN201310671059.9 provides a database deployment method and device. The invention deploys a database through a cloud platform. When a new database request sent by a database application user is received, a resource package associated with a specified organization is selected, and a corresponding database template is selected in a pre-established database template library associated with the specified organization; the storage space and capacity of the database file are set in the resource package so that a new database can be created using the selected database template; a parameter set for the new database is set, a user name and password for the new database is set, a new database access file and a new database universal unique identification code are generated, and the generated new database access file and new database universal unique identification code are sent to the database application user. This facilitates centralized management of databases of different organizations and types in the cloud platform without having to worry about the specific location and deployment process of the database, thereby improving the efficiency of providing database services on the cloud platform. This patent only changes the medium for deploying the database from a physical machine to a cloud platform, and the process of database deployment remains basically unchanged, which cannot shorten the time of database deployment and improve the efficiency of database deployment.

[0003] Although the existing technologies support the deployment of databases on cloud platforms, most of them are simple replications of the database deployment process on physical machines, which does not substantially shorten the time for database deployment and cannot realize the function of batch installation of databases. In addition, when dealing with databases of different organizations and different types, the existing technologies often need to care about the specific location and deployment process of the database, which limits the flexibility and scalability of cloud platform database services. In terms of database deployment, especially in cloud environments, dynamic management and optimization of resources remain a challenge. At the same time, the monitoring and alarm mechanism of the database operation status after the database is deployed in the existing technologies is not perfect enough, which affects the stability and reliability of the database. After the database is deployed, the configuration management of database components in the existing technologies may not be flexible enough, and database managers need to manually adjust the configuration, which increases the complexity and workload of operation and maintenance. In summary, although the existing technologies have made some progress in the deployment of cloud platform databases, they still need to be improved in terms of batch deployment, resource management, monitoring and alarming, and configuration management. Summary of the invention

[0004] To address the deficiencies in the prior art, the present invention provides a method for batch creating container nodes that meet the specifications through a cloud platform, and then quickly establishing a database cluster according to the database networking information obtained by the database management and control platform through an interface, thereby greatly reducing the total time consumption for database installation, realizing the function of batch multiple databases, and significantly improving the efficiency of database installation.

[0005] A first aspect of the present invention provides a method for batch installing databases based on a cloud platform, comprising:

[0006] S1. The application side initiates a database resource application through the database cloud management platform;

[0007] S2. The database cloud management platform calls an interface from the PaaS platform according to the resource application to create containers in batches;

[0008] S3: Create a component image of the database, call the interface to install database components in batches, and call the script to build a database cluster;

[0009] S4. The database management and control platform monitors the database operation status and dynamically manages the creation container.

[0010] Exemplarily, the types of the batch created containers are divided into computing node containers, data node containers, and global transaction node containers according to different components.

[0011] Exemplarily, the making of component images of the database, calling an interface to batch install database components and calling a script to build a database cluster includes: after the database management and control platform receives a response that the database cloud management platform has successfully created a container, the database side creates image files of each component by calling a K8S interface, and then uploads the image files of each component to the database management and control platform;

[0012] After uploading the image files of each component to the database management and control platform, the following steps are also included:

[0013] The database management and control platform calls the installation script according to the networking information to create relevant components in the corresponding container and mounts the disk to the persistence directory of each node;

[0014] The database management and control platform calls the script component database cluster based on the networking information.

[0015] Exemplarily, the database management and control platform monitors the running status of the database and dynamically manages the creation of the container, including: using the insight interface of the database management and control platform to inspect, collect, diagnose, monitor, and alarm the database, wherein collection refers to sending collection scripts through the insight of the database management and control platform to regularly collect the running information of the database components to determine whether the running status of each component is normal.

[0016] Exemplarily, the database management and control platform monitors the database operation status and dynamically manages the created container, and also includes: using the Paas platform to dynamically manage the created container, including removing faulty nodes and automatically adding new replacement containers.

[0017] Exemplarily, the method also includes: after the database cluster is successfully installed, the isolation level, number of connections, parameter configuration of database components, adding and deleting data monitoring items, screening important alarms and notifying database administrators in a timely manner can be modified by logging into the insight interface of the database management and control platform.

[0018] The present application also provides a system for batch installation of databases based on a cloud platform, comprising:

[0019] Application side application module: the application side initiates database resource application through the database cloud management platform;

[0020] A container creation module, used to call an interface from the PaaS platform according to the resource application to create containers in batches;

[0021] The database cluster creation module is used to create database component images, call interfaces to batch install database components, and call scripts to build database clusters;

[0022] The monitoring and management module is used to monitor the database operation status and dynamically manage the creation of the container.

[0023] The present invention also provides a computer-readable storage medium, characterized in that a computer program is stored on the storage medium, and when the computer program is executed by a processor, the method according to any one of claims 1 to 6 is implemented.

[0024] The present invention also provides an electronic device, characterized in that it includes a processor and a memory;

[0025] The memory is used to store computer programs;

[0026] The processor is configured to execute the method according to any one of claims 1 to 6 by calling a stored computer program.

[0027] The present invention also relates to a computer program product, comprising a computer program and / or instructions, characterized in that the computer program and / or instructions implement the steps of the above method when executed by a processor.

[0028] The beneficial effects of the present invention are:

[0029] (1) Through standardized component specifications and modular assembly methods, the time required for database deployment is shortened from hours to minutes, greatly improving deployment efficiency; (2) During database operation, if a component fails, the system can quickly remove the failed node and automatically create a new component to replace it, ensuring the high availability and stability of the database cluster, thereby significantly reducing the workload of database operation and maintenance personnel; (3) By quickly installing databases in batches, the need for manual operations is reduced, the complexity of the operation and maintenance process is reduced, and database administrators can focus more on database management and optimization; (4) Rapid database deployment and efficient fault recovery mechanisms improve database availability and response speed, and improve the end-user experience; (5) Standardized components and modular assembly methods enable database deployment to flexibly adapt to the needs of different business scenarios, providing higher configuration flexibility and scalability. BRIEF DESCRIPTION OF THE DRAWINGS

[0030] Figure 1 The present invention is a flow chart of a method for batch installation of databases based on a cloud platform.

[0031] Figure 2 This is a schematic diagram of the system structure for batch installation of databases based on a cloud platform in the present invention.

[0032] Figure 3 A cluster flow diagram is added to the database of the present invention. DETAILED DESCRIPTION

[0033] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, rather than all of the embodiments. The components of the embodiments of the present invention generally described and shown in the drawings here can be arranged and designed in various different configurations. Therefore, the following detailed description of the embodiments of the present invention provided in the drawings is not intended to limit the scope of the claimed invention, but merely represents selected embodiments of the present invention. Based on the embodiments in the present invention, all other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of the present invention.

[0034] It should be noted that similar reference numerals and letters represent similar items in the following drawings, so once an item is defined in one drawing, it does not need to be further defined and explained in the subsequent drawings. At the same time, in the description of the present invention, the terms "first", "second", etc. are only used to distinguish the description and cannot be understood as indicating or implying relative importance.

[0035] Glossary:

[0036] PaaS, or Platform as a Service, is a cloud computing service model that provides a series of services and functions required for application development and deployment, allowing developers to focus on application development without having to worry about the underlying infrastructure and operation and maintenance.

[0037] PaaS computing resource pool, the PaaS computing resource pool for building a database cluster is a resource management method provided at the Platform as a Service (PaaS) level, which allows users to centrally manage and monitor database resources without having to worry about the details of the underlying infrastructure.

[0038] The database cloud management platform is a service for enterprise hybrid database environments. It provides one-stop database management services across multi-cloud architectures and multiple types of databases. This platform provides enterprises with full-life cycle database management services such as database installation and deployment, monitoring and inspection, performance and capacity management, improved availability, and security management in a standardized, automated, and intelligent manner.

[0039] The database management and control platform refers to a comprehensive management platform that is specifically used to monitor, manage, and optimize the performance and resources of the database system. This platform usually has the following core functions: monitoring the status of multiple database instances and clusters, including performance indicators, resource usage, operation logs, etc., so as to promptly identify and handle problems; providing performance analysis tools to help administrators identify performance bottlenecks, optimize query statements, and adjust database configurations to improve the overall performance of the database; being able to intelligently schedule resources according to business load to achieve optimal resource allocation; being able to set alarm rules to promptly notify administrators when database anomalies occur, and providing event management functions to help track and solve database problems, etc.

[0040] In the first aspect, the present application provides a method for batch installation of databases based on a cloud platform, such as Figure 1 As shown, including:

[0041] S1. The application side initiates a database resource application through the database cloud management platform;

[0042] Specifically, in order to install databases in batches, the application side initiates a resource application through the database cloud management platform to create containers that meet user requirements. The cloud management platform here is equivalent to the management system of the cloud platform, which is used to manage the resources of the cloud platform, including allocating resources, recycling resources, managing new resources on the host, and reinitializing resources. The cloud platform can be a mainstream cloud platform on the market such as Huawei Cloud, Alibaba Cloud, etc.; it can also be a series of host resource groups integrated through the PaaS container orchestration service, similar to a resource pool, which can achieve efficient use of server resources.

[0043] S2. The database cloud management platform calls an interface from the PaaS platform according to the resource application to create containers in batches;

[0044] Specifically, the database cloud management platform uses the database resource application information sent by the application side to call the K8S interface through the PaaS platform to batch create containers. Depending on the components, they can be divided into computing nodes, data nodes, global transaction node containers, etc. Of course, even if the components are the same, the container specifications will be different, which is subject to the actual situation.

[0045] S3: Create a component image of the database, call the interface to install database components in batches, and call the script to build a database cluster;

[0046] Specifically, the database side creates image files for each component by calling the K8S interface, including computing node images, data node images, and global transaction node images, and then uploads the image files of these components to the database management and control platform. When the database management and control platform receives a successful response from the cloud management platform, it will call the installation script according to the obtained networking information to quickly create relevant components in the corresponding container, and mount the disk to the persistent directory of each node. The image production process includes formulating corresponding Dockerfiles and startup scripts (including startup process sequence, data mount directory, environment variable settings, etc.) based on the container operating system and according to the different types of database components, and then calling the K8S interface to create image files for each component and upload them to the database management and control platform insight. The Dockerfile template is as follows:

[0047] #Specify the base image

[0048] FROM ARM:KYLINV10

[0049] #Install script execution environment

[0050] RUN yuminstall-ypython-2.7.5

[0051] #Add the product packages required for installing DB, installing the product packages required for insightagent, and the pre-installed environment initialization script

[0052] ADD / home / dockerpre / db_prepare.zip / home / prepare

[0053] #Execute the installation DB script

[0054] #This script will have built-in environment initialization module, DB installation module, insightagent installation module

[0055] RUN python install_db.py

[0056] #Set the directory for the persistent volume

[0057] VOLUME[" / home / zxdb1 / etc"," / home / zxdb1 / log"]

[0058] #Expose the ports used and their meanings

[0059] #Listening port of the main process mysqld of the DB container

[0060] EXPOSE 5021

[0061] #Start the executable file compressed by the container script

[0062] #This script at least includes commands to start each subprocess and modify the configuration file command according to the IP address of the starting container.

[0063] CMD[" / sbin / init"]

[0064] When the database management and control platform receives the response that each database component has been successfully created, it will call the script according to the networking information to quickly build a database cluster, which can be a single cluster or multiple clusters; it can be a centralized cluster or a distributed cluster. The networking information template is as follows:

[0065] #Cluster topology, key name cannot be modified

[0066] clusterList:

[0067] #Cluster name, key name can be modified

[0068] cluster1:

[0069] #Data node topology in the cluster, key name cannot be modified

[0070] dnCluster:

[0071] #Shard name, please fill in the form of group+int, starting from group1

[0072] group1:

[0073] #Computer room name, modified according to the deployment room

[0074] YHT:

[0075] #key is the group name, please fill it in the form of team+int, starting from team1, value is the number of deployments

[0076] team1:1

[0077] #Compute node topology in the cluster, keyname cannot be modified

[0078] cnCluster:

[0079] #Computer room name, modified according to the deployment room

[0080] YHT: 1

[0081] #Global transaction management node topology in the cluster, keyname cannot be modified

[0082] dnCluster:

[0083] #Shard name, please fill in the form of group+int, only one group is allowed

[0084] group1:

[0085] #Computer room name, modified according to the deployment room

[0086] YHT:

[0087] #key is the group name, please fill it in the form of team+int, starting from team1, value is the number of deployments

[0088] team1:1

[0089] #The topology of the import and export components in the cluster. The keyname cannot be modified.

[0090] LdsCluster:

[0091] #Computer room name, modified according to the deployment room

[0092] YHT: 1

[0093] #Cluster configuration, key name cannot be modified

[0094] clusterConfig:

[0095] #Username and password used by the business to access the cluster. The key cannot be modified and the value is encrypted using base64

[0096] insUserPasswd:ZGIxeEBOSisx

[0097] #High availability mode, key cannot be modified, value has the following options: 0 high availability, 1 high reliability, 2 high reliability - single machine room multi-node deployment, 3 high reliability - dual machine room deployment in the same city - only select the local master, 4 high reliability - dual machine room deployment in the same city - local priority, local exceptions are automatically switched across AZs, 5 strong consistency - dual machine room deployment in the same city - local priority, local exceptions are automatically switched across AZs

[0098] haMode:0

[0099] #Instance type, key cannot be modified, value has the following options: 0 multiple shards, 1 single shard

[0100] instanceType;0

[0101] #dn parameter template, key and value cannot be modified, pre-stored in configmap, configmap key is template id, value is template content

[0102] dnTemplateId:my.cnf

[0103] The new process of adding a database, such as Figure 3 As shown: fill in the installation database component information through the database cloud management platform, and choose to synchronize to the database cluster configuration baseline in advance; then call the PaaS platform to create a database cluster; the PaaS computing resource pool creates a container for the database according to the deployment requirements, and calls the PaaS platform to return the installation result; determine whether the installation result meets the requirements (if not, reinstallation is required), and finally form the cluster configuration information required by the database; call the database management and control platform Rest API interface to pass the cluster information of each node; the database management and control platform installs the agent and assembles the database cluster according to the cluster information.

[0104] S4. The database management and control platform monitors the database operation status and dynamically manages the creation container.

[0105] Specifically, after the database is successfully deployed on the cloud platform, the database status monitoring is completed through the database management and control platform. The database management and control platform insight is a graphical operation and maintenance interface with inspection, collection, diagnosis, monitoring, alarm and other functions to facilitate database management personnel's operation and maintenance. The database management and control platform insight regularly collects the operation information of database components by sending collection scripts to each component of the database, including the operation status of each component and whether the link is normal; while PaaS dynamically manages container node resources, including removing faulty nodes and automatically adding substitute nodes. The two work together to significantly improve the database monitoring capabilities and better facilitate database operation and maintenance personnel.

[0106] After the database is successfully installed, each component is in normal state and the cluster parameters are in the default state. In order to better adapt to different business scenarios, improve database performance, and facilitate database management personnel's operation and maintenance, you can log in to the operation and maintenance platform insight to modify the isolation level, number of connections, configuration parameters of database components, etc., add or delete database monitoring items, filter important alarms and notify database management personnel in a timely manner. In addition, you can also log in to the background server, switch to the corresponding component user, modify the *.ini or my.cnf file in the ~ / etc directory, and restart to take effect.

[0107] This method uses the cloud platform to batch create container nodes that meet the user's specifications. After that, the database management and control platform creates database components such as data nodes and computing nodes in batches in the container nodes through the interface based on the received database networking information. The management and control platform then quickly builds a database cluster through the interface. During the operation of the database, if a database component fails, the container where the failed node is located can be removed from the network at any time, and a new component can be created to automatically fill the position. This method, which is similar to standard modular assembly, can quickly install databases in batches, greatly reducing the total time required for database deployment, significantly reducing the workload of database operation and maintenance personnel, and improving the database usage experience.

[0108] This application also provides a system for batch installation of databases based on a cloud platform, such as Figure 2 As shown, including:

[0109] Application side application module: the application side initiates database resource application through the database cloud management platform;

[0110] A container creation module, used to call an interface from the PaaS platform according to the resource application to create containers in batches;

[0111] The database cluster creation module is used to create database component images, call interfaces to batch install database components, and call scripts to build database clusters;

[0112] The monitoring and management module is used to monitor the database operation status and dynamically manage the creation of the container.

[0113] By using this system, the above-mentioned processing method can be executed and the corresponding technical effects can be achieved.

[0114] An embodiment of the present invention also provides a computer-readable storage medium capable of implementing all the steps in the method in the above embodiment, wherein a computer program is stored on the computer-readable storage medium, and when the computer program is executed by a processor, all the steps in the method in the above embodiment are implemented.

[0115] An embodiment of the present invention also provides an electronic device for executing the above method. As an implementation device of the method, the electronic device has at least a processor and a memory, and in particular, the memory stores data and related computer programs required for executing the method, and the processor calls the data and programs in the memory to execute all steps of the implementation method and obtains the corresponding technical effect.

[0116] Preferably, the electronic device may include a bus architecture, the bus may include any number of interconnected buses and bridges, and the bus will include various circuits linked together by one or more processors and memories. The bus may also link together various other circuits such as peripherals, voltage regulators, and power management circuits, which are all well known in the art and are therefore not further described herein. The bus interface provides an interface between the bus and the receiver and transmitter. The receiver and transmitter may be the same component, i.e., a transceiver, providing a unit for communicating with various other systems over a transmission medium. The processor is responsible for managing the bus and general processing, while the memory may be used to store data used by the processor when performing operations.

[0117] In addition, the electronic device may further include components such as a communication module, an input unit, an audio processor, a display, and a power supply. The processor (or controller, operation control) used may include a microprocessor or other processor device and / or a logic device, which receives input and controls the operation of various components of the electronic device; the memory may be one or more of a cache, a flash memory, a hard drive, a removable medium, a volatile memory, a non-volatile memory, or other suitable devices, which may store the above-mentioned related data information, and may also store a program for executing related information, and the processor may execute the program stored in the memory to realize information storage or processing, etc.; the input unit is used to provide input to the processor, for example, it may be a key or a touch input device; the power supply is used to provide power to the electronic device; the display is used to display display objects such as images and text, for example, it may be an LCD display. The communication module is a transmitter / receiver that sends and receives signals via an antenna. The communication module (transmitter / receiver) is coupled to the processor to provide input signals and receive output signals, which may be the same as the case of a conventional mobile communication terminal. Based on different communication technologies, multiple communication modules may be provided in the same electronic device, such as a cellular network module, a Bluetooth module and / or a wireless local area network module, etc. The communication module (transmitter / receiver) is also coupled to a speaker and a microphone via an audio processor to provide an audio output via the speaker and receive an audio input from the microphone, thereby realizing a common telecommunication function. The audio processor may include any suitable buffer, decoder, amplifier, etc. In addition, the audio processor is also coupled to a central processor, so that recording can be performed on the machine through the microphone, and the sound stored on the machine can be played through the speaker.

[0118] Those skilled in the art will appreciate that embodiments of the present invention may be provided as methods, systems, or computer program products. Therefore, the present invention may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Moreover, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0119] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowchart and / or block diagram, as well as the combination of processes and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A system that specifies the functions of a box or multiple boxes.

[0120] These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing device to work in a specific manner, so that the instructions stored in the computer-readable memory produce a product including an instruction system, which is implemented in the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0121] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process in the computer or other programmable device. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps of the functions specified in a box or multiple boxes. Although the preferred embodiments of the present invention have been described, those skilled in the art may make additional changes and modifications to these embodiments once they know the basic creative concept. Therefore, the attached claims are intended to be interpreted as including the preferred embodiments and all changes and modifications that fall within the scope of the present invention.

[0122] The above is only a preferred specific embodiment of the present invention, but the protection scope of the present invention is not limited thereto. Any changes or substitutions that can be easily thought of by a person skilled in the art within the technical scope disclosed by the present invention should be included in the protection scope of the present invention. Therefore, the protection scope of the present invention should be based on the protection scope of the claims.

Claims

1. A method for batch installation of databases based on a cloud platform, characterized in that: include: S1. The application side initiates a database resource application through the database cloud management platform; S2. The database cloud management platform calls an interface from the PaaS platform according to the resource application to create containers in batches; S3: Create a component image of the database, call the interface to install database components in batches, and call the script to build a database cluster; S4. The database management and control platform monitors the database operation status and dynamically manages the creation container.

2. The method according to claim 1, characterized in that The types of batch created containers are divided into computing node containers, data node containers, and global transaction node containers according to different components.

3. The method according to claim 1, characterized in that: The component images of the database are produced, the interface is called to batch install the database components, and the script is called to form a database cluster, including: after the database management and control platform receives the response that the database cloud management platform has successfully created the container, the database side creates the image files of each component by calling the K8S interface, and then uploads the image files of each component to the database management and control platform; After uploading the image files of each component to the database management and control platform, the database management and control platform calls the installation script according to the networking information to create relevant components in the corresponding container, and mounts the disk to the persistent directory of each node; The database management and control platform calls the script component database cluster based on the networking information.

4. The method according to claim 1, characterized in that: The database management and control platform monitors the database operation status and dynamically manages the creation container, including: using the insight interface of the database management and control platform to inspect, collect, diagnose, monitor, and alarm the database, wherein collection refers to sending collection scripts through the insight of the database management and control platform to regularly collect the operation information of database components to determine whether the operation status of each component is normal.

5. The method according to claim 4, characterized in that The database management and control platform monitors the database operation status and dynamically manages the created container, and also includes: using the Paas platform to dynamically manage the created container, including removing faulty nodes and automatically adding new containers as replacements.

6. The method according to claim 1, characterized in that The method also includes: after the database cluster is successfully installed, the isolation level, number of connections, parameter configuration of database components, adding and deleting data monitoring items, screening important alarms and notifying database administrators in a timely manner can be modified by logging into the insight interface of the database management and control platform.

7. A system for batch installation of databases based on a cloud platform, characterized in that: include: Application side application module: the application side initiates database resource application through the database cloud management platform; A container creation module, used to call an interface from the PaaS platform according to the resource application to create containers in batches; The database cluster creation module is used to create database component images, call interfaces to batch install database components, and call scripts to build database clusters; The monitoring and management module is used to monitor the database operation status and dynamically manage the creation of the container.

8. A computer-readable storage medium, characterized in that: The storage medium stores a computer program, and when the computer program is executed by a processor, the method according to any one of claims 1 to 6 is implemented.

9. An electronic device, characterized in that: including a processor and a memory; The memory is used to store computer programs; The processor is configured to execute the method according to any one of claims 1 to 6 by calling a stored computer program.

10. A computer program product comprising a computer program and / or instructions, characterized in that: When the computer program and / or the instructions are executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

Citation Information

Patent Citations

  • Database deployment method and device

    CN104717233A