JP4375158B2 - Computer system and transaction recovery method thereof - Google Patents

Description

  The present invention relates to an online transaction processing system in which transaction processing is coordinated between a plurality of information processing devices. When a failure occurs during transaction processing in one information processing device, the information processing device in which the failure occurs in another information processing device A transaction aimed at releasing the exclusion depending on the transaction acquired by the resource manager represented by the RDBMS when adding or updating data within the transaction. The present invention relates to a recovery method and a system.

In an online transaction system in which transaction processing is linked between multiple information processing devices, if a failure occurs during transaction processing on a certain information processing device, the exclusion acquired by the resource manager depending on the transaction during the transaction is not released. Until the transaction is instructed to remove the failure and the exclusion is released, the resource manager used in the transaction cannot be secured in some or all accesses from other information processing devices. Cannot browse, update or add.
Therefore, in the prior art, when the standby system 1 information processing system has the complete standby configuration of the active system 1 information system, the mutual standby system or the configuration of the standby system 1 system as the active system N system (1 to N Configuration) at least one spare information processing device is prepared, and instead of the information processing device in which a failure has occurred during transaction processing, a transaction is performed after referring to the transaction information before the failure in the spare information processing device by system switching. The finalization instruction was issued and the exclusion was cancelled.
However, this requires at least one set of standby information processing system as a spare information processing device. In the case of a complete standby configuration and a 1-to-N configuration, the standby system has spare resources such as CPU and memory in preparation for system switching. It is necessary to perform other processing in the state. In addition, in the mutual standby configuration, it is necessary to secure enough CUP and memory for the information system to operate two sets, and it is necessary to prepare extra resources such as CPU and memory.

Japanese Patent Publication No. 08-016620

However, this requires at least one set of standby information processing system as a spare information processing device. In the case of a complete standby configuration and a 1-to-N configuration, the standby system has spare resources such as CPU and memory in preparation for system switching. It is necessary to perform other processing in the state. In addition, in the mutual standby configuration, it is necessary to secure enough CUP and memory for the information system to operate two sets, and it is necessary to prepare extra resources such as CPU and memory.

  SUMMARY OF THE INVENTION An object of the present invention is to dynamically determine an information processing apparatus that issues a transaction settlement instruction.

  In order to achieve the above object, a transaction that has already been started or dynamically automatically started in an information processing apparatus that is determined to have the lightest load based on load information because the transaction is settled at the time of a transaction failure of the own information processing apparatus The recovery process is used for transaction recovery of another information processing apparatus.

  According to the present invention, it is possible to dynamically issue a transaction settlement instruction.

  Embodiments of the present invention will be described below.

  Hereinafter, the best mode for carrying out the present invention will be described in detail with reference to the drawings.

FIG. 1 shows the configuration of a transaction processing system according to an embodiment of the present invention. In this embodiment, the transaction processing system includes information processing apparatuses 110, 120, and 130, a shared disk 140, and a DBMS 150 connected by a network 160. ing. The information processing apparatuses 110, 120, and 130 are information processing apparatuses that provide the same or individual services, and the network 160 is connected to a large number of clients.

  FIG. 2 shows the main functions of the information processing apparatus, ie, a 111 transaction processing function, a 112 transaction recovery function, and a life / death confirmation function between 113 information processing apparatuses.

