CN115658098A

CN115658098A - Upgrading method and device for distributed business processing system

Info

Publication number: CN115658098A
Application number: CN202211121204.1A
Authority: CN
Inventors: 吴佳文; 郭锡超; 邬灼坚; 张华鹏
Original assignee: Industrial and Commercial Bank of China Ltd ICBC
Current assignee: Industrial and Commercial Bank of China Ltd ICBC
Priority date: 2022-09-15
Filing date: 2022-09-15
Publication date: 2023-01-31

Abstract

The application provides an upgrading method and device of a distributed business processing system, relates to the technical field of software upgrading, can also be used in the financial field, and comprises the following steps: determining a system upgrading mode according to a database operation language, a database definition language and a change type of a data table of a database server to be upgraded; the system upgrading mode comprises shutdown upgrading and non-shutdown upgrading; determining a database upgrading strategy according to a system upgrading mode, and upgrading a database server to be upgraded according to the database upgrading strategy, a database operation language and a database definition language; and after the database server to be upgraded is upgraded, performing rolling upgrade on the service processing server according to the flow of the service processing server and the service processing time period. The method and the device can reasonably distinguish the types of the hardware equipment to be upgraded and the specific upgrading content in a fine-grained manner, thereby effectively reducing the downtime in the system upgrading process and the influence on the service processing.

Description

Upgrading method and device for distributed business processing system

Technical Field

The application relates to the field of software upgrading, can be used in the field of finance, and particularly relates to an upgrading method and device for a distributed business processing system.

Background

In the financial field, in order to provide better service for customers, more and more financial institutions choose to deploy their servers in a distributed platform system (hereinafter referred to as a system), wherein some core financial services involved often need to provide 7 × 24 hours of uninterrupted service for customers.

In order to avoid the shutdown of the distributed platform system caused by software upgrading, in the prior art, the distributed platform system is often subjected to rolling upgrading in a manner of setting a redundant container, thereby causing a great deal of system resource waste. In fact, not all software upgrading processes need system shutdown to be completed, and an inevitable shutdown upgrading scene generally only involves some upgrading operations on the database, such as overall upgrading of the database system or resource domain migration; carrying out data table change and data synchronization with an application program; and carrying out large-data-volume data table index change, field addition, data cleaning and the like on the database. The prior art fails to reasonably distinguish types of hardware equipment to be upgraded and specific upgrading items in a fine-grained manner, and fails to effectively reduce the downtime in the system upgrading process and the influence on business processing.

Disclosure of Invention

Aiming at the problems in the prior art, the application provides an upgrading method and device of a distributed service processing system, which can reasonably distinguish the types of hardware equipment to be upgraded and specific upgrading contents in a fine-grained manner, thereby effectively reducing the downtime in the system upgrading process and the influence on service processing.

In order to solve the technical problem, the application provides the following technical scheme:

in a first aspect, the present application provides a method for upgrading a distributed service processing system, where the distributed service processing system includes a database server and a service processing server; the method comprises the following steps:

determining a system upgrading mode according to a database operation language, a database definition language and a change type of a data table of a database server to be upgraded; the system upgrading mode comprises shutdown upgrading and non-shutdown upgrading;

determining a database upgrading strategy according to the system upgrading mode, and upgrading the database server to be upgraded according to the database upgrading strategy, the database operation language and the database definition language;

and after the upgrading of the database server to be upgraded is completed, performing rolling upgrading on the service processing server according to the flow of the service processing server and a preset service busy time period.

Further, the determining a system upgrade mode according to a database operation language of a database server to be upgraded, a database definition language, and a change type of a data table includes:

determining whether a change type of the data table involves an index change, an add field, or a data scrub; if the index change, field addition or data cleaning is involved, the system upgrading mode is shutdown upgrading;

if the index change, field addition or data cleaning is not involved, judging whether the operation involved in the database operation language contains statements influencing on-line services; if the statement influencing the online service is included, the system upgrading mode is shutdown upgrading;

if the statement influencing the online service is not contained, judging whether the operation related in the database definition language conflicts with the online service; if the related operation conflicts with the online service, the system upgrading mode is shutdown upgrading; otherwise, the system upgrading mode is non-stop upgrading.

Furthermore, the system upgrading mode is the shutdown upgrading; the upgrading the database server to be upgraded according to the database upgrading strategy, the database operation language and the database definition language comprises the following steps:

the control routing layer server routes the service processing flow to the backup database server, and an upgraded operating system and a software program are installed on the database server to be upgraded;

executing the database definition language on the database server to be upgraded to clean a data table, build a new table structure, and update fields and/or indexes of the table;

and executing the database operation language on the database server to be upgraded so as to insert and/or update the data of the data table.

Further, the system upgrading mode is the non-stop upgrading; the upgrading the database server to be upgraded according to the database upgrading strategy, the database operation language and the database definition language comprises the following steps:

controlling a routing layer server to route the service processing flow to the database server to be upgraded;

executing the database definition language on the database server to be upgraded to clean a data table, build a new table structure and update fields and/or indexes of the table;

and executing the database operation language on the database server to be upgraded so as to insert and/or update data of a data table.

Further, the performing rolling upgrade on the service processing server according to the traffic of the service processing server and a preset service busy time period includes:

