OpenGauss database cloud platform deployment method and device, medium and equipment

Through the deployment method of openGauss database cloud platform, the problem of complexity of openGauss database installation and operation and maintenance is solved, and a simple and fast visual deployment method is provided, which reduces user costs, realizes rapid deployment and management, and improves the reliability of database services.

CN118963807AInactive Publication Date: 2024-11-15SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD

Patent Information

Application Number
CN202411156222.2
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-08-22
Publication Date
2024-11-15
Estimated Expiration
Not applicable · inactive patent

AI Technical Summary

Technical Problem

The installation and operation and maintenance of openGauss database is technically difficult for beginners and general users and the process is complicated, especially the installation operation of the enterprise version is more difficult, and there is a lack of a simple and fast visual deployment method.

Method used

Provides an openGauss database cloud platform deployment method, which is executed through the cloud platform, including version selection, installation package selection, installation environment detection, dependency service detection, installation deployment, operation log analysis and resource monitoring, to realize visual installation and operation and maintenance processes. Supports offline and online installation, providing single-node, master-support and multi-node deployment methods.

Benefits of technology

It reduces the learning costs and operation and maintenance costs of users, realizes the rapid deployment and management of openGauss database, provides a simple and fast visual deployment method, reduces operation and maintenance complexity, and improves the reliability and convenience of database services.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118963807A_ABST
    Figure CN118963807A_ABST
Patent Text Reader

Abstract

The invention provides an openGauss database cloud platform deployment method and device, a medium and equipment. The method comprises the steps that a first page is provided, and version options and installation mode options of openGauss database service are arranged on the first page so that personnel can select the version and the installation mode of the openGauss database service on the first page; a corresponding openGauss installation package is selected; a second page is provided, and the second page is provided with an installation and deployment information filling item, so that a person fills installation and deployment information on the second page; carrying out installation environment detection on the target server; if the installation environment detection is passed, the openGauss installation package is uploaded to the target server, and the dependent service is detected; and if the detection of the dependency service is passed, installing and deploying the openGauss database service on the target server according to the openGauss installation package, the installation mode and the installation and deployment information. The invention provides a simple and rapid visual deployment mode.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of databases, and in particular to an openGauss database cloud platform deployment method, device, medium and equipment. Background Art

[0002] OpenGauss is an open source relational database management system developed and maintained by Huawei, aiming to provide an alternative to commercial databases for domestic enterprises. The installation and operation of openGauss is technically difficult, complicated, and has a steep learning curve for novice users or users who simply want to test the basic features of the openGauss database. In particular, the installation of the enterprise version is more difficult for general users. Therefore, a simple and fast visual deployment method is urgently needed. Summary of the invention

[0003] In response to at least one of the above technical problems, an embodiment of the present invention provides an openGauss database cloud platform deployment method and apparatus, medium, and equipment.

[0004] According to a first aspect, an openGauss database cloud platform deployment method provided by an embodiment of the present invention is executed by a cloud platform, and the method includes:

[0005] Providing a first page, wherein the first page has a version selection item and an installation method selection item of the openGauss database service, so that a person can select the version and installation method of the openGauss database service on the first page;

[0006] Select a corresponding openGauss installation package according to the architecture of the target server on which the openGauss database service is to be installed and the version of the openGauss database service;

[0007] Providing a second page, wherein the second page has an installation and deployment information filling item, so that a person can fill in the installation and deployment information on the second page;

[0008] Performing installation environment detection on the target server;

[0009] If the installation environment detection passes, the openGauss installation package is uploaded to the target server, and the dependent services of the openGauss installation package on the target server are detected;

[0010] If the detection of the dependent service passes, the openGauss database service is installed and deployed on the target server according to the openGauss installation package, the installation method and the installation and deployment information.

[0011] In one embodiment, the versions available for selection in the version selection item on the first page include minimalist version, lightweight version and enterprise version; and / or, the installation methods available for selection in the installation method selection item include offline installation and online installation; and / or, the architecture of the target server is X86 architecture or ARM architecture; and / or, the installation deployment information includes at least one of the IP address of the target server, the user of the openGauss database service, the installation directory of the openGauss database service and the port number occupied by the openGauss database service.

