Invention Grant
- Patent Title: Routing and translating a database command from a proxy server to a database server
-
Application No.: US15615728Application Date: 2017-06-06
-
Publication No.: US10649962B1Publication Date: 2020-05-12
- Inventor: Jeremiah C. Wilton
- Applicant: Amazon Technologies, Inc.
- Applicant Address: US WA Seattle
- Assignee: Amazon Technologies, Inc.
- Current Assignee: Amazon Technologies, Inc.
- Current Assignee Address: US WA Seattle
- Agency: Davis Wright Tremaine LLP
- Main IPC: G06F16/182
- IPC: G06F16/182 ; G06F16/17 ; G06F16/33

Abstract:
The routing of commands within a database cluster is managed by a proxy server. The database cluster is comprised of a master database and at least one read-replica database. When the proxy server receives a database command, the proxy server determines whether the command is capable of being translated into an alternate command that can be executed on the read-replica database. If the command is not capable of being reliably translated, the database command is executed on the master database. If the command is capable of being executed on a read-replica database, the proxy server translates the database command into an alternate command that is compatible with the read-replica database, and executes the alternate command on the read-replica database. If results are returned from the read-replica database, the results may be converted into a format produced by the master database.
Information query