determining whether the current upgrading time belongs to the heavy traffic time period; if not, determining the upgrading batch of each business processing server according to the flow of the business processing servers;

and performing rolling upgrade on each service processing server according to the upgrade batch.

Further, the method for upgrading a distributed service processing system further includes:

performing data migration operation on the data table related to the table association migration scene according to the data after the database server to be upgraded is upgraded; and the data migration operation is completed by calling a data migration program by a service processing batch server in the service processing server.

In a second aspect, the present application provides an upgrade apparatus for a distributed service processing system, including:

the upgrading mode determining unit is used for determining a system upgrading mode according to a database operation language, a database definition language and a change type of a data table of a database server to be upgraded; the system upgrading mode comprises shutdown upgrading and non-shutdown upgrading;

the database upgrading unit is used for determining a database upgrading strategy according to the system upgrading mode and upgrading the database server to be upgraded according to the database upgrading strategy, the database operation language and the database definition language;

and the server upgrading unit is used for performing rolling upgrading on the service processing server according to the flow of the service processing server and a preset service busy time period after the upgrading of the database server to be upgraded is completed.

Further, the upgrade mode determining unit includes:

a change type determination module for determining whether a change type of the data table involves an index change, an add field, or data cleanup; if the index change, field increase or data cleaning is involved, the system upgrading mode is shutdown upgrading;

the online service statement determining module is used for judging whether the operation related in the database operation language contains statements influencing online service when the index change, field addition or data cleaning is not related; if the statement influencing the online service is included, the system upgrading mode is shutdown upgrading;

the online service resource determining module is used for judging whether the operation related in the database definition language conflicts with the online service when the statement influencing the online service is not included; if the related operation conflicts with the online service, the system upgrading mode is shutdown upgrading; otherwise, the system upgrading mode is upgrading without stopping.

Further, the system upgrading mode is the shutdown upgrading; the database upgrading unit comprises:

the first flow guiding module is used for controlling the routing layer server to route the service processing flow to the backup database server and installing an upgraded operating system and software programs on the database server to be upgraded;

the first definition language execution module is used for executing the database definition language on the database server to be upgraded so as to clean a data table, build a new table structure and update fields and/or indexes of the table;

and the first operation language execution module is used for executing the database operation language on the database server to be upgraded so as to insert and/or update data of the data table.

Further, the system upgrading mode is the non-stop upgrading; the database upgrading unit comprises:

the second flow guiding module is used for controlling the routing layer server to route the service processing flow to the database server to be upgraded;

the second definition language execution module is used for executing the database definition language on the database server to be upgraded so as to clean a data table, build a new table structure and update fields and/or indexes of the table;

and the second operation language execution module is used for executing the database operation language on the database server to be upgraded so as to insert and/or update the data of the data table.

Further, the server upgrade unit includes:

the upgrading batch determining module is used for determining whether the current upgrading time belongs to the busy service time interval or not; if not, determining the upgrading batch of each business processing server according to the flow of the business processing servers;

and the rolling upgrading execution module is used for performing rolling upgrading on each service processing server according to the upgrading batch.

Further, the upgrade apparatus for a distributed service processing system further includes:

the data migration operation unit is used for performing data migration operation on the data table related to the table association migration scene according to the data after the database server to be upgraded is upgraded; and the data migration operation is completed by calling a data migration program by a service processing batch server in the service processing server.

In a third aspect, the present application provides an electronic device including a memory, a processor, and a computer program stored on the memory and executable on the processor, where the processor implements the steps of the upgrade method for the distributed service processing system when executing the program.

In a fourth aspect, the present application provides a computer readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of the upgrade method for a distributed service processing system.

In a fifth aspect, the present application provides a computer program product comprising computer programs/instructions which, when executed by a processor, implement the steps of the upgrade method of the distributed service processing system.

Aiming at the problems in the prior art, the upgrading method and the upgrading device of the distributed business processing system can uniformly control the upgrading sequence of each application server and database service in the distributed system through the upgrading strategy control server, and greatly improve the upgrading operation and maintenance efficiency of the system; the upgrading strategy is automatically verified and the process is analyzed through the strategy analysis optimizing component, so that the problems of the upgrading strategy of manual equipment are corrected, and the correctness of system upgrading is better guaranteed; the condition that the database upgrading needs to be stopped and upgraded is automatically analyzed, the non-stop upgrading strategy is started, uninterrupted service upgrading of the system is automatically completed by adjusting the fragment routing and the upgrading strategy, and the service continuity of the whole system is improved, so that the customer experience is improved.

Drawings

In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the embodiments or the prior art descriptions will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and other drawings can be obtained by those skilled in the art without creative efforts.

Fig. 1 is a flowchart of an upgrade method of a distributed service processing system in an embodiment of the present application;

FIG. 2 is a flowchart of determining a system upgrade manner in an embodiment of the present application;

fig. 3 is one of the flowcharts of upgrading the database server to be upgraded in the embodiment of the present application;

fig. 4 is a second flowchart illustrating upgrading a database server to be upgraded in the embodiment of the present application;

fig. 5 is a flowchart of performing rolling upgrade on a service processing server in the embodiment of the present application;