[0012] In one embodiment, before selecting a corresponding openGauss installation package according to the architecture of the target server on which the openGauss database service is to be installed and the version of the openGauss database service, the method further includes:

[0013] Providing a third page, wherein the third page has a deployment mode selection item, wherein the selectable deployment modes in the deployment mode selection item include a single-node deployment mode, a primary-backup deployment mode, and a multi-node deployment mode, so that a person can select a deployment mode of the openGauss database service on the third page;

[0014] Correspondingly, selecting a corresponding openGauss installation package according to the architecture of the target server on which the openGauss database service is to be installed and the version of the openGauss database service includes: determining the target server on which the openGauss database service is to be installed according to the deployment method selected by the personnel, and selecting a corresponding openGauss installation package according to the architecture of the target server and the version of the openGauss database service.

[0015] In one embodiment, the performing installation environment detection on the target server includes:

[0016] Detect whether the architecture information and operating system information corresponding to the target server and the openGauss installation package match; if they match, determine whether the remaining resources of the target server meet the installation and deployment requirements of the openGauss database service; if they meet the installation and deployment requirements, determine whether the user meets the installation conditions; if they meet the installation conditions, determine that the installation environment test has passed.

[0017] In one embodiment, the method further comprises:

[0018] If the installation environment detection of the target server fails, remotely log in to the target server through the secure shell protocol, and modify the installation environment of the target server until the modified detection environment passes the installation environment detection;

[0019] Alternatively, if the detection of the dependent service fails, the target server is remotely logged in through the secure shell protocol to modify the dependent service until the modified dependent service passes the detection.

[0020] In one embodiment, the method further comprises:

[0021] Regularly query the operation log of the openGauss database service;

[0022] The operation log is analyzed to obtain the operation status of the openGauss database service, and the operation status is visualized.

[0023] In one embodiment, the method further comprises:

[0024] Regularly collect resource usage data and abnormal events of the target server;

[0025] Determining whether resource usage of the server is abnormal based on the resource usage data;

[0026] Visualizing the resource usage;

[0027] If an abnormality occurs or the abnormal event is collected, an alarm is generated and pushed to the user of the openGauss database service.

[0028] According to a second aspect, an openGauss database cloud platform deployment device provided by an embodiment of the present invention is deployed on a cloud platform, and the device includes:

[0029] A first providing module is used to provide a first page, wherein the first page has a version selection item and an installation method selection item of the openGauss database service, so that a person can select the version and installation method of the openGauss database service on the first page;

[0030] A first selection module is used to select a corresponding openGauss installation package according to the architecture of the target server where the openGauss database service is to be installed and the version of the openGauss database service;

[0031] A second providing module is used to provide a second page, wherein the second page has an installation and deployment information filling item, so that a person can fill in the installation and deployment information on the second page;

[0032] A first detection module, used to perform installation environment detection on the target server;

[0033] A first uploading module is used to upload the openGauss installation package to the target server if the installation environment detection passes, and detect the dependent services of the openGauss installation package on the target server;

[0034] The installation and deployment module is used to install and deploy the openGauss database service on the target server according to the openGauss installation package, the installation method and the installation and deployment information if the detection of the dependent service passes.

[0035] According to a third aspect, an embodiment of the present invention provides a computer-readable storage medium having a computer program stored thereon, which, when executed in a computer, enables the computer to execute the method provided in the first aspect.

[0036] According to a fourth aspect, an embodiment of the present invention provides a computing device, including a memory and a processor, wherein the memory stores executable code, and when the processor executes the executable code, the method provided in the first aspect is implemented.

