Systems and methods for redirect handling

• US 10,671,622 B2
• Filed: 04/18/2017
• Issued: 06/02/2020
• Est. Priority Date: 05/20/2014
• Status: Active Grant

• Current Assignee: Citrix Systems, Inc. (Cloud Software Group)
• Original Assignee: Citrix Systems, Inc. (Cloud Software Group)
• Inventors: Sah, Sudish Kumar, Ganji, Bhavana, Joshi, Rajesh
• Primary Examiner(s): Corrielus, Jean M
• Application Number:
  US15/490,529
• Publication Number:
  US 20170223095A1
• Time in Patent Office: 1,141 Days
• Field of Search: 709227
• CPC Class Codes: G06F 16/2471 Distributed queries
• CPC Class Codes: H04L 45/00 Routing or path finding of packets in data switching networks routing or path finding in wireless networks H04W40/00
• CPC Class Codes: H04L 45/76 Routing in software-defined topologies, e.g. routing between virtual machines
• CPC Class Codes: H04L 67/01 Protocols
• CPC Class Codes: H04L 67/1001 for accessing one among a plurality of replicated servers
• CPC Class Codes: H04L 67/563 Data redirection of data network streams

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.

Claims

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.