AUTOMATIC DATA REQUEST RECOVERY AFTER SESSION FAILURE

摘要

Techniques for recovering from session failures between clients and database servers are described herein. A session may be established between a client and a first database server to handle a database query for the client. A command of the session may be received by the first database server from the client. Data requested by the command may be retrieved. Prior to responding to the command, the data is spooled to a session state stored in a repository of the first database server, and the session state is replicated to one or more additional database servers. The session state stored in the repository of the first database server enables the first database server and client to recover from a failure of the session. The replicated session state enables the additional database server(s) to reestablish the session and respond to the command, instead of the first database server, if the session fails.

主权项

1. A method in a database server, comprising:
establishing a first session with a client to handle a database query for the client; receiving a request for data associated with the first session from the client; retrieving the requested data; spooling the data to a session state stored in a repository that is accessible to the database server by communications with an entity comprising at least one computing device, the entity controlling access to the session state in the repository; transmitting the data to the client in response to the request.