[0037] The openGauss database cloud platform deployment method, device, medium, and equipment provided by the embodiment of the present invention, the personnel select the version and installation method of the openGauss database service on the first page of the cloud platform, and then the cloud platform selects the corresponding openGauss installation package according to the architecture of the target server and the version of the openGauss database service, and then the personnel fills in the installation and deployment information on the second page of the cloud platform. The target server is tested for the installation environment, and after the environment test passes, the openGauss installation package is uploaded to the target server, and the dependent services of the openGauss installation package on the target server are tested; after the dependent service test passes, the openGauss database service is installed and deployed on the target server according to the openGauss installation package, the installation method, and the installation and deployment information. It can be seen that based on the method provided by the embodiment of the present invention, the personnel only need to input or select information according to the prompts on the page to realize the installation and deployment of the openGauss database service, so that the operation and maintenance personnel can quickly deploy various types of openGauss database services in the generation environment, reducing the user's learning cost and operation and maintenance cost, and is a simple and fast visual deployment method. BRIEF DESCRIPTION OF THE DRAWINGS

[0038] Figure 1 A schematic diagram of the process of deploying the openGauss database cloud platform in one embodiment of the present invention;

[0039] Figure 2 It is a structural block diagram of an openGauss database cloud platform deployment device in one embodiment of the present invention. DETAILED DESCRIPTION

[0040] In a first aspect, an embodiment of the present invention provides an openGauss database cloud platform deployment method, the method is executed by the cloud platform, see Figure 1 , the method comprises the following steps S110 to S170:

[0041] S110, providing a first page, wherein the first page has a version selection item and an installation method selection item of the openGauss database service, so that a person can select the version and installation method of the openGauss database service on the first page;

[0042] That is, the personnel select the version and installation method of the openGauss database service on the first page of the cloud platform.

[0043] Among them, the versions available for selection in the version selection item on the first page include minimalist version, lightweight version and enterprise version.

[0044] Among them, the installation methods available in the installation method selection item include offline installation and online installation.

[0045] S120, selecting a corresponding openGauss installation package according to the architecture of the target server on which the openGauss database service is to be installed and the version of the openGauss database service;

[0046] The architecture of the target server is X86 architecture or ARM architecture.

[0047] It is understandable that different server architectures and different openGauss database service versions require different openGauss installation packages, so it is necessary to select the installation package based on the architecture of the target server and the version of the openGauss database service.

[0048] In one embodiment, before selecting the corresponding openGauss installation package according to the architecture of the target server where the openGauss database service is to be installed and the version of the openGauss database service in S120, the method may further include:

[0049] A third page is provided, which has deployment mode selection items. The selectable deployment modes in the deployment mode selection items include single-node deployment mode, active-standby deployment mode and multi-node deployment mode, so that personnel can select the deployment mode of the openGauss database service on the third page.

[0050] It can be seen that personnel can choose the desired deployment method on the second page of the cloud platform.

[0051] Correspondingly, the step of selecting a corresponding openGauss installation package according to the architecture of the target server on which the openGauss database service is to be installed and the version of the openGauss database service in S120 may specifically include:

[0052] According to the deployment method selected by the personnel, determine the target server on which the openGauss database service is to be installed, and select the corresponding openGauss installation package according to the architecture of the target server and the version of the openGauss database service.

[0053] It can be seen that after knowing the deployment method selected by the personnel, each server that needs to deploy the openGauss database service can be used as the target server according to the deployment method, and then the corresponding openGauss installation package can be selected based on the architecture of the target server and the version of the openGauss database service.

[0054] S130, providing a second page, wherein the second page has an installation and deployment information filling item, so that a person can fill in the installation and deployment information on the second page;

[0055] It can be seen that personnel can select or fill in the installation and deployment information on the second page as needed.

[0056] The installation and deployment information may include at least one of the IP address of the target server, the user of the openGauss database service, the installation directory of the openGauss database service, and the port number occupied by the openGauss database service.

[0057] S140, performing installation environment detection on the target server;

[0058] In one embodiment, the installation environment detection of the target server in S140 may include: detecting whether the architecture information and operating system information corresponding to the target server and the openGauss installation package match; if they match, determining whether the remaining resources of the target server meet the installation and deployment requirements of the openGauss database service; if the installation and deployment requirements are met, determining whether the user meets the installation conditions; if the installation conditions are met, determining that the installation environment detection has passed.