fig. 6 is a structural diagram of an upgrade apparatus of a distributed service processing system in an embodiment of the present application;

fig. 7 is a structural diagram of an upgrade mode determination unit in the embodiment of the present application;

FIG. 8 is a block diagram of a database upgrade unit in an embodiment of the present application;

FIG. 9 is a block diagram of a database upgrade unit in an embodiment of the present application;

FIG. 10 is a block diagram of a server upgrade unit in an embodiment of the present application;

fig. 11 is a schematic structural diagram of an electronic device in an embodiment of the present application;

FIG. 12 is a schematic structural diagram of an upgrade system without shutdown in an embodiment of the present application;

fig. 13 is a schematic structural diagram of an upgrade policy control server in an embodiment of the present application;

FIG. 14A is a flowchart illustrating a process of an upgrade method without shutdown in an embodiment of the present application;

FIG. 14B is a second flowchart illustrating a process of the non-stop upgrading method according to the embodiment of the present application;

FIG. 14C is a third flowchart illustrating a process of the method for upgrading without shutdown in the embodiment of the present application;

FIG. 14D is a fourth flowchart illustrating a process of the non-stop upgrading method according to the embodiment of the present application;

FIG. 14E is a fifth flowchart illustrating a process of the non-stop upgrading method according to the embodiment of the present application;

FIG. 14F is a sixth flowchart illustrating a process of the non-stop upgrade method according to an embodiment of the present application;

fig. 14G is a seventh processing flowchart of the non-stop upgrading method in the embodiment of the present application.

Detailed Description

The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.

It should be noted that the method and the apparatus for upgrading a distributed service processing system provided by the present application may be used in the financial field, and may also be used in any field other than the financial field.

According to the technical scheme, the data acquisition, storage, use, processing and the like meet relevant regulations of national laws and regulations.

In an embodiment, referring to fig. 1, in order to reasonably distinguish types of hardware devices to be upgraded and specific upgrade contents in a fine-grained manner, thereby effectively reducing downtime in a system upgrading process and an influence on service processing, the present application provides an upgrading method for a distributed service processing system, where the distributed service processing system includes a database server and a service processing server; the method comprises the following steps:

s101: determining a system upgrading mode according to a database operation language, a database definition language and a change type of a data table of a database server to be upgraded; the system upgrading mode comprises shutdown upgrading and non-shutdown upgrading;

the database definition language and the database operation language are upgrading scripts of the database. Specifically, the database definition language includes: adding, deleting, adding fields and modifying indexes of the table structure. The database operation language includes: and operations of data in the database, such as addition, deletion, updating and the like.

It can be understood that, in order to achieve the technical effects of the present invention, the technical solutions adopted by the present invention are as follows:

referring to fig. 12, the distributed system non-stop upgrading method and system provided by the present invention includes a load balancer, a routing layer server, a service processing layer online server, a service processing layer batch server, a database server, and an upgrade policy server. The service processing layer online server and the service processing layer batch server are collectively called a service processing server.

A load balancer: and receiving a transaction request, and calling the service provided by the routing layer server according to the load condition of the routing layer after the operation of the load balancing algorithm.

Routing layer server: the distributed service provider is composed of 1-N groups of containers, virtual machines or physical machines, and is called by a load balancing server in an HTTP mode to generate a fragment routing field, and a service processing layer online server needing to be called is calculated by adopting a Hash algorithm according to the value of the fragment routing field. For example, in a bank bill receiving business system, a business processing layer online server adopts an order number to transversely split a database, an order number is generated in a routing layer server, and a hash algorithm is performed to calculate which business processing layer online server needs to be routed for processing the transaction.

The business processing layer online server: the application server for performing on-line service logic processing is composed of 1-N groups of containers and virtual machines or physical machines, and is called by a routing layer server in an RPC remote call mode. The service processing layer online server performs routing calculation according to a certain routing field, and each group of service processing layer online servers only process the transaction requests falling in the fragment.

The service processing layer batch server: the application server for batch service logic processing consists of 1-N groups of containers and virtual machines or physical machines, and is connected with the same database server as the online server of the service processing layer.

The service processing layer batch server performs batch service logic processing on days or days, including but not limited to data statistics, data migration, data processing, service report generation and the like.

A database server: and the database connected with the service processing layer server is used for persistently storing the transaction request processing, and recording and updating the service processing result. The database server also comprises 1-N groups of containers, virtual machines or physical machines, the groups of the business processing layer online servers and the business processing layer batch servers are in one-to-one correspondence, for example, the group 1 of the business processing layer online servers corresponds to the group 1 of the database servers, the group 2 of the business processing layer online servers corresponds to the group 2 of the database servers, and so on.

The upgrading strategy control server: and the server is used for uniformly controlling the system upgrading strategies of the routing layer server, the business processing layer online server, the business processing layer batch server and the database server.

Specifically, referring to fig. 13, the upgrade policy control server includes a policy configuration maintenance component 01, a policy analysis optimization component 02, a policy pushing component 03, and an upgrade flow control component 04.

