CN114510493A - System deployment method, apparatus, computer equipment and storage medium - Google Patents

Abstract

The present application discloses a system deployment method, device, computer equipment and storage medium, including: acquiring a target update method of a system database, and the target update method includes at least one of the following: script setting update and comparison database update; update according to the above target The database update is completed by the method; the version file is sent to N deployment points, and the target operation is started. The above target operation is: deploying the system code; restarting the system. In this way, when the database and version files are set in advance in the system, the system can automatically complete the whole process of system deployment without manual operation, thereby greatly reducing the consumption of human and material resources, saving the deployment time of system deployment, and improving the efficiency of system deployment.

Description

System deployment method, apparatus, computer equipment and storage medium

technical field

The embodiments of the present application relate to the field of system deployment, and in particular, to a system deployment method, apparatus, computer equipment, and storage medium.

Background technique

At present, all walks of life have the ability to process business online, and the business previously processed offline can be synchronized to the online, which can greatly improve the efficiency of business processing.

Due to the continuity of the business, many enterprises need to synchronize the original offline data and systems to the online. In related technologies, some enterprises use manual system deployment methods to complete online business synchronization, and some enterprises adopt the method of building An update mechanism that meets its own needs automatically completes the system deployment.

It can be seen from the above process that whether manual system deployment or self-built update mechanism is used for system deployment, it takes a lot of manpower and material resources, and it takes a long time and is inefficient.

SUMMARY OF THE INVENTION

The embodiments of the present application provide a method, an apparatus, a computer device, and a storage medium capable of automatically deploying online services.

In order to solve the above-mentioned technical problem, a technical solution adopted by the embodiments of the present invention is to provide a system deployment method, including: acquiring a target update method of a system database, and the above-mentioned target update method includes at least one of the following: script setting update and Compare database updates; complete database update according to the above target update method; send version files to N deployment points, and start target operations. The above target operations are: deploying system code; restarting the system.

Optionally, in the case that the above-mentioned target update method is the above-mentioned script setting update, and the above-mentioned database update is completed according to the target update method, the system deployment method provided by the embodiment of the present application may include: uploading a preset script, and the above-mentioned preset script is used for running The above database; execute the above preset script.

Optionally, when the above-mentioned target update method is the above-mentioned comparison database update, in the above-mentioned completion of the database update according to the target update method, the system deployment method provided by this embodiment of the present application may include: comparing the source database and the target database, confirming the above. The format difference between the source database and the above-mentioned target database, the above-mentioned source database is the database corresponding to the system data before the system is deployed, and the above-mentioned target database is the database corresponding to the above-mentioned system data after the system deployment is completed; Generate an update script for the above-mentioned target database; Execute the update script .

Optionally, in the case where the above-mentioned target update method is the above-mentioned script setting update and the above-mentioned comparison database update, in the above-mentioned completing the database update according to the target update method, the system deployment method provided by the embodiment of the present application may include: uploading a preset script, The above-mentioned preset script is used to run the above-mentioned database; in the case of receiving the above-mentioned instruction to compare the database, the source database and the target database are connected, the above-mentioned source database is the database corresponding to the system data before the system is deployed, and the above-mentioned target database is the system deployment. After completion, the database corresponding to the above-mentioned system data; compare the source database and the target database, confirm the format difference between the above-mentioned source database and the above-mentioned target database, and generate an update script for the above-mentioned target database; confirm the execution sequence of the above-mentioned preset script and the above-mentioned update script , the above-mentioned execution sequence is preset by the system in advance; according to the above-mentioned execution sequence, the above-mentioned preset script and the above-mentioned update script are sequentially executed.

Optionally, in the case where the above-mentioned execution sequence is: firstly execute the above-mentioned update script, and then execute the above-mentioned preset script, the above-mentioned preset script and the above-mentioned update script are executed in sequence according to the above-mentioned execution order, the embodiment of the present application provides. The system deployment method may further include: executing the above-mentioned update script to update the first database format of the above-mentioned target database to a second database format, and the above-mentioned second database format matches the data format in the above-mentioned source database; and executing the above-mentioned preset script.

Optionally, before obtaining the target update method of the system database, the system deployment method provided by the embodiment of the present application may further include: inputting system deployment information, where the system deployment information includes at least one of the following: email information, database information, deployment point information; the above-mentioned mail information is used to send the system deployment content to the system deployer, the above-mentioned database information is used to set the database information of the above-mentioned source database and the database information of the above-mentioned target database; the above-mentioned deployment point information is used to set the server information corresponding to the system deployment; Upload a system deployment file; the system deployment file includes at least one of the following: the preset script and the version file.

Optionally, in the above-mentioned completing the database update according to the target update method and the above-mentioned sending the version file to N deployment points, and starting the target operation, the mid-system deployment method provided by the embodiment of the present application may further include: storing an execution log, the above-mentioned execution log. It is a procedural file for recording the above-mentioned database update and the above-mentioned deployment system code.

Optionally, after the above-mentioned deployment of the system code, the mid-system deployment method provided by the embodiment of the present application may further include: determining a target deployment point among the N deployment points, where the above-mentioned target deployment point is a deployment point with abnormal system deployment; according to the above-mentioned target The execution log of the deployment point, redeploy the system to the above target deployment point.

In order to solve the above technical problem, an embodiment of the present invention also provides a system deployment device, including: an acquisition module for acquiring a target update mode of a system database, where the target update mode includes at least one of the following: script setting update and comparison database update; an update module is used to complete the database update according to the above-mentioned target update method obtained by the above-mentioned acquisition module; a startup module is used to send the version file to N deployment points, and start the target operation, and the above-mentioned target operation is: deploying the system code; module, also used to restart the system.

Optionally, when the above-mentioned target update method is to update the above-mentioned script settings, the execution module is used for uploading a preset script, and the above-mentioned preset script is used for running the above-mentioned database; the execution module is further used for executing the above-mentioned preset script.

Optionally, when the above-mentioned target update method is the above-mentioned comparison database update, the comparison module is used to compare the source database and the target database, and confirm the format difference between the above-mentioned source database and the above-mentioned target database, and the above-mentioned source database is a system deployment. For the database corresponding to the previous system data, the above target database is the database corresponding to the above system data after the system deployment is completed; the generating module is used to generate an update script for the above target database; the execution module is used to execute the update script.

Optionally, when the above-mentioned target update method is the above-mentioned script setting update and the above-mentioned comparison database update, the execution module is used to upload a preset script, and the above-mentioned preset script is used to run the above-mentioned database; Under the situation of the above-mentioned instruction of the comparison database, then connect the source database and the target database, the above-mentioned source database is the database corresponding to the system data before the system deployment, and the above-mentioned target database is the database corresponding to the above-mentioned system data after the system deployment is completed; the comparison module , used to compare the source database and the target database, confirm the format difference between the above-mentioned source database and the above-mentioned target database, and generate an update script for the above-mentioned target database; Confirmation module is used to confirm the execution sequence of the above-mentioned preset script and the above-mentioned update script, The above-mentioned execution sequence is preset by the system in advance; the execution module is further configured to execute the above-mentioned preset script and the above-mentioned update script in sequence according to the above-mentioned execution sequence.

Optionally, when the above-mentioned execution sequence is: firstly execute the above-mentioned update script, and then execute the above-mentioned preset script, the execution module is configured to execute the above-mentioned update script, and update the first database format of the above-mentioned target database to the second database The format of the second database matches the data format in the source database; the execution module is further configured to execute the preset script.

Optionally, the input module is used to input system deployment information, and the system deployment information includes at least one of the following: email information, database information, and deployment point information; the email information is used to send system deployment content to system deployers, and the database The information is used to set the database information of the above-mentioned source database and the database information of the above-mentioned target database; the above-mentioned deployment point information is used to set the server information corresponding to the system deployment; the upload module is also used to upload the system deployment file; The above-mentioned system deployment file includes at least the following: One item: the above preset script, the above version file.

Optionally, the storage module is configured to store an execution log, where the execution log is a procedural file for recording the above-mentioned database update and the above-mentioned deployment system code.

Optionally, a determination module is used to determine a target deployment point in the N deployment points, and the above target deployment point is a deployment point with abnormal system deployment; an execution module is used for re-analyzing the above target deployment point according to the execution log of the above target deployment point. Deployment point for system deployment.

To solve the above technical problem, an embodiment of the present invention further provides a computer device, including a memory and a processor, where computer-readable instructions are stored in the memory, and when the computer-readable instructions are executed by the processor, the The processor executes the steps of the system deployment method described above.

In order to solve the above technical problem, the embodiment of the present invention further provides a storage medium storing computer-readable instructions. When the computer-readable instructions are executed by one or more processors, the one or more processors execute the above-mentioned The steps of the system deployment method.

The beneficial effects of the embodiments of the present invention are: by acquiring the target update mode of the system database (the above target update mode includes at least one of the following: script setting update and comparison database update), and complete the database update according to the target update mode, and update the system The version file pre-stored in the system is sent to N deployment points, the target operation of deploying the system code is started, and finally the system is restarted to complete the automatic system deployment. In the above process, when the database and version files are set in advance in the system, the system can automatically complete the whole process of system deployment without manual operation, thereby greatly reducing the consumption of human and material resources, saving the deployment time of system deployment, and improving the system Deployment efficiency.

Description of drawings

In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the following briefly introduces the accompanying drawings required for the description of the embodiments or the prior art. Obviously, the drawings in the following description are only These are some embodiments of the present application. For those of ordinary skill in the art, other drawings can also be obtained based on these drawings without any creative effort.

FIG. 1 is a schematic diagram of a basic flow of a system deployment method according to a specific embodiment of the present invention;

FIG. 2 is a schematic diagram of a basic structure of a system deployment apparatus according to an embodiment of the present invention;

FIG. 3 is a basic structural block diagram of a computer device according to an embodiment of the present invention.

Detailed ways

The following describes in detail the embodiments of the present application, examples of which are illustrated in the accompanying drawings, wherein the same or similar reference numerals refer to the same or similar elements or elements having the same or similar functions throughout. The embodiments described below with reference to the accompanying drawings are exemplary and are only used to explain the present application, but not to be construed as a limitation on the present application.

It will be understood by those skilled in the art that the singular forms "a", "an", "the" and "the" as used herein can include the plural forms as well, unless expressly stated otherwise. It should be further understood that the word "comprising" used in the specification of this application refers to the presence of stated features, integers, steps, operations, elements and/or components, but does not preclude the presence or addition of one or more other features, Integers, steps, operations, elements, components and/or groups thereof.

It will be understood by those skilled in the art that, unless otherwise defined, all terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this application belongs. It should also be understood that terms, such as those defined in a general dictionary, should be understood to have meanings consistent with their meanings in the context of the prior art and, unless specifically defined as herein, should not be interpreted in idealistic or overly formal meaning to explain.

Those skilled in the art can understand that the "terminal" used here includes both a device of a wireless signal receiver, which only has a device of a wireless signal receiver without transmission capability, and a device of receiving and transmitting hardware, which has a device capable of transmitting a wireless signal. On a two-way communication link, a device that performs the receiving and transmitting hardware of the two-way communication. Such equipment may include: cellular or other communication equipment, which has a single-line display or a multi-line display or a cellular or other communication device without a multi-line display; PCS (Personal Communications Service), which can combine voice, data Processing, fax and/or data communication capabilities; PDA (Personal Digital Assistant), which may include a radio frequency receiver, pager, Internet/Intranet access, web browser, notepad, calendar and/or GPS (Global Positioning System) receiver; conventional laptop and/or palmtop computer or other device having and/or including a conventional laptop and/or palmtop computer or other device with a radio frequency receiver. "Terminal" as used herein may be portable, transportable, mounted in a vehicle (air, marine and/or land), or adapted and/or configured to operate locally, and/or in a distributed fashion, to operate Operates anywhere on Earth and/or space. The "terminal" used here can also be a communication terminal, an Internet terminal, and a music/video playing terminal, such as a PDA, a MID (Mobile Internet Device) and/or a mobile phone with a music/video playing function, It can also be a smart TV, a set-top box and other devices.

Please refer to FIG. 1. FIG. 1 is a schematic diagram of a basic flow of a system deployment method provided by this embodiment, including steps 201 to 204:

Step 201: Obtain the target update method of the system database.

In the embodiment of the present invention, the above-mentioned target update method includes at least one of the following: script setting update and comparison database update.

In the embodiment of the present invention, the above-mentioned target update manner may be preset in advance, or may be user-defined setting.

In an example, when the above-mentioned target update method is preset in advance, the target update method has been pre-stored in the system, and when the system deployment starts, that is, when step 201 is started, the system can be read from the content pre-stored in the system. Take the target update method.

In the embodiment of the present invention, the above-mentioned target update manner is used to update the database.

In this embodiment of the present invention, the target update method may be only a script setting update, may also be a comparison database update, and may include both a script setting update and a comparison database update, which is not limited in the present invention.

Step 202: Complete the database update according to the above target update method.

It should be noted:

1. In the case where the target update method is the script setting update, the script setting update method is to update the database by executing the script. The function of the script is to run the database in the new system deployment, that is, when the target update method is only Including the script settings update, there are actually no critical differences in the format of the database after system deployment and the database before system deployment.

2. In the case where the target update method is to compare database updates, the comparison database is: comparing the database before system deployment with the database after system deployment, that is, comparing the source database and the target database. The reason is that there are key differences in the format and content of the source database and the target database. After the system is deployed, the target database cannot fully carry the content in the source database. Therefore, the target database needs to be updated by comparing the database, for example, updating the target database. fields, can add, and/or delete, and/or change fields in the target database.

3. The target update method includes both the script setting update and the comparison database update, that is, it can be considered that in the process of system deployment, the database needs to be run through the script, and there are key differences in the format and content of the source database and the target database. Therefore, The database needs to be updated using two update methods. Further, since two update methods are included, the order of use of the two update methods may be different according to the actual situation of the source database and the target database, and please refer to the following content for details.

Step 203: Send the pre-stored version file to N deployment points to start the target operation.

In the embodiment of the present invention, the above target operation is: deploying system code.

In this embodiment of the present invention, the above-mentioned N deployment points are preset by the system, and may also be user-defined settings, which are not limited in the present invention.

In this embodiment of the present invention, the above-mentioned N deployment points may be deployment points corresponding to N different geographic locations.

In the embodiment of the present invention, the above-mentioned version file is used to deploy system code, that is, update system code.

In this embodiment of the present invention, the above-mentioned version file may be preset in advance, that is, pre-stored in the system.

It should be noted that the system deployment process is mainly composed of two parts, the first part is database update, corresponding to steps 201 and 202, and the second part is deploying system code, that is, corresponding to step 203.

Step 204: Reboot the system.

In this embodiment of the present invention, after completing the above steps 201 to 203, the system is automatically restarted, so as to complete the new system operation.

In the system deployment method provided by the embodiment of the present application, by acquiring the target update mode of the system database (the above target update mode includes at least one of the following: script setting update and comparison database update), and completing the database update according to the target update mode, And send the version files pre-stored in the system to N deployment points, start the target operation of deploying the system code, and finally restart the system to complete the automatic system deployment. In the above process, when the database and version files are set in advance in the system, the system can automatically complete the whole process of system deployment without manual operation, thereby greatly reducing the consumption of human and material resources, saving the deployment time of system deployment, and improving the system Deployment efficiency.

Optionally, in the embodiment of the present application, in the case where the above-mentioned target update method is the above-mentioned script setting update, in the above-mentioned step 202, the system deployment method provided by the embodiment of the present application further includes the following steps A1 and A2:

Step A1: Upload the preset script.

Exemplarily, the above preset script is used to run the above database.

Step A2: Execute the above preset script.

It can be understood that, as can be seen from the foregoing content, when the target update method is only the script setting update, the script in the update method, that is, the preset script, can be preset in advance, and the preset script needs to be used to perform the update. Database update, in the case of running the database, directly call and upload the preset script.

Exemplarily, the above preset script is preset in advance.

In this way, in the case where the above-mentioned target update method is the above-mentioned script setting update, the database update in the system deployment can be completed by automatically retrieving the preset script preset in advance and directly executing the preset script without manual operation. Reduce manual operation time and efficiency.

Optionally, in the embodiment of the present application, when the above-mentioned target update method is the above-mentioned comparison database update, in the above-mentioned step 202, the system deployment method provided by the embodiment of the present application further includes the following steps B1 to B3:

Step B1: Compare the source database and the target database, and confirm the format difference between the source database and the target database.

Step B2: Generate an update script for the above target database.

Step B3: Execute the update script.

Exemplarily, the source database is a database corresponding to the system data before the system is deployed, and the target database is a database corresponding to the system data after the system deployment is completed.

Exemplarily, the foregoing target update manner is to compare the database update, and reference may be made to the foregoing description, which will not be repeated here.

Exemplarily, in the process of comparing databases, it is actually comparing the above-mentioned source database and target database, and the specific content of its comparison mainly includes the following 5 types of content:

1. Compare the consistency of the roles and users of the source database and the target database to see if there is any addition or deletion;

2. Compare whether the tables in the source database and the target database are added or deleted, whether the comments in the system have been changed, whether there are new and deleted indexes, whether the fields are added or deleted, and whether the fields are renamed. , the field is not empty, the default value, the comment is changed, whether the table itself has new or deleted triggers;

3. Compare the source and target database views, stored procedures, functions, and package SQL statements for changes, additions and deletions;

4. Compare whether the source database and the target database are synchronized, and whether the system type is added, deleted or modified;

5. Compare the tables, views, stored procedures, packages, and synchronization authorizations of the source database and the target database to see if there is a new or revoked situation.

Further, after the comparison is completed, if there is a situation in the above-mentioned content, the target database needs to be revised according to the source database situation, so that the target database can carry the data in the source database, and the above-mentioned revision process can be completed by updating the script, See below for details.

Exemplarily, after the comparison according to the above comparison process, an update script can be generated, and the update script can be used to revise the target database. After the update script is executed, the target database can carry the data in the source database.

In this way, in the case where the above-mentioned target update method is the above-mentioned comparison database update, by comparing the source database and the target database, generating an update script, and executing the update script, the database update in the system deployment can be completed, without manual operation, reducing the cost. Manual operation time and efficiency.

Optionally, in the embodiment of the present application, in the case that the above-mentioned target update method is the above-mentioned script setting update and the above-mentioned comparison database update, in the above step 202, the system deployment method provided by the embodiment of the present application further includes the following steps C1 to: Step C5:

Step C1: Upload the preset script.

Step C2: In the case of receiving the above instruction for comparing the databases, connect the source database and the target database.

Step C3: Compare the source database and the target database, confirm the format difference between the source database and the target database, and generate an update script for the target database.

Step C4: Confirm the execution sequence of the above-mentioned preset script and the above-mentioned update script.

Step C5: According to the above execution sequence, execute the above preset script and the above update script in sequence.

Exemplarily, the above preset script is used to run the above database.

Exemplarily, the above-mentioned source database is a database corresponding to the system data before the system is deployed, and the above-mentioned target database is a database corresponding to the above-mentioned system data after the system deployment is completed.

Exemplarily, the above execution sequence is preset by the system in advance.

Exemplarily, the above-mentioned step C1 may refer to the description of step A1 in the foregoing content, and step C3 may refer to the description of step B1 to step B3 in the foregoing content, which will not be repeated here.

Exemplarily, since the above-mentioned target update methods include: script setting update and comparison database update two update methods, therefore, after the system obtains the preset script, the source database and the target database need to be connected to be able to carry out the follow-up. Compare work.

Exemplarily, the above-mentioned instruction for comparing the database may be an instruction that automatically triggers the electronic device to send after the system obtains the preset script, for connecting the source database and the target database.

Exemplarily, the above execution sequence may be that the preset script is executed first, and then the update script is executed; or the update script may be executed first, and then the preset script is executed, which is not limited in this embodiment of the present invention.

In this way, when the above-mentioned target update method is the above-mentioned script setting update and the above-mentioned comparison database update, the pre-stored script can be obtained and the preset script and the update script can be executed according to the preset order, thereby completing the database update without manual operation and reducing labor costs. Operation time and efficiency.

Optionally, in the embodiment of the present application, in the case where the above-mentioned execution sequence is: the above-mentioned update script is executed first, and then the above-mentioned preset script is executed, in the above-mentioned step C5, the system deployment method provided by the embodiment of the present application further includes: Steps D1 and D2 are as follows:

Step D1: Execute the above update script to update the first database format of the target database to the second database format.

Step D2: Execute the above preset script.

Exemplarily, the above-mentioned second database format matches the data format in the above-mentioned source database.

Exemplarily, as described in the foregoing content, the reason for performing database update by comparing database updates is usually that the key format content of the source database and the target database are different, therefore, it is necessary to compare the database updates.

Further, generally, when the key format content of the source database and the target database is different, it is necessary to compare the database update first, that is, execute the update script, and then perform the script setting update, that is, execute the preset script.

Optionally, in the embodiment of the present application, before the above step 201, the system deployment method provided by the embodiment of the present application further includes the following steps E1 and E2:

Step E1: Enter system deployment information.

Step E2: Upload the system deployment file.

Exemplarily, the above-mentioned system deployment information includes at least one of the following: mail information, database information, and deployment point information; the above-mentioned mail information is used to send the system deployment content to the system deployer, and the above-mentioned database information is used to set the database information of the above-mentioned source database. and the database information of the above target database; the above deployment point information is used to set the server information corresponding to the system deployment.

Exemplarily, the above-mentioned system deployment file includes at least one of the following: the above-mentioned preset script and the above-mentioned version file.

Exemplarily, the above-mentioned system deployment personnel are personnel who need to be notified during the system deployment process.

Further, different deployment points may correspond to different system deployment personnel, or may correspond to the same system deployment personnel, which is not limited in this embodiment of the present invention.

Exemplarily, the above-mentioned system deployment content includes the content of this system deployment.

Further, different deployment points may correspond to different system deployment contents. That is, the content of the mail information may be different.

Exemplarily, the sending time of the above-mentioned email information may be set in advance, for example, set to be sent one day before the system is deployed, or may not be set in advance and sent in real time.

Exemplarily, within a predetermined time of system deployment, a message may also be automatically sent to remind the system deployer that the system is about to be deployed.

Exemplarily, the database information of the above-mentioned source database may include: the server where the source database is located, the type of the source database, the name of the source database, the port, the user name and the password, and the connection result information of the connection between the test source database and the target database, for example, the connection is successful or the connection is made. fail. Similarly, the database information of the target database may include: the server where the target database is located, the type of the target database, the name of the target database, the port, the user name and the password, and the connection result information of the connection between the test source database and the target database, for example, the connection succeeds or the connection fails.

Exemplarily, the above-mentioned database information of the source database and the database information of the target database may further include an update method of the target database.

Exemplarily, the above-mentioned target database may be one database, or may include multiple databases.

Exemplarily, the above server information may be multiple server information.

Further, the above-mentioned manner of entering deployment point information may be accomplished by receiving user input. For example, all server information is displayed in the electronic device, and the electronic device can enter the server information that has received the user's click input by receiving the user's click input. The server corresponding to the above selected server information will perform database update and system code update.

Exemplarily, the foregoing preset script may be one or multiple, which is not limited in this embodiment of the present invention.

Further, when there are multiple preset scripts, the execution order of the multiple preset scripts should be set.

Exemplarily, the above-mentioned system deployment file should also include the execution sequence of the update script and the preset script.

Exemplarily, the above-mentioned version file is the latest version of the code package file.

Further, if only part of the code in the system code is updated, only the part of the version file that needs to be updated can be uploaded. It should be noted that, if only the part of the version file that needs to be updated is uploaded, the code directory structure needs to be uploaded.

In this way, before the system automatically completes the system deployment, through the above simple preset operation, the system deployment can be automatically completed without manual operation in the subsequent system deployment process, saving manpower and time, and improving the efficiency of system deployment.

Optionally, in the embodiment of the present application, in the above steps 202 and 203, the system deployment method provided by the embodiment of the present application further includes the following step F:

Step F: Store the execution log.

Exemplarily, the above-mentioned execution log is a procedural file for recording the above-mentioned database update and the above-mentioned deployment system code.

It is understandable that, in the process of system deployment, each step of updating the database and deploying the system code will automatically record the execution process, so as to facilitate subsequent inquiry of problems when the system deployment is abnormal.

Optionally, in the embodiment of the present application, in the foregoing step 205, the system deployment method provided by the embodiment of the present application may include the following steps G1 and G2:

Step G1: Determine a target deployment point among the N deployment points.

Step G2: According to the execution log of the above-mentioned target deployment point, system deployment is performed on the above-mentioned target deployment point again.

Exemplarily, the above-mentioned target deployment point is a deployment point where the system deployment is abnormal.

Exemplarily, when the system deployment of the target deployment point is abnormal, the target deployment point can automatically feed back deployment abnormality information, so as to determine the target deployment point.

Exemplarily, the above-mentioned re-deployment of the system to the above-mentioned target deployment point is to re-execute the above-mentioned steps 201 to 204 for the target deployment point.

In this way, in the event of an abnormal system deployment at any deployment point, the problem can be checked in time according to the execution log during the system deployment process, and the system can be re-deployed at the abnormal deployment point to improve the success rate of the system deployment.

To solve the above technical problem, an embodiment of the present invention further provides a system deployment apparatus. Please refer to FIG. 2 for details. FIG. 2 is a schematic diagram of the basic structure of the system deployment apparatus according to the present embodiment.

As shown in FIG. 2 , a system deployment device includes: an acquisition module 301 for acquiring a target update method of a system database, where the above target update method includes at least one of the following: script setting update and comparison database update; update module 302 , is used to complete the database update according to the above-mentioned target update method obtained by the above-mentioned acquisition module 301; the startup module 303 is used to send the pre-stored version file to N deployment points, and start the target operation, and the above-mentioned target operation is: deploying the system code; Module 303 is also used to restart the system.

The system deployment device obtains the target update method of the system database (the above target update method includes at least one of the following: script setting update and comparison database update), and completes the database update according to the target update method, and sends the version file pre-stored in the system. To N deployment points, start the target operation of deploying the system code, and finally restart the system to complete the automatic system deployment. In the above process, when the database and version files are set in advance in the system, the system can automatically complete the whole process of system deployment without manual operation, thereby greatly reducing the consumption of human and material resources, saving the deployment time of system deployment, and improving the system Deployment efficiency.

In some embodiments, when the above-mentioned target update method is the above-mentioned script setting update, the execution module is used to upload a preset script, and the above-mentioned preset script is used to run the above-mentioned database; the execution module is also used to execute the above-mentioned preset script. .

In some embodiments, when the above-mentioned target update method is the above-mentioned comparison database update, the comparison module is used to compare the source database and the target database, and confirm the format difference between the above-mentioned source database and the above-mentioned target database, and the above-mentioned source database is The database corresponding to the system data before the system is deployed, the target database is the database corresponding to the system data after the system deployment is completed; the generation module is used to generate an update script for the above target database; the execution module is used to execute the update script.

In some embodiments, the above-mentioned target update method is that in the case of the above-mentioned script setting update and the above-mentioned comparison database update, the execution module is used for uploading a preset script, and the above-mentioned preset script is used for running the above-mentioned database; the connection module is used for In the case of receiving the above-mentioned instruction to compare the database, then connect the source database and the target database, the above-mentioned source database is the database corresponding to the system data before the system is deployed, and the above-mentioned target database is the database corresponding to the above-mentioned system data after the system deployment is completed; The pairing module is used for comparing the source database and the target database, confirming the format difference between the above-mentioned source database and the above-mentioned target database, and generating an update script for the above-mentioned target database; the confirmation module is used for confirming the execution of the above-mentioned preset script and the above-mentioned update script The above-mentioned execution order is preset by the system in advance; the execution module is further configured to execute the above-mentioned preset script and the above-mentioned update script in sequence according to the above-mentioned execution order.

In some embodiments, when the above-mentioned execution sequence is: firstly execute the above-mentioned update script, and then execute the above-mentioned preset script, the execution module is configured to execute the above-mentioned update script, and update the first database format of the above-mentioned target database to the first Second database format, the second database format matches the data format in the source database; the execution module is further configured to execute the preset script.

In some embodiments, the input module is used to input system deployment information, and the system deployment information includes at least one of the following: email information, database information, and deployment point information; the email information is used to send the system deployment content to the system deployer, The above-mentioned database information is used to set the database information of the above-mentioned source database and the database information of the above-mentioned target database; the above-mentioned deployment point information is used to set the server information corresponding to the system deployment; the upload module is also used to upload the system deployment file; the above-mentioned system deployment file includes At least one of the following: the above preset script, the above version file.

In some embodiments, the system deployment apparatus further includes: a storage module configured to store an execution log, where the execution log is a procedural file for recording the database update and the deployment system code.

In some embodiments, the above-mentioned system deployment apparatus further includes: a determination module for determining a target deployment point among the N deployment points, where the above-mentioned target deployment point is a deployment point with abnormal system deployment; an execution module for determining the target deployment point according to the above-mentioned target deployment point. , and redeploy the system to the above target deployment point.

To solve the above technical problems, the embodiments of the present invention further provide computer equipment. For details, please refer to FIG. 3 , which is a block diagram of a basic structure of a computer device according to this embodiment.

As shown in Figure 3, a schematic diagram of the internal structure of the computer equipment. The computer device includes a processor, non-volatile storage medium, memory, and a network interface connected by a system bus. Wherein, the non-volatile storage medium of the computer device stores an operating system, a database and computer-readable instructions, and the database may store a sequence of control information. When the computer-readable instructions are executed by the processor, the processor can realize a A data relationship reconstruction method. The processor of the computer device is used to provide computing and control capabilities and support the operation of the entire computer device. Computer-readable instructions may be stored in the memory of the computer device, and when executed by the processor, the computer-readable instructions may cause the processor to perform a data relationship reconstruction method. The network interface of the computer equipment is used for communication with the terminal connection. Those skilled in the art can understand that the structure shown in FIG. 3 is only a block diagram of a partial structure related to the solution of the present application, and does not constitute a limitation on the computer equipment to which the solution of the present application is applied. Include more or fewer components than shown in the figures, or combine certain components, or have a different arrangement of components.

In this embodiment, the processor is used to execute the specific functions of the acquisition module 301 , the update module 302 and the startup module 303 in FIG. 2 , and the memory stores program codes and various types of data required to execute the above modules. The network interface is used for data transmission between user terminals or servers. The memory in this embodiment stores the program codes and data required to execute all the submodules in the data relationship reconstruction apparatus, and the server can call the program codes and data of the server to execute the functions of all the submodules.

The present invention also provides a storage medium storing computer-readable instructions, and when the computer-readable instructions are executed by one or more processors, the one or more processors perform the steps of the system deployment method in any of the foregoing embodiments.

Those of ordinary skill in the art can understand that the realization of all or part of the processes in the methods of the above embodiments can be accomplished by instructing relevant hardware through a computer program, and the computer program can be stored in a computer-readable storage medium, and the program is During execution, it may include the processes of the embodiments of the above-mentioned methods. The aforementioned storage medium may be a non-volatile storage medium such as a magnetic disk, an optical disk, a read-only memory (Read-Only Memory, ROM), or a random access memory (Random Access Memory, RAM).

Those skilled in the art can understand that various operations, methods, steps, measures, and solutions in the process discussed in this application may be alternated, modified, combined or deleted. Further, other steps, measures, and solutions in the various operations, methods, and processes that have been discussed in this application may also be alternated, modified, rearranged, decomposed, combined, or deleted. Further, steps, measures and solutions in the prior art with various operations, methods, and processes disclosed in this application may also be alternated, modified, rearranged, decomposed, combined or deleted.

The above are only part of the embodiments of the present application. It should be pointed out that for those skilled in the art, without departing from the principles of the present application, several improvements and modifications can also be made. It should be regarded as the protection scope of this application.

Claims (11)

1. a system deployment method, is characterized in that, comprises: Obtain the target update mode of the system database, the target update mode includes at least one of the following: script setting update and comparison database update; Complete the database update according to the target update method; The version file is sent to N deployment points, and the target operation is started, and the target operation is: deploying the system code; Reboot the system. 2. The method according to claim 1, wherein, in the case that the target update mode is the script setting update, the database update is completed according to the target update mode, comprising: uploading a preset script, the preset script is used to run the database; Execute the preset script. 3. The method according to claim 1, wherein, in the case that the target update mode is the comparison database update, the database update is completed according to the target update mode, comprising: Compare the source database and the target database, confirm the format difference between the source database and the target database, the source database is the database corresponding to the system data before the system deployment, and the target database is the system data corresponding to the system data after the system deployment is completed database; generating an update script for the target database; Execute the update script. 4. The method according to claim 1, wherein the target update mode is under the situation of the script setting update and the comparison database update, and the database update is completed according to the target update mode, comprising: uploading a preset script, the preset script is used to run the database; In the case of receiving the instruction for comparing the databases, the source database and the target database are connected, the source database is the database corresponding to the system data before the system is deployed, and the target database is the system data corresponding to the system data after the system deployment is completed. database; Compare the source database and the target database, confirm the format difference between the source database and the target database, and generate an update script for the target database; Confirm the execution sequence of the preset script and the update script, and the execution sequence is preset by the system in advance; According to the execution sequence, the preset script and the update script are sequentially executed. 5 . The method according to claim 4 , wherein, when the execution sequence is: executing the update script first and then executing the preset script, the execution sequence is executed sequentially according to the execution sequence. 6 . The preset script and the update script include: Execute the update script to update the first database format of the target database to a second database format, and the second database format matches the data format in the source database; Execute the preset script. 6. The method according to any one of claims 1 to 5, wherein, before the acquisition of the target update mode of the system database, the method further comprises: Enter system deployment information, where the system deployment information includes at least one of the following: email information, database information, and deployment point information; the email information is used to send system deployment content to system deployment personnel, and the database information is used to set the The database information of the source database and the database information of the target database; the deployment point information is used to set the server information corresponding to the system deployment; Upload a system deployment file; the system deployment file includes at least one of the following: the preset script and the version file. 7. The method according to any one of claims 1 to 5, wherein the database update is completed according to the target update mode and the version file is sent to N deployment points, and the target operation is started, comprising: An execution log is stored, where the execution log is a procedural file for recording the database update and the deployment system code. 8. The method according to claim 7, after the deploying the system code, the method further comprises: Determine a target deployment point in the N deployment points, where the target deployment point is a deployment point with abnormal system deployment; According to the execution log of the target deployment point, system deployment is performed on the target deployment point again. 9. A system deployment device, comprising: an acquisition module, used for acquiring the target update mode of the system database, the target update mode includes at least one of the following: script setting update and comparison database update; an update module, configured to complete the database update according to the target update mode acquired by the acquisition module; A startup module, used to send the version file to N deployment points, and start a target operation, where the target operation is: deploying the system code; The startup module is also used to restart the system. 10. A computer device, characterized in that it comprises a memory and a processor, wherein computer-readable instructions are stored in the memory, and when the computer-readable instructions are executed by the processor, the processor can execute the The steps of the system deployment method of any one of claims 1 to 8. 11. A storage medium storing computer-readable instructions, characterized in that, when the computer-readable instructions are executed by one or more processors, the one or more processors are made to execute any one of claims 1 to 8. The steps of a system deployment method as claimed in one of the claims.

Images