[0059] It can be seen that the installation environment test is considered to have passed only if the architecture and operating system corresponding to the target server and the openGauss installation package match, the remaining resources of the target server meet the installation and deployment requirements of the openGauss database service, and the user meets the installation conditions. If any one of the conditions is not met, the installation environment test is considered to have failed.

[0060] In one embodiment, the method may further include: if the installation environment test of the target server fails, remotely logging into the target server via a secure shell protocol, and modifying the installation environment of the target server until the modified test environment passes the installation environment test.

[0061] It can be seen that if the installation environment test of the target server fails, the personnel can remotely log in to the target server through the secure shell protocol on the cloud platform, and then remotely modify and adjust the installation environment on the target server, and then perform the installation environment test, and repeat this process until the test environment passes the installation environment test.

[0062] S150, if the installation environment detection passes, uploading the openGauss installation package to the target server, and detecting the dependent services of the openGauss installation package on the target server;

[0063] It can be seen that after the installation environment test is passed, the openGauss installation package is uploaded to the target server, and then the dependent services of the openGauss installation package on the target server are tested. The so-called dependent services refer to the software services required for the installation, deployment and operation of the openGauss database service. Only when the dependent services pass the test can the installation and deployment of the openGauss database service be carried out.

[0064] Different openGauss database service version types and operating system version types correspond to different dependent services, so different dependent service libraries can be formed in advance according to different openGauss database service version types and operating system version types. When installing the openGauss database service for the same openGauss database service version type and operating system version type, all dependent services in the corresponding dependent service library are directly downloaded.

[0065] In one embodiment, the method may further include: if the detection of the dependent service fails, remotely logging into the target server through a secure shell protocol, and modifying the dependent service until the modified dependent service passes the detection.

[0066] It can be seen that if the detection of the dependent service fails, the personnel can remotely log in to the target server through the secure shell protocol on the cloud platform, remotely modify and adjust the dependent service on the target server, and then perform the dependent service detection again, and repeat this process until the dependent service passes the detection.

[0067] S160: If the detection of the dependent service passes, the openGauss database service is installed and deployed on the target server according to the openGauss installation package, the installation method and the installation and deployment information.

[0068] It can be seen that after the dependency service detection is passed, the openGauss database service can be installed and deployed on the target server according to the openGauss installation package, the previously selected installation method and the installation and deployment information filled in by the personnel.

[0069] When installing the openGauss database service on the server, if the installation fails, obtain the exception information, analyze the exception and give modification suggestions, and remotely log in to the server through the secure shell protocol to handle the exception. Clean up the remnants of the previous installation and install the database service again until the installation is successful. Record the server environment information and the corresponding exception information to form installation guidelines to help with future installations. After the installation is successful, the server returns the installation success message to the cloud platform, so that the cloud platform will update the corresponding relationship between the server and the openGauss database service cluster. Install monitoring collection tools and log collection agents on the server to collect various monitoring and logs of the server and openGauss database service.

[0070] In one embodiment, the method provided by the embodiment of the present invention may further include:

[0071] Regularly query the operation log of the openGauss database service;

[0072] The operation log is analyzed to obtain the operation status of the openGauss database service, and the operation status is visualized.

[0073] It can be seen that by regularly analyzing the operation log of the openGauss database service, the operation status of the openGauss database service can be learned, and then the operation status of the openGauss database service can be visualized, thereby realizing the operation and maintenance of the openGauss database service.

[0074] Of course, in addition to analyzing the operation log, you can also perform query statements, i.e. SQL statements, to diagnose and manage installation packages. SQL diagnosis can provide standardized guidance for the use of databases on the business side. Installation package management can manage the database installation packages and various database plug-ins used, and can upload compiled products to the platform. It can also provide a remote console function, which can connect to any server node in the cluster and execute server commands.

[0075] In one embodiment, the method provided by the embodiment of the present invention may further include:

[0076] Regularly collect resource usage data and abnormal events of the target server;

