Database installation method and device, terminal and storage medium

Abstract

The invention provides a database installation method and device, a terminal and a storage medium, and relates to the field of database management and maintenance. The method comprises the steps that database information and server information needing to be installed by a target user are obtained, the database information comprises a database installation package, the server information comprises hardware information, development information and installation path information of a target server, and the installation path information comprises a database installation package directory; judging whether the target server meets preset server conditions or not, wherein the preset server conditions comprise a hardware judgment sub-condition, a development judgment sub-condition and an installation path judgment sub-condition; and if the target servers meet the preset server conditions, decompressing the database installation package to a database installation package directory of the target servers, and performing installation. The installation efficiency and accuracy can be improved, and the requirement for professional skills of installation personnel is lowered.

Description

Technical Field

[0001] The present application relates to the field of database management and maintenance, and in particular to a database installation method, device, terminal and storage medium. Background Art

[0002] In the current database application environment, database installation and configuration is a crucial part of the database deployment process. Traditionally, database installation and configuration often rely on complex command line operations or editing configuration files, which not only requires users to have a high level of technical skills and professional knowledge, but is also prone to installation failure or improper configuration due to human errors, thus affecting the stability and performance of the database. Summary of the invention

[0003] The present application provides a database installation method, device, terminal and storage medium to solve the problem in the prior art that database installation is prone to errors and is inefficient due to manual operation.

[0004] In a first aspect, the present application provides a database installation method, comprising: Obtain database information and server information that the target user needs to install, wherein the database information includes a database installation package, and the server information includes hardware information, development information, and installation path information of the target server, wherein the installation path information includes a database installation package directory; Determine whether the target server meets a preset server condition, wherein the preset server condition includes a hardware judgment sub-condition, a development judgment sub-condition, and an installation path judgment sub-condition; If the target servers all meet the preset server conditions, the database installation package is decompressed to the database installation package directory of the target server and installed.

[0005] In a second aspect, the present application provides a database installation device, comprising: An acquisition module is used to acquire the database information and the server information of the database installation selected by the target user on the WEB visual interface. The database information includes the database installation package. The server information includes the hardware information, development information and installation path information of the target server. The installation path information includes the database installation package directory. A judgment module, used to judge whether the target server meets the preset server conditions, wherein the preset server conditions include hardware judgment sub-conditions, development judgment sub-conditions and installation path judgment sub-conditions; The installation module is used to decompress the database installation package to the database installation package directory of the target server and install it if the target servers all meet the preset server conditions.

[0006] In a third aspect, the present application provides a terminal comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the computer program, the steps of the method described in the first aspect or any possible implementation of the first aspect are implemented.

[0007] In a fourth aspect, the present application provides a computer-readable storage medium, which stores a computer program. When the computer program is executed by a processor, it implements the steps of the method described in the first aspect or any possible implementation of the first aspect.

[0008] The present application provides a database installation method, device, terminal and storage medium. The method obtains database information and server information that a target user needs to install, wherein the database information includes a database installation package, and the server information includes hardware information, development information and installation path information of the target server, and the installation path information includes a database installation package directory; determines whether the target server meets preset server conditions, and the preset server conditions include hardware judgment sub-conditions, development judgment sub-conditions and installation path judgment sub-conditions; if the target server meets the preset server conditions, the database installation package is unzipped to the database installation package directory of the target server and installed. By pre-acquiring the database information and server information that the target user needs to install, the present application can ensure that all information required for the installation process is ready, reduce the accuracy or incorrectness of the information during the installation process, and thus improve the installation efficiency and accuracy; by performing conditional judgment on the target server before installation, it can ensure that the database can run in a suitable hardware and development environment, thereby avoiding resource waste or performance bottlenecks caused by improper configuration, helping to optimize server resource utilization and improve the operating efficiency of the overall system, and the comprehensive judgment mechanism helps to ensure that the database installation package can run smoothly on the target server, enhancing the compatibility and stability of the database; in addition, according to the clear installation guide and conditional judgment, the user can easily complete the installation process without in-depth understanding of the complex details of the database installation, greatly improving the user's installation experience and making the installation and use of the database more convenient, and the present application automates the process of unzipping the database installation package to the specified directory of the target server and installing it, reducing the complexity and error rate of manual operations, making the database installation process more concise and clear, and reducing the requirements for the professional skills of the installer. BRIEF DESCRIPTION OF THE DRAWINGS

[0009] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative labor.

