Fault tolerant client server system

• US 5,796,934 A
• Filed: 05/31/1996
• Issued: 08/18/1998
• Est. Priority Date: 05/31/1996
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle Corporation
• Inventors: Jackson, Paul, Bhanot, Pradeep
• Primary Examiner(s): Treat, William M.
• Application Number:
  US08/656,665
• Time in Patent Office: 809 Days
• Field of Search: 395/182.02, 395/182.03, 395/182.04, 395/182.05, 395/182.13, 395/182.16, 395/182.17, 395/182.18, 395/200.69, 395/200.73
• US Class Current: 714/4.12
• CPC Class Codes: G06F 11/1474 in transactions G06F16/20 takes precedence
• CPC Class Codes: G06F 11/2023 Failover techniques
• CPC Class Codes: G06F 11/2035 without idle spare hardware
• CPC Class Codes: G06F 11/2046 where the redundant components share persistent storage G06F11/2043 takes precedence

Abstract

A method for providing fault tolerance in a client/server computer system. A client is initially connected to a primary server. The primary server normally handles all of the client'"'"'s transactions. However, a secondary connection is designated to a backup server, whereby if the primary server ever becomes disabled, the client is automatically switched over to the backup server. In-flight transaction information corresponding to transactions currently being processed by the primary server is stored and regularly updated by the client. The client regularly polls the primary server to check whether the primary server is properly functioning. If the primary server becomes disabled, all in-flight transactions pending on the disabled server are rolled back and the client resubmits in-flight transaction information to the backup server so that it can complete any transactions which were in progress on the primary server at the time of the failure. Thus, server failures are transparent to the user.

Claims

1. In a client/server computer system, a method for providing fault tolerance, comprising the steps of:

establishing a connection from a client computer to a primary server computer;

designating a backup server computer for processing transactions from the client if the primary server becomes disabled, wherein the transactions are processed according to database management system (DBMS) instructions;

storing connection information for connecting the client to the backup server;

storing in-flight client transaction information by a log writing process for completing in-flight transactions without user intervention if the primary server becomes disabled;

determining whether the primary server is disabled, wherein if the primary server becomes disabled;

A) establishing a connection from the client to the backup server;

B) submitting the in-flight transaction information to the backup server;

C) completing the in-flight transactions on the backup server;

D) routing subsequent transactions from the client to the backup server for processing.

2. The method of claim 1, further comprising the step of the client periodically polling the primary server to determine whether the primary server is functioning properly, wherein the client submits the in-flight transaction information to the backup server if the primary server becomes disabled.

3. The method of claim 1, wherein the in-flight transaction information to be submitted to the backup server is stored in memory residing within the client.

4. The method of claim 3 further comprising the step of storing in-flight transaction information in memory residing within the primary server, wherein a user can selectively rollback an in-flight transaction according to the information stored within the properly functioning primary server.

5. The method of claim 4 further comprising the steps of:

storing in-flight transaction information within memory residing within a mass storage device coupled to the primary server and the backup server;

determining whether the primary server is properly functioning;

rolling back in-flight transactions pending on the primary server when the primary server becomes disabled, wherein the rollback is performed by the backup server according to the information stored in the memory residing in the mass storage device.

6. A fault tolerant computer system comprising:

a client computer for running an application;

a first server coupled to the client for accepting transactions generated by the client application, wherein the transactions are processed according to database management system (DBMS) instructions;

a first memory for storing connection information corresponding to a second server, wherein if the first server becomes disabled, a connection from the client to the second server is automatically established by the client and transactions from the client are handled by the second server;

a second memory for storing information pertaining to transactions pending on the first server, wherein the information is stored by a log writing process for completing the pending transactions without user intervention when the first server becomes disabled;

a client interface coupled to the second memory which submits pending transaction information to the second server for processing by the second server when the first server becomes disabled.

7. The computer system of claim 6, further comprising polling logic for determining whether the first server is functioning properly, wherein the client submits the transaction information stored in the second memory residing within the client when the first server becomes disabled.

8. The computer system of claim 6 further comprising:

a third memory residing within the first server for storing pending transaction information;

rollback logic coupled to the client, wherein a user can selectively rollback a transaction pending on the client according to the information stored within the third memory in the properly functioning first server.

9. The computer system of claim 8 further comprising a fourth memory residing within a mass storage device for storing information pertaining to a plurality of pending transactions on the first server and the second server, wherein when the first server becomes disabled, the backup server utilizes the rollback logic to roll back transactions pending on the first server according to the information stored in the fourth memory.

10. A computer-readable medium having stored thereon instructions for causing a client computer to implement fault tolerance comprising the steps of:

establishing a first connection between the client and a primary server for servicing transactions generated by an application running on the client, wherein the transactions are processed according to database management system (DBMS) instructions;

designating a second connection between the client and a backup server;

storing in-flight transaction information corresponding to transactions being processed by the primary server, wherein the information is stored by a log writing process for completing the in-flight transactions without user intervention if the primary server fails;

detecting whether the primary server has failed, wherein if the primary server fails;

a) establishing the second connection to the backup server;

b) submitting the in-flight transaction information to the backup server,

c) completing the in-flight transaction by the backup server.

11. The computer-readable memory of claim 10, wherein the instructions further comprise the step of periodically polling the primary server to determine whether the primary server is functioning properly, wherein the client submits the in-flight transaction information to the backup server if the primary server becomes disabled.

12. The computer-readable memory of claim 10, wherein the in-flight transaction information to be submitted to the backup server is stored by the client.

13. The computer-readable memory of claim 10, wherein the in-flight transaction information is stored by the primary server, wherein a user can selectively rollback the in-flight transaction according to the information stored in the properly functioning primary server.

14. The computer-readable memory of claim 10, wherein the instructions further comprise the steps of:

storing in-flight transaction information within memory residing within a mass storage device coupled to the primary server and the backup server;

determining whether the primary server is properly functioning;

rolling back in-flight transactions pending on the primary server when the primary server becomes disabled, wherein the rollback is performed by the backup server according to the information stored in the memory residing in the mass storage device.

15. A computer capable of being coupled as a client to a server of a computer network for accessing a database stored in a mass storage device, comprising:

a bus;

a processor coupled to the bus for running an application on the client;

a first memory coupled to the bus for storing connection information for connecting the client to a primary server and for connecting the client to a backup server, wherein the client is normally connected to the primary server and the primary server handles transactions generated by an application running on the client, and the transactions are processed according to database management system (DBMS) instructions;

a second memory coupled to the bus for storing in-flight transaction information by a log writing process for completing in-flight transactions without user intervention if the primary server becomes disabled;

an interface coupled to the bus for determining whether the primary server is functioning properly, wherein if the primary server becomes disabled, the client automatically establishes a connection to the backup server and transmits the in-flight transaction information to the backup server so that the backup server can complete the in-flight transaction.