[0077] Determining whether resource usage of the server is abnormal based on the resource usage data;

[0078] Visualizing the resource usage;

[0079] If an abnormality occurs or the abnormal event is collected, an alarm is generated and pushed to the user of the openGauss database service.

[0080] It can be seen that the resource usage data of the target server is collected regularly to understand the resource usage and visualize the resource usage. When the resource usage is abnormal or an abnormal event occurs on the target server, an alarm will be generated and notified to the user, so that the user can know the abnormality and suspend the openGauss database service.

[0081] That is to say, the CPU, memory, and disk usage of the server are monitored, and abnormal events such as master-slave delay, session status, deadlock, blocked session, and waiting events of the display library are collected. If the monitoring indicators are abnormal, an alarm will be generated, and the configuration of third-party communication methods is supported to notify cluster users.

[0082] Of course, in the embodiment of the present invention, the cloud platform can establish a connection with the openGauss database service cluster and provide a visual database operation interface for web access. It supports uploading the openGaussjdbc driver and selecting the corresponding jdbc driver according to the version and type of the openGauss database service; it can perform DML and DDL operations on the openGauss database service on the web page; it can import and export SQL files; it can display the database SQL execution results and record database operations.

[0083] Among them, jdbc is the abbreviation of Java Database Connectivity, which is an API for database connection in Java. It allows Java developers to interact with the database using the standard SQL language. Among them, DDL is the abbreviation of Data Definition Language. In simple terms, it is an operation language for creating, deleting, and modifying objects within the database. Among them, DDL is the abbreviation of Data Definition Languages, which is a data definition language. These statements define the definitions of different database objects such as data segments, databases, tables, columns, indexes, etc. DML is the abbreviation of Data Manipulation Language, which is a data manipulation language. Users can use it to perform basic operations on the database.

[0084] It can be seen that the embodiment of the present invention deploys a management system in the cloud platform environment to connect to the server where the openGauss database service is to be deployed. Through the secure shell protocol, the server is remotely connected to perform operations, and the server where the openGauss database service is located can be managed, the openGauss database service cluster can be managed, the openGauss database service can be installed and deployed, the openGauss database service can be operated and monitored, and the database visualization operation can be performed.

[0085] Specifically, the management system on the cloud platform can manage the server by storing the server's IP address, private key, architecture, operating system, remote login user, storage specifications and other information. It can also monitor the server's CPU, memory, disk, and network IO to understand the server's operating status and resource usage, provide remote login user creation and management, and use designated users to connect to the server for database deployment and operation and maintenance. It can also provide an environment separation file, and when connecting to the server, you can use the designated environment separation file to configure environment variables.

[0086] Among them, one or more openGauss database services can be deployed on a server. If multiple openGauss database services are deployed, these openGauss database services are called an openGauss database cluster. The management system can manage the openGauss database service cluster by displaying the version, status, number of nodes, database users, ports, number of rounds, number of locks and other information of each openGauss database service. Each openGauss database service can be started, stopped, restarted, backed up, uninstalled and other operations. The parameters of each openGauss database service can be modified and sent to the cluster. If a restart is required to take effect, the openGauss database service can be restarted.

[0087] The management system on the cloud platform installs and deploys the openGauss database service, including: the management system controls the server to install the corresponding version of the database as required, and supports the installation of single-node, master-slave architecture, and high-availability architecture clusters. It supports the installation of various versions of the openGauss database and provides an offline installation function. It manages the openGauss installation packages corresponding to various operating system versions and openGauss database service versions, and can be selected according to the system architecture and openGauss database service version. The openGauss database service version is available in 3.0 and 5.0 versions.

[0088] It can be seen that the embodiment of the present invention provides a simple and fast installation and deployment solution for the openGauss database service, and can also provide basic operation and maintenance to ensure the normal use of the openGauss database service. It also provides a visual database connection page to facilitate the use and management of the openGauss database service.