[0010] Figure 1 It is a scenario diagram of the database installation method provided in an embodiment of the present application; Figure 2 is a flowchart of the implementation of the database installation method provided in the embodiment of the present application; Figure 3 It is a specific implementation flow chart of the database installation provided in the embodiment of the present application; Figure 4 It is a specific implementation flow chart of the database instance installation provided in the embodiment of the present application; Figure 5 It is a structural schematic diagram of a database installation device provided in an embodiment of the present application; Figure 6 It is a schematic diagram of a terminal provided in an embodiment of the present application. DETAILED DESCRIPTION

[0011] In the following description, specific details such as specific system structures, technologies, etc. are provided for the purpose of illustration rather than limitation, so as to provide a thorough understanding of the embodiments of the present application. However, it should be clear to those skilled in the art that the present application may also be implemented in other embodiments without these specific details. In other cases, detailed descriptions of well-known systems, devices, circuits, and methods are omitted to prevent unnecessary details from obstructing the description of the present application.

[0012] In order to make the purpose, technical solutions and advantages of the present application clearer, specific embodiments will be described below in conjunction with the accompanying drawings.

[0013] Since the installation and configuration of traditional databases often rely on complex command line operations or editing configuration files, it not only requires users to have a high level of technical skills and expertise, but is also prone to installation failure or improper configuration due to human errors, which in turn affects the stability and performance of the database.

[0014] Although there are some GBase 8S visual installation devices, they often mix the GBase 8S database installation with the database instance installation, which cannot provide a good database resource environment for the GBase 8S database cluster construction.

[0015] Based on the above problems, the embodiment of the present application proposes a database installation method, which aims to guide users to complete the database installation and configuration process through a graphical interface, reduce errors, and improve installation efficiency. It also isolates the GBase 8S database installation from the instance installation, providing a good database environment for GBase 8S to build a high-availability cluster.

[0016] The embodiment of the present application encapsulates complex installation steps and configuration options in a visual interface, and provides an automated configuration optimization tool that can automatically recommend the optimal configuration parameters based on the server system parameters. Users only need to follow the interface prompts to complete the database deployment, which greatly reduces the technical threshold for database management, allowing more users to easily get started with the management and maintenance of the GBase 8S database, and provides a good environment for the subsequent construction of a GBase 8S high-availability cluster. Figure 1 , users can Figure 1 The database is deployed through the browser interface in the database, and is distributed to multiple different receiving devices (Server A, Server B and / or Server C) by the back-end server at the same time.

[0017] In addition, the embodiment of the present application uses WebSocket technology to update the installation progress and status in real time, and the user does not need to manually refresh the interface or wait for a long time to respond. During the installation process, the system can push logs and progress information in real time, and the user can understand the current installation status through dynamic progress bars, real-time log output, etc. Help users clearly understand the progress of the installation and be able to respond in time when problems arise. When installation errors occur, they can be corrected and reinstalled in time according to the prompt information provided by the device. The embodiment of the present application aims to simplify the complexity of database management and improve operation and maintenance efficiency, especially in the face of rapid response capabilities such as changing database ports, restarting, stopping, uninstalling databases, and server IP address changes, and also provides intelligent diagnosis functions to solve problems that may arise during the installation process and provide personalized installation suggestions.

[0018] During the installation process, users can not only select a specific database and a specific server on the visual interface and install and deploy the database to the server, but also select any database and install and deploy the database to any server that meets the requirements. Moreover, multiple databases of different versions can be installed and deployed on one server.

[0019] Among them, the database described in the embodiments of the present application is a GBase 8S database, and the databases in the whole text all refer to the GBase 8S database.

[0020] For specific data installation process, refer to Figure 2 , Figure 2The implementation flow chart of the database installation method provided in the embodiment of the present application is detailed as follows: In step 201, the database information and server information that the target user needs to install are obtained. The database information includes the database installation package. The server information includes the hardware information, development information and installation path information of the target server. The installation path information includes the database installation package directory.

[0021] In an embodiment of the present application, the database information and server information that need to be installed and are selected by the target user are obtained.

[0022] The database information may include a database installation package, and the database installation package is uploaded to the WEB server, waiting for installation and deployment. The database information may also include a database installation account (such as root or a specific user) and an installation path.

[0023] The server information may include the hardware information, development information, and installation path information of the target server. In addition, the server information may also include the service address (IP or domain name) where the database is installed.

[0024] The embodiment of the present application can ensure that all information required for the installation process is ready by pre-acquiring the database information and server information required by the target user, including a detailed database installation package and server hardware configuration, development environment, and installation path, thereby reducing information missing or errors during the installation process and improving installation efficiency and accuracy.

