JP2011159014A - Information processing system, information processing device, communication control program, and communication control method - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide an information processing system which prevents connection information from being inconsistent. <P>SOLUTION: A monitoring part 1c monitors an operational state of a service providing part 1b. A transmission part 1d transmits prescribed control information when the monitoring part 1c detects the completion of the start-up of the service providing part 1b. The service providing part 1b transmits a request for processing to the service providing part 1b via a prescribed resource. A connection information storage part 2a stores connection information which defines resources. When receiving the control information from an information processing device 1, a control part 2c disables a resource included in the connection information stored in the connection information storage part 2a on the basis of the received control information. <P>COPYRIGHT: (C)2011,JPO&INPIT

Description

  The present invention relates to an information processing system, an information processing apparatus, a communication control program, and a communication control method for managing connection information for controlling communication between servers.

  Conventionally, an information processing system for performing data communication between a plurality of information processing apparatuses connected via a network has been used. As this information processing system, for example, there is a business processing system in which an application (AP) server that executes a business application program and a database (DB) server that stores various data are connected.

  In this business processing system, communication between the AP server and the DB server is managed in connection information units called sessions. For example, the AP server receives a session from the DB server in order to communicate with the DB server. The AP server manages the paid-out session as connection information in association with the DB server. On the other hand, the DB server also manages the delivered session in association with the AP server as connection information. The AP server requests processing from the DB server via the established session. The DB server responds to the AP server through the session.

  However, if a session is established every time communication is performed, session requests / payouts frequently occur when communication occurs frequently. For this reason, there is a possibility that communication will be congested in each server or the processing load will increase.

  On the other hand, for example, the AP server may conceivably hold and establish a plurality of sessions to be used with the DB server in advance. In this case, the AP server communicates with the DB server by reusing the assigned session. Such a technique is called a session pool. By using a session pool, it is not necessary to establish a session each time communication occurs. For this reason, the congestion as described above can be suppressed.

  By the way, in the above-described business processing system, there is a case where data communication between servers may be hindered by a failure of a function for managing a session. In the business processing system, it is desirable that such a failure can be appropriately dealt with in the operation.

  Therefore, there is a method of appropriately acquiring communication information between the establishment and release of a session as a unit (see, for example, Patent Document 1). In addition, there is a method for efficiently transmitting an error to a request source apparatus when the database requested by the request source apparatus cannot be accessed via a session (for example, see Patent Document 2).

  Furthermore, it can be considered that the business processing system has a load distribution configuration. For example, a plurality of AP servers and a plurality of DB servers are provided. In this way, for example, the load can be made uniform in the AP layer (a set of AP servers) and the DB layer (a set of DB servers). Further, for example, even if a failure occurs in the service providing function in either the AP server or the DB server, the business process can be continued. That is, the responsiveness and availability of the entire business processing system can be improved.

Japanese Patent No. 2928157 JP 2009-157762 A

  As described above, when the business processing system has a load distribution configuration, a server in which a failure has occurred is excluded from the processing distribution destination. When the service providing function is restored, the distribution of processing to the server is resumed.

  However, in the process request source server (for example, AP server), there may be a case where the management information of the session established before the failure with the recovered server (for example, DB server) remains. On the other hand, the restored server (for example, DB server) performs maintenance (for example, restart) of the service providing function, thereby clearing the session held before the failure.

  In this case, even if session management information remains in the request source server, there is no corresponding session on the restored server side. For this reason, even if the requesting server tries to communicate using the session, there is a problem that communication cannot be performed and an error occurs due to inconsistency of the sessions managed by both servers. In addition, problems such as delays in business processing and inability to perform proper processing have occurred due to this error.

  The present invention has been made in view of these points, and an object thereof is to provide an information processing system, an information processing apparatus, a communication control program, and a communication control method that suppress inconsistencies in connection information.

  In the present invention, an information processing system is provided to solve the above problems. The information processing system includes a first information processing device and a second information processing device. The first information processing apparatus includes a first service providing unit, a monitoring unit, and a transmission unit. The first service providing unit executes processing according to the processing request. The monitoring unit monitors the operating status of the first service providing unit. The transmission unit transmits predetermined control information when the monitoring unit detects completion of activation of the first service providing unit. The second information processing apparatus includes a second service providing unit, a connection information storage unit, and a control unit. The second service providing unit transmits a processing request to the first service providing unit via a predetermined resource. The connection information storage unit stores connection information defining resources. When receiving the control information from the first information processing apparatus, the control unit invalidates the resource included in the connection information stored in the connection information storage unit based on the received control information.

  An information processing apparatus is provided to solve the above problems. This information processing apparatus includes a monitoring unit and a transmission unit. The monitoring unit monitors the operating status of the first service providing unit. When the monitoring unit detects the completion of activation of the first service providing unit, the transmitting unit transmits a processing request to the counterpart device including the second service providing unit, and the second service providing unit transmits the processing request to the first service providing unit. Control information that prompts invalidation of the resource included in the connection information stored in the connection information storage unit that stores the connection information that defines the resource to be used is transmitted.

  An information processing apparatus is provided to solve the above problems. This information processing apparatus includes a connection information storage unit and a control unit. The connection information storage unit stores connection information defining resources used by the first service providing unit to transmit a processing request to the second service providing unit provided in the counterpart device. When the control unit receives the predetermined control information transmitted from the partner device when the completion of the activation of the second service providing unit is detected on the partner device side, the control unit stores the control information in the connection information storage unit based on the received control information The resources included in the connected information are invalidated.

  A communication control program is provided to solve the above problems. A computer that executes the communication control program functions as a monitoring unit and a transmission unit. The monitoring means monitors the operating status of the first service providing means. When the monitoring unit detects the completion of activation of the first service providing unit, the transmission unit sends a processing request to the information processing apparatus including the second service providing unit, and the second service providing unit sends a processing request to the first service providing unit. Control information that prompts invalidation of the resource included in the connection information stored in the connection information storage unit that stores the connection information defining the resource used for transmission is transmitted.

  A communication control program is provided to solve the above problems. The computer that executes this communication control program functions as connection information storage means and control means. The connection information storage means stores connection information defining resources used for transmitting a processing request to the second service providing means provided in the information processing apparatus by the first service providing means. When the control unit receives the predetermined control information transmitted from the information processing device when the completion of the activation of the second service providing unit is detected on the information processing device side, the control unit stores the connection information storage unit based on the received control information. The resource included in the connection information stored in is invalidated.

  In addition, a communication control method for an information processing system is provided to solve the above problems. In this communication control method, when the first information processing apparatus monitors the operation information of the first service providing unit that executes the process according to the processing request and detects the completion of the activation of the first service providing unit, Send control information. Then, when the second information processing apparatus receives control information from the first information processing apparatus, the second service providing unit defines a predetermined resource used for transmitting a processing request to the first service providing unit. The resource included in the connection information stored in the connection information storage unit that stores the connection information is invalidated.

  According to the information processing system, information processing apparatus, communication control program, and communication control method, it is possible to suppress inconsistencies in connection information.

It is a figure showing an information processing system concerning a 1st embodiment. It is a figure which shows the business processing system which concerns on 2nd Embodiment. It is a figure which shows the hardware constitutions of DB server of 2nd Embodiment. It is a figure which shows the function structure of the DB server of 2nd Embodiment. It is a figure which shows the function structure of AP server of 2nd Embodiment. It is a figure which shows the example of a data structure of the cluster version number table which DB server has. It is a figure which shows the example of a data structure of the version number management table which AP server has. It is a figure which shows the example of a data structure of the session management table which AP server has. It is a sequence diagram which shows the DB server switching process of 2nd Embodiment. It is a flowchart which shows the DB service stop version number notification processing of the second embodiment. It is a flowchart which shows the DB service starting version number notification process of 2nd Embodiment. It is a flowchart which shows the session invalidation process of 2nd Embodiment. It is a sequence diagram which shows the business processing of 2nd Embodiment. It is a flowchart which shows DB request transmission processing of 2nd Embodiment. It is a flowchart which shows the session allocation process of 2nd Embodiment. It is a flowchart which shows DB response transmission processing of 2nd Embodiment. It is a flowchart which shows DB response reception processing of 2nd Embodiment. It is a flowchart which shows the session rearrangement process of 2nd Embodiment. It is a 1st sequence diagram which shows the session invalidation process of 2nd Embodiment. It is a 2nd sequence diagram which shows the session invalidation process of 2nd Embodiment. It is a 3rd sequence diagram which shows the session invalidation process of 2nd Embodiment. It is a figure which shows the function structure of DB server of 3rd Embodiment. It is a figure which shows the function structure of AP server of 3rd Embodiment. It is a figure which shows the example of a data structure of the version number management table which DB server has. It is a figure which shows the example of a data structure of the session management table which DB server has. It is a figure which shows the example of a data structure of the server version number table which AP server has. FIG. 20 is a sequence diagram illustrating degeneration start / degeneration release processing of an AP server according to the third embodiment. It is a flowchart which shows the version number notification process at the time of AP service stop of 3rd Embodiment. It is a flowchart which shows AP service starting version number notification processing of 3rd Embodiment. It is a flowchart which shows the session release process of 3rd Embodiment. It is a sequence diagram which shows the business processing of 3rd Embodiment. It is a flowchart which shows DB request transmission processing of 3rd Embodiment. It is a flowchart which shows the session allocation process of 3rd Embodiment. It is a flowchart which shows the session opening process of 3rd Embodiment. It is a flowchart which shows DB response transmission processing of 3rd Embodiment. FIG. 10 is a first sequence diagram illustrating session release processing according to the third embodiment. It is a 2nd sequence diagram which shows the session release process of 3rd Embodiment.

Hereinafter, the present embodiment will be described in detail with reference to the drawings.
[First Embodiment]
FIG. 1 is a diagram illustrating an information processing system according to the first embodiment. In this information processing system, the information processing apparatus 1 and the information processing apparatus 2 are connected via a network.

The information processing apparatus 1 includes a connection information storage unit 1a, a service providing unit 1b, a monitoring unit 1c, and a transmission unit 1d.
The connection information storage unit 1a stores connection information defining resources used by the service providing unit 1b for communication with the service providing unit 2b. The service providing unit 2b can transmit a processing request to the service providing unit 1b via the resource. The resource defined in the connection information is, for example, a session.

  Resources used for communication are agreed in advance between the information processing apparatus 1 and the information processing apparatus 2. For example, the information processing apparatus 1 preallocates resources for accessing the information processing apparatus 1 to the information processing apparatus 2. The information processing apparatus 1 stores and manages the allocated resource as connection information in the connection information storage unit 1a. In the information processing apparatus 2, the allocated resource is stored and managed in the connection information storage unit 2a as connection information. The resource allocation is executed when the information processing apparatus 1 receives an allocation request from the information processing apparatus 2, for example.

  The service providing unit 1 b is an application program that is executed on the information processing apparatus 1. The service providing unit 1b performs data communication with the service providing unit 2b via the resources defined in the connection information stored in the connection information storage unit 1a.

  The service providing unit 1b executes processing according to the processing request received from the service providing unit 2b. The service providing unit 1b returns the execution result to the service providing unit 2b. The service providing unit 1b is a DB application process, for example.

The monitoring unit 1c monitors the operating status of the service providing unit 1b. When detecting the activation completion of the service providing unit 1b, the monitoring unit 1c notifies the transmission unit 1d to that effect.
When the monitoring unit 1c detects completion of activation of the service providing unit 1b, the transmission unit 1d transmits control information that prompts the information processing device 2 to invalidate the connection information stored in the connection information storage unit 2a.

The information processing apparatus 2 includes a connection information storage unit 2a, a service providing unit 2b, and a control unit 2c.
The connection information storage unit 2a stores connection information defining resources used by the service providing unit 2b for communication with the service providing unit 1b.

  The service providing unit 2 b is an application program that is executed on the information processing apparatus 2. The service providing unit 2b performs data communication with the service providing unit 1b via resources defined in the connection information stored in the connection information storage unit 2a. The service providing unit 2b requests processing from the service providing unit 1b and receives a response from the service providing unit 1b. The service providing unit 2b executes business processing, for example, based on the response from the service providing unit 1b. The service providing unit 2b further transmits a processing request to, for example, the service providing unit 1b based on the execution result of the business process. Alternatively, the service providing unit 2b further transmits the execution result of the business process to a client device (not shown), for example. The service providing unit 2b is a business application process, for example.