[0089] In summary, based on the method provided in the embodiment of the present invention, personnel only need to input information or select according to the prompts on the page to realize the installation and deployment of the openGauss database service, allowing operation and maintenance personnel to quickly deploy various openGauss database services in the production environment, reducing the user's learning cost and operation and maintenance cost, and realizing the visualization of various common operations of openGauss.

[0090] In a second aspect, an embodiment of the present invention provides an openGauss database cloud platform deployment device, wherein the device is deployed on a cloud platform. Figure 2 , the device 100 comprises:

[0091] A first providing module 110 is used to provide a first page, wherein the first page has a version selection item and an installation method selection item of the openGauss database service, so that a person can select the version and installation method of the openGauss database service on the first page;

[0092] A first selection module 120 is used to select a corresponding openGauss installation package according to the architecture of the target server where the openGauss database service is to be installed and the version of the openGauss database service;

[0093] A second providing module 130 is used to provide a second page, wherein the second page has an installation and deployment information filling item, so that a person can fill in the installation and deployment information on the second page;

[0094] A first detection module 140, configured to perform installation environment detection on the target server;

[0095] The first uploading module 150 is used to upload the openGauss installation package to the target server if the installation environment detection passes, and detect the dependent services of the openGauss installation package on the target server;

[0096] The installation and deployment module 160 is used to install and deploy the openGauss database service on the target server according to the openGauss installation package, the installation method and the installation and deployment information if the detection of the dependent service passes.

[0097] In one embodiment, the versions available for selection in the version selection item on the first page include minimalist version, lightweight version and enterprise version; and / or, the installation methods available for selection in the installation method selection item include offline installation and online installation; and / or, the architecture of the target server is X86 architecture or ARM architecture; and / or, the installation deployment information includes at least one of the IP address of the target server, the user of the openGauss database service, the installation directory of the openGauss database service and the port number occupied by the openGauss database service.

[0098] In one embodiment, before selecting the corresponding openGauss installation package according to the architecture of the target server on which the openGauss database service is to be installed and the version of the openGauss database service, the first selection module is further used to: provide a third page, wherein the third page has a deployment mode selection item, wherein the deployment modes available in the deployment mode selection item include a single-node deployment mode, a primary-backup deployment mode, and a multi-node deployment mode, so that a person can select the deployment mode of the openGauss database service on the third page; correspondingly, the first selection module is specifically used to: determine the target server on which the openGauss database service is to be installed according to the deployment mode selected by the person, and select the corresponding openGauss installation package according to the architecture of the target server and the version of the openGauss database service.

[0099] In one embodiment, the first detection module is specifically used to: detect whether the architecture information and operating system information corresponding to the target server and the openGauss installation package match; if they match, determine whether the remaining resources of the target server meet the installation and deployment requirements of the openGauss database service; if the installation and deployment requirements are met, determine whether the user meets the installation conditions; if the installation conditions are met, determine that the installation environment test has passed.

[0100] In one embodiment, the device may further include:

[0101] An environment modification module, for remotely logging into the target server through a secure shell protocol and modifying the installation environment of the target server if the installation environment detection of the target server fails, until the modified detection environment passes the installation environment detection;

[0102] Alternatively, the dependency modification module is used to remotely log in to the target server through a secure shell protocol if the detection of the dependency service fails, and perform a modification operation on the dependency service until the modified dependency service passes the detection.

[0103] In one embodiment, the device may further include:

[0104] The database operation and maintenance module is used to regularly query the operation log of the openGauss database service; analyze the operation log to obtain the operation status of the openGauss database service, and visualize the operation status.

[0105] In one embodiment, the device may further include:

[0106] The server operation and maintenance module is used to regularly collect resource usage data and abnormal events of the target server; determine whether the resource usage of the server is abnormal based on the resource usage data; visualize the resource usage; if an abnormality occurs or the abnormal event is collected, generate an alarm, and push the alarm to users of the openGauss database service.

[0107] It is understandable that the explanation, specific implementation, beneficial effects, examples, etc. of the relevant contents in the device provided in the embodiment of the present invention can be found in the corresponding parts of the method provided in the first aspect, and will not be repeated here.

