Geographically split connection pooling for databases

A non-transitory computer-readable storage medium that, if executed by a processing system of a first server, will cause the processing system to perform operations comprising:

• establishing, at the first server of a distributed database service, a client-side database connection between a client node of the first server and a database client of the first server, wherein the client-side database connection is for a database that is external to the distributed database service, wherein the database client issues queries directed to the database, and wherein establishing the client-side database connection includes performing authentication to the database;
• receiving, at the first server, a first database query over the client-side database connection;
• responsive to determining that the first server cannot respond to the first database query using a cache that is locally available to the first server, proxying, by the client node of the first server of the distributed database service, the first database query to a second server of the distributed database service, wherein the second server includes a pool node for the database that maintains a plurality of pre-established database connections to the database for handling queries directed to the database, wherein the second server is located physically closer to the database compared to the first server;
• receiving, from the second server, a first response to the first database query;
• and
• transmitting the first response to the first database query to the database client.

A first server, comprising:

• a processing system;
• and
• a non-transitory machine-readable storage medium coupled to the processing system, wherein the non-transitory machine-readable storage medium stores instructions that, when executed by the processing system, causes the first server to perform operations including:
• establishing, at the first server of a distributed database service, a client-side database connection between a client node of the first server and a database client of the first server, wherein the client-side database connection is for a database that is external to the distributed database service, wherein the database client issues queries directed to the database, and wherein establishing the client-side database connection includes performing authentication to the database;
• receiving, at the first server, a first database query over the client-side database connection;
• responsive to determining that the first server cannot respond to the first database query using a cache that is locally available to the first server, proxying, by the client node of the first server of the distributed database service, the first database query to a second server of the distributed database service, wherein the second server includes a pool node for the database that maintains a plurality of pre-established database connections to the database for handling queries directed to the database, wherein the second server is located physically closer to the database compared to the first server;
• receiving, from the second server, a first response to the first database query;
• and
• transmitting the first response to the first database query to the database client.