[0025] In a possible implementation, obtaining the database information and server information that the target user needs to install may include: Obtain the database information and server information that the target user selects on the WEB visual interface and needs to install.

[0026] Optionally, the target user can use the WEB visualization interface (i.e. Figure 1 Select the database information and server information that need to be installed on the visual interface of the browser in the browser, and then the back-end server obtains the selected database information and server information.

[0027] The embodiment of the present application uses a WEB visual interface, and the target user can intuitively select the database information and server information to be installed without having to deeply understand the complex installation steps or technical details. This method greatly reduces the difficulty of database installation, allowing non-professionals to easily complete the installation process, and improves the convenience and user-friendliness of the operation.

[0028] In a possible implementation, after obtaining the database information and server information that the target user needs to install, the method may further include: The user configures the server information on the WEB visual interface, where the server information may also include basic information such as IP address, port, account, password, etc.

[0029] In step 202, it is determined whether the target server meets the preset server conditions, where the preset server conditions include hardware determination sub-conditions, development determination sub-conditions, and installation path determination sub-conditions.

[0030] In the embodiment of the present application, after obtaining the server information, it is necessary to first verify whether the target service can be deployed and installed with a database, and then determine whether the target server meets the preset server conditions. The preset server conditions include hardware judgment sub-conditions, development judgment sub-conditions, and installation path judgment sub-conditions.

[0031] It should be noted that the hardware judgment sub-condition, development judgment sub-condition and installation path sub-condition are executed in sequence. The purpose is to reduce the judgment process and complexity to a greater extent. If the hardware judgment sub-condition is not met, the subsequent development judgment sub-condition and installation path judgment sub-condition do not need to be executed. If the hardware judgment sub-condition is met and the development judgment sub-condition is not met, the subsequent installation path judgment sub-condition does not need to be executed.

[0032] The embodiment of the present application includes a step of determining whether the target server meets the preset server conditions, which cover multiple aspects such as hardware, development and installation paths, etc. This comprehensive determination mechanism helps ensure that the database installation package can run smoothly on the target server, and enhances the compatibility and stability of the database.

[0033] In a possible implementation, the hardware information may include memory capacity, disk capacity, and CPU capacity, the development information may include a JDK environment and an UNZIP package, and the installation path information may include a database installation directory; The hardware judgment sub-conditions are: Determine whether the hardware information of the target server is greater than a preset minimum setting value, the preset minimum setting value includes a preset minimum memory capacity, a preset minimum disk capacity, and a preset minimum CPU capacity; The development judgment sub-conditions are: Determine whether the target server has installed the JDK environment and whether the target server has installed the UNZIP package; The installation path judgment sub-conditions are: Determine whether the database installation directory exists on the target server.

[0034] Optionally, the hardware information in the embodiment of the present application may include memory capacity, disk capacity and CPU capacity. Correspondingly, the hardware judgment sub-condition is specifically: Determine whether the hardware information of the target server is greater than the preset minimum setting value, that is, whether the target server is available and whether the memory, disk and CPU meet the preset basic conditions.

[0035] Among them, the preset minimum setting value in this embodiment is consistent with the preset basic conditions, both including the preset minimum memory capacity, the preset minimum disk capacity and the preset minimum CPU capacity.

[0036] If it is greater, continue to execute the development judgment sub-condition; If it is not greater, an error message will be prompted and the installation process will be exited directly, and the target server will be reselected for judgment.

[0037] The development information in the embodiment of the present application may include the JDK environment and the UNZIP package. Accordingly, the development judgment sub-condition is specifically: Determine whether the target server has installed the JDK environment and whether the target server has installed the UNZIP package; If the target server has JDK environment installed and UNZIP package installed, continue to execute the installation path judgment sub-condition; If the target server does not have the JDK environment installed and / or the target server does not have UNZIP installed, an error message will be displayed and the installation will be exited directly. Then reselect the target server for re-judgment.

[0038] The installation path information in the embodiment of the present application includes the database installation directory. Accordingly, the installation path judgment sub-condition is specifically: Determine whether the database installation directory exists on the target server; If the target server does not have a database installation directory, it is necessary to create the database installation directory and execute step 203; If the target server has a database installation directory, determine whether the database installation directory is empty; If the database installation directory is empty, execute step 203; If the database installation directory is not empty, an error message will be displayed. Exit directly, reselect the target server, and restart the judgment from the hardware judgment sub-condition.

[0039] The embodiment of the present application performs conditional judgment on the target server before installation, which can ensure that the database can run in a suitable hardware and development environment, thereby avoiding resource waste or performance bottlenecks caused by improper configuration. This helps to optimize the resource utilization of the server and improve the operating efficiency of the overall system.

[0040] In step 203, if the target servers all meet the preset server conditions, the database installation package is decompressed to the database installation package directory of the target server and installed.

[0041] In the embodiment of the present application, if the target servers all meet the preset server conditions, the database installation package is uploaded to the database installation package directory of the target server where the database is installed, and the database installation package is decompressed.

[0042] The process of decompressing the database installation package to the specified directory of the target server and installing it is automatically processed in the embodiment of the application, reducing the complexity and error rate of manual operation. This one-click installation method makes the database installation process more concise and clear, and reduces the requirements for the professional skills of the installer.

[0043] In a possible implementation, if the target servers all meet the preset server conditions, the database installation package is decompressed to the database installation package directory of the target server and installed, which may include: Determine whether the database installation package directory exists on the target server; If the target server has a database installation package directory, upload the database installation to the database installation package directory and determine whether the target server has a database installation package. If the target server has a database installation package, decompress the database installation package to the database installation package directory of the target server and install it.

[0044] The installation path information may include a database installation package.

[0045] Optionally, if the target server has a database that meets the preset server conditions, determine whether the target server has a database installation package directory. If the target server has a database installation package directory, upload the database installation package to the database installation package directory, and determine whether the target server has a database installation package. If the target server has a database installation package, unzip the database installation package to the database installation package directory of the target server and install it.

[0046] In a possible implementation, after determining whether the target server has a database installation package directory, the method may further include: If the database installation package directory does not exist on the target server, create a new database installation package directory on the target server and upload the database installation package to the new database installation package directory.

[0047] Optionally, if the database installation package directory does not exist on the target server, you need to create a new database installation package directory and upload the database installation package to the new database installation package directory.

[0048] In a possible implementation, after determining whether the target server has a database installation package, the method may further include: If the database installation package does not exist on the target server, directly upload the database installation package to the database installation package directory, and then decompress the database installation package after uploading it to the database installation package directory.

[0049] In a possible implementation, the database installation package is decompressed into the database installation package directory of the target server and installed, which may include: According to the preset parameters and database installation path entered by the target user on the WEB visual interface, the database installation package is placed in the database installation package directory of the target server; Unzip the database installation package in the database installation package directory of the target server and install the unzipped database.

[0050] Among them, the preset parameters are preset installation parameters.

[0051] Optionally, according to the preset installation parameters and database installation path set by the user using the WEB visual interface, the database installation package is placed in the database installation package directory of the target server, the database installation package under the database installation package target of the target server is unzipped, and the unzipped database is installed.

[0052] In a possible implementation, after the database installation package is decompressed into the database installation package directory of the target server and installed, the method may further include: Determine whether the database is installed successfully; If the database is installed successfully, the database installation information is persisted and the database installation package extracted to the database installation package directory of the target server is deleted; If the database installation fails, delete all files in the database installation package directory and delete the database installation package that is unzipped to the database installation package directory of the target server; After deleting the database installation package in the database installation package directory that is unzipped to the target server, an installation report and installation analysis of the installed database is generated.

[0053] Optionally, after the database installation is completed, it is also necessary to determine whether the database is successfully installed. If the installation is successful, the database installation information is persisted, and the database installation package extracted to the database installation package directory of the target server is deleted. If the installation is unsuccessful, all files in the database installation package directory are deleted, and the database installation package extracted to the database installation package directory of the target server is deleted. Then, after deleting the database installation package extracted to the database installation package directory of the target server, an installation report and installation analysis of the installed database are generated, and the user can timely understand the database installation status through the WEB visual interface, and the installation is completed.

[0054] The system uses the generated installation report and installation analysis. If the database installation fails, the system provides reference information to let the user know the reason for the installation failure, terminate the installation abnormally, clean up the installation path, delete all files after the database is unzipped, and initialize the installation environment of the database installation package directory.

[0055] The embodiment of the present application provides a database installation report and analysis to understand the key data and performance indicators during the installation process. When the database installation fails, the failure cause and solution are provided.

[0056] For example, Figure 3 This is a specific implementation flow chart of the database installation method. The implementation process is as follows: Step 1.1, select the target server's IP address, installation package, installation account, installation path, etc.

[0057] Step 1.2: Verify whether the target server is available and whether the memory, disk, and CPU meet the basic conditions, that is, the hardware judgment sub-conditions. If they do, go to step 1.3; if not, exit the installation and go to step 1.1.

[0058] Step 1.3, determine whether the target server has installed the JDK environment and UNZIP package, that is, develop the judgment sub-condition. If both are installed, go to step 1.4; if not, exit the installation and go to step 1.1.

[0059] Step 1.4, determine whether the database installation directory is installed on the target server. If it is installed, go to step 1.5; if not, go to step 1.6.

[0060] Step 1.5, determine whether the database installation directory is empty. If it is empty, go to step 1.7; if it is not empty, exit the installation and go to step 1.1.

[0061] Step 1.6, create a database installation directory on the target server and proceed to step 1.7.

[0062] Step 1.7, determine whether there is a database installation package directory under the database installation directory. If so, upload the database installation package to the database installation package directory and go to step 1.8; if not, go to step 1.9.

[0063] Step 1.8, determine whether the database installation package exists in the database installation package directory. If so, decompress the database installation package to the database installation package directory and go to step 1.10; if not, go to step 1.9.

[0064] Step 1.9, create a new database installation package directory, upload the database installation package to the new database installation package directory, and go to step 1.8.

[0065] Step 1.10: Install the database to the installation path set by the user according to the preset installation parameters.

[0066] Step 1.11, determine whether the database is installed successfully. If successful, go to step 1.12; if unsuccessful, go to step 1.15.

[0067] Step 1.12, persist the installation information.

[0068] Step 1.13, delete the database installation package decompression file.

[0069] Step 1.14: Issue an installation report and analysis, and the installation is complete.

[0070] Step 1.15, delete all files in the database installation package directory and go to step 1.13.

[0071] After multiple databases are installed, the embodiment of the present application can also install database instances for multiple databases at the same time. Figure 4 , the specific database instance installation process is as follows: Step 2.1, select the database to be installed specified by the target user. The target user selects the database to be installed through the WEB visual interface.

[0072] Step 2.2, configure the database instance information, including instance name, instance port, installation account, and the target user sets the instance name, database port, installation account and other information on the WEB visualization interface.

[0073] Step 2.3, verify whether the database instance name exists and whether the port is occupied, that is, verify whether the database instance name exists on the target server and whether the database port is occupied. If the database instance name does not exist and the port is not occupied, go to step 2.4; if the database instance name exists or the port is occupied, an error is prompted, exit the installation, and go to step 2.2.

[0074] Step 2.4, verify whether the database has set the preset parameters of the database instance, where the preset parameters include character set encoding, logical log space, physical log space, smart large object, temporary data table space size, as well as the number of database table spaces, the number of temporary table spaces, etc.; if it has been set, go to step 2.5; if not, go to step 2.6.

[0075] In step 2.5, install the database instance according to the selected preset parameters and go to step 2.7.

[0076] In step 2.6, the system tracks system information such as server CPU usage, memory usage, and disk I / O, and sets the optimal database instance installation parameters, that is, the default installation parameters for database instance installation. Users can set their own parameter values ​​based on these parameters as long as they meet the system setting ratio for database instance installation. The database instance is installed according to the system's optimal database instance installation parameters, and then go to step 2.7.

[0077] Step 2.7: Verify whether the database instance is installed successfully. If successful, go to step 2.8; if not, go to step 2.10.

[0078] Step 2.8, persist the database instance installation information.

[0079] Step 2.9: Issue an installation report and analysis, and the installation is complete.

[0080] In step 2.10, the system provides reference information to help the user understand the reason for the installation failure. The installation ends abnormally, the file information generated by the database instance installation is cleaned up, and the process goes to step 2.9.

[0081] The embodiment of the present application provides a database instance installation report and analysis to understand the key data and performance indicators during the installation process. When the database instance installation fails, the failure cause and solution are provided. In addition, the database and database instance installation can be installed and maintained separately, which further improves the flexibility of installation and deployment.

[0082] The present application provides a database installation method, which obtains database information and server information that a target user needs to install, wherein the database information includes a database installation package, and the server information includes hardware information, development information, and installation path information of the target server, and the installation path information includes a database installation package directory; determines whether the target server meets preset server conditions, and the preset server conditions include hardware determination sub-conditions, development determination sub-conditions, and installation path determination sub-conditions; if the target server meets the preset server conditions, the database installation package is unzipped to the database installation package directory of the target server and installed. By pre-acquiring the database information and server information that the target user needs to install, the present application can ensure that all information required for the installation process is ready, reduce the accuracy or incorrectness of the information during the installation process, and thus improve the installation efficiency and accuracy; by performing conditional judgment on the target server before installation, it can ensure that the database can run in a suitable hardware and development environment, thereby avoiding resource waste or performance bottlenecks caused by improper configuration, helping to optimize server resource utilization and improve the operating efficiency of the overall system, and the comprehensive judgment mechanism helps to ensure that the database installation package can run smoothly on the target server, enhancing the compatibility and stability of the database; in addition, according to the clear installation guide and conditional judgment, the user can easily complete the installation process without in-depth understanding of the complex details of the database installation, greatly improving the user's installation experience and making the installation and use of the database more convenient, and the present application automates the process of unzipping the database installation package to the specified directory of the target server and installing it, reducing the complexity and error rate of manual operations, making the database installation process more concise and clear, and reducing the requirements for the professional skills of the installer.

[0083] It should be understood that the size of the serial numbers of the steps in the above embodiments does not mean the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present application.

[0084] The following is an embodiment of the device of the present application. For details not described in detail, please refer to the corresponding method embodiment described above.

[0085] Figure 5 The following is a schematic diagram of the structure of the database installation device provided in the embodiment of the present application. For the convenience of explanation, only the parts related to the embodiment of the present application are shown, which are described in detail as follows: like Figure 5 As shown, the database installation device 5 includes: The acquisition module 51 is used to acquire the database information and the server information of the database installation selected by the target user on the WEB visual interface. The database information includes the database installation package. The server information includes the hardware information, development information and installation path information of the target server. The installation path information includes the database installation package directory. A judgment module 52, used to judge whether the target server meets the preset server conditions, the preset server conditions include hardware judgment sub-conditions, development judgment sub-conditions and installation path judgment sub-conditions; The installation module 53 is used to decompress the database installation package to the database installation package directory of the target server and install it if the target server meets the preset server conditions.

[0086] The present application provides a database installation device, which obtains database information and server information that a target user needs to install, wherein the database information includes a database installation package, and the server information includes hardware information, development information, and installation path information of the target server, and the installation path information includes a database installation package directory; determines whether the target server meets preset server conditions, and the preset server conditions include hardware judgment sub-conditions, development judgment sub-conditions, and installation path judgment sub-conditions; if the target server meets the preset server conditions, the database installation package is unzipped to the database installation package directory of the target server and installed. By pre-acquiring the database information and server information that the target user needs to install, the present application can ensure that all information required for the installation process is ready, reduce the accuracy or incorrectness of the information during the installation process, and thus improve the installation efficiency and accuracy; by performing conditional judgment on the target server before installation, it can ensure that the database can run in a suitable hardware and development environment, thereby avoiding resource waste or performance bottlenecks caused by improper configuration, helping to optimize server resource utilization and improve the operating efficiency of the overall system, and the comprehensive judgment mechanism helps to ensure that the database installation package can run smoothly on the target server, enhancing the compatibility and stability of the database; in addition, according to the clear installation guide and conditional judgment, the user can easily complete the installation process without in-depth understanding of the complex details of the database installation, greatly improving the user's installation experience and making the installation and use of the database more convenient, and the present application automates the process of unzipping the database installation package to the specified directory of the target server and installing it, reducing the complexity and error rate of manual operations, making the database installation process more concise and clear, and reducing the requirements for the professional skills of the installer.

[0087] In a possible implementation, the hardware information may include memory capacity, disk capacity, and CPU capacity, the development information may include a JDK environment and an UNZIP package, and the installation path information may include a database installation directory; The hardware judgment sub-conditions can be: Determine whether the hardware information of the target server is greater than a preset minimum setting value, the preset minimum setting value includes a preset minimum memory capacity, a preset minimum disk capacity, and a preset minimum CPU capacity; The development judgment sub-conditions can be: Determine whether the target server has installed the JDK environment and whether the target server has installed the UNZIP package; The installation path judgment sub-condition can be: Determine whether the database installation directory exists on the target server.

[0088] In one possible implementation, the installation module can be used to: Determine whether the database installation package directory exists on the target server; If the target server has a database installation package directory, upload the database installation to the database installation package directory and determine whether the target server has a database installation package. If the target server has a database installation package, decompress the database installation package to the database installation package directory of the target server and install it.

[0089] In a possible implementation, the installation module can also be used to: If the database installation package directory does not exist on the target server, create a new database installation package directory on the target server and upload the database installation package to the new database installation package directory.

[0090] In a possible implementation, the installation module can also be used to: According to the preset parameters and database installation path entered by the target user on the WEB visual interface, the database installation package is placed in the database installation package directory of the target server; Unzip the database installation package in the database installation package directory of the target server and install the unzipped database.

[0091] In a possible implementation, the device may further include a verification module, which may be used to: Determine whether the database is installed successfully; If the database is installed successfully, the database installation information is persisted and the database installation package extracted to the database installation package directory of the target server is deleted; If the database installation fails, delete all files in the database installation package directory and delete the database installation package that is unzipped to the database installation package directory of the target server; After deleting the database installation package in the database installation package directory that is unzipped to the target server, an installation report and installation analysis of the installed database is generated.

[0092] In a possible implementation, the acquisition module may be used to: Obtain the database information and server information that the target user selects on the WEB visual interface and needs to install.

[0093] Figure 6 is a schematic diagram of a terminal provided in an embodiment of the present application. Figure 6 As shown, the terminal 6 of this embodiment includes: a processor 60, a memory 61, and a computer program 62 stored in the memory 61 and executable on the processor 60. When the processor 60 executes the computer program 62, the steps in the above-mentioned database management method embodiments are implemented, for example Figure 1 Alternatively, when the processor 60 executes the computer program 62, the functions of each module / unit in the above-mentioned device embodiments are realized, for example Figure 5 The functions of each module are shown.

[0094] Exemplarily, the computer program 62 may be divided into one or more modules / units, which are stored in the memory 61 and executed by the processor 60 to complete the present application. The one or more modules / units may be a series of computer program instruction segments capable of completing specific functions, which are used to describe the execution process of the computer program 62 in the terminal 6. For example, the computer program 62 may be divided into Figure 5 The modules shown.

[0095] The terminal 6 may be a computing device such as a desktop computer, a notebook, a PDA, or a cloud server. The terminal 6 may include, but is not limited to, a processor 60 and a memory 61. Those skilled in the art will appreciate that Figure 6 It is only an example of terminal 6 and does not constitute a limitation on terminal 6. It may include more or fewer components than shown in the figure, or a combination of certain components, or different components. For example, the terminal may also include input and output devices, network access devices, buses, etc.

[0096] The processor 60 may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. A general-purpose processor may be a microprocessor or any conventional processor, etc.

[0097] The memory 61 may be an internal storage unit of the terminal 6, such as a hard disk or memory of the terminal 6. The memory 61 may also be an external storage device of the terminal 6, such as a plug-in hard disk, a smart media card (SMC), a secure digital (SD) card, a flash card, etc. equipped on the terminal 6. Further, the memory 61 may also include both an internal storage unit of the terminal 6 and an external storage device. The memory 61 is used to store the computer program and other programs and data required by the terminal. The memory 61 may also be used to temporarily store data that has been output or is to be output.

[0098] The technicians in the relevant field can clearly understand that for the convenience and simplicity of description, only the division of the above-mentioned functional units and modules is used as an example for illustration. In practical applications, the above-mentioned function allocation can be completed by different functional units and modules as needed, that is, the internal structure of the device can be divided into different functional units or modules to complete all or part of the functions described above. The functional units and modules in the embodiment can be integrated in a processing unit, or each unit can exist physically separately, or two or more units can be integrated in one unit. The above-mentioned integrated unit can be implemented in the form of hardware or in the form of software functional units. In addition, the specific names of the functional units and modules are only for the convenience of distinguishing each other, and are not used to limit the scope of protection of this application. The specific working process of the units and modules in the above-mentioned system can refer to the corresponding process in the aforementioned method embodiment, which will not be repeated here.

[0099] In the above embodiments, the description of each embodiment has its own emphasis. For parts that are not described or recorded in detail in a certain embodiment, reference can be made to the relevant descriptions of other embodiments.

[0100] Those of ordinary skill in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of this application.

[0101] In the embodiments provided in the present application, it should be understood that the disclosed devices / terminals and methods can be implemented in other ways. For example, the device / terminal embodiments described above are only schematic. For example, the division of the modules or units is only a logical function division. There may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.

[0102] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0103] In addition, each functional unit in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.