[0108] In a third aspect, an embodiment of the present invention provides a computer-readable medium, on which computer instructions are stored. When the computer instructions are executed by a processor, the processor executes the method provided in the first aspect.

[0109] Specifically, a system or device equipped with a storage medium can be provided, on which software program code that implements the functions of any of the above-mentioned embodiments is stored, and a computer (or CPU or MPU) of the system or device can be enabled to read and execute the program code stored in the storage medium.

[0110] In this case, the program code itself read from the storage medium can realize the function of any one of the above-mentioned embodiments, and thus the program code and the storage medium storing the program code constitute a part of the present invention.

[0111] The storage medium embodiments for providing the program code include a floppy disk, a hard disk, a magneto-optical disk, an optical disk (such as CD-ROM, CD-R, CD-RW, DVD-ROM, DVD-RAM, DVD-RW, DVD+RW), a magnetic tape, a non-volatile memory card, and a ROM. Alternatively, the program code can be downloaded from a server computer by a communication network.

[0112] In addition, it should be clear that the functions of any of the above embodiments can be implemented not only by executing the program code read by the computer, but also by enabling an operating system operating on the computer to complete part or all of the actual operations based on instructions from the program code.

[0113] In addition, it can be understood that the program code read from the storage medium is written to a memory provided in an expansion board inserted into the computer or to a memory provided in an expansion module connected to the computer, and then based on the instructions of the program code, a CPU installed on the expansion board or expansion module is enabled to perform part or all of the actual operations, thereby realizing the functions of any of the above-mentioned embodiments.

[0114] It is understandable that the explanation, specific implementation methods, beneficial effects, examples, etc. of the relevant contents in the computer-readable medium provided in the embodiment of the present invention can be found in the corresponding parts of the method provided in the first aspect, and will not be repeated here.

[0115] In a fourth aspect, an embodiment of the present specification provides a computing device, including a memory and a processor, wherein the memory stores executable code, and when the processor executes the executable code, it implements the method in any embodiment of the specification.

[0116] It is understandable that the explanation, specific implementation, beneficial effects, examples, etc. of the relevant contents in the computing device provided in the embodiment of the present invention can be found in the corresponding parts of the method provided in the first aspect, and will not be repeated here.

[0117] Each embodiment in this specification is described in a progressive manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the device embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment.

[0118] Those skilled in the art should be aware that in one or more of the above examples, the functions described in the present invention can be implemented by hardware, software, widgets, or any combination thereof. When implemented by software, these functions can be stored in a computer-readable medium or transmitted as one or more instructions or codes on a computer-readable medium.

[0119] The specific implementation methods described above further illustrate the objectives, technical solutions and beneficial effects of the present invention in detail. It should be understood that the above description is only a specific implementation method of the present invention and is not intended to limit the scope of protection of the present invention. Any modifications, equivalent substitutions, improvements, etc. made on the basis of the technical solution of the present invention should be included in the scope of protection of the present invention.

Claims

1. A method for deploying an openGauss database cloud platform, characterized in that: The method is performed by a cloud platform, and includes: Providing a first page, wherein the first page has a version selection item and an installation method selection item of the openGauss database service, so that a person can select the version and installation method of the openGauss database service on the first page; Select a corresponding openGauss installation package according to the architecture of the target server on which the openGauss database service is to be installed and the version of the openGauss database service; Providing a second page, wherein the second page has an installation and deployment information filling item, so that a person can fill in the installation and deployment information on the second page; Performing installation environment detection on the target server; If the installation environment detection passes, the openGauss installation package is uploaded to the target server, and the dependent services of the openGauss installation package on the target server are detected; If the detection of the dependent service passes, the openGauss database service is installed and deployed on the target server according to the openGauss installation package, the installation method and the installation and deployment information.

2. The method according to claim 1, characterized in that The versions available for selection in the version selection item on the first page include minimalist version, lightweight version and enterprise version; and / or, the installation methods available for selection in the installation method selection item include offline installation and online installation; and / or, the architecture of the target server is X86 architecture or ARM architecture; and / or, the installation deployment information includes at least one of the IP address of the target server, the user of the openGauss database service, the installation directory of the openGauss database service and the port number occupied by the openGauss database service.

