Systems and methods for redirect handling

Patent metadata

Field	Value
Publication number	US-10671622-B2
Application number	US-201715490529-A
Country	US
Kind code	B2
Filing date	Apr 18, 2017
Priority date	May 20, 2014
Publication date	Jun 2, 2020
Grant date	Jun 2, 2020

Abstract

The present invention is related to a method for routing requests among a plurality of database servers. A device intermediary to a client and a plurality of database servers receives a request to access a database provided by the plurality of database servers. The plurality of database servers can include a first database server configured to process write requests and one or more second database servers configured to process read requests. The device determines that the request to access the database is a read request. The device identifies, responsive to determining that the request is a read request, one of the one or more second database servers to send the request instead of the first database server. The device then transmits the request to the identified second database server.

First claim

The invention claimed is:

1. A method comprising
establishing, by a device intermediary to plurality of clients and a plurality of databases, a first virtual server for processing types of request that write to one or more databases of the plurality of databases configured for processing write requests, and a second virtual server for processing types of request to read from one or more databases of the plurality of databases configured for processing read requests;
receiving, by the device, a request from a client of the plurality of clients to access a database of the plurality of databases;
determining, by the device, whether the type of the request is a write request or a read request; and
forwarding, by the device, the request to the first virtual server responsive to determining that the type of the request is the write request or forwarding, by the device, the request to the second virtual server responsive to determining that the type of the request is the read request.

2. The method of claim 1 , further comprising transmitting, by one of the first virtual server or the second virtual server, the request to the database of the plurality of the databases.

3. The method of claim 1 , further comprising establishing, by the device, a third virtual server for determining the type of request received from any of the plurality of clients to access the plurality of databases.

4. The method of claim 3 , wherein the third virtual server is configured to receive the request from the client and forward the request to the first virtual server responsive to determining that the type of the request is the write request or forward the request to the second virtual server responsive to determining that the type of the request is the read request.

5. The method of claim 1 , further comprising determining, by the device, the type of the request using one or more properties of the request.

6. The method of claim 1 , further comprising determining, by the device, the type of the request using content of the request.

7. The method of claim 6 , further comprising determining, by the device, the type of the request using a Structured Query Language (SQL) command identified in content of the request.

8. The method of claim 1 , further comprising determining, by the device, the type of the request using a policy applied to the request.

9. A system comprising
a device, comprising one or more processors, coupled to memory, and intermediary to plurality of clients and a plurality of databases;
a first virtual server executable on the one or more processors and configured for processing types of requests that write to one or more databases of the plurality of databases configured for processing write requests;
a second virtual server for processing types of request to read from one or more databases of the plurality of databases configured for processing read requests;
wherein the device is further configured to:
receive a request from a client of the plurality of clients to access a database of the plurality of databases;
determine whether the type of the request is a write request or a read request; and
forward, the request to the first virtual server responsive to determining that the type of the request is the write request or forward the request to the second virtual server responsive to determining that the type of the request is the read request.

10. The system of claim 9 , wherein one of the first virtual server or the second virtual server is configured to forward the request to the database of the plurality of the databases.

11. The system of claim 9 , wherein the device is further configured to establish a third virtual server for determining the type of request received from any of the plurality of clients to access the plurality of databases.

12. The system of claim 11 , wherein the third virtual server is further configured to receive the request from the client and forward the request to the first virtual server responsive to determining that the type of the request is the write request or forward the request to the second virtual server responsive to determining that the type of the request is the read request.

13. The system of claim 9 , wherein the device is further configured to determine the type of the request using one or more properties of the request.

14. The system of claim 9 , wherein the device is further configured to determine the type of the request using content of the request.

15. The system of claim 14 , wherein the device is further configured to determine the type of the request using a Structured Query Language (SQL) command identified in content of the request.

16. The system of claim 9 , wherein the device is further configured to determine the type of the request using a policy applied to the request.

Assignees

• Citrix Systems Inc

Inventors

• Sah Sudish Kumar
• Ganji Bhavana
• Joshi Rajesh

Classifications

• H04L67/2814

  Electricity · mapped topic

• G06F16/2471 Primary

  Distributed queries · CPC title

• H04L45/00

  Routing or path finding of packets in data switching networks (routing or path finding in wireless networks H04W40/00) · CPC title

• H04L67/1002

  Electricity · mapped topic

• H04L67/42

  Electricity · mapped topic