READ/WRITE SPLIT DATABASE QUERY ROUTING

摘要

Systems and methods for improving database system performance are described. In one embodiment, a database system includes a database application cluster including at least one read-write node and a plurality of read nodes, a shared memory, and a multiplexer coupled to the database application cluster 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 routed to one of the plurality of read nodes. In response, the database query is routed to one of the read nodes for execution.

主权项

1. A database system, comprising:
a database application cluster comprising at least one read-write node and a plurality of read nodes; a shared memory; and a multiplexer coupled to the database application cluster 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 at least on a lookup in the shared memory, that the database query can be routed to one of the plurality of read nodes; and routing the database query to one of the plurality of read nodes for execution based on the determination.