Invention Grant
US09032017B1 Method and system for transparent read-write query routing when load balancing databases
有权
负载平衡数据库时透明读写查询路由的方法和系统
- Patent Title: Method and system for transparent read-write query routing when load balancing databases
- Patent Title (中): 负载平衡数据库时透明读写查询路由的方法和系统
-
Application No.: US12853650Application Date: 2010-08-10
-
Publication No.: US09032017B1Publication Date: 2015-05-12
- Inventor: Varun Singh , Uday V. Sawant , Prateek Goel , Naresh G. Deshaveni
- Applicant: Varun Singh , Uday V. Sawant , Prateek Goel , Naresh G. Deshaveni
- Applicant Address: US CA Santa Clara
- Assignee: Scalarc Inc
- Current Assignee: Scalarc Inc
- Current Assignee Address: US CA Santa Clara
- Agency: Haynes Beffel & Wolfeld LLP
- Agent Warren S. Wolfeld
- Main IPC: G06F15/16
- IPC: G06F15/16 ; G06F15/173 ; G06F17/30

Abstract:
Roughly described, a database query router is installed transparently in a network between database client systems and a database server cluster. One subset of the servers is designated to handle read queries only and a second subset is designated to handle write queries. The query router receives, through a network port, the database queries made by a client system, and directed to the IP address and port assigned to the query router. The query router determines whether the query is a read or a write query, and forwards read queries to servers in the first subset and write queries to servers in the second subset of servers. By installing the query router transparently in the network, no modifications are required to the software in either the client systems or the database servers in order to add query routing functionality to a client/server database environment.
Information query