CN107315803A - A kind of automatic building method of data-base cluster and system - Google Patents

Abstract

The invention discloses a method and system for automatically building a database cluster. The method includes: acquiring connection parameters and resource parameters of an operating system for building a database cluster; generating a corresponding operation instruction set according to the connection parameters and resource parameters; controlling the target through the operation instruction set The K‑UX operating system performs system environment settings, database installation, and cluster construction; obtains the execution results of the target K‑UX operating system and displays the execution results in real time. According to the connection parameters and resource parameters, the corresponding database cluster installation operation instruction set is automatically generated, so that the automatic environment of the database cluster can be automatically set up and installed in the K-UX operating system, and the execution results will be displayed in real time until the installation is completed, greatly greatly It reduces the time required to build and test the database on the K‑UX operating system, and improves the efficiency of building and testing the database cluster environment.

Description

A method and system for automatically building a database cluster

technical field

The invention relates to the field of information technology, in particular to a method and system for automatically building a database cluster.

Background technique

With the development of information technology, people's life and work have been inseparable from information technology, and information technology has become an indispensable part of people's work.

The K-UX operating system is my country's first and currently the only host operating system certified by Unix03. The K-UX operating system has extensive compatibility, including the Oracle10g database. Currently, the Oracle 10g database cluster can only be deployed manually On the K-UX2.1 operating system.

Large-scale database systems are the supporting software for key business systems. Because of the complexity and importance of large-scale database systems, large-scale database products require long-term technical accumulation and huge R&D investment. Oracle database system is currently one of the most popular relational database management systems in the world. It has good portability, convenient use, and strong functions. It is suitable for various large, medium, small, and microcomputer environments. It is a high-efficiency, reliable Well suited for high throughput database solutions. Setting up and testing the Oracle 10g database cluster environment is a complex and repetitive task.

Therefore, how to improve the efficiency of building and detecting the database cluster environment is a technical problem that those skilled in the art need to solve.

Contents of the invention

The purpose of the present invention is to provide a method and system for automatically building a database cluster, which can improve the efficiency of building and detecting a database cluster environment.

In order to solve the problems of the technologies described above, the present invention provides the following technical solutions:

A method for automatically building a database cluster, comprising:

Obtain the operating system connection parameters and resource parameters for building a database cluster;

generating a corresponding operation instruction set according to the connection parameters and the resource parameters;

Control the target K-UX operating system by the operation instruction set to execute system environment setting, database installation, and cluster construction;

The execution result of the target K-UX operating system is obtained, and the execution result is displayed in real time.

Preferably, said obtaining operating system connection parameters and resource parameters for building a database cluster includes:

Obtain the operating system connection protocol for building a database cluster, the number of connected hosts, host IP, port number, and reconnection interval;

Obtain media, cluster software, driver packages, test script resource transfer mode and storage location.

Preferably, the generating a corresponding operation instruction set according to the connection parameters and the resource parameters includes:

Generate corresponding system environment variable setting instructions, database cluster installation instructions and database detection instructions according to the connection parameters and the resource parameters.

Preferably, it also includes:

Obtain the execution exception information of the target K-UX operating system;

Invoking a corresponding exception handling strategy according to the exception information, and generating a corresponding exception handling command;

Controlling the target K-UX operating system to execute a rollback action or the exception handling command according to the exception handling command.

A system for automatically building a database cluster, comprising:

The parameter management module is used to obtain the operating system connection parameters and resource parameters for building the database cluster;

A job scheduling module, configured to generate a corresponding operation instruction set according to the connection parameters and the resource parameters;

The K-UX operating system module is used to perform system environment setting, database installation, and cluster construction according to the operation instruction set;

The console module is used to obtain the execution result of the target K-UX operating system and display the execution result in real time.

Preferably, it also includes:

Monitoring module, for monitoring the K-UX operating system module execution system environment setting, database installation, system status and execution results in the cluster building process, and sending the monitoring results to the console module and exception handling module;

An exception handling module, configured to receive the monitoring result sent by the monitoring module, analyze and process the abnormal information in the monitoring result, and generate a corresponding exception handling strategy and send it to the job scheduling module for the job scheduling module to generate The corresponding exception handling command;

Wherein, the K-UX operating system module is further configured to execute a rollback action or the exception handling command according to the exception handling command.

Preferably, it also includes:

The database monitoring module is used to monitor the operation information of the database, and at the same time, send the monitored operation information of the database to the console module for display.

Preferably, it also includes:

The database verification module is used to verify the database installation and the corresponding database cluster, and at the same time, send each verification information to the console module for display.

Preferably, it also includes: an operating system SSH protocol interface module, wherein the parameter management module, job scheduling module, monitoring module, exception handling module, database monitoring module and database verification module all pass the operating system SSH protocol interface module and The K-UX operating system module is connected.

Preferably, the K-UX operating system module includes: a first K-UX operating system unit and a second K-UX operating system unit, and the first K-UX operating system unit and the second K-UX operating system unit connected, and respectively connected to the SSH protocol interface module of the operating system.

Compared with the prior art, the above-mentioned technical solution has the following advantages:

A method for automatically building a database cluster provided by the present invention includes: obtaining the operating system connection parameters and resource parameters for building a database cluster; generating a corresponding operation instruction set according to the connection parameters and resource parameters; controlling the target K-UX through the operation instruction set The operating system performs system environment settings, database installation, and cluster construction; obtains the execution results of the target K-UX operating system, and displays the execution results in real time. After obtaining the operating system connection parameters and resource parameters for building the database cluster, the corresponding database cluster installation operation instruction set is automatically generated, so that the automatic environment of the database cluster can be automatically built and installed in the K-UX operating system, and the execution results are processed in real time. It shows that until the installation is completed, the time required for building and testing the database on the K-UX operating system is greatly reduced, and the efficiency of building and testing the database cluster environment is improved.

Description of drawings

In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the following will briefly introduce the drawings that need to be used in the description of the embodiments or the prior art. Obviously, the accompanying drawings in the following description are For some embodiments of the present invention, those skilled in the art can also obtain other drawings based on these drawings without creative work.

Fig. 1 is a flowchart of a method for automatically building a database cluster provided by a specific embodiment of the present invention;

FIG. 2 is a schematic structural diagram of a system for automatically building a database cluster provided by a specific embodiment of the present invention.

detailed description

The core of the present invention is to provide a method and system for automatically building a database cluster, which can improve the efficiency of building and detecting a database cluster environment.

In order to make the above objects, features and advantages of the present invention more comprehensible, the specific implementation manners of the present invention will be described in detail below in conjunction with the accompanying drawings.

In the following description, specific details are set forth in order to provide a thorough understanding of the present invention. However, the present invention can be implemented in many other ways than those described here, and those skilled in the art can make similar extensions without departing from the connotation of the present invention. Accordingly, the invention is not limited to the specific implementations disclosed below.

Please refer to FIG. 1 , which is a flowchart of a method for automatically building a database cluster provided by a specific embodiment of the present invention.

A specific embodiment of the present invention provides a method for automatically building a database cluster, including:

S11: Obtain the operating system connection parameters and resource parameters for building the database cluster.

In this embodiment, it is preferable to obtain the operating system connection parameters and resource parameters for building a database cluster, including: obtaining the operating system connection protocol for building a database cluster, the number of connected hosts, host IP, port number, and reconnection interval; Software, driver package, test script resource transfer mode and storage location. That is, in this embodiment, it is preferable to install a database cluster.

S12: Generate a corresponding operation instruction set according to the connection parameters and the resource parameters.

Preferably, the corresponding operation instruction set is generated according to the connection parameters and resource parameters, including: generating corresponding system environment variable setting instructions, database cluster installation instructions and database detection instructions according to the connection parameters and resource parameters.

S13: Control the target K-UX operating system through the operation instruction set to perform system environment setting, database installation, and cluster construction;

S14: Obtain the execution result of the target K-UX operating system, and display the execution result in real time.

After obtaining the operating system connection parameters and resource parameters for building the database cluster, the corresponding database cluster installation operation instruction set is automatically generated, so that the automatic environment of the database cluster can be automatically built and installed in the K-UX operating system, and the execution results are processed in real time. It shows that until the installation is completed, the time required for building and testing the database on the K-UX operating system is greatly reduced, and the efficiency of building and testing the database cluster environment is improved.

Further, the method also includes: obtaining execution exception information of the target K-UX operating system; calling a corresponding exception handling strategy according to the exception information, and generating a corresponding exception handling command; controlling the execution of the target K-UX operating system according to the exception handling command A fallback action or exception handling command.

Real-time monitoring of information such as resources and environment construction of the operating system, once a problem occurs, timely rollback or exception handling operations are performed until the construction and detection of the database cluster is completed. It can intuitively and quickly complete the construction and detection of database clusters on the K-UX operating system.

Please refer to FIG. 2 . FIG. 2 is a schematic structural diagram of an automatic database cluster building system provided by a specific embodiment of the present invention.

Correspondingly, an embodiment of the present invention also provides a system for automatically building a database cluster, including: a parameter management module 21, configured to acquire operating system connection parameters and resource parameters for building a database cluster; a job scheduling module 22, configured to Connection parameters and resource parameters generate corresponding operation instruction sets; K-UX operating system module 23 is used to perform system environment setting, database installation, and cluster construction according to the operation instruction set; console module 24 is used to obtain target K-UX operations The execution result of the system is displayed in real time.

After obtaining the operating system connection parameters and resource parameters for building the database cluster, the corresponding database cluster installation operation instruction set is automatically generated, so that the automatic environment of the database cluster can be automatically built and installed in the K-UX operating system, and the execution results are processed in real time. It shows that until the installation is completed, the time required for building and testing the database on the K-UX operating system is greatly reduced, and the efficiency of building and testing the database cluster environment is improved.

Further, the system also includes: a monitoring module 25, which is used to monitor the K-UX operating system module execution system environment settings, database installation, system status and execution results in the cluster construction process, and send the monitoring results to the console module 24 And exception processing module 26; Abnormal processing module 26 is used to receive the monitoring result sent to by monitoring module 25, analyze and process the abnormal information in the monitoring result, and generate a corresponding abnormal processing strategy and send it to the job scheduling module for the job scheduling module to generate Corresponding exception handling command; wherein, the K-UX operating system module 23 is also used to execute a rollback action or an exception handling command according to the exception handling command. The database monitoring module 27 is used to monitor the operation information of the database, and at the same time, send the monitored operation information of the database to the console module 24 for display. The database verification module 28 is used for verifying the installation of the database and the verification of the corresponding database cluster, and at the same time sending each verification information to the console module for display. Operating system SSH protocol interface module 29, wherein, parameter management module 21, job scheduling module 22, monitoring module 25, exception handling module 26, database monitoring module 27 and database verification module 28 all pass operating system SSH protocol interface module 29 and K- The UX operating system module 23 is connected.

K-UX operating system module 23 comprises: the first K-UX operating system unit 231 and the second K-UX operating system unit 232, the first K-UX operating system unit 231 and the second K-UX operating system unit 232 are connected, And are respectively connected with the operating system SSH protocol interface module 29.

The setting of the operating system SSH protocol interface module enables the entire system to be connected to the K-UX operating system modules of the two nodes through the SSH protocol, and after the relevant configuration of each parameter is completed through the parameter management The module sends operation instructions. These operation instructions are a set of SHELL commands to execute the construction and detection of database cluster environments such as Oracle 10g. Take the establishment of database clusters such as Oracle 10g as an example to illustrate:

Firstly, the Oracle 10g database installation package, Oracle 10g cluster software, driver package, and inspection script are transmitted to the K-UX operating system module through binary mode, and then the system environment setting, database installation, cluster construction, and database testing are performed. During the construction and detection process of the entire database cluster, the construction system always monitors information such as system resources, environment construction, and the operating status of each module. Once a problem occurs, the job scheduling module will handle the problem and perform operation rollback or exception handling in a timely manner , until the final completion of the construction and detection of the Oracle 10g database cluster, the console module can be intuitively and quickly configured and connected to the K-UX operating system module, and at the same time view various information monitored by the monitoring module.

Specifically, the first communication port of the operating system SSH protocol interface module is connected with the instruction interface of the first K-UX operating system unit, and the second communication port of the operating system SSH protocol interface module is connected with the instruction interface of the second K-UX operating system unit. The interfaces are connected, the third communication port of the operating system SSH protocol interface module is connected to the first communication port of the job scheduling module, the fourth communication port of the operating system SSH protocol interface module is connected to the third communication port of the exception handling module, and the operating system SSH protocol The fifth communication port of the interface module is connected with the second communication port of the monitoring module, the sixth communication port of the operating system SSH protocol interface module is connected with the first communication port of the database verification module, and the seventh communication port of the operating system SSH protocol interface module It is connected with the first communication port of the database monitoring module. The first communication port of the parameter management module is connected to the second communication port of the job scheduling module, and the second communication port of the parameter management module is connected to the fifth communication port of the console module. The third communication port of the job scheduling module is connected to the first communication port of the exception handling module. The first communication port of the monitoring module is connected to the fourth communication port of the exception processing module, and the third communication port of the monitoring module is connected to the third communication port of the console module. The second communication port of the exception handling module is connected with the fourth communication port of the console module. The second communication port of the database monitoring module is connected with the first communication port of the console module. The first communication port of the database verification module is connected with the second communication port of the console module.

According to the system parameters and system resources, the operation command is sent to the K-UX operating system module through the job scheduling module. First, the Oracle 10g media, cluster software, driver package, and inspection script are uploaded to the operating systems of the two nodes through binary mode, and then Perform environment variable setting, install cluster software and Oracle 10g database, after the installation is completed, verify the database through the test script, and finally complete the automatic installation and detection of Oracle 10g database.

The console module intuitively configures and connects the operating system interface and uploads resources through the graphical interface, and at the same time displays the operating status of each module of the system or the execution result information fed back by the K-UX system.

Wherein, the operating system SSH protocol interface module is connected with two nodes K-UX (i.e. the first K-UX operating system unit and the second K-UX operating system unit), and the connection steps are as follows:

Complete the installation of the build system and open the console;

Enter the IP, port number, user name, and password related to the two K-UX connections;

Check whether the connection is established with the K-UX operating system through the console interface;

The build system maintains and monitors connection status through the interface.

Further, the job scheduling module is connected with the operating system SSH protocol interface module, the parameter management module, and the exception handling module, and the connection steps are as follows:

The job scheduling module uploads the Oracle 10g database installation package, Oracle 10g cluster software, driver package, and inspection script to the K-UX operating system of the two nodes according to the parameter settings;

The job scheduling module sends environment variable settings, system parameter configuration, database installation, and cluster installation commands to the K-UX operating system;

The job scheduling module sends the inspection script command to the K-UX operating system to detect the database installation;

The job scheduling receives the exception handling strategy of the exception handling module, and generates an exception handling instruction;

Send the exception handling instruction to the two-node operating system to execute the rollback or exception handling command.

The monitoring module is connected to the operating system SSH protocol interface module, exception handling module, and console module. The connection steps are as follows:

The monitoring module receives the command execution result information fed back by the K-UX2.1 operating system;

Send the command execution result information to the console module for display;

Send the exception status result information to the exception handling module.

The database monitoring module is connected with the operating system SSH protocol interface module and the console module, and the connection steps are as follows:

Monitor the running status of the database on the K-UX operating system;

Send the monitored information to the console for display;

The database exception information is transmitted to the exception handling module through the console module for exception handling.

It should be noted that the above-mentioned implementation mode is described by taking the Oracle 10g database as an example, and this construction system can realize the construction of all data blocks on the K-UX2.1 compatibility list, such as DB210.5, MySQL5.5, etc.

In summary, the database cluster automatic building method and system provided by the present invention, after obtaining the operating system connection parameters and resource parameters for building a database cluster, automatically generates a corresponding database cluster installation operation instruction set, so that the K-UX operating system Realize the automatic construction and installation of the automatic environment of the database cluster, and display the execution results in real time until the installation is complete, which greatly reduces the time required to build and detect the database on the K-UX operating system, and improves the construction and installation of the database cluster environment. detection efficiency.

The above describes in detail the method and system for automatically building a database cluster provided by the present invention. In this paper, specific examples are used to illustrate the principle and implementation of the present invention, and the descriptions of the above embodiments are only used to help understand the method and core idea of the present invention. It should be pointed out that for those skilled in the art, without departing from the principle of the present invention, some improvements and modifications can be made to the present invention, and these improvements and modifications also fall within the protection scope of the claims of the present invention.

Claims (10)

1. A method for automatically building a database cluster, characterized in that, comprising: Obtain the operating system connection parameters and resource parameters for building a database cluster; generating a corresponding operation instruction set according to the connection parameters and the resource parameters; Control the target K-UX operating system by the operation instruction set to execute system environment setting, database installation, and cluster construction; The execution result of the target K-UX operating system is obtained, and the execution result is displayed in real time. 2. The method according to claim 1, wherein said obtaining the operating system connection parameters and resource parameters for building the database cluster comprises: Obtain the operating system connection protocol for building a database cluster, the number of connected hosts, host IP, port number, and reconnection interval; Obtain media, cluster software, driver packages, test script resource transfer mode and storage location. 3. The method according to claim 2, wherein said generating a corresponding operation instruction set according to said connection parameters and said resource parameters comprises: Generate corresponding system environment variable setting instructions, database cluster installation instructions and database detection instructions according to the connection parameters and the resource parameters. 4. The method according to claim 3, further comprising: Obtain the execution exception information of the target K-UX operating system; Invoking a corresponding exception handling strategy according to the exception information, and generating a corresponding exception handling command; Controlling the target K-UX operating system to execute a rollback action or the exception handling command according to the exception handling command. 5. A database cluster automatic building system, characterized in that, comprising: The parameter management module is used to obtain the operating system connection parameters and resource parameters for building the database cluster; A job scheduling module, configured to generate a corresponding operation instruction set according to the connection parameters and the resource parameters; The K-UX operating system module is used to perform system environment setting, database installation, and cluster construction according to the operation instruction set; The console module is used to obtain the execution result of the target K-UX operating system and display the execution result in real time. 6. The system according to claim 5, further comprising: Monitoring module, for monitoring the K-UX operating system module execution system environment setting, database installation, system status and execution results in the cluster building process, and sending the monitoring results to the console module and exception handling module; An exception handling module, configured to receive the monitoring result sent by the monitoring module, analyze and process the abnormal information in the monitoring result, and generate a corresponding exception handling strategy and send it to the job scheduling module for the job scheduling module to generate The corresponding exception handling command; Wherein, the K-UX operating system module is further configured to execute a rollback action or the exception handling command according to the exception handling command. 7. The system according to claim 6, further comprising: The database monitoring module is used to monitor the operation information of the database, and at the same time, send the monitored operation information of the database to the console module for display. 8. The system according to claim 7, further comprising: The database verification module is used to verify the database installation and the corresponding database cluster, and at the same time, send each verification information to the console module for display. 9. The system according to claim 8, further comprising: an operating system SSH protocol interface module, wherein said parameter management module, job scheduling module, monitoring module, exception processing module, database monitoring module and database verification The modules are all connected to the K-UX operating system module through the operating system SSH protocol interface module. 10. system according to claim 9, is characterized in that, described K-UX operating system module comprises: the first K-UX operating system unit and the second K-UX operating system unit, described first K-UX The operating system unit is connected with the second K-UX operating system unit, and is respectively connected with the SSH protocol interface module of the operating system.