Intermediate database management layer

摘要

Disclosed herein are systems, methods, and non-transitory computer-readable storage media for using an intermediate database management layer to manage communications between an application layer and a database layer. The database management layer can receive an initial communication from the application layer and transmit a subsequent communication to a particular database based upon a rule. The rules can specify the particular database based upon the initial communication and an availability status of the database. The rules specify criteria by which the initial communication is identified and logic specifying the particular database to receive the subsequent communication based upon the identification of the initial communication. The rules can specify a plurality of potential particular databases to receive the subsequent communication and an order in which to select one of the databases to receive the subsequent communication based upon the determined availability status of each of the potential particular databases.

主权项

1. A system, comprising:
an application layer including a plurality of applications; a database layer including a plurality of databases; and a database management layer configured to transparently handle requests from a particular application in the application layer to a particular database in the plurality of databases such that the application layer communicates with the database management layer using substantially the same syntax as the particular application uses if it were communicating directly to the particular database, the database management layer including a plurality of database management instances, each database management instances including:
a rules module configured to determine the particular database in the database layer for transmitting a request on behalf of the particular application in the application layer in accordance with a rule that determines the particular database based on parameters of a request received from the particular application in the application layer, anda failover logic configured to handle a failover from one of the plurality of databases that becomes insufficiently responsive to one of the plurality of databases that can sufficiently handle the response.