[0104] If the integrated module / unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the present application implements all or part of the processes in the above-mentioned embodiment method, and can also be completed by instructing the relevant hardware through a computer program. The computer program can be stored in a computer-readable storage medium. When the computer program is executed by the processor, the steps of the above-mentioned database management method embodiments can be implemented. Among them, the computer program includes computer program code, and the computer program code can be in source code form, object code form, executable file or some intermediate form. The computer-readable medium may include: any entity or device capable of carrying the computer program code, recording medium, U disk, mobile hard disk, disk, optical disk, computer memory, read-only memory (ROM), random access memory (RAM), electric carrier signal, telecommunication signal and software distribution medium. It should be noted that the content contained in the computer-readable medium can be appropriately increased or decreased according to the requirements of legislation and patent practice in the jurisdiction. For example, in some jurisdictions, according to legislation and patent practice, computer-readable media do not include electric carrier signals and telecommunication signals.

[0105] The embodiments described above are only used to illustrate the technical solutions of the present application, rather than to limit them. Although the present application has been described in detail with reference to the aforementioned embodiments, a person skilled in the art should understand that the technical solutions described in the aforementioned embodiments may still be modified, or some of the technical features may be replaced by equivalents. Such modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present application, and should all be included in the protection scope of the present application.

Claims