When receiving the control information transmitted by the transmission unit 1d, the control unit 2c invalidates the connection information stored in the connection information storage unit 2a.
According to such an information processing apparatus 1, the monitoring unit 1c monitors the operating status of the service providing unit 1b. When the monitoring unit 1c detects completion of activation of the service providing unit 1b by the transmission unit 1d, control information that prompts invalidation of the connection information stored in the connection information storage unit 2a is transmitted to the information processing device 2.

  Thereby, when the service provision part 1b starts, the connection information (namely, the resource contained in connection information) remaining in the connection information storage part 2a can be invalidated. Therefore, the service providing unit 2b does not attempt communication with the service providing unit 1b using the connection information. That is, inconsistency of connection information can be suppressed. As a result, the occurrence of errors due to inconsistencies can be suppressed.

  Note that after invalidating the remaining connection information, the information processing apparatus 2 can also discard the resources included in the connection information. The timing for discarding can be changed according to the progress of the processing of the business application. For example, there may be a case where a resource that has been invalidated is locked by a transaction of a business application being executed. In this case, for example, the resource can be discarded after the corresponding transaction is completed. This ensures that the resource can be discarded.

  In the above description, the DB application process is exemplified as the service providing unit 1b. The business application process is exemplified as the service providing unit 2b. On the other hand, the service providing unit 1b may be a business application process and the service providing unit 2b may be a DB application process. In this case, the information processing apparatus 1 receives resource allocation from the information processing apparatus 2. That is, when the service providing unit 1b is activated in the information processing apparatus 1, the control unit 2c invalidates the connection information assigned to the information processing apparatus 1 by the information processing apparatus 2 based on the control information received from the transmission unit 1d. Thereafter, the information processing apparatus 2 can release the resources included in the invalid connection information. As a result, the information processing apparatus 2 can reuse resources that are no longer used.

In the following embodiments, a more specific information processing system having a plurality of AP servers and a plurality of DB servers will be described as an example.
[Second Embodiment]
Hereinafter, a second embodiment will be described in detail with reference to the drawings.

  FIG. 2 is a diagram illustrating a business processing system according to the second embodiment. This business processing system includes DB clusters 10, 20, and 30, a load balancer 40, terminal devices 61, 62, 63,... And AP servers 400, 500, and 600. The DB clusters 10, 20, 30, the terminal devices 61, 62, 63,... And the AP servers 400, 500, 600 are connected via the load balancer 40 and the networks 50, 60. The networks 50 and 60 are, for example, an intranet or another dedicated communication network provided for this business processing system. Below, the case where the networks 50 and 60 are networks which communicate by TCP / IP (Transmission Control Protocol / Internet Protocol) is illustrated.

  The DB clusters 10, 20, and 30 are for clustering DB servers to achieve high data access reliability. The DB cluster 10 includes a storage device 11 and DB servers 100 and 100a. The DB cluster 20 includes a storage device 21 and DB servers 200 and 200a. The DB cluster 30 includes a storage device 31 and DB servers 300 and 300a.

  The storage device 11 is a shared storage of the DB servers 100 and 100a. The storage device 11 stores various business data used for the business processing system. The storage device 11 is connected to the DB servers 100 and 100a by a predetermined interface (for example, fiber channel).

  The DB servers 100 and 100 a manage business data stored in the storage device 11. The DB servers 100 and 100a realize a fault tolerant by duplication. Specifically, it has a redundant configuration by clustering. Therefore, the DB servers 100 and 100a are connected by a heart beat network. For example, when the DB server 100 is the active system and the DB server 100a is the standby system, the DB server 100a can detect a service down of the DB server 100 because it cannot receive the heartbeat packet from the DB server 100. Then, the DB server 100a starts providing the DB service instead of the DB server 100.

  A single virtual IP address (referred to as a DB virtual address) that binds the DB servers 100 and 100a is assigned to the DB cluster 10. The DB servers 100 and 100a share DB virtual addresses in association with individual real IP addresses. The DB servers 100 and 100a control the life and death of the DB virtual address in the own server so that the processing request from the external device for the DB virtual address reaches the active server. That is, the DB virtual address becomes active in the active server. In the standby server, the DB virtual address becomes inactive.

The DB clusters 20 and 30 can also be realized by the same configuration as the DB cluster 10.
The load balancer 40 distributes the processing requests received from the terminal devices 61, 62, 63 to the AP servers 400, 500, 600.

  Examples of the load distribution method of the load distribution apparatus 40 include round robin, minimum connection, and minimum response time. Round robin is a method of assigning processing to each server in order. The minimum connection is a method of allocating processing to a server having the smallest number of TCP connections or UDP (User Datagram Protocol) flows among the servers. The minimum response time is a method of measuring the response time of each server and assigning a process to a server with a short response time.

  The load balancer 40 manages the IP addresses of the AP servers 400, 500, and 600 in association with a single virtual address. The terminal devices 61, 62, 63, ... transmit processing requests to virtual addresses on the load balancer 40. Then, the load balancer 40 distributes the process to any of the AP servers 400, 500, and 600. Note that the load balancer 40 excludes servers that are determined to be unusable as a result of the alive monitoring of the AP servers 400, 500, and 600 from the processing distribution destination.

  The terminal devices 61, 62, 63,... Are computers handled by users who use the business processing system. The terminal devices 61, 62, 63,... Provide a GUI (Graphical User Interface) to the user so that a business processing request can be input to the business processing system. The user can cause the business processing system to execute a desired process by performing an operation input on the terminal devices 61, 62, 63,... According to the GUI.

  The AP servers 400, 500, and 600 execute business processing in response to business processing requests received from the terminal devices 61, 62, 63,. The AP servers 400, 500, 600 also function as Web servers that transmit information for generating a user GUI to the terminal devices 61, 62, 63,.

  Further, the AP servers 400, 500, and 600 transmit processing requests to any of the DB clusters 10, 20, and 30 as required for business processing. Specifically, the AP servers 400, 500, and 600 sequentially distribute processing requests to the DB clusters 10, 20, and 30 by round robin. The AP servers 400, 500, and 600 manage whether the DB clusters 10, 20, and 30 are currently in operation. The AP servers 400, 500, and 600 exclude DB clusters that are not in operation from the processing request transmission destination.

  FIG. 3 is a diagram illustrating a hardware configuration of the DB server according to the second embodiment. The DB server 100 includes a CPU (Central Processing Unit) 101, a ROM (Read Only Memory) 102, a RAM (Random Access Memory) 103, a disk array interface 104, a graphic processing device 105, an input interface 106, a recording medium reading device 107, and a communication. It has an interface 108.

The CPU 101 controls the entire DB server 100.
The ROM 102 stores a BIOS (Basic Input / Output System) program on the DB server 100.

  The RAM 103 temporarily stores at least part of an OS (Operating System) program and application software (hereinafter referred to as an application) program to be executed by the CPU 101. The RAM 103 stores various data necessary for processing by the CPU 101.

  The disk array interface 104 is connected to the storage apparatus 11. The disk array interface 104 communicates with a RAID (Redundant Array of Independent Disks) controller built in the storage apparatus 11 and inputs / outputs data to / from the storage apparatus 11. The RAID controller in the storage device 11 has any of RAID 0 to 6 functions, for example, and manages a plurality of HDDs (Hard Disk Drives) as a redundant storage device. The storage device 11 stores data handled by the AP servers 400, 500, and 600.

  The storage device 11 stores an OS program, an application program, and data. The OS program, application program, and data may be stored in another storage device provided separately from the storage device 11, for example.

The storage device 11 may use another type of storage device such as an SSD (Solid State Drive) instead of the HDD (or in combination with the HDD).
The graphic processing device 105 is connected to the monitor 12. The graphic processing device 105 displays an image on the screen of the monitor 12 in accordance with a command from the CPU 101.

  The input interface 106 is connected to the keyboard 13 and the mouse 14. The input interface 106 transmits a signal sent from the keyboard 13 or the mouse 14 to the CPU 101.

  The recording medium reading device 107 is a reading device that reads data stored in the recording medium 15. For example, a function that the DB server 100 should have can be realized by causing a computer to execute a program describing the processing content of the function. Such a program can be recorded on a computer-readable recording medium 15 and distributed. Further, the program may be stored from the recording medium 15 in a program distribution server device (not shown) connected to the network 50. In this case, the DB server 100 can download the program from the program distribution server device via the network 50.

  As the recording medium 15, for example, a magnetic recording device, an optical disk, a magneto-optical recording medium, and a semiconductor memory can be used. Magnetic recording devices include HDDs, flexible disks (FD), magnetic tapes, and the like. Optical disks include CD (Compact Disc), CD-R (Recordable) / RW (ReWritable), DVD (Digital Versatile Disc), DVD-R / RW / RAM, and the like. Magneto-optical recording media include MO (Magneto-Optical disk). Semiconductor memory includes flash memory such as USB (Universal Serial Bus) memory.

The communication interface 108 is connected to the network 50. The communication interface 108 performs data communication with other information processing apparatuses via the network 50.
The DB servers 100 a, 200, 200 a, 300, 300 a, the AP servers 400, 500, 600, and the terminal devices 61, 62, 63, etc. can also be realized by the same hardware configuration as the DB server 100. However, the AP servers 400, 500, 600 and the terminal devices 61, 62, 63,... Can incorporate storage devices such as HDDs and SSDs in place of the storage device 11 and the disk array interface 104.

  FIG. 4 is a diagram illustrating a functional configuration of the DB server according to the second embodiment. The DB server 100 includes a version number storage unit 110, a DB processing unit 120, a cluster control unit 130, a service monitoring unit 140, a version number transmission unit 150, and an AP communication unit 160. These functions are realized by the CPU 101 executing a predetermined program. All or at least a part of these functions may be realized using dedicated hardware.

The version number storage unit 110 stores the version number of the DB cluster 10 (hereinafter referred to as cluster version number). Details of the cluster version will be described later.
The DB processing unit 120 executes a processing request for the DB. For example, the DB processing unit 120 reads and updates data stored in the storage device 11. The DB processing unit 120 outputs a response to the processing request to the AP communication unit 160.

  The cluster control unit 130 transmits a heartbeat packet to the DB server 100a while the DB processing unit 120 is operating. As a result, the cluster control unit 130 notifies the DB server 100a that the server itself is operating as an active system. Further, the cluster control unit 130 controls activation / deactivation of each function of the version number storage unit 110, the DB processing unit 120, the service monitoring unit 140, the version number transmission unit 150, and the AP communication unit 160. That is, when the DB server 100a operates as a standby system, the cluster control unit 130 activates each of these functions in order to operate the own server as an active system.

  The service monitoring unit 140 monitors the start / stop of the DB processing unit 120. The service monitoring unit 140 updates the cluster version number stored in the version number storage unit 110 when the DB processing unit 120 is activated or stopped.

  When the cluster version number stored in the version number storage unit 110 is updated by the service monitoring unit 140, the version number transmission unit 150 transmits the cluster version number to the AP servers 400, 500, and 600.

  The AP communication unit 160 communicates with the AP servers 400, 500, and 600. The AP communication unit 160 receives processing requests from the AP servers 400, 500, and 600 and outputs them to the DB processing unit 120. In addition, the AP communication unit 160 transmits the response acquired from the DB processing unit 120 to the AP servers 400, 500, and 600 that are the transmission source of the processing request.

  The DB server 100a includes a version number storage unit 110a, a DB processing unit 120a, a cluster control unit 130a, a service monitoring unit 140a, a version number transmission unit 150a, and an AP communication unit 160a. These functions are realized by the CPU provided in the DB server 100a executing a predetermined program. All or at least a part of these functions may be realized using dedicated hardware.

  Here, the version number storage unit 110 a corresponds to the version number storage unit 110. The DB processing unit 120a corresponds to the DB processing unit 120. The cluster control unit 130 a corresponds to the cluster control unit 130. The service monitoring unit 140a corresponds to the service monitoring unit 140. The version number transmission unit 150 a corresponds to the version number transmission unit 150. The AP communication unit 160a corresponds to the AP communication unit 160.

  Activation / deactivation of each function of the version number storage unit 110a, DB processing unit 120a, service monitoring unit 140a, version number transmission unit 150a, and AP communication unit 160a is controlled by the cluster control unit 130a.

  Note that the cluster control unit 130a maintains the stopped state of these functions when the DB server 100 is operating as an active system. On the other hand, when the DB server 100 becomes unusable, each of these functions is activated to operate the own server as an active system.