3 is an outline of the configuration of the shared disk 140 in FIG. 1, and FIG. 4 is a definition storage area for 114 transaction recovery, and 1411, 1412, and 1413 have definitions necessary for recovery of the information processing apparatuses 110, 120, and 130, respectively. Is shown.
FIG. 5 stores the load levels of the information processing apparatuses 110, 120, and 130. FIG. 6 shows the detailed contents of transaction history information for each information processing apparatus. FIG. 7 shows a processing flow of the information processing apparatuses 110, 120, and 130.

  The information processing apparatuses 110, 120, and 130 first store definitions necessary for transaction recovery in the transaction recovery definition storage area 141 of the shared disk 140 (step 201).

  The information processing apparatuses 110, 120, and 130 periodically store the load information of the information processing apparatus in the load check table 142 of the shared disk 140 during online processing (step 202).

  Here, as shown in FIG. 1, it is assumed that a failure has occurred during execution of a transaction accessing the DBMS 150 in the information processing apparatus 120.

  Then, the information processing apparatus 110 detects a failure in the information processing apparatus 120 (step 203), refers to the load check table 142, compares the data 1421 and 1423 of the apparatus in which no failure has occurred, and information with a small load. A transaction recovery process activation request is issued to the processing device 130 (step 205).

  When the transaction recovery process 131 has been started, the information processing apparatus 130 that has received the transaction recovery process activation request stores the definition 1412 necessary for transaction recovery of the information processing apparatus 120 and the transaction history information 1432 of the information processing apparatus 120. The transaction that is being processed is read and read by the information processing apparatus 120 (step 207). If not started, this is started, the definition 1412 required for transaction recovery of the information processing apparatus 120 and the transaction history information 1432 of the information processing apparatus 120 are read, and the information processing apparatus 120 recovers the transaction being processed. Do.

FIG. 7 shows a configuration of a transaction processing system that is slightly different from the first embodiment of the present invention. In this embodiment, the transaction processing system includes information processing apparatuses 210, 220, and 230, a shared disk 240, and a DBMS 250 connected by a network 260. Has been. The information processing apparatuses 210, 220, and 230 are servers, and the network 260 is connected to many clients.
The difference from the first embodiment is that the transaction history information of the information processing apparatuses 210, 220, and 230 is stored in the local disks 211, 221, and 231 instead of the shared disk. Accordingly, the transaction recovery definition 241 and the load check table 242 are stored in the shared disk 240 as shown in FIG.
The movements of the information processing apparatuses 210, 220, and 230 are almost the same as those of the first embodiment, but the movement of step 207 in FIG. 7 is different. Since the transaction history information necessary for transaction recovery exists in the local disk of each information processing device, the transaction history information on the local disk 221 of the information processing device 220 is viewed from the information processing device 230 that starts the transaction recovery process. I can't. Therefore, each local disk is included in the definition for transaction recovery, NAS (Network-Attached Storage),
Transaction history in the disk 221 can be referred to via the network using a SAN (Storage Area Network) or the like, and the local disk 221 is dynamically referenced from the information processing device 230 when the transaction recovery process 2302 is started or recovered. Use the information to recover the transaction.

  As described above, since no information processing device dedicated to standby is required, if the information processing system situation is a mutual standby configuration and a 1-to-N standby configuration if the configuration is a complete standby configuration, extra resources such as CPU and memory are secured. There is no need to set up a transaction, and it is possible to issue a transaction settlement instruction.

It is a figure which shows schematic structure of the transaction processing system of Embodiment 1. FIG. 1 is a diagram illustrating a configuration within an information processing apparatus 110 according to a first embodiment. 2 is a diagram illustrating a configuration within a shared disk device 140 according to Embodiment 1. FIG. FIG. 3 is a diagram illustrating a schematic configuration of a transaction recovery definition storage area according to the first embodiment. It is a figure which shows schematic structure of the load check table of Embodiment 1. FIG. FIG. 2 is a diagram illustrating a schematic configuration of a transaction history information storage area according to the first embodiment. It is a flowchart which shows the process sequence of the information processing apparatus of this embodiment. It is a figure which shows schematic structure of the transaction processing system of Embodiment 2. FIG. 6 is a diagram illustrating a configuration in an information processing apparatus 230 according to Embodiment 2. FIG. It is a figure which shows the structure in the shared disk 240 of Embodiment 2. FIG. It is a figure which shows schematic structure of the transaction storage definition storage area of Embodiment 2. It is a figure which shows schematic structure of the load check table of Embodiment 1. FIG.

Explanation of symbols

110 Information processing device 120 Information processing device 130 Information processing device 111 Transaction processing function 112 Transaction recovery function 113 Information processing device life / death confirmation function 140 Shared disk 141 Transaction recovery definition storage area 1411 Definition 1412 required for transaction information of information processing 110 Definition 1413 Required for Transaction Information of Information Processing 120 142 Definition Required for Transaction Information of Information Processing 130 Load Check Table 1421 Load Level 1422 of Information Processing 110 Load Level 1423 of Information Processing 120 Load Level 143 of Information Processing 130 Transaction History Information 1431 Transaction history information 1432 of information processing 110 Transaction history information 1433 of information processing 120 Transaction history information 150 DBMS
160 Network 210 Information processing device 211 Transaction history information 220 Information processing device 221 Transaction history information 230 Information processing device 2301 Transaction processing function 2302 Transaction recovery function 2303 Life / death monitoring function 231 between information processing devices Transaction history information 240 Shared disk 2411 Information processing 210 Definition required for transaction information of 2412 Definition required for transaction information of information processing 220 2413 Definition required for transaction information of information processing 230 241 Transaction recovery definition storage area 242 Load check table 2421 Load level 2422 of information processing 210 220 load level 2423 information processing 230 load level 250 DBMS
260 network

Claims (2)

A plurality of information processing devices, each of the information processing devices performs processing based on the received transaction processing request, wherein the information processing device detects a failure of the other information processing device and a plurality of the processing requests In a transaction recovery method in a computer system having resource management means for performing exclusive management of a database accessed based on
When a failure during transaction processing by the first information processing apparatus of the information processing apparatus is generated, dependent on the transaction that was reserved when updating or addition of data in-process during the transaction of the first information processing apparatus The plurality of information processing devices refer to the load information , respectively ,
Of the plurality of information processing apparatuses, a second information processing apparatus that has a lower load than other information processing apparatuses other than the first information processing apparatus in which the failure has occurred performs the transaction settlement, and the second information processing apparatus by executing the transaction recovery process stored performs transaction settlement instruction to the reference to the transaction settlement is the resource managing means necessary historical information of transactions in the-process,
The resource management unit that is instructed to complete the transaction performs a transaction settlement process in the transaction in progress based on the instructed transaction completion instruction, and then releases the exclusion depending on the transaction in progress. And
Further, the computer system has at least a standby configuration of the execution system information processing device with respect to the standby information processing device, a mutual standby configuration, or a configuration of N execution system systems (1 to N configuration) with respect to the standby system. A transaction recovery method characterized by requiring a spare information processing device but not requiring the information processing device dedicated to standby .
A plurality of information processing apparatuses, each of which processes the processing request based on the received transaction processing request, wherein the information processing apparatus detects a failure of another information processing apparatus; In a computer system having resource management means for performing exclusive management of a database accessed by the processing request,
When a failure occurs during transaction processing in the first information processing apparatus among the information processing apparatuses, it depends on the transaction secured when updating or adding data in the transaction in progress of the first information processing apparatus The plurality of information processing devices refer to the load information, respectively,
Of the plurality of information processing apparatuses, a second information processing apparatus that has a lower load than other information processing apparatuses other than the first information processing apparatus in which the failure has occurred performs the transaction settlement, and the second information processing apparatus Executes a stored transaction recovery process, refers to the history information of the transaction in progress, and issues a transaction conclusion instruction to the resource management means that requires a transaction conclusion;
The resource management means instructed to complete the transaction releases the exclusion depending on the transaction,
Further, the computer system has at least a standby configuration of the execution system information processing device with respect to the standby information processing device, a mutual standby configuration, or a configuration of N execution system systems (1 to N configuration) with respect to the standby system. A computer system characterized by requiring a spare information processing device but not requiring the information processing device dedicated to standby .

Images