REPLICA DATABASE QUERY ROUTING FOR DATABASE ENVIRONMENTS

摘要

Systems and methods for improving database system performance are described. In one embodiment, a database system includes a master database, a replica database, a shared memory, and a multiplexer coupled to the master database, replica database, and shared memory. The multiplexer is configured to receive a request from a client computing system which includes a database query. Based on a lookup in the shared memory, the multiplexer determines that the database query can be satisfied by the replica database. In response, the database query is routed to the replica database for execution.

主权项

1. A database system, comprising:
a master database; a replica database; a shared memory; and a multiplexer coupled to the master database, replica database, and shared memory, and comprising a non-transitory memory and one or more hardware processors coupled to the non-transitory memory and configured to read instructions from the non-transitory memory to cause the multiplexer to perform operations comprising: receiving a request from a client computing system, wherein the request comprises at least a database query; determining, based on a lookup in the shared memory, that the database query can be satisfied by the replica database; and routing the database query to the replica database for execution.