3. The method according to claim 1, characterized in that Before selecting a corresponding openGauss installation package according to the architecture of the target server on which the openGauss database service is to be installed and the version of the openGauss database service, the method further includes: Providing a third page, wherein the third page has a deployment mode selection item, wherein the selectable deployment modes in the deployment mode selection item include a single-node deployment mode, a primary-backup deployment mode, and a multi-node deployment mode, so that a person can select a deployment mode of the openGauss database service on the third page; Correspondingly, selecting a corresponding openGauss installation package according to the architecture of the target server on which the openGauss database service is to be installed and the version of the openGauss database service includes: determining the target server on which the openGauss database service is to be installed according to the deployment method selected by the personnel, and selecting a corresponding openGauss installation package according to the architecture of the target server and the version of the openGauss database service.

4. The method according to claim 1, characterized in that The performing installation environment detection on the target server includes: Detect whether the architecture information and operating system information corresponding to the target server and the openGauss installation package match; if they match, determine whether the remaining resources of the target server meet the installation and deployment requirements of the openGauss database service; if they meet the installation and deployment requirements, determine whether the user meets the installation conditions; if they meet the installation conditions, determine that the installation environment test has passed.

5. The method according to claim 1, characterized in that The method further comprises: If the installation environment detection of the target server fails, remotely log in to the target server through the secure shell protocol, and modify the installation environment of the target server until the modified detection environment passes the installation environment detection; Alternatively, if the detection of the dependent service fails, the target server is remotely logged in through the secure shell protocol to modify the dependent service until the modified dependent service passes the detection.

6. The method according to claim 1, characterized in that Also includes: Regularly query the operation log of the openGauss database service; The operation log is analyzed to obtain the operation status of the openGauss database service, and the operation status is visualized.

7. The method according to claim 1, characterized in that Also includes: Regularly collect resource usage data and abnormal events of the target server; Determining whether resource usage of the server is abnormal based on the resource usage data; Visualizing the resource usage; If an abnormality occurs or the abnormal event is collected, an alarm is generated and pushed to the user of the openGauss database service.

8. An openGauss database cloud platform deployment device, characterized in that: The device is deployed on a cloud platform and includes: A first providing module is used to provide a first page, wherein the first page has a version selection item and an installation method selection item of the openGauss database service, so that a person can select the version and installation method of the openGauss database service on the first page; A first selection module is used to select a corresponding openGauss installation package according to the architecture of the target server where the openGauss database service is to be installed and the version of the openGauss database service; A second providing module is used to provide a second page, wherein the second page has an installation and deployment information filling item, so that a person can fill in the installation and deployment information on the second page; A first detection module, used to perform installation environment detection on the target server; A first uploading module is used to upload the openGauss installation package to the target server if the installation environment detection passes, and detect the dependent services of the openGauss installation package on the target server; The installation and deployment module is used to install and deploy the openGauss database service on the target server according to the openGauss installation package, the installation method and the installation and deployment information if the detection of the dependent service passes.

9. A computer-readable storage medium, characterized in that: A computer program is stored thereon, and when the computer program is executed in a computer, the computer is caused to execute the method according to any one of claims 1 to 7.

10. A computing device, characterized in that The method comprises a memory and a processor, wherein the memory stores executable codes, and when the processor executes the executable codes, the method according to any one of claims 1 to 7 is implemented.

Citation Information

Patent Citations

  • Data deployment and installation method, equipment, system and medium

    CN109491669A

  • Cluster deployment method and device, electronic equipment and storage medium

    CN113572862A

  • Database installation method

    CN113778468A

  • Method for integrating OpenGauss in big data platform supporting multi-core multi-OS combined environment

    CN117762433A

  • Method and system for managing micro release automation in an application delivery system

    US20170168795A1

Cited By

  • Method and system for batch deployment of openGauss kernel-based relational databases

    CN120909605A