Systems and methods for caching of SQL responses using integrated caching
Systems and methods of the present disclosure provide for caching, by a device intermediary to a client and a database, a result of a structured query language (SQL) query request. In some embodiments, the device intermediary to a plurality of clients and a database receives a SQL response from the database to a first SQL query request of a client of the plurality of clients. The device may maintain a cache of SQL responses from the database. The device may identify that the first SQL query request matches a rule of a policy for caching SQL responses from the database. The policy may include a cache action to take when the rule is matched. The device may perform, responsive to the policy, on the SQL response the cache action identified by the policy.
1. A method for caching by a device intermediary to a client and a database a result of a structured query language (SQL) query request, the method comprising:
(a) receiving, by a device intermediary to a plurality of clients and a database, a SQL response from the database to a first structured query language (SQL) query request of a client of the plurality of clients, the device maintaining a cache of SQL responses from the database;
(b) identifying, by the device, that the first SQL query request matches a rule of a policy for caching SQL responses from the database, the policy comprising a cache action to take on a response to a query when the rule is matched; and
(c) performing, by the device responsive to the policy, on the SQL response received from the database the cache action identified by the policy matching the first SQL query request.
2. The method of claim 1 , further comprising identifying, by the device, that the SQL response from the first SQL query request is stored in the cache responsive to receiving from one of the plurality of clients a second SQL query request comprising the SQL query of the first SQL query request.
3. The method of claim 2 , further comprising serving, by the device, the SQL response from the cache responsive to the second SQL query request.
4. The method of claim 1 , wherein step (a) further comprises maintaining, by the device, SQL responses in the cache via a hash of two or more of the following: username, database name, character set and client version.
5. The method of claim 1 , wherein step (b) further comprises identifying, by the device, that an expression of the rule matches SQL content of the first SQL query request.
6. The method of claim 1 , wherein step (b) further comprises identifying, by the device, that the cache action of the policy specifies an action of one of to store to cache, not cache or invalidate a corresponding cache entry.
7. The method of claim 1 , wherein step (c) further comprises storing, by the device, the SQL response to the cache responsive to the cache action of the policy specifying an action to cache.
8. The method of claim 1 , wherein step (c) further comprises invalidating, by the device, the SQL response stored in the cache responsive to the cache action of the policy specifying an action to invalidate.
9. The method of claim 1 , further comprising identifying, by the device, that the policy specifies a selector for identifying a group of content to which the policy applies.
10. The method of claim 9 , further comprising performing, by the device, the cache action of the policy on the group of content identified by the selector.
11. A system for caching by a device intermediary to a client and a database a result of a structured query language (SQL) query request, the system comprising:
a device intermediary to a plurality of clients and a database;
a cache of the device configured to cache SQL responses from the database;
a database proxy of the device receiving an SQL response from the database to a first structured query language (SQL) query request of a client of the plurality of clients;
a policy engine configured to identify that the first SQL query request matches a rule of a policy for caching SQL responses from the database, the policy comprising a cache action to take on a response to a query when the rule is matched; and
wherein the device, responsive to the policy, is configured to perform on the SQL response received from the database the cache action identified by the policy matching the first SQL query request.
12. The system of claim 11 , wherein the database proxy is configured to identify that the SQL response from the first SQL query request is stored in the cache responsive to receiving from one of the plurality of clients a second SQL query request comprising the SQL query of the first SQL query request.
13. The system of claim 12 , wherein the database proxy is configured to serve the SQL response from the cache responsive to the second SQL query request.
14. The system of claim 11 , wherein the cache maintains SQL responses in the cache via a hash of two or more of the following: username, database name, character set and client version.
15. The system of claim 11 , wherein the policy engine is configured to identify that an expression of the rule matches SQL content of the first SQL query request.
16. The system of claim 11 , wherein the policy engine is configured to identify that the cache action of the policy specifies an action of one of to store to cache, not cache or invalidate a corresponding cache entry.
17. The system of claim 11 , wherein the device is configured to store the SQL response to the cache responsive to the cache action of the policy specifying an action to cache.
18. The system of claim 11 , wherein the device is configured to invalidate the SQL response stored in the cache responsive to the cache action of the policy specifying an action to invalidate.
19. The system of claim 11 , wherein the policy engine is configured to identify that the policy specifies a selector for identifying a group of content to which the policy applies.
20. The system of claim 19 , wherein the device is further configured to perform the cache action of the policy on the group of content identified by the selector.