1. A database installation method, characterized in that: include: Obtain database information and server information that the target user needs to install, wherein the database information includes a database installation package, and the server information includes hardware information, development information, and installation path information of the target server, wherein the installation path information includes a database installation package directory; Determine whether the target server meets a preset server condition, wherein the preset server condition includes a hardware judgment sub-condition, a development judgment sub-condition, and an installation path judgment sub-condition; If the target servers all meet the preset server conditions, the database installation package is decompressed to the database installation package directory of the target server and installed.

2. The database installation method according to claim 1, characterized in that: The hardware information includes memory capacity, disk capacity and CPU capacity, the development information includes JDK environment and UNZIP package, and the installation path information includes database installation directory; The hardware judgment sub-conditions are: Determine whether the hardware information of the target server is greater than a preset minimum setting value, wherein the preset minimum setting value includes a preset minimum memory capacity, a preset minimum disk capacity, and a preset minimum CPU capacity; The development judgment sub-conditions are: Determine whether the target server has installed the JDK environment and whether the target server has installed the UNZIP package; The installation path judgment sub-condition is: Determine whether the database installation directory exists on the target server.

3. The database installation method according to claim 1, characterized in that: If the target servers all meet the preset server conditions, the database installation package is decompressed to the database installation package directory of the target server and installed, including: Determine whether the database installation package directory exists on the target server; If the target server has the database installation package directory, then upload the database installation to the database installation package directory, and determine whether the target server has the database installation package; If the database installation package exists on the target server, decompress the database installation package to the database installation package directory of the target server and install it.

4. The database installation method according to claim 3, characterized in that: After determining whether the database installation package directory exists on the target server, the method further includes: If the database installation package directory does not exist in the target server, a new database installation package directory is created in the target server, and the database installation package is uploaded to the new database installation package directory.

5. The database installation method according to claim 1, characterized in that: The step of decompressing the database installation package to the database installation package directory of the target server and installing the package includes: According to the preset parameters input by the target user on the WEB visual interface and the installation path of the database, the database installation package is placed in the database installation package directory of the target server; Decompress the database installation package in the database installation package directory of the target server, and install the decompressed database.

6. The database installation method according to claim 1, characterized in that: After decompressing the database installation package to the database installation package directory of the target server and installing it, the method further includes: Determine whether the database is installed successfully; If the database is successfully installed, the installation information of the database is persisted, and the database installation package extracted to the database installation package directory of the target server is deleted; If the database installation fails, delete all files in the database installation package directory and delete the database installation package unzipped to the database installation package directory of the target server; After deleting the database installation package unzipped to the database installation package directory of the target server, an installation report and installation analysis of the installed database are generated.

7. The database installation method according to claim 1, characterized in that: The step of obtaining the database information and server information that the target user needs to install includes: Obtain the database information and server information that need to be installed selected by the target user on the WEB visual interface.

8. A database installation device, characterized in that: include: An acquisition module is used to acquire the database information and the server information of the database installation selected by the target user on the WEB visual interface. The database information includes the database installation package. The server information includes the hardware information, development information and installation path information of the target server. The installation path information includes the database installation package directory. A judgment module, used to judge whether the target server meets the preset server conditions, wherein the preset server conditions include hardware judgment sub-conditions, development judgment sub-conditions and installation path judgment sub-conditions; The installation module is used to decompress the database installation package to the database installation package directory of the target server and install it if the target servers all meet the preset server conditions.

9. A terminal comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, the steps of the database installation method as described in any one of claims 1 to 7 are implemented.

10. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the steps of the database installation method as described in any one of claims 1 to 7 are implemented.

Images