That is, each function of the DB server 100a is a redundant function for enabling each function of the DB server 100 to be replaced.
The DB clusters 20 and 30 can also be realized by the same functional configuration as the DB cluster 10.

  FIG. 5 is a diagram illustrating a functional configuration of the AP server according to the second embodiment. The AP server 400 includes a session information storage unit 410, an AP processing unit 420, a client communication unit 430, a session control unit 440, a version number receiving unit 450, and a DB communication unit 460. These functions are realized by the CPU provided in the AP server 400 executing a predetermined program. All or at least a part of these functions may be realized using dedicated hardware.

  The session information storage unit 410 stores the cluster version numbers of the DB clusters 10, 20, and 30. In addition, the session information storage unit 410 stores session information that defines sessions assigned from the DB clusters 10, 20, and 30.

  The AP processing unit 420 executes the business process request acquired from the terminal devices 61, 62, 63,. The AP processing unit 420 generates processing requests (for example, queries written in SQL) for the DB clusters 10, 20, and 30 according to the contents of the business processing. The AP processing unit 420 outputs the generated processing request to the DB communication unit 460.

  In addition, the AP processing unit 420 receives a response from the DB clusters 10, 20, and 30 in response to the processing request from the DB communication unit 460. Based on the response, the AP processing unit 420 regenerates the processing request and outputs it to the DB communication unit 460. Alternatively, when the AP processing unit 420 completes processing for the business processing request from the terminal devices 61, 62, 63,..., The AP processing unit 420 generates a business response and outputs the business response to the client communication unit 430.

  The client communication unit 430 communicates with the terminal devices 61, 62, 63,. The client communication unit 430 outputs the business process request received from the terminal devices 61, 62, 63,... To the AP processing unit 420. In addition, the client communication unit 430 transmits the business response acquired from the AP processing unit 420 to the terminal devices 61, 62, 63,.

  The session control unit 440 manages the cluster version number and session information of the DB clusters 10, 20, and 30 stored in the session information storage unit 410. The session control unit 440 receives a session to be used for data communication with the DB clusters 10, 20, and 30 in advance, and stores the allocated session in the session information storage unit 410 as session information.

  The session control unit 440 controls session invalidation based on the cluster version numbers of the DB clusters 10, 20, and 30. The session control unit 440 refers to the session information stored in the session information storage unit 410 and outputs to the DB communication unit 460 the DB cluster to which the processing request is to be transmitted and the session that can be used for communication with the DB cluster. To do.

  The version number receiving unit 450 receives the cluster version number of each cluster from the DB clusters 10, 20, and 30. The version number receiving unit 450 outputs the received cluster version number to the session control unit 440.

  The DB communication unit 460 communicates with the DB clusters 10, 20, and 30 using the specified session for the DB cluster specified by the session control unit 440. When the DB communication unit 460 acquires a processing request from the AP processing unit 420, the DB communication unit 460 transmits the acquired processing request to the DB clusters 10, 20, and 30. When the DB communication unit 460 receives a response from the DB clusters 10, 20, and 30, the DB communication unit 460 outputs the response to the AP processing unit 420.

The AP servers 500 and 600 can also be realized by the same functional configuration as the AP server 400.
FIG. 6 is a diagram illustrating an example of the data structure of the cluster version number table included in the DB server. The cluster version number table 111 is updated by the service monitoring unit 140 and stored in the version number storage unit 110. In the cluster version number table 111, the cluster version number of the DB cluster 10 is set.

  For example, information “1257051200” is set in the cluster version number table 111. This is the number of seconds since midnight, January 1, 1970. When updating the cluster version number table 111, the service monitoring unit 140 can acquire such time information as a cluster version number from the OS, for example.

  The cluster version number is set to a predetermined initial value (for example, “−1”) at the time immediately after starting the DB service. Then, at a predetermined timing after completion of activation, the service monitoring unit 140 sets the current time information as the cluster version number.

  FIG. 7 is a diagram illustrating a data structure example of the version number management table of the AP server. The version number management table 411 is updated by the session control unit 440 and stored in the session information storage unit 410. The version number management table 411 includes an item indicating the cluster name, an item indicating the cluster version number, and an item indicating the operation status. Information arranged in the horizontal direction of each item is associated with each other to indicate information related to one DB cluster.

  In the item indicating the cluster name, information indicating the cluster name is set. In the item indicating the cluster version number, information indicating the cluster version number is set. In the item indicating the operation state, information indicating whether the operation is in progress is set.

  In the version number management table 411, for example, information that the cluster name is “DB0001”, the cluster version number is “1257043210”, and the operation state is “in operation” is set. This indicates that the cluster version number of the DB cluster 10 indicated by the cluster name “DB0001” is “1257043210”. Further, since the DB cluster 10 is currently “in operation”, it indicates that it can be a transmission target of a processing request.

Hereinafter, the cluster name of the DB cluster 20 is “DB0002” and the cluster name of the DB cluster 30 is “DB0003”.
FIG. 8 is a diagram illustrating a data structure example of a session management table included in the AP server. The session management tables 412, 413, and 414 are updated by the session control unit 440 and stored in the session information storage unit 410. The session management table 412 corresponds to the DB cluster 10. The session management table 413 corresponds to the DB cluster 20. The session management table 414 corresponds to the DB cluster 30. Although only the session management table 412 will be described below, the session management tables 413 and 414 have the same configuration.

  The session management table 412 includes an item indicating an entry ID, an item indicating request source identification information, an item indicating a version number at the time of session acquisition, an item indicating a session number, and an item indicating an invalid flag. Information arranged in the horizontal direction of each item is associated with each other to indicate information related to one session.

  In the item indicating the entry ID, an entry ID for identifying one record included in the session management table 412 is set. In the item indicating the request source identification information, the identification information of the terminal device that is the transmission source of the business process request is set. In the item indicating the version number at the time of session acquisition, the cluster version number when the session corresponding to the corresponding record is established is set. In the item indicating the session number, a session number for identifying a session allocated from the DB cluster 10 is set. In the item indicating the invalid flag, information indicating whether or not the corresponding session is invalid is set.

  In the session management table 412, for example, the entry ID is “1”, the requester identification information is “CL0005”, the session acquisition version number is “12570445340”, the session number is “4”, and the invalid flag is “−” (no setting) ) Is set. This indicates that the business process request received from the terminal device identified by “CL0005” is communicating with the DB cluster 10 using the session identified by the session number “4” on the DB cluster 10. ing. Further, it is indicated that the cluster version number of the DB cluster 10 when this session is acquired is “12570445340”. The invalid flag is “-”, indicating that the session is valid.

  In the session management table 412, for example, information indicating that the entry ID is “11”, the request source information is “CL0003”, the session acquisition version number is “1257038229”, the session number is “11”, and the invalid flag is “invalid”. Is set. Here, the invalid flag is set to “invalid” in this record. This indicates that the session corresponding to this record cannot be used. That is, the DB cluster 10 indicates that a session with the session number “11” does not already exist as a session for communicating with the AP server 400.

  Here, an upper limit (for example, 50) of the number of sessions that the DB cluster 10 can pool with the AP server 400 is preset in the session management table 412. Hereinafter, this upper limit value is referred to as a pool upper limit value. The session control unit 440 monitors whether or not the pool upper limit value of the number of sessions issued from the DB cluster 10 at a predetermined timing is exceeded. If the number of the sessions exceeds the limit, the pooled sessions are sorted (for example, an unnecessary session discard request is transmitted to the DB cluster 10). In this way, it is possible to prevent the number of sessions that the DB cluster 10 pays out to the AP server 400 from becoming excessive compared to other AP servers.

  Next, a processing procedure of a business processing system having the above configuration will be described. Here, the processing procedure will be described below focusing on the DB cluster 10 and the AP server 400. However, the process between the DB cluster 10 and the AP servers 500 and 600 is the same. The processing between the DB clusters 20 and 30 and the AP servers 400, 500, and 600 is the same.

  FIG. 9 is a sequence diagram illustrating DB server switching processing according to the second embodiment. In the following, the process illustrated in FIG. 9 will be described in order of step number. Note that immediately before step S1, in the DB cluster 10, it is assumed that the DB server 100 is the active system and the DB server 100a is the standby system.

  [Step S1] The DB server 100 receives an instruction to stop the DB service (DB processing unit 120). As a case where this stop instruction is accepted, for example, a case where the system administrator performs an operation input for instructing a service stop for maintenance to the DB server 100 can be considered.

[Step S2] The DB server 100 starts to stop the DB processing unit 120.
[Step S3] When the DB processing unit 120 is stopped, the DB server 100 updates the cluster version number stored in the version number storage unit 110. The DB server 100 transmits the updated cluster version number and cluster stop start notification to the AP servers 400, 500, and 600.

  [Step S4] The AP server 400 receives the cluster version number and the cluster stop start notification from the DB server 100. The AP server 400 executes a session invalidation process to which the AP server 400 has been allocated from the DB cluster 10 based on the received cluster version number.

  [Step S5] Upon receiving the cluster stop start notification, the AP server 400 changes the operation state of the DB cluster 10 (cluster name “DB0001”) in the version number management table 411 stored in the session information storage unit 410. Set to “Not in operation”.

[Step S6] The DB server 100 completes stopping the DB processing unit 120.
[Step S7] The DB server 100a detects that no heartbeat packet has been received from the DB server 100. Then, the DB server 100a starts activation of the DB service (DB processing unit 120a).

[Step S8] The DB server 100a completes activation of the DB processing unit 120a.
[Step S9] The DB server 100a updates the cluster version number stored in the version number storage unit 110a when the activation of the DB processing unit 120a is completed. The DB server 100a transmits the updated cluster version number and cluster activation completion notification to the AP servers 400, 500, and 600.

  [Step S10] The AP server 400 receives the cluster version number from the DB server 100a. The AP server 400 executes a session invalidation process to which the AP server 400 has been allocated from the DB cluster 10 based on the received cluster version number.

  [Step S11] Upon receiving the cluster activation completion notification, the AP server 400 changes the operation status of the DB cluster 10 (cluster name “DB0001”) in the version number management table 411 stored in the session information storage unit 410. Set to “Active”.

  In this way, the DB server 100 transmits the cluster version number to the AP server 400 when the DB processing unit 120 is stopped. Further, the DB server 100a transmits the cluster version number to the AP server 400 when the DB processing unit 120a is started.

  When the AP server 400 receives the cluster version number from the DB cluster 10 (that is, one of the DB servers 100 and 100a), the AP server 400 compares the cluster version number of the DB cluster 10 managed by its own device, and according to the comparison result. A session already established with the DB cluster 10 is invalidated.

Next, the DB service stop version number notification process of the DB cluster 10 shown in step S3 of FIG. 9 will be described in detail.
FIG. 10 is a flowchart illustrating DB service stop version number notification processing according to the second embodiment. In the following, the process illustrated in FIG. 10 will be described in order of step number.

[Step S <b> 21] The cluster control unit 130 starts the stop process of the DB processing unit 120. The service monitoring unit 140 detects the stop start of the DB processing unit 120.
[Step S22] The service monitoring unit 140 acquires the current time stamp as the cluster version number from the OS.

[Step S23] The service monitoring unit 140 updates the cluster version number of the cluster version number table 111 stored in the version number storage unit 110 to the newly acquired cluster version number.
[Step S24] The version number transmission unit 150 refers to the cluster version number table 111 to acquire the cluster version number and transmits it to the AP servers 400, 500, and 600. In addition, the version number transmission unit 150 transmits a cluster stop start notification of the DB cluster 10 to the AP servers 400, 500, and 600 together with the cluster version number.

  In this way, the DB server 100 updates the cluster version number when stopping the DB processing unit 120. Then, the DB server 100 transmits the updated cluster version number to the AP servers 400, 500, and 600.

Next, the DB service startup version number notification process of the DB cluster 10 shown in step S9 of FIG. 9 will be described in detail.
FIG. 11 is a flowchart illustrating DB service activation version number notification processing according to the second embodiment. In the following, the process illustrated in FIG. 11 will be described in order of step number.

[Step S31] The service monitoring unit 140a detects completion of activation of the DB processing unit 120a.
[Step S32] The service monitoring unit 140a obtains the current time stamp as the cluster version number from the OS.

[Step S33] The service monitoring unit 140a updates the cluster version number in the cluster version table stored in the version number storage unit 110a to the newly acquired cluster version number.
[Step S34] The version number transmission unit 150a refers to the cluster version number table stored in the version number storage unit 110a, acquires the cluster version number, and transmits it to the AP servers 400, 500, and 600. Also, the version number transmission unit 150a transmits a cluster activation completion notification of the DB cluster 10 to the AP servers 400, 500, and 600 together with the cluster version number.

  In this way, the DB server 100a updates the cluster version number when starting the DB service. Then, the DB server 100a transmits the updated cluster version number to the AP servers 400, 500, and 600.

Next, the session invalidation process of the AP server 400 shown in steps S4 and S10 in FIG. 9 will be described in detail.
FIG. 12 is a flowchart illustrating session invalidation processing according to the second embodiment. In the following, the process illustrated in FIG. 12 will be described in order of step number.

[Step S41] The version number receiving unit 450 receives the cluster version number from the DB cluster 10. The version number receiving unit 450 outputs the received cluster version number to the session control unit 440.
[Step S42] The session control unit 440 refers to the session management table 412 stored in the session information storage unit 410 and acquires a record defining a session corresponding to the DB cluster 10.

  [Step S43] The session control unit 440 determines whether or not there is a record in which the cluster version number received in Step S41 and the session acquisition version number are different from the acquired records. If it exists, the process proceeds to step S44. If not, the process proceeds to step S45.

[Step S44] The session control unit 440 sets “invalid” to an invalid flag of a record whose version number at the time of session acquisition is different from the newly received cluster version number.
[Step S45] The session control unit 440 sets the cluster version number received in step S41 as the cluster version number of the DB cluster 10 of the version number management table 411 stored in the session information storage unit 410.

In this way, the session control unit 440 invalidates the corresponding session when the cluster version number received from the DB cluster 10 is different from the session acquisition version number.
Next, a procedure for business processing executed in the business processing system will be described.

  FIG. 13 is a sequence diagram illustrating business processing according to the second embodiment. In the following, the process illustrated in FIG. 13 will be described in order of step number. It is assumed that immediately before step S51, in the DB cluster 10, the DB server 100 is the active system and the DB server 100a is the standby system.

[Step S51] The AP server 400 receives a business process request (hereinafter referred to as an AP request) from the terminal device 61.
[Step S52] The AP server 400 executes a business process corresponding to the acquired AP request. The AP server 400 generates a processing request (hereinafter referred to as a DB request) when processing that should be requested to the DB cluster occurs according to the business processing. The AP server 400 selects a DB cluster to which the generated DB request is to be transmitted. For example, the AP server 400 sequentially selects DB clusters to which a DB request should be transmitted by round robin. Here, it is assumed that the AP server 400 selects the DB cluster 10. Then, a DB request is transmitted to the DB cluster 10.

  [Step S53] The DB server 100 receives a DB request from the AP server 400. The DB server 100 executes DB processing based on the received DB request. The DB server 100 generates a DB response based on the result of the DB processing, and transmits it to the AP server 400 together with the cluster version number. Here, when the session designated by the AP server 400 is invalid, the DB server 100 returns a session invalidation notification as a DB response together with the cluster version number.

  [Step S54] The AP server 400 receives the DB response. The AP server 400 determines whether or not the DB response is a normal response. If not a normal response, the process proceeds to step S55. If it is a normal response, the process proceeds to step S56.

  [Step S55] The AP server 400 executes a session invalidation process. The session invalidation process is the same as the process described with reference to FIG. Then, the process proceeds to step S52.

[Step S56] The AP server 400 executes DB response reception processing.
[Step S57] The AP server 400 further executes a business process according to the DB response as necessary to generate an AP response to the terminal device 61. Then, the AP server 400 transmits the generated AP response to the terminal device 61.

[Step S58] The AP server 400 detects that a series of communications with the terminal device 61 has been completed.
[Step S59] The AP server 400 executes a process for organizing a session (between the AP server 400 and the DB cluster 10) that has been managed to execute the business process requested from the terminal device 61. .

In this way, communication associated with the business process is performed between the AP server 400 and the DB cluster 10.
Next, the DB request transmission process of the AP server 400 shown in step S52 of FIG. 13 will be described.

FIG. 14 is a flowchart illustrating DB request transmission processing according to the second embodiment. In the following, the process illustrated in FIG. 14 will be described in order of step number.
[Step S61] The AP processing unit 420 generates a DB request describing the processing content to be requested of the DB cluster, in accordance with the execution of the business process corresponding to the AP request. The AP processing unit 420 outputs the generated DB request to the DB communication unit 460.

[Step S62] The session control unit 440 refers to the session management table 412 stored in the session information storage unit 410.
[Step S63] The session control unit 440 determines whether or not there is a DB cluster whose operation state is “in operation”. If there is a DB cluster in operation, the process proceeds to step S64. When there is no “in operation” DB cluster, the processing is completed. When there is no “in operation” DB cluster, the AP processing unit 420 then responds an error to the terminal device 61 via the client communication unit 430 and completes the business process.

  [Step S64] The session control unit 440 selects a DB cluster that is “in operation”. The session control unit 440 selects the “in operation” DB cluster set in the version number management table 411 by round robin. For example, if the DB cluster 30 (cluster name “DB0003”) is selected in the previous cluster selection process in this step, the DB cluster 10 (cluster name “DB0001”) is selected this time. For example, if the DB cluster 10 was selected last time, the DB cluster 20 (cluster name “DB0002”) is selected this time.

  [Step S65] The session control unit 440 executes session allocation processing for the selected DB cluster. That is, the DB communication unit 460 allocates a session for transmitting a DB request to the corresponding DB cluster. At this time, for example, if there is no available session acquired in advance from the corresponding DB cluster, the corresponding DB cluster is requested to open a session. If a new session is paid out from the DB cluster, the session can be assigned to DB request transmission. In addition, a session cannot be assigned unless the session is paid out.

  [Step S66] The session control unit 440 determines whether or not a session for transmitting a DB request has been allocated. If it can be allocated, the process proceeds to step S67. If it cannot be assigned, the process proceeds to step S63.

  [Step S67] The DB communication unit 460 includes the session number (designated session number) assigned by the session control unit 440 in the DB request. Then, the DB communication unit 460 transmits a DB request to the DB cluster selected by the session control unit 440.

In this way, when transmitting a DB request, the AP server 400 selects a DB cluster to be transmitted and allocates a session used for communication with the DB cluster.
Next, the session allocation process of the AP server 400 shown in step S65 of FIG. 14 will be described in detail.

  FIG. 15 is a flowchart illustrating session allocation processing according to the second embodiment. In the following, the process illustrated in FIG. 15 will be described in order of step number. Note that the DB cluster 10 is selected in step S64 of FIG.

[Step S71] The session control unit 440 refers to the session management table 412 stored in the session information storage unit 410.
[Step S <b> 72] The session control unit 440 determines whether there is an unassigned session that is not assigned to any terminal device among the sessions entered in the session management table 412. If an unallocated session exists, the process proceeds to step S73. If there is no unassigned session, the process proceeds to step S76.

  [Step S73] The session control unit 440 determines whether there is a valid (that is, not invalid) session among unassigned sessions. If it exists, the process proceeds to step S78. If not, the process proceeds to step S74.

  [Step S <b> 74] The session control unit 440 generates an invalid session discard request that instructs the DB cluster 10 to discard the invalid session set in the session management table 412, and outputs the invalid session discard request to the DB communication unit 460. The DB communication unit 460 transmits an invalid session discard request to the DB cluster 10.

  [Step S75] The DB communication unit 460 receives from the DB cluster 10 an invalid session discard response indicating that the session specified in step S74 has been discarded. The DB communication unit 460 outputs a discard response to the session control unit 440.

  [Step S76] The session control unit 440 generates a session establishment request for requesting the DB cluster 10 to establish a new session, and outputs the session establishment request to the DB communication unit 460. The DB communication unit 460 transmits the generated session opening request to the DB cluster 10.

  [Step S77] The DB communication unit 460 receives new session information indicating a session newly allocated from the DB cluster 10 and the cluster version number of the DB cluster 10. The DB communication unit 460 outputs the received new session information and the cluster version number to the session control unit 440. The session control unit 440 sets new session information (for example, session number) in the session management table 412. In addition, the session control unit 440 sets the cluster version number received together with the new session as the session acquisition version number corresponding to the new session. The new session set in the session management table 412 is an unassigned session. Also, the new session becomes a valid session.

  [Step S78] The session control unit 440 refers to the session management table 412, and uses the identification information (request source identification information) of the transmission source terminal device of the AP request that is the generation source of the DB request as a valid and unallocated session. Set to. At this time, for example, among the valid and unallocated sessions included in the session management table 412, the one with the smallest entry ID is preferentially selected, and the request source identification information is set. As a result, a session is assigned for this DB request.

As described above, if there is a valid unallocated session, the AP server 400 allocates the session to a new business process data communication.
If there is an invalid unallocated session, the AP server 400 instructs the DB cluster 10 to discard the session, and then requests the DB cluster 10 to issue a new session. Then, the AP server 400 allocates the session newly acquired from the DB cluster 10 to a new data communication for business processing.

  If there is no unallocated session, the AP server 400 requests the DB cluster 10 to issue a new session. Then, the AP server 400 allocates the session newly acquired from the DB cluster 10 to a new data communication for business processing.

The AP server 400 continues to use the session assigned this time for a series of processes received from the terminal device specified by the request source identification information.
Further, it may be considered that new session information cannot be acquired from the DB cluster 10 in step S77. As the factors, for example, a session cannot be paid out due to a shortage of resources such as memory on the DB cluster 10, or a failure has occurred in the communication path. In this case, the session control unit 440 completes the session assignment process without assigning a session for transmitting the DB request. Then, another attempt is made to assign a process to another DB cluster by the processes in steps S63 to S66 in FIG.

Next, the DB response transmission process of the DB server 100 shown in step S53 of FIG. 13 will be described in detail.
FIG. 16 is a flowchart illustrating DB response transmission processing according to the second embodiment. In the following, the process illustrated in FIG. 16 will be described in order of step number.

[Step S81] The AP communication unit 160 receives a DB request from the AP server 400. The AP communication unit 160 outputs the received DB request to the DB processing unit 120.
[Step S82] The DB processing unit 120 determines whether the designated session included in the DB request is appropriate. If so, the process proceeds to step S83. If not, the process proceeds to step S87. Note that the DB processing unit 120 can determine whether or not the designated session is appropriate by checking the session number of the designated session with the session number of the session pooled for the AP server 400, for example. That is, when the session number of the designated session of the AP server 400 and the session pooled for the AP server 400 in the DB server 100 match, it is determined to be appropriate. If they do not match, it is determined that they are not appropriate. The pooled session information is stored in a predetermined storage unit in association with the identification information of the AP server, for example.

[Step S83] The DB processing unit 120 executes DB processing according to the DB request.
[Step S84] The DB processing unit 120 refers to the version number storage unit 110 to obtain a cluster version number.

[Step S85] The DB processing unit 120 generates a DB response including the cluster version number based on the execution result of the DB processing.
[Step S86] The DB processing unit 120 outputs the generated DB response to the AP communication unit 160. The AP communication unit 160 transmits the acquired DB response to the AP server 400. Since this DB response is a response when the DB processing is normally performed, it is a normal response.

  [Step S87] The DB processing unit 120 refers to the version number storage unit 110 to obtain a cluster version number. Here, when the cluster version number stored in the version number storage unit 110 indicates a predetermined initial value (for example, “−1”), the service monitoring unit 140 sets the new cluster version number to the version number storage unit. Set to 110. In this case, the DB processing unit 120 acquires the cluster version number set by the service monitoring unit 140.

  [Step S88] The DB processing unit 120 generates a session invalidation notification indicating that the designated session is not appropriate. The DB processing unit 120 includes the cluster version number in the session invalidation notification.

  [Step S89] The DB processing unit 120 outputs a session invalidation notification to the AP communication unit 160. The AP communication unit 160 transmits a session invalidation notification and a cluster version number to the AP server 400. Since this response is a response when the DB processing is not normally performed, it is not a normal response. In this case, the AP server 400 does not determine a normal response in step S54 of FIG.

In this way, the DB server 100 transmits the cluster version number together with the response to the AP server 400.
In steps S85 to S89, the cluster version number is generated and transmitted in various responses, but these may be transmitted separately to the AP server 400. For example, when the AP communication unit 160 transmits various responses to the AP server 400, the version number transmission unit 150 may transmit the cluster version number to the AP server 400.

Next, the DB response reception process of the AP server 400 shown in step S56 of FIG. 13 will be described in detail.
FIG. 17 is a flowchart illustrating DB response reception processing according to the second embodiment. In the following, the process illustrated in FIG. 17 will be described in order of step number.

  [Step S91] The AP processing unit 420 acquires a DB response that is determined to be a normal response by the DB communication unit 460. The AP processing unit 420 executes AP processing according to the DB response. The AP processing unit 420 transmits an AP response to the terminal device 61 based on the execution result of the AP processing.

[Step S <b> 92] The session control unit 440 acquires the cluster version number received by the DB communication unit 460.
[Step S93] The session control unit 440 refers to the session management table of the DB response transmission source cluster. Here, the session management table 412 stored in the session information storage unit 410 is referred to.

  [Step S94] The session control unit 440 determines whether there is a record having a different cluster version number from the received version number. If it exists, the process proceeds to step S95. If not, the process proceeds to Step S96.

  [Step S95] The session control unit 440 sets “invalid” in the invalid flag for a record in the session management table 412 in which the session acquisition version number is different from the current cluster version number.

  [Step S96] The session control unit 440 sets the received cluster version number to the cluster version number corresponding to the DB cluster 10 (cluster name “DB0001”) in the version number management table 411 stored in the session information storage unit 410. .

  In this way, if there is a session in which a session acquisition version number different from the cluster version number received from the DB cluster 10 exists among the sessions included in the session management table 412, the AP server 400 selects the session. “Invalid”.

Next, the session organization process of the AP server 400 shown in step S59 of FIG. 13 will be described in detail.
FIG. 18 is a flowchart illustrating session organizing processing according to the second embodiment. In the following, the process illustrated in FIG. 18 will be described in order of step number.

[Step S101] The session control unit 440 identifies a session assigned to the terminal device 61.
[Step S102] The session control unit 440 refers to the session management table 412 stored in the session information storage unit 410 and determines whether or not the session is valid. If it is valid, the process proceeds to step S103. If invalid, the process proceeds to step S105.

  [Step S103] The session control unit 440 determines whether or not the total number of sessions set in the session management table 412 exceeds the pool upper limit value. If not, the process proceeds to step S104. If so, the process proceeds to step S105.

  [Step S104] The session control unit 440 unassigns the session specified in step S101. That is, the request source identification information of the terminal device 61 is deleted from the corresponding record.

  [Step S <b> 105] The session control unit 440 generates an invalid session discard request that instructs the DB cluster 10 to discard the invalid session set in the session management table 412, and outputs the invalid session discard request to the DB communication unit 460. The DB communication unit 460 transmits an invalid session discard request to the DB cluster 10.

  [Step S106] The DB communication unit 460 receives from the DB cluster 10 an invalid session discard response indicating that the session instructed in Step S105 has been discarded. The DB communication unit 460 outputs a discard response to the session control unit 440.

[Step S107] The session control unit 440 deletes the invalid session record included in the session management table 412.
In this way, the AP server 400 can reuse a session on the DB cluster 10 used for business processing after transmitting an AP response to the terminal devices 61, 62, 63,. And

  Further, after invalidating the session, the AP server 400 discards the invalid session after completing a series of communications with the terminal devices 61, 62, 63,. Thereby, the following effects can be obtained.

  For example, there may occur a case where the business process transaction is continued in a state where the communication between the AP server 400 and the DB cluster 10 is completed. In this case, if the corresponding session is locked by a transaction, an error may occur even if the session is discarded, and the session may not be appropriately discarded.

  On the other hand, as described above, the AP server 400 transmits the AP response to the terminal devices 61, 62, 63,... (That is, the business processing transaction is completed and the AP server 400 is completed. And the terminal devices 61, 62, 63,... (After a series of communications are completed), the invalid session is discarded, so that the session can be reliably discarded.

  Next, a specific example of the processing flow in the business processing system will be described. In the following example, only processing between the DB cluster 10 and the AP server 400 will be described, but between the DB cluster 10 and the AP servers 500 and 600 and between the DB clusters 20 and 30 and the AP servers 400, 500, and 600. The same applies to the processing of.

Immediately before the step in each of the following drawings, it is assumed that the DB server 100 is in the active state and the DB server 100a is in the standby state for the DB cluster 10.
FIG. 19 is a first sequence diagram illustrating session invalidation processing according to the second embodiment. In the following, the process illustrated in FIG. 19 will be described in order of step number.

[Step ST1] The DB server 100 starts stopping the DB service.
[Step ST2] The DB server 100 updates the cluster version number. The DB server 100 transmits a cluster stop start notification and a cluster version number to the AP server 400. The AP server 400 receives the cluster stop start notification and the cluster version number from the DB server 100.

  [Step ST3] The AP server 400 executes a session invalidation process. The AP server 400 sets the DB cluster 10 to “not in operation”. As a result, the DB cluster 10 is excluded from the DB processing distribution target.

[Step ST4] The DB server 100a detects that the reception of the heartbeat packet from the DB server 100 has ceased.
[Step ST5] The DB server 100a starts activation of the DB service.

  [Step ST6] The DB server 100a completes activation of the DB service. The DB server 100a becomes the active system. The bearer of the virtual DB address is switched to the DB server 100a. That is, data communication with the external device via the virtual DB address is performed by the DB server 100a.

  [Step ST7] The DB server 100a updates the cluster version number. The DB server 100a transmits a cluster activation completion notification and a cluster version number to the AP server 400. The AP server 400 receives the cluster activation completion notification and the cluster version number from the DB server 100a.

  [Step ST8] The AP server 400 executes a session invalidation process. The AP server 400 sets the DB cluster 10 to “in operation”. As a result, the DB cluster 10 becomes a target for distribution of DB processing.

  [Step ST9] Upon receiving an AP request from the terminal device 61, the AP server 400 selects the DB cluster 10 as a DB processing distribution destination. Then, the AP server 400 transmits a session establishment request to the DB cluster 10 for DB request transmission.

As described above, the DB cluster 10 transmits a notification indicating the stage of each process to the AP servers 400, 500, and 600 when the cluster switching is started and when the cluster switching is completed.
As a result, the AP servers 400, 500, and 600 can properly detect the start and completion of cluster switching in the DB cluster 10. Since the AP servers 400, 500, and 600 do not distribute processing to the DB cluster 10 between steps ST2 and ST8, transmission of useless DB requests to the DB cluster 10 during cluster switching can be suppressed.

  Further, the DB cluster 10 transmits the cluster version number at the start of cluster switching and at the completion of cluster switching. When the AP server 400, 500, 600 receives the updated cluster version number, it invalidates the session allocated from the DB cluster 10. Therefore, when the DB cluster 10 becomes available, the AP servers 400, 500, and 600 do not have a session that can be used when communication with the DB cluster 10 is started. Accordingly, when performing data communication with the DB cluster 10, the AP servers 400, 500, and 600 first request the DB cluster 10 to open a new session.

  As a result, a DB request specifying a session that is not pooled by the DB server 100a immediately after cluster switching is not transmitted from the AP server 400, 500, 600 to the DB server 100a. Therefore, it is possible to suppress the occurrence of errors due to session mismatch between the AP server side and the DB server side.

  Further, the DB servers 100 and 100a included in the DB cluster 10 manage the state of the DB cluster 10 using a consistent version number. Therefore, the AP server 400 only needs to be able to identify the reception source by the DB virtual address in cluster units, and does not need to be aware of the subordinate DB server. Therefore, it is possible to easily manage a session established with a server existing under the virtual address.

  Further, the DB cluster 10 updates and transmits the cluster version number at the start and completion of cluster switching. For this reason, even if the cluster version does not reach the AP server due to the failure of the DB server 100 at the start of cluster switching, the AP server side is notified by the notification of the cluster version when the cluster switching is completed. Ensures that the session is invalidated. Next, such a case is illustrated.

FIG. 20 is a second sequence diagram illustrating session invalidation processing according to the second embodiment. In the following, the process illustrated in FIG. 20 will be described in order of step number.
[Step ST11] The DB server 100 cannot use the DB service due to a failure.

[Step ST12] The DB server 100a detects that the reception of the heartbeat packet from the DB server 100 has ceased.
[Step ST13] The DB server 100a starts starting the DB service.

  [Step ST14] The DB server 100a completes the activation of the DB service. The DB server 100a becomes the active system. The bearer of the virtual DB address is switched to the DB server 100a. That is, data communication with the external device via the virtual DB address is performed by the DB server 100a.

  [Step ST15] The DB server 100a updates the cluster version number. The DB server 100a transmits a cluster version number and a cluster activation completion notification to the AP server 400. The AP server 400 receives the cluster version number and the cluster activation completion notification from the DB server 100a.

  [Step ST16] The AP server 400 executes a session invalidation process. The AP server 400 sets the DB cluster 10 to “in operation”. As a result, the DB cluster 10 becomes a target for distribution of DB processing.

  [Step ST17] Upon receiving the AP request from the terminal device 61, the AP server 400 selects the DB cluster 10 as a DB processing distribution destination. Then, the AP server 400 transmits a session establishment request to the DB cluster 10 for DB request transmission.

  As described above, even when the DB cluster 10 cannot transmit the cluster version number to the AP server 400, 500, 600 at the start of the cluster switching due to the failure of the DB server 100, the session is surely performed to the AP server 400, 500, 600. It is possible to prompt invalidation processing.

  Next, a case where a DB request is received from the AP server 400 before the DB cluster 10 transmits a cluster activation completion notification to the AP servers 400, 500, 600 after the cluster switching is completed will be exemplified.

FIG. 21 is a third sequence diagram illustrating session invalidation processing according to the second embodiment. In the following, the process illustrated in FIG. 21 will be described in order of step number.
[Step ST21] The DB server 100 cannot use the DB service due to a failure.

[Step ST22] The DB server 100a detects that the reception of the heartbeat packet from the DB server 100 has ceased.
[Step ST23] The DB server 100a starts starting the DB service.

  [Step ST24] The DB server 100a completes activation of the DB service. The DB server 100a becomes the active system. The bearer of the virtual DB address is switched to the DB server 100a. That is, data communication with the external device via the virtual DB address is performed by the DB server 100a.

  [Step ST25] The AP server 400 designates a session paid out from the DB server 100 before the cluster switching, and transmits a DB request to the DB cluster 10. The DB server 100a receives a DB request from the AP server 400.

  [Step ST26] The DB server 100a sets a new cluster version number because the cluster version number is an initial value. The DB server 100a transmits a session invalid notice and the cluster version number to the AP server 400. The AP server 400 receives a session invalidation notification and a cluster version number from the DB server 100a.

[Step ST27] The AP server 400 executes a session invalidation process.
[Step ST28] Upon receiving the AP request from the terminal device 61, the AP server 400 selects the DB cluster 10 as a DB processing distribution destination. Then, the AP server 400 transmits a session establishment request to the DB cluster 10 for DB request transmission.

  As described above, when the cluster stop start notification is not transmitted to the AP servers 400, 500, and 600 due to a failure or the like, a DB request specifying a session that is not pooled by the DB server 100a immediately after the cluster switching is transmitted to the DB server 100a. It can also be considered.

  In response to this, the DB server 100a responds to such a DB request with a session invalidation notification and a cluster version number. For this reason, the AP server 400 can detect that the session pooled with the DB cluster 10 is invalid.

  In the above example, the DB server 100a performs a session invalidation notification and a cluster version number response to the DB request in step ST26. As a result, in the AP server 400, the session invalidation process is performed by the session invalidation notification, and therefore the DB service activation version number notification process is not performed thereafter. However, the DB server 100a may execute DB service activation version number notification processing. In this case, since the cluster version number is updated, the AP server 400 performs the session invalidation process again separately from the session invalidation process in step ST27.

As described above, according to the business processing system of the present embodiment, it is possible to suppress the occurrence of an error due to session mismatch between the AP server side and the DB server side.
For example, even when an error occurs due to cluster switching in a backbone system having a cluster configuration, terminal errors are not displayed on the client device side (terminal devices 61, 62, 63,...). As a result, it is possible to solve problems such as old session errors displayed on a large number of client apparatuses, interruption of work, and disruption of the site.

[Third Embodiment]
The third embodiment will be described below. Differences from the second embodiment will be mainly described, and description of similar matters will be omitted.

  Here, in the second embodiment, the cluster version number on the DB cluster side is managed on the AP server side. In the third embodiment, the version number (server version number) on the AP server side is further managed on the DB cluster side. Below, the function implement | achieved by it is demonstrated.

  The configuration of the business processing system according to the third embodiment is the same as the configuration of the business processing system according to the second embodiment shown in FIG. Furthermore, the hardware configuration of each device of the business processing system according to the third embodiment is the same as the hardware configuration of the DB server 100 according to the second embodiment shown in FIG. .

In the following description, each device of the third embodiment will be described using the same reference numerals as those assigned to the devices of the second embodiment.
FIG. 22 is a diagram illustrating a functional configuration of the DB server according to the third embodiment. The DB server 100 includes a version number storage unit 110, a DB processing unit 120, a cluster control unit 130, a service monitoring unit 140, an AP communication unit 160, a session information storage unit 170, a session control unit 180, and a version number transmission / reception unit 190. These functions are realized by the CPU 101 executing a predetermined program. All or at least a part of these functions may be realized using dedicated hardware.

  Here, the version number storage unit 110, the DB processing unit 120, the cluster control unit 130, the service monitoring unit 140, and the AP communication unit 160 are the same as the components described using the same reference numerals in FIG. Omitted.

  However, the cluster control unit 130 activates each function of the version number storage unit 110, the DB processing unit 120, the service monitoring unit 140, the AP communication unit 160, the session information storage unit 170, the session control unit 180, and the version number transmission / reception unit 190. -Control stop. That is, when the DB server 100a operates as a standby system, the cluster control unit 130 activates each of these functions in order to operate the own server as an active system.

  Session information storage unit 170 corresponds to session information storage unit 410 of AP server 400. The session information storage unit 170 stores the server version numbers of the AP servers 400, 500, and 600. Details of the server version will be described later. The session information storage unit 410 stores session information that defines sessions assigned to the AP servers 400, 500, and 600.

The session control unit 180 manages the server version number and session information of the AP servers 400, 500, and 600 stored in the session information storage unit 170.
When the service monitoring unit 140 updates the cluster version number stored in the version number storage unit 110, the version number transmission / reception unit 190 transmits the cluster version number to the AP servers 400, 500, and 600. The version number transmission / reception unit 190 receives the server version number of each server from the AP servers 400, 500, and 600. The version number transmission / reception unit 190 outputs the received server version number to the session control unit 180.

  The DB server 100a includes a version number storage unit 110a, a DB processing unit 120a, a cluster control unit 130a, a service monitoring unit 140a, an AP communication unit 160a, a session information storage unit 170a, a session control unit 180a, and a version number transmission / reception unit 190a. These functions are realized by the CPU provided in the DB server 100a executing a predetermined program. All or at least a part of these functions may be realized using dedicated hardware.

  Here, the version number storage unit 110a, the DB processing unit 120a, the cluster control unit 130a, the service monitoring unit 140a, and the AP communication unit 160a are the same as those described using the same reference numerals in FIG. Omitted.

  However, when the DB server 100 is operating as an active system, the cluster control unit 130a maintains the stopped state of these functions. On the other hand, when the DB server 100 becomes unusable, each of these functions is activated to operate the own server as an active system.

  The session information storage unit 170a corresponds to the session information storage unit 170. The session control unit 180a corresponds to the session control unit 180. The version number transmission / reception unit 190 a corresponds to the version number transmission / reception unit 190.

The DB clusters 20 and 30 can also be realized by the same functional configuration as the DB cluster 10.
FIG. 23 is a diagram illustrating a functional configuration of the AP server according to the third embodiment. The AP server 400 includes a session information storage unit 410, an AP processing unit 420, a client communication unit 430, a session control unit 440, a DB communication unit 460, a version number storage unit 470, a service monitoring unit 480, and a version number transmission / reception unit 490. These functions are realized by the CPU provided in the AP server 400 executing a predetermined program. All or at least a part of these functions may be realized using dedicated hardware.

  Here, the session information storage unit 410, the AP processing unit 420, the client communication unit 430, the session control unit 440, and the DB communication unit 460 are the same as those described using the same reference numerals in FIG. Omitted.

The version number storage unit 470 stores the server version number of the AP server 400.
The service monitoring unit 480 monitors activation / deactivation of the AP processing unit 420. The service monitoring unit 480 updates the server version number stored in the version number storage unit 470 when the AP processing unit 420 is activated or stopped.

  When the server version number stored in the version number storage unit 470 is updated by the service monitoring unit 480, the version number transmission / reception unit 490 transmits the server version number to the DB clusters 10, 20, and 30. The version number transmission / reception unit 490 receives the cluster version number of each cluster from the DB clusters 10, 20, and 30. The version number transmission / reception unit 490 outputs the received cluster version number to the session control unit 440.

The AP servers 500 and 600 can also be realized by the same functional configuration as the AP server 400.
FIG. 24 is a diagram illustrating a data structure example of a version number management table included in the DB server. The version number management table 171 is updated by the session control unit 180 and stored in the session information storage unit 170. The version number management table 171 includes an item indicating the AP server name, an item indicating the server version number, and an item indicating the operation status. Information arranged in the horizontal direction of each item is associated with each other to indicate information related to one AP server.

  Information indicating the server name of the AP server is set in the item indicating the AP server name. In the item indicating the server version number, information indicating the server version number of the AP server is set. In the item indicating the operation state, information indicating whether the operation is in progress is set.

  In the version number management table 171, for example, information that the AP server name is “AP0001”, the server version number is “1257041552”, and the operation state is “in operation” is set. This indicates that the server version number of the AP server 400 indicated by the cluster name “AP0001” is “1257041552”. Further, the AP server 400 indicates that it is currently “in operation”.

Hereinafter, the AP server name of the AP server 500 is “AP0002”, and the AP server name of the AP server 600 is “AP0003”.
FIG. 25 is a diagram illustrating a data structure example of a session management table included in the DB server. The session management tables 172, 173, and 174 are updated by the session control unit 180 and stored in the session information storage unit 170. The session management table 172 is for managing a session assigned to the AP server 400. The session management table 173 is for managing a session assigned to the AP server 500. The session management table 174 is for managing a session assigned to the AP server 600. Hereinafter, only the session management table 172 will be described, but the session management tables 173 and 174 have the same configuration.

  The session management table 172 includes an item indicating an entry ID, an item indicating a session allocation version number, an item indicating a session number, and an item indicating request destination identification information. Information arranged in the horizontal direction of each item is associated with each other to indicate information related to one session.

  In the item indicating the entry ID, an entry ID for identifying one record included in the session management table 172 is set. In the item indicating the version number at session allocation, the server version number when the session is allocated is set. In the item indicating the session number, a session number for identifying a session assigned to the AP server 400 is set. Information for identifying a thread for executing a processing request is set in the item indicating request destination identification information.

  In the session management table 172, for example, the entry ID is “1”, the session allocation version number is “12570415552”, the session number is “4”, and the request destination identification information is “thread 5” is set. This indicates that for the processing request specifying the session number “4” received from the AP server 400, the server version of the AP server 400 when the session is allocated is “1257041552”. Further, it is indicated that the thread that performs processing for the processing request is the thread of the request destination identification information “thread 5”.

  FIG. 26 is a diagram illustrating a data structure example of a server version number table included in the AP server. The server version number table 471 is updated by the service monitoring unit 480 and stored in the version number storage unit 470. The server version number of the AP server 400 is set in the server version number table 471.

  In the server version number table 471, for example, information “1257044381” is set. Similar to the cluster version number table 111 described with reference to FIG. 6, this is the number of seconds from January 1, 1970, 00:00:00. When the service monitoring unit 480 updates the server version number table 471, for example, such time information can be acquired as the server version number from the OS.

  The server version number is set to a predetermined initial value (for example, “−1”) at the time immediately after the AP service is started. Then, at a predetermined timing after the start is completed, the service monitoring unit 480 sets the current time information as the server version number.

  Next, a processing procedure of a business processing system having the above configuration will be described. Here, the processing procedure will be described below focusing on the DB cluster 10 and the AP server 400. However, the process between the DB cluster 10 and the AP servers 500 and 600 is the same. The processing between the DB clusters 20 and 30 and the AP servers 400, 500, and 600 is the same.

  First, the AP servers 400, 500, and 600 are degenerated. The degenerate operation means that the AP service is stopped at any part of the AP servers 400, 500, 600 and the business processing system is operated. In the following description, a case where the AP server 400 stops and starts the AP service is illustrated. In the DB cluster 10, the DB server 100 is the active system, and the DB server 100a is the standby system.

FIG. 27 is a sequence diagram illustrating degeneration start / degeneration release processing of the AP server according to the third embodiment. In the following, the process illustrated in FIG. 27 will be described in order of step number.
[Step S111] The AP server 400 receives an instruction to stop the AP service (AP processing unit 420). As a case where the stop instruction of the AP processing unit 420 is received, for example, a case where the system administrator performs an operation input for instructing stop of the service for maintenance to the AP server 400 can be considered. Further, there may be a case where the AP server 400 is planned to be stopped in order to perform a degenerate operation during a period when the system is not used, such as at night or on holidays.

[Step S112] The AP server 400 starts stopping the AP processing unit 420.
[Step S113] When the AP processing unit 420 is stopped, the AP server 400 updates the server version number stored in the version number storage unit 470. The AP server 400 transmits the updated server version number and AP service stop start notification to the DB clusters 10, 20, and 30.

  [Step S114] The DB server 100 receives the server version number from the AP server 400. The AP server 400 executes a session release process that the DB server 100 has assigned to the AP server 400 based on the received server version number. In addition, the DB server 100 receives the AP service stop start notification, so that the operation status of the AP server 400 (AP server name “AP0001”) in the version number management table 171 stored in the session information storage unit 170 is displayed. Set to “Not in operation”.

[Step S115] The AP server 400 completes stopping the AP processing unit 420.
[Step S116] The AP server 400 starts the AP processing unit 420 in response to a start instruction accompanying the completion of maintenance or a start instruction for recovery from a planned stop.

[Step S117] The AP server 400 completes the activation of the AP processing unit 420.
[Step S118] When the activation of the AP processing unit 420 is completed, the AP server 400 updates the server version number stored in the version number storage unit 470. The AP server 400 transmits the updated server version number and AP service start completion notification to the DB clusters 10, 20, and 30.

  [Step S119] The DB server 100 receives the server version number from the AP server 400. The DB server 100 executes a session release process that the DB server 100 has assigned to the AP server 400 based on the received server version number. Further, the DB server 100 sets the operation state of the AP server to “in operation” in the version number management table 171 stored in the session information storage unit 170 by receiving the AP service start completion notification.

  [Step S120] The DB server 100 transmits the cluster version number to the newly activated AP server 400. This is to notify the AP server 400 that the DB cluster 10 is currently available.

In this way, the AP server 400 transmits the server version number to the DB cluster 10 when the AP service is stopped and started.
Next, the DB service stop version number notification process of the DB cluster 10 shown in step S113 of FIG. 27 will be described in detail.

FIG. 28 is a flowchart illustrating AP service stop version number notification processing according to the third embodiment. In the following, the process illustrated in FIG. 28 will be described in order of step number.
[Step S <b> 121] The service monitoring unit 480 detects the stop of the AP processing unit 420.

[Step S122] The service monitoring unit 480 obtains the current time stamp as the server version number from the OS.
[Step S123] The service monitoring unit 480 updates the server version number of the server version number table 471 stored in the version number storage unit 470 to the server version number acquired in step S122.

  [Step S124] The version number transmission / reception unit 490 refers to the server version number table 471, acquires the server version number, and transmits it to the DB clusters 10, 20, and 30. Further, the version number transmission / reception unit 490 transmits an AP service stop start notification of the AP server 400 to the DB clusters 10, 20, and 30 together with the server version number.

  In this way, the AP server 400 updates the server version number when stopping the AP processing unit 420. Then, the AP server 400 transmits the updated server version number to the DB clusters 10, 20, and 30.

Next, the AP service activation version number notification process of the AP server 400 shown in step S118 of FIG. 27 will be described in detail.
FIG. 29 is a flowchart illustrating AP service activation version number notification processing according to the third embodiment. In the following, the process illustrated in FIG. 29 will be described in order of step number.

[Step S131] The service monitoring unit 480 detects completion of activation of the AP processing unit 420.
[Step S132] The service monitoring unit 480 acquires the current time stamp as the server version number from the OS.

[Step S133] The service monitoring unit 480 updates the server version number in the server version table 471 stored in the version number storage unit 470 to the version number acquired in step S132.
[Step S134] The version number transmission / reception unit 490 refers to the server version number table 471 to acquire the server version number and transmits it to the DB clusters 10, 20, and 30. In addition, the version number transmission / reception unit 490 transmits an AP service activation completion notification of the AP server 400 to the DB clusters 10, 20, and 30 together with the server version number.

  In this way, the AP server 400 updates the server version number when starting the AP service. Then, the AP server 400 transmits the updated server version number to the DB clusters 10, 20, and 30.

Next, the session release process of the DB server 100 shown in steps S114 and S119 of FIG. 27 will be described in detail.
FIG. 30 is a flowchart illustrating session release processing according to the third embodiment. In the following, the process illustrated in FIG. 30 will be described in order of step number.

  [Step S <b> 141] The version number transmission / reception unit 190 receives the server version number from the AP server 400. The version number transmission / reception unit 190 outputs the received server version number to the session control unit 180.

  [Step S142] The session control unit 180 refers to the session management table 172 stored in the session information storage unit 170, and identifies a record that defines a session assigned to the AP server 400.

  [Step S143] The session control unit 180 determines whether or not there is a record in which the server version received in Step S141 and the session allocation version number are different among the identified records. If it exists, the process proceeds to step S144. If not, complete the process.

  [Step S144] The session control unit 180 acquires request destination identification information corresponding to a record whose version number at the time of session acquisition is different from the newly received server version number. Then, the session control unit 180 issues a stop signal to the thread specified by the request destination identification information.

  [Step S145] The session control unit 180 releases a session indicated by a record having a session acquisition version number different from the newly received server version number. That is, the corresponding session is in an empty state not assigned to any AP server and thread, and can be reused.

  [Step S146] The session control unit 180 sets the server version number received in step S141 as the server version number of the AP server 400 in the version number management table 171 stored in the session information storage unit 170.

In this manner, the session control unit 180 releases the corresponding session when the server version number received from the AP server 400 is different from the session allocation version number.
Next, a procedure for business processing executed in the business processing system will be described.

FIG. 31 is a sequence diagram illustrating business processing according to the third embodiment. In the following, the process illustrated in FIG. 31 will be described in order of step number.
[Step S151] The AP server 400 receives a business process request (hereinafter referred to as an AP request) from the terminal device 61.

  [Step S152] The AP server 400 executes a business process according to the acquired AP request. The AP server 400 generates a processing request (hereinafter referred to as a DB request) when processing that should be requested to the DB cluster occurs according to the business processing. The AP server 400 selects a DB cluster to which the generated DB request is to be transmitted. The selection method is the same as the method described in the second embodiment (for example, round robin). Here, it is assumed that the AP server 400 selects the DB cluster 10. Then, a DB request is transmitted to the DB cluster 10. At this time, the AP server 400 includes the server version number of the AP server 400 in the DB request.

  [Step S153] The DB server 100 receives a DB request from the AP server 400. The DB server 100 determines whether the session currently allocated to the AP server 400 is valid based on the server version number included in the received DB request. If it is valid, the DB server 100 executes DB processing based on the received DB request. The DB server 100 generates a DB response based on the result of the DB processing, and transmits it to the AP server 400 together with the cluster version number.

  [Step S154] The AP server 400 receives the DB response. The AP server 400 determines whether or not the DB response is a normal response. If not a normal response, the process proceeds to step S155. If it is a normal response, the process proceeds to step S156.

  [Step S155] The AP server 400 executes a session invalidation process. The session invalidation process is the same as the process shown in FIG. Then, the process proceeds to step S152.

  [Step S156] The AP server 400 executes DB response reception processing. The DB response reception process is the same as the procedure of the DB response reception process of the second embodiment shown in FIG.

  [Step S157] The AP server 400 further executes a business process according to the DB response as necessary to generate an AP response to the terminal device 61. Then, the AP server 400 transmits the generated AP response to the terminal device 61.

[Step S158] The AP server 400 detects that a series of communication with the terminal device 61 has been completed.
[Step S159] The AP server 400 executes a process for organizing a session (between the AP server 400 and the DB cluster) managed for communication with the terminal device 61. The session organization process is the same as the session organization process of the second embodiment shown in FIG.

In this way, communication associated with the business process is performed between the AP server 400 and the DB cluster 10.
Next, the DB request transmission process of the AP server 400 shown in step S152 of FIG. 31 will be described.

FIG. 32 is a flowchart illustrating DB request transmission processing according to the third embodiment. In the following, the process illustrated in FIG. 32 will be described in order of step number.
[Step S161] The AP processing unit 420 generates a DB request describing the processing content to be requested of the DB cluster in accordance with the execution of the business process corresponding to the AP request. The AP processing unit 420 refers to the server version number table 471 stored in the version number storage unit 470 and acquires the server version number. The AP processing unit 420 includes the acquired server version number in the DB request. The AP processing unit 420 outputs the generated DB request to the DB communication unit 460.

[Step S162] The session control unit 440 refers to the version number management table 411 stored in the session information storage unit 410.
[Step S163] The session control unit 440 determines whether or not there is a DB cluster whose operation status is “in operation”. If there is an “in operation” DB cluster, the process proceeds to step S164. When there is no “in operation” DB cluster, the processing is completed. When there is no “in operation” DB cluster, the AP processing unit 420 then responds an error to the terminal device 61 via the client communication unit 430 and completes the business process.

  [Step S164] The session control unit 440 selects a DB cluster that is “in operation”. The selection method is the same as the method described in the second embodiment (for example, round robin).

  [Step S165] The session control unit 440 executes session allocation processing for the selected DB cluster. That is, the DB communication unit 460 allocates a session for transmitting a DB request to the corresponding DB cluster. At this time, for example, if there is no available session acquired in advance from the corresponding DB cluster, the corresponding DB cluster is requested to open a session. If a new session is paid out from the DB cluster, the session can be assigned to DB request transmission. In addition, a session cannot be assigned unless the session is paid out.

  [Step S166] The session control unit 440 determines whether or not a session for transmitting a DB request has been allocated. If it can be assigned, the process proceeds to step S167. If it cannot be assigned, the process proceeds to step S163.

  [Step S167] The DB communication unit 460 includes the session number (designated session number) assigned by the session control unit 440 in the DB request. Then, the DB communication unit 460 transmits a DB request to the DB cluster selected by the session control unit 440.

  In this way, when transmitting a DB request, the AP server 400 selects a DB cluster to be transmitted and allocates a session used for communication with the DB cluster. At this time, the AP server 400 includes the server version number in the DB request.

  The AP server 400 may transmit the DB request and the server version number separately. For example, when the DB communication unit 460 transmits a DB request to the DB cluster 10, the version number transmission / reception unit 490 may transmit the server version number to the DB cluster 10.

Next, the session allocation process of the AP server 400 shown in step S165 of FIG. 32 will be described in detail.
FIG. 33 is a flowchart illustrating session allocation processing according to the third embodiment. In the following, the process illustrated in FIG. 33 will be described in order of step number.

[Step S171] The session control unit 440 refers to the session management table 412 stored in the session information storage unit 410.
[Step S172] The session control unit 440 determines whether there is an unassigned session that is not assigned to any terminal device among the sessions entered in the session management table 412. If an unallocated session exists, the process proceeds to step S173. If there is no unassigned session, the process proceeds to step S176.

  [Step S173] The session control unit 440 determines whether there is a valid (that is, not invalid) session among unallocated sessions. If it exists, the process proceeds to step S179. If not, the process proceeds to step S174.

  [Step S174] The session control unit 440 generates an invalid session discard request that instructs the DB cluster 10 to discard the invalid session set in the session management table 412 and outputs the invalid session discard request to the DB communication unit 460. The DB communication unit 460 transmits an invalid session discard request to the DB cluster 10.

  [Step S175] The DB communication unit 460 receives from the DB cluster 10 an invalid session discard response indicating that the session designated in step S174 has been discarded. The DB communication unit 460 outputs a discard response to the session control unit 440.

  [Step S176] The session control unit 440 generates a session opening request for requesting the DB cluster 10 to open a new session. The session control unit 440 acquires the server version number with reference to the server version number table 471 stored in the version number storage unit 470, and includes the acquired server version number in the session opening request. The session control unit 440 outputs the acquired session establishment request to the DB communication unit 460. The DB communication unit 460 transmits the generated session opening request to the DB cluster 10.

  [Step S177] Upon receiving a session establishment request from the AP server 400, the DB server 100 executes a session establishment process. Then, as a result of executing the session opening process, the DB server 100 generates new session information indicating a newly assigned session number and the like, and transmits the new session information to the AP server 400.

  [Step S178] The DB communication unit 460 receives new session information indicating a session newly allocated from the DB cluster 10 and the cluster version number of the DB cluster 10. The DB communication unit 460 outputs the received new session information and the cluster version number to the session control unit 440. The session control unit 440 sets new session information (for example, session number) in the session management table 412. In addition, the session control unit 440 sets the cluster version number received together with the new session as the session acquisition version number corresponding to the new session. The new session set in the session management table 412 is an unassigned session. Also, the new session becomes a valid session.

  [Step S179] The session control unit 440 refers to the session management table 412, and uses the identification information (requester identification information) of the transmission source terminal device of the AP request that is the generation source of the DB request as a valid and unallocated session. Assign to. For example, among the valid and unallocated sessions included in the session management table 412, the one with the smallest entry ID is preferentially allocated.

  As described above, the AP server 400 includes the server version number of the AP server 400 in the session establishment request in addition to the processing of the second embodiment. The DB server 100 can execute a session establishment process based on the server version number.

  The AP server 400 may transmit the session establishment request and the server version number separately. For example, when the DB communication unit 460 transmits a session establishment request to the DB cluster 10, the version number transmission / reception unit 490 may transmit the server version number to the DB cluster 10.

Next, the session establishment process of the DB server 100 shown in step S177 of FIG. 33 will be described in detail.
FIG. 34 is a flowchart illustrating session opening processing according to the third embodiment. In the following, the process illustrated in FIG. 34 will be described in order of step number.

[Step S181] The AP communication unit 160 receives a session establishment request. The AP communication unit 160 outputs the received session establishment request to the session control unit 440.
[Step S182] The session control unit 440 executes session release processing based on the server version number included in the session establishment request. The session release process is the same as the procedure after step S142 shown in FIG. However, the server version number is included in the session establishment request. For this reason, the session control unit 440 refers to the session establishment request acquired from the AP communication unit 160 and acquires the server version number.

[Step S183] The session control unit 440 allocates a new session to the AP server 400.
[Step S184] The session control unit 440 refers to the cluster version number table 111 stored in the version number storage unit 110 and acquires the cluster version number.

  [Step S185] The session control unit 440 generates a session establishment response including new session information indicating the cluster version number and the new session allocation content. Session control unit 440 outputs the generated session establishment response to AP communication unit 160.

[Step S186] The AP communication unit 160 transmits the session establishment response acquired from the session control unit 440 to the AP server 400.
In this way, the DB server 100 opens a new session with the AP server 400. At that time, the session release process can be executed based on the server version number received from the AP server 400.

  In step S185, the DB server 100 includes the cluster version number in the session establishment response, but the session establishment response and the cluster version number may be transmitted separately. For example, when the AP communication unit 160 transmits a session establishment response to the AP server 400, the version number transmission / reception unit 190 may transmit the cluster version number to the AP server 400.

FIG. 35 is a flowchart illustrating DB response transmission processing according to the third embodiment. In the following, the process illustrated in FIG. 35 will be described in order of step number.
[Step S191] The AP communication unit 160 receives a DB request from the AP server 400. The AP communication unit 160 outputs the server version number included in the received DB request to the session control unit 440. In addition, the AP communication unit 160 outputs a DB request to the DB processing unit 120.

  [Step S192] The session control unit 440 executes session release processing based on the server version number. The session release process is the same as the procedure after step S142 shown in FIG.

  [Step S193] The DB processing unit 120 refers to the session management table 172 stored in the session information storage unit 170, and determines whether or not the designated session included in the DB request is appropriate. If so, the process proceeds to step S194. If not, the process proceeds to Step S198.

[Step S194] The DB processing unit 120 executes DB processing according to the DB request.
[Step S195] The DB processing unit 120 refers to the version number storage unit 110 to obtain a cluster version number.

[Step S196] The DB processing unit 120 generates a DB response including the cluster version number based on the execution result of the DB processing.
[Step S197] The DB processing unit 120 outputs the generated DB response to the AP communication unit 160. The AP communication unit 160 transmits the acquired DB response to the AP server 400. Since this DB response is a response when the DB processing is normally performed, it is a normal response.

  [Step S198] The DB processing unit 120 refers to the version number storage unit 110 to obtain a cluster version number. Here, when the cluster version number stored in the version number storage unit 110 indicates a predetermined initial value (for example, “−1”), the service monitoring unit 140 sets the new cluster version number to the version number storage unit. Set to 110. In this case, the DB processing unit 120 acquires the cluster version number set by the service monitoring unit 140.

  [Step S199] The DB processing unit 120 generates a session invalidation notification indicating that the designated session is not appropriate. The DB processing unit 120 includes the cluster version number in the session invalidation notification.

  [Step S200] The DB processing unit 120 outputs a session invalidation notification to the AP communication unit 160. The AP communication unit 160 transmits a session invalidation notification and a cluster version number to the AP server 400. Since this response is a response when the DB processing is not normally performed, it is not a normal response. In this case, the AP server 400 does not determine that the response is normal in step S154 of FIG.

  As described above, the DB server 100 executes a session release process (step S192) based on the server version number received from the AP server 400 in addition to the DB response transmission process procedure of the second embodiment.

As a result, the DB server 100 can reuse a session that is pooled for communication with the AP server 400 and that is not likely to be used.
In steps S196 to S200, the cluster version number is generated and transmitted in various responses, but may be separately transmitted to the AP server 400. For example, when the AP communication unit 160 transmits various responses to the AP server 400, the version number transmission / reception unit 190 may transmit the cluster version number to the AP server 400.

  Next, a specific example of the processing flow in the business processing system will be described. In the following example, only processing between the DB cluster 10 and the AP server 400 will be described, but between the DB cluster 10 and the AP servers 500 and 600 and between the DB clusters 20 and 30 and the AP servers 400, 500, and 600. The same applies to the processing of.

Immediately before the step in each of the following drawings, it is assumed that the DB server 100 is in the active state and the DB server 100a is in the standby state for the DB cluster 10.
FIG. 36 is a first sequence diagram illustrating session release processing according to the third embodiment. In the following, the process illustrated in FIG. 36 will be described in order of step number.

[Step ST31] The AP server 400 starts stopping the AP service.
[Step ST32] The AP server 400 updates the server version number. The AP server 400 transmits an AP service stop start notification and a server version number to the DB cluster 10. The DB server 100 receives the AP service stop start notification and the server version number from the AP server 400.

[Step ST33] The DB server 100 executes session release processing. The DB server 100 sets the AP server 400 “not in operation”.
[Step ST34] The AP server 400 starts activation of the AP service.

[Step ST35] The AP server 400 completes activation of the AP service.
[Step ST36] The AP server 400 updates the server version number. The AP server 400 transmits an AP service activation completion notification and server version number to the DB cluster 10. The DB server 100 receives an AP service activation completion notification and server version number from the AP server 400.

[Step ST37] The DB server 100 executes session release processing. The DB server 100 sets the AP server 400 to “in operation”.
[Step ST38] The DB server 100 transmits the cluster version number to the AP server 400. The AP server 400 receives the cluster version number from the DB server 100.

  As described above, the AP server 400 updates the server version number when the AP service stops and starts, and transmits the updated server version to the DB clusters 10, 20, and 30. When receiving the updated server version number, the DB clusters 10, 20, and 30 release the session assigned to the AP server 400.

  For this reason, the active DB server on the DB cluster side (for example, the DB server 100) can reliably release a session that is no longer used by the AP server 400 when the AP server 400 stops the AP service. . The released session is in an unallocated state which is not allocated to any AP server and processing request destination thread. Therefore, the DB clusters 10, 20, and 30 do not allocate useless sessions to the AP server 400. For example, more sessions can be allocated to the operating AP servers 500 and 600. That is, the session can be used efficiently.

  Further, upon receiving the AP service activation completion notification from the AP server 400, the DB clusters 10, 20, and 30 transmit the cluster version number to the AP server 400. The AP server 400 can detect that the DB clusters are available by receiving the cluster version numbers from the DB clusters 10, 20, and 30. For example, it is possible to manage the DB cluster that receives the cluster version number as “in operation”. On the other hand, a DB cluster that could not receive the cluster version number can be managed as “not in operation”.

  Further, the AP server 400 transmits the server version number not only when the stop of the AP service is started but also when the activation is completed. For this reason, even when the server version number cannot be transmitted at the start of the stop due to a failure or the like in the AP server 400, the DB clusters 10, 20, and 30 can be surely prompted to release the session. Next, such a case is illustrated.

FIG. 37 is a second sequence diagram illustrating session release processing according to the third embodiment. In the following, the process illustrated in FIG. 37 will be described in order of step number.
[Step ST41] The AP server 400 cannot use the AP service due to a failure. At this time, it is assumed that the server version number cannot be transmitted because the network cannot be used.

[Step ST42] The AP server 400 starts activation of the AP service upon failure recovery.
[Step ST43] The AP server 400 completes activation of the AP service.

  [Step ST44] The AP server 400 updates the cluster version number. The AP server 400 transmits an AP service activation completion notification and server version number to the DB cluster 10. The DB server 100 receives an AP service activation completion notification and server version number from the AP server 400.

[Step ST45] The DB server 100 executes a session release process.
[Step ST46] The DB server 100 transmits the cluster version number to the AP server 400. The AP server 400 receives the cluster version number from the DB server 100.

  As described above, even when the AP server 400 cannot transmit the server version number when the AP service is stopped to the DB clusters 10, 20, and 30 due to a failure, the AP server 400 sends the server to the DB clusters 10, 20, and 30 when the AP service is started. Send the version number. For this reason, it is possible to surely prompt the DB clusters 10, 20, and 30 to release the session.

In the business processing system of the third embodiment, the server versions of the AP servers 400, 500, and 600 are also managed on the DB cluster 10, 20, and 30 side.
As a result, in addition to the same effects as those of the second embodiment, the DB clusters 10, 20, and 30 can appropriately release sessions according to the state of the AP servers 400, 500, and 600. As a result, for example, a free session can be assigned to another AP server. Further, for example, resources such as a memory allocated to the corresponding session can be used for other business processes.

That is, the resources of the DB clusters 10, 20, and 30 can be used efficiently.
In the second and third embodiments, the time stamp is used as the cluster version number and the server version number, but the present invention is not limited to this.

  For example, the version number may be a numerical value managed so as to add a predetermined numerical value (for example, 1) when the cluster is switched or when the service is started / stopped. However, when this is the cluster version number, the cluster version number is synchronized between the active and standby DB servers. As a result, the cluster version number can be managed consistently for each DB cluster on the AP server side.

  The information processing system, information processing apparatus, communication control program, and communication control method of the present invention have been described above based on the illustrated embodiments. However, the present invention is not limited to these, and the configuration of each unit has the same function. It can be replaced with one having any structure. Moreover, other arbitrary structures and processes may be added. Further, any two or more configurations (features) of the above-described embodiments may be combined.

DESCRIPTION OF SYMBOLS 1, 2 Information processing apparatus 1a Connection information storage part 1b Service provision part 1c Monitoring part 1d Transmission part 2a Connection information storage part 2b Service provision part 2c Control part

Claims (13)

A first service providing unit that executes processing according to the processing request;
A monitoring unit for monitoring the operating status of the first service providing unit;
A transmission unit that transmits predetermined control information when the monitoring unit detects completion of activation of the first service providing unit;
A first information processing apparatus comprising:
A second service providing unit that transmits the processing request to the first service providing unit via a predetermined resource;
A connection information storage unit for storing connection information defining the resource;
When receiving control information from the first information processing apparatus, a control unit that invalidates the resource included in the connection information stored in the connection information storage unit based on the received control information;
A second information processing apparatus comprising:
An information processing system comprising: The monitoring unit updates the predetermined first version number stored in the first version number storage unit when detecting the completion of activation of the first service providing unit,
The transmission unit includes the first version number updated by the monitoring unit in control information and transmits the control information to the second information processing apparatus,
The connection information storage unit stores a predetermined second version number indicating the time when the resource is allocated in association with the resource,
The control unit invalidates the resource when the first version number included in the control information received from the first information processing apparatus is different from the second version number;
The information processing system according to claim 1. The transmitting unit is configured to store the first version number stored in the first version number storage unit when the first service providing unit transmits a response to the processing request to the second service providing unit. Send control information including
The information processing system according to claim 2. The processing request received from the second service providing unit is in a stopped state when the first service providing unit is in an active state, and is in an active state when the first service providing unit is in a stopped state. A redundant service providing unit that replaces the processing of the first service providing unit according to
A redundancy monitoring unit for monitoring the operating status of the redundant service providing unit;
A redundant transmitter that transmits predetermined control information when the redundancy monitoring unit detects a stop of the redundant service providing unit;
A third information processing apparatus comprising:
The first service providing unit starts when the redundant service providing unit stops,
The information processing system according to any one of claims 2 and 3. The redundancy monitoring unit updates the predetermined third version number stored in the third version number storage unit when detecting the stop of the redundancy service providing unit,
The redundant transmission unit includes the third version number updated by the redundancy monitoring unit in control information and transmits the control information to the second information processing device,
The control unit invalidates the resource when the third version number included in the control information received from the third information processing apparatus is different from the second version number;
The information processing system according to claim 4. The first information processing apparatus includes:
A resource control unit that allocates the resource in response to an allocation request from the second service providing unit and generates resource management information for managing the resource allocation;
A resource information storage unit for storing the resource management information;
Further comprising
The second information processing apparatus
A service monitoring unit for monitoring an operating state of the second service providing unit;
A notification information transmitting unit that transmits predetermined notification information when the service monitoring unit detects stop and activation of the second service providing unit;
Further comprising
The resource control unit includes the second service providing unit out of the resources included in the resource management information stored in the resource information storage unit based on the notification information received from the second information processing apparatus. Free allocated resources,
The information processing system according to claim 1, wherein the information processing system is an information processing system. When the service monitoring unit detects the stop and activation of the second service providing unit, the service monitoring unit updates a predetermined fourth version number stored in a fourth version number storage unit,
The notification information transmission unit includes the fourth version number updated by the service monitoring unit in the notification information and transmits the notification to the first information processing apparatus,
The resource information storage unit stores a predetermined fifth version number indicating the time when the allocation request is transmitted by the second service providing unit in association with the resource,
The resource control unit allocates the resource to the second service providing unit when the fourth version number included in the notification information received from the second information processing apparatus is different from the fifth version number. Release,
The information processing system according to claim 6.   The notification information transmission unit transmits the notification information including the fourth version number stored in the fourth version number storage unit when the second service providing unit transmits the processing request. The information processing system according to claim 7. A monitoring unit for monitoring the operating status of the first service providing unit;
When the monitoring unit detects completion of activation of the first service providing unit, the second service providing unit transmits a processing request to the first service providing unit to a partner apparatus including the second service providing unit. A transmission unit that transmits control information that prompts invalidation of the resource included in the connection information stored in the connection information storage unit that stores connection information that defines resources used to
An information processing apparatus comprising: A connection information storage unit for storing connection information defining resources used for the first service providing unit to transmit a processing request to the second service providing unit of the counterpart device;
When completion of activation of the second service providing unit is detected on the partner device side, when predetermined control information transmitted from the partner device is received, it is stored in the connection information storage unit based on the received control information A control unit that invalidates the resource included in the connection information
An information processing apparatus comprising: Computer
Monitoring means for monitoring the operating status of the first service providing means;
When the monitoring unit detects completion of activation of the first service providing unit, the second service providing unit sends a processing request to the first service providing unit to the information processing apparatus including the second service providing unit. A transmission means for transmitting control information for prompting invalidation of the resource included in the connection information stored in the connection information storage means for storing connection information defining resources used for transmission;
A communication control program characterized by causing it to function as Computer
Connection information storing means for storing connection information defining resources used for transmitting a processing request to a second service providing means provided in the information processing apparatus by the first service providing means;
When the predetermined completion of control information transmitted from the information processing device is received when completion of activation of the second service providing unit is detected on the information processing device side, the connection information storage unit based on the received control information Control means for invalidating the resource included in the connection information stored in
A communication control program characterized by causing it to function as A communication control method for an information processing system,
The first information processing apparatus monitors the operation information of the first service providing unit that executes processing according to the processing request, and transmits predetermined control information when detecting the completion of activation of the first service providing unit. ,
When the second information processing apparatus receives control information from the first information processing apparatus, a second resource providing unit uses a predetermined resource used for transmitting the processing request to the first service providing unit. Invalidating the resource included in the connection information stored in the connection information storage unit that stores the defined connection information;
A communication control method characterized by the above.

Images