Policy configuration maintenance component 01: the module provides a visual upgrading pipeline configuration interface of an upgrading strategy, and system upgrading personnel configure the upgrading pipeline according to the time, content and steps of each upgrading of the routing layer server, the service processing layer online server, the service processing layer batch server and the database server. For the routing layer server, the service processing layer online server and the service processing layer batch server, a rolling upgrading strategy of the program version packages in 1-N groups can be set, namely the upgrading sequence and the time interval of the program version packages in the 1-N groups are sequentially upgraded, parameters required by a program and the release time of a file are configured at the same time, and the program version packages are ensured to be imported before being upgraded. For the database server, DML and DDL for upgrading the database are set, and the upgrading time and sequence of each DML and DDL are set.

Policy analysis optimization component 02: the module analyzes and optimizes the upgrade strategy according to the upgrade strategy set by the strategy configuration maintenance component 01. The specific upgrade strategy analysis method comprises the following steps: firstly, DML and DDL statements of database upgrading and specific data volume and access volume of a database table are obtained, whether shutdown upgrading is needed or not is analyzed according to the type of structure change of the database table (the type comprises a new table, a new index, a new added column, a deleted column and the like) by combining the data volume of the database table and program codes, and if shutdown upgrading is needed, a shutdown upgrading strategy is started. Scenarios requiring shutdown upgrades include, but are not limited to: 1. the data table changes are consistent with the application needs. For example, an application may need to record into another table using some added field to the data table structure. If rolling upgrade is adopted, the programs which are not upgraded cannot be processed correctly; 2. when a database of some types changes indexes, increases fields or cleans data of a data table with large data volume, the operation of normal transaction is influenced by the reasons that the table is locked during upgrading and the like. For example, a database version needs to update a table a, add fields B and C, and needs to be assigned with default values, wherein the data size of the table a is 2000 ten thousands, the access amount per second is 100 times, the database version is mysql5.7, table reconstruction is needed, the database version needs more than 180 seconds of update time after analysis, and during the change, due to large transaction access amount, blockage occurs, which causes the change failure, and a non-stop upgrading strategy needs to be started.

The policy pushing component 03: the system is responsible for establishing communication connection with a routing layer server, a business processing layer online server, a business processing layer batch server and a database server, and pushing communication and upgrading strategies during production and upgrading. The method comprises the pushing of a routing layer server, a business processing layer online server, a business processing layer batch server program version package, an installation script and the like, and also comprises the pushing of a database program, a DML and DDL upgrading strategy, an installation script and the like of a database server. Meanwhile, the policy pushing component 03 receives and records the processing results of the routing layer server, the service processing layer online server and the service processing layer batch server.

Upgrade flow control component 04: and the system is responsible for configuring the upgrading strategy determined by the module and the strategy analysis and optimization component according to the upgrading strategy, pushing and receiving the upgrading result of each node through the strategy pushing component according to the upgrading flow steps, and integrally scheduling and controlling the upgrading process. For example, a certain system upgrade step is: 1) Firstly, stopping a batch server of a service processing layer; 2) Installing DML and DDL scripts of a database server; 3) Upgrading the online server program of the service processing layer by rolling every minute; 4) And starting the batch servers of the service processing layer and finishing the upgrading process. The upgrading process control assembly pushes the arrangement program package through the strategy pushing assembly according to the steps and the sequence, and starts the next upgrading step according to the upgrading result of the previous step.

Specifically, referring to fig. 2, the determining the system upgrade mode according to the database operation language of the database server to be upgraded, the database definition language, and the change type of the data table includes:

s201: determining whether a change type of the data table involves an index change, an add field, or a data scrub; if the index change, field addition or data cleaning is involved, the system upgrading mode is shutdown upgrading;

s202: if the index change, field addition or data cleaning is not involved, judging whether the operation involved in the database operation language contains statements influencing on-line services; if the statement influencing the online service is included, the system upgrading mode is shutdown upgrading;

s203: if the statement influencing the online service is not contained, judging whether the operation related in the database definition language conflicts with the online service; if the related operation and the online service have resource conflict, the system upgrading mode is shutdown upgrading; otherwise, the system upgrading mode is non-stop upgrading.

It can be understood that in an actual application scenario, shutdown upgrading is required under some conditions, and for the condition that shutdown upgrading is required, the "shutdown-free upgrading strategy" provided by the present application may be started to perform system upgrading; in some cases, upgrading can be carried out on the running database server or the running service processing server without stopping the machine for upgrading or guiding the service processing flow. See steps S201 to S203 for a specific determination method.

S102: determining a database upgrading strategy according to the system upgrading mode, and upgrading the database server to be upgraded according to the database upgrading strategy, the database operation language and the database definition language;

specifically, in an embodiment, referring to fig. 3, the system upgrade mode is the shutdown upgrade; the upgrading the database server to be upgraded according to the database upgrading strategy, the database operation language and the database definition language comprises the following steps:

s301: the control routing layer server routes the service processing flow to the backup database server, and an upgraded operating system and a software program are installed on the database server to be upgraded;

s302: executing the database definition language on the database server to be upgraded to clean a data table, build a new table structure and update fields and/or indexes of the table;

s303: and executing the database operation language on the database server to be upgraded so as to insert and/or update data of a data table.

First, if the upgrade operation involves a change in the database type or a replacement of the database server, the database type and the replacement of the database server need to be performed first. For example, the Oracle database is converted into Mysql database, and the database server is replaced with a new device; secondly, if the database program version is upgraded, the upgrade of the database version is executed first. Thirdly, after the above steps are completed, the database definition language is executed first, and then the database operation language is executed.

It can be understood that, referring to fig. 14A to 14G, in order to achieve the object of the present invention, a distributed system non-stop upgrading method and system provided by the present invention need to start a "non-stop upgrading policy" when a database upgrading stop condition is involved. Before executing the "non-stop upgrading strategy", the routing layer server is controlled to route the service processing traffic to the backup database server, and the upgraded operating system and software program are installed on the database server to be upgraded, that is, the service processing traffic is guided. The aim of doing so is not to affect the external business service, that is, the backup database server is temporarily used to replace the database server to be upgraded for the external business service.

The specific implementation steps for executing the 'non-stop upgrading strategy' are as follows:

referring to fig. 14A, step 1: the routing layer server adjusts the routing strategy: and the routing layer server acquires the non-stop upgrading strategy according to the parameters. The upgrade strategy sets half of databases numbered from N/2+1 to N to be upgraded first, and the routing field of the transaction controlled by the routing layer server only generates the routing field of the transaction to the database server from 1 to N/2, so that the transaction is automatically routed to the online server connected with the database server from 1 to N/2. For example, the bank merchant receipt payment system consists of 8 databases (numbered 1-8), and the system performs transaction routing by taking the hash value of the order number as a routing field, so that when the routing layer generates the order number, the hash value of the order number is controlled to only generate the database sub-library with the number of 1-4, the transaction is automatically routed to the online server with the number of 1-4, and the online server with the number of 5-8 does not have the transaction to enter any more.

Referring to fig. 14B, step 2: upgrading from N/2+1 to N database servers: and upgrading the database servers of N/2+1 to N, wherein the database servers comprise database programs, installation databases DML, DDL scripts and the like.

Referring to fig. 14C, step 3: upgrading the programs of the N/2+1 to N online servers and batch servers: and the online server and the batch server program are butted by the database servers of N/2+1 to N.

Referring to fig. 14D, step 4: and (4) association table scene transition: for the table-related migration scene, performing data migration by using a new batch server program; for example, the C field is added to table a, and the data needs to be obtained through the association of table B and table C, and then the data is moved to the C field of table a.

Referring to fig. 14E, step 5: the routing layer server adjusts the routing strategy: and adjusting the upgrade strategy to set the number of the database upgrade from 1 to N/2, wherein the routing field of the transaction controlled by the routing layer server only generates the routing field of the transaction to the database server from N/2+1 to N, so that the transaction is automatically routed to the online server butted with the database servers from N/2+1 to N.

Referring to fig. 14F, step 6:1-N database servers, online servers, and batch server upgrades. The upgrading method is the same as the steps 2,3 and 4;

referring to fig. 14G, step 7: the routing layer server adjusts the routing strategy, recovers the control of the routing strategy, and can route the transaction to 1-N total online servers to complete the system upgrade.

As can be seen from the above description, the upgrading method for the distributed service processing system provided in the present application can upgrade the database server to be upgraded according to the database upgrading policy, the database operation language, and the database definition language.

Specifically, in an embodiment, referring to fig. 4, the system upgrade mode is the non-stop upgrade; the upgrading the database server to be upgraded according to the database upgrading strategy, the database operation language and the database definition language comprises the following steps:

s401: controlling a routing layer server to route the service processing flow to the database server to be upgraded;

s402: executing the database definition language on the database server to be upgraded to clean a data table, build a new table structure and update fields and/or indexes of the table;

s403: and executing the database operation language on the database server to be upgraded so as to insert and/or update the data of the data table.

It can be understood that in a scenario where a shutdown upgrade is not required, the upgrade may be directly performed on the running database server or the running service processing server without draining the service processing traffic. In this case, the service processing traffic is routed to the database server to be upgraded with respect to the control routing layer server, that is, the database server to be upgraded continues to process the service traffic. The specific implementation process of steps S402 to S403 is the same as that of steps S302 to S303, and is not repeated herein.

S103: and after the upgrading of the database server to be upgraded is completed, performing rolling upgrading on the service processing server according to the flow of the service processing server and a preset service busy time period.

Specifically, in an embodiment, referring to fig. 5, the performing rolling upgrade on the service processing server according to the traffic of the service processing server and a preset busy time period of the service includes:

s501: determining whether the current upgrading time belongs to the heavy traffic time period; if not, determining the upgrading batch of each business processing server according to the flow of the business processing servers; if not, waiting can be carried out until the current upgrading time is determined not to belong to the busy service time period, and then determining an upgrading batch to prepare for upgrading;

s502: and performing rolling upgrade on each service processing server according to the upgrade batch.

It can be understood that after the database server is upgraded, the database server is the latest version, and only the program of the service processing server connected with the database server needs to be upgraded, and since there are a plurality of service processing servers, the upgrade can be performed in a rolling upgrade mode.

The rolling upgrading mode is an upgrading mode of a plurality of copy services and is characterized in that the external service is not interrupted in the upgrading process, and the outside does not sense the upgrading process; the upgrade mode may be understood as that the service processing servers to be upgraded are upgraded in turn.

As can be seen from the above description, the upgrading method of the distributed service processing system provided in the present application can perform rolling upgrading on the service processing server according to the traffic of the service processing server and the preset service busy time period.

In an embodiment, the method for upgrading a distributed service processing system further includes:

performing data migration operation on a data table related to a table association migration scene according to the data after the database server to be upgraded is upgraded; and the data migration operation is completed by calling a data migration program by a service processing batch server in the service processing server.

It will be appreciated that the application of the so-called data migration operation is for example as follows:

adding a new field to a certain table structure (such as a table A) in the database, and acquiring data of the field in association with other table structures (such as a table B and a table C), wherein the service processing batch server starts a migration program through batch scheduling; the migration program queries other association tables (such as a table B and a table C) through the main key or the foreign key of the data table so as to acquire information required by the newly added field; and the migration program performs calculation or splicing on the acquired information according to the requirement of the service logic, and then writes the information into a newly-added field of the upgrading table structure, namely the information is stored in the changed table.

As can be seen from the above description, the upgrade method for a distributed service processing system provided in the present application can perform data migration operation on a data table related to a table-associated migration scenario.

In summary, the upgrading method of the distributed service processing system provided by the application can uniformly control the upgrading sequence of each application server and the database service in the distributed system through the upgrading policy control server, and greatly improve the upgrading operation and maintenance efficiency of the system; the upgrading strategy is automatically verified and the process is analyzed through the strategy analysis optimizing component, so that the problems of the upgrading strategy of manual equipment are corrected, and the correctness of system upgrading is better guaranteed; the condition that the database upgrading needs to be stopped and upgraded is automatically analyzed, the non-stop upgrading strategy is started, the uninterrupted service upgrading of the system is automatically completed by adjusting the fragment routing and the upgrading strategy, the service continuity of the whole system is improved, and therefore the customer experience is improved.

Based on the same inventive concept, the embodiment of the present application further provides an upgrading apparatus for a distributed service processing system, which can be used to implement the method described in the foregoing embodiment, as described in the following embodiment. Because the principle of solving the problem of the upgrading device of the distributed service processing system is similar to that of the upgrading method of the distributed service processing system, the implementation of the upgrading device of the distributed service processing system can refer to the implementation of the software performance reference determination method, and repeated parts are not described again. As used hereinafter, the term "unit" or "module" may be a combination of software and/or hardware that implements a predetermined function. While the system described in the embodiments below is preferably implemented in software, implementations in hardware, or a combination of software and hardware are also possible and contemplated.

In an embodiment, referring to fig. 6, in order to reasonably distinguish types of hardware devices to be upgraded and specific upgrade contents in a fine-grained manner, so as to effectively reduce downtime in a system upgrade process and influence on service processing, an upgrade apparatus for a distributed service processing system is provided, which includes: an upgrade mode determination unit 601, a database upgrade unit 602, and a server upgrade unit 603.

An upgrade mode determining unit 601, configured to determine a system upgrade mode according to a database operation language of a database server to be upgraded, a database definition language, and a change type of a data table; the system upgrading mode comprises shutdown upgrading and non-shutdown upgrading;

a database upgrading unit 602, configured to determine a database upgrading policy according to the system upgrading mode, and upgrade the database server to be upgraded according to the database upgrading policy, the database operation language, and the database definition language;

a server upgrading unit 603, configured to perform rolling upgrade on the service processing server according to the traffic of the service processing server and a preset service busy period after the upgrade of the database server to be upgraded is completed.

In an embodiment, referring to fig. 7, the upgrade mode determining unit 601 includes: a change type determining module 701, an online service statement determining module 702 and an online service resource determining module 703.

A change type determining module 701, configured to determine whether a change type of the data table relates to an index change, a field addition, or data cleaning; if the index change, field increase or data cleaning is involved, the system upgrading mode is shutdown upgrading;

an online service statement determining module 702, configured to determine whether an operation related in the database operation language includes a statement that affects an online service when the index change, field addition, or data cleaning is not related; if the statement influencing the online service is included, the system upgrading mode is shutdown upgrading;

an online service resource determining module 703, configured to determine whether an operation related to the database definition language conflicts with an online service resource when the statement that affects the online service is not included; if the related operation and the online service have resource conflict, the system upgrading mode is shutdown upgrading; otherwise, the system upgrading mode is upgrading without stopping.

In an embodiment, referring to fig. 8, the system upgrade mode is the shutdown upgrade; the database upgrading unit 602 includes:

a first traffic guidance module 801, configured to control the routing layer server to route the service processing traffic to a backup database server, and install an upgraded operating system and software program on a database server to be upgraded;

a first definition language executing module 802, configured to execute the database definition language on the database server to be upgraded, so as to perform table cleaning, table newly-built structure, and table updating on a field and/or an index;

a first operation language execution module 803, configured to execute the database operation language on the database server to be upgraded, so as to insert and/or update data of a data table.

In an embodiment, referring to fig. 9, the system upgrade mode is the non-stop upgrade; the database upgrading unit 602 includes: a second traffic guidance module 901, a second definition language execution module 902, and a second operation language execution module 903.

A second traffic guiding module 901, configured to control a routing layer server to route a service processing traffic to the database server to be upgraded;

a second definition language executing module 902, configured to execute the database definition language on the database server to be upgraded, so as to perform table cleaning, new table building structure, and table updating of fields and/or indexes;

a second operation language execution module 903, configured to execute the database operation language on the database server to be upgraded, so as to insert and/or update data of a data table.

In an embodiment, referring to fig. 10, the server upgrading unit 603 includes:

an upgrade batch determining module 1001 configured to determine whether a current upgrade time belongs to the traffic busy period; if not, determining the upgrading batch of each business processing server according to the flow of the business processing servers;

and the rolling upgrade executing module 1002 is configured to perform rolling upgrade on each service processing server according to the upgrade batch.

In an embodiment, the upgrade apparatus for a distributed service processing system further includes:

In order to reasonably distinguish types of hardware devices to be upgraded and specific upgrading contents in a fine-grained manner from each other in a hardware level, thereby effectively reducing downtime in a system upgrading process and influence on service processing, the present application provides an embodiment of an electronic device for implementing all or part of contents in an upgrading method of a distributed service processing system, where the electronic device specifically includes the following contents:

a Processor (Processor), a Memory (Memory), a communication Interface (Communications Interface) and a bus; the processor, the memory and the communication interface complete mutual communication through the bus; the communication interface is used for realizing information transmission between the upgrading device of the distributed service processing system and relevant equipment such as a core service system, a user terminal, a relevant database and the like; the logic controller may be a desktop computer, a tablet computer, a mobile terminal, and the like, but the embodiment is not limited thereto. In this embodiment, the logic controller may refer to an embodiment of an upgrade method of a distributed service processing system and an embodiment of an upgrade apparatus of a distributed service processing system in the embodiments for implementation, and the contents thereof are incorporated herein, and repeated details are not repeated.

It is understood that the user terminal may include a smart phone, a tablet electronic device, a network set-top box, a portable computer, a desktop computer, a Personal Digital Assistant (PDA), a vehicle-mounted device, a smart wearable device, and the like. Wherein, intelligence wearing equipment can include intelligent glasses, intelligent wrist-watch, intelligent bracelet etc..

In practical applications, part of the upgrade method of the distributed service processing system may be executed on the electronic device side as described in the above, or all operations may be completed in the client device. The selection may be specifically performed according to the processing capability of the client device, the limitation of the user usage scenario, and the like. This is not a limitation of the present application. The client device may further include a processor if all operations are performed in the client device.

The client device may have a communication module (i.e., a communication unit), and may be in communication connection with a remote server to implement data transmission with the server. The server may include a server on the task scheduling center side, and in other implementation scenarios, the server may also include a server on an intermediate platform, for example, a server on a third-party server platform that has a communication link with the task scheduling center server. The server may include a single computer device, or may include a server cluster formed by a plurality of servers, or a server structure of a distributed apparatus.

Fig. 11 is a schematic block diagram of a system configuration of an electronic device 9600 according to an embodiment of the present application. As shown in fig. 11, the electronic device 9600 can include a central processor 9100 and a memory 9140; the memory 9140 is coupled to the central processor 9100. It is noted that this FIG. 11 is exemplary; other types of structures may also be used in addition to or in place of the structure to implement telecommunications or other functions.

In one embodiment, the upgrade method function of the distributed business processing system may be integrated into the central processor 9100. The central processor 9100 can be configured to perform the following control:

As can be seen from the above description, the upgrading method of the distributed service processing system provided by the present application can uniformly control the upgrading sequence of each application server and database service in the distributed system through the upgrading policy control server, thereby greatly improving the upgrading operation and maintenance efficiency of the system; the upgrading strategy is automatically verified and the process is analyzed through the strategy analysis optimizing component, so that the problems existing in the manual equipment upgrading strategy are corrected, and the correctness of system upgrading is better guaranteed; the condition that the database upgrading needs to be stopped and upgraded is automatically analyzed, the non-stop upgrading strategy is started, uninterrupted service upgrading of the system is automatically completed by adjusting the fragment routing and the upgrading strategy, and the service continuity of the whole system is improved, so that the customer experience is improved.

In another embodiment, the upgrading apparatus of the distributed service processing system may be configured separately from the central processing unit 9100, for example, the upgrading apparatus of the distributed service processing system of the data compound transmission apparatus may be configured as a chip connected to the central processing unit 9100, and the function of the upgrading method of the distributed service processing system may be implemented by the control of the central processing unit.

As shown in fig. 11, the electronic device 9600 may further include: a communication module 9110, an input unit 9120, an audio processor 9130, a display 9160, and a power supply 9170. It is noted that the electronic device 9600 also does not necessarily include all of the components shown in fig. 11; in addition, the electronic device 9600 may further include components not shown in fig. 11, which may be referred to in the prior art.

As shown in fig. 11, a central processor 9100, sometimes referred to as a controller or operational control, can include a microprocessor or other processor device and/or logic device, which central processor 9100 receives input and controls the operation of the various components of the electronic device 9600.

The memory 9140 can be, for example, one or more of a buffer, a flash memory, a hard drive, a removable media, a volatile memory, a non-volatile memory, or other suitable device. The information relating to the failure may be stored, and a program for executing the information may be stored. And the central processing unit 9100 can execute the program stored in the memory 9140 to realize information storage or processing, or the like.

The input unit 9120 provides input to the central processor 9100. The input unit 9120 is, for example, a key or a touch input device. The power supply 9170 is used to provide power to the electronic device 9600. The display 9160 is used for displaying display objects such as images and characters. The display may be, for example, an LCD display, but is not limited thereto.

The memory 9140 can be a solid state memory, e.g., read Only Memory (ROM), random Access Memory (RAM), a SIM card, or the like. There may also be a memory that holds information even when power is off, can be selectively erased, and is provided with more data, an example of which is sometimes called an EPROM or the like. The memory 9140 could also be some other type of device. The memory 9140 includes a buffer memory 9141 (sometimes referred to as a buffer). The memory 9140 may include an application/function storage part 9142, the application/function storage part 9142 being used to store application programs and function programs or a flow for executing the operation of the electronic device 9600 by the central processing unit 9100.

The memory 9140 can also include a data store 9143, the data store 9143 being used to store data, such as contacts, digital data, pictures, sounds, and/or any other data used by an electronic device. The driver storage portion 9144 of the memory 9140 may include various drivers for the electronic device for communication functions and/or for performing other functions of the electronic device (e.g., messaging applications, contact book applications, etc.).

The communication module 9110 is a transmitter/receiver 9110 that transmits and receives signals via an antenna 9111. The communication module (transmitter/receiver) 9110 is coupled to the central processor 9100 to provide input signals and receive output signals, which may be the same as in the case of a conventional mobile communication terminal.

Based on different communication technologies, a plurality of communication modules 9110, such as a cellular network module, a bluetooth module, and/or a wireless lan module, may be disposed in the same electronic device. The communication module (transmitter/receiver) 9110 is also coupled to a speaker 9131 and a microphone 9132 via an audio processor 9130 to provide audio output via the speaker 9131 and receive audio input from the microphone 9132, thereby implementing ordinary telecommunication functions. The audio processor 9130 may include any suitable buffers, decoders, amplifiers and so forth. In addition, the audio processor 9130 is also coupled to the central processor 9100, thereby enabling recording locally through the microphone 9132 and enabling locally stored sounds to be played through the speaker 9131.

An embodiment of the present application further provides a computer-readable storage medium capable of implementing all steps in the upgrade method of the distributed service processing system whose execution subject is the server or the client in the foregoing embodiment, where the computer-readable storage medium stores a computer program thereon, and when the computer program is executed by a processor, the computer program implements all steps of the upgrade method of the distributed service processing system whose execution subject is the server or the client in the foregoing embodiment, for example, when the processor executes the computer program, the processor implements the following steps:

As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, apparatus, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.

The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (devices), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

The principle and the implementation mode of the invention are explained by applying specific embodiments in the invention, and the description of the embodiments is only used for helping to understand the method and the core idea of the invention; meanwhile, for a person skilled in the art, according to the idea of the present invention, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present invention.

Claims

1. The upgrading method of a distributed business processing system is characterized in that the distributed business processing system comprises a database server and a business processing server; the method comprises the following steps:

2. The method for upgrading the distributed service processing system according to claim 1, wherein the determining of the system upgrading mode according to the database operation language of the database server to be upgraded, the database definition language, and the change type of the data table includes:

determining whether a change type of the data table involves an index change, an add field, or a data scrub; if the index change, field increase or data cleaning is involved, the system upgrading mode is shutdown upgrading;

if the index change, field increase or data cleaning is not involved, judging whether the operation involved in the database operation language contains a statement influencing an online service; if the statement influencing the online service is included, the system upgrading mode is shutdown upgrading;

if the statement influencing the online service is not contained, judging whether the operation related in the database definition language conflicts with the online service; if the related operation conflicts with the online service, the system upgrading mode is shutdown upgrading; otherwise, the system upgrading mode is upgrading without stopping.

3. The upgrading method for the distributed service processing system according to claim 1, wherein the system upgrading mode is the shutdown upgrading; the upgrading the database server to be upgraded according to the database upgrading strategy, the database operation language and the database definition language comprises the following steps:

4. The upgrading method for the distributed service processing system according to claim 1, wherein the system upgrading mode is the non-stop upgrading; the upgrading the database server to be upgraded according to the database upgrading strategy, the database operation language and the database definition language comprises the following steps:

5. The upgrading method for the distributed service processing system according to claim 1, wherein the performing rolling upgrade on the service processing server according to the traffic of the service processing server and a preset service busy period includes:

determining whether the current upgrading time belongs to the traffic busy time period; if not, determining the upgrading batch of each business processing server according to the flow of the business processing servers;

6. The upgrade method for a distributed service processing system according to claim 1, further comprising:

7. An upgrade device for a distributed service processing system, comprising:

8. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the steps of the method for upgrading a distributed transaction processing system according to any of claims 1 to 6 when executing the program.

9. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the method for upgrading a distributed service processing system according to any of claims 1 to 6.

10. A computer program product comprising computer programs/instructions, characterized in that the computer programs/instructions, when executed by a processor, implement the steps of the upgrade method of a distributed service processing system of any of claims 1 to 6.