Invention Grant
- Patent Title: Scalable relational database replication
- Patent Title (中): 可扩展关系数据库复制
-
Application No.: US14148503Application Date: 2014-01-06
-
Publication No.: US09304868B2Publication Date: 2016-04-05
- Inventor: Cory M. Isaacson , Andrew F. Grove
- Applicant: CODEFUTURES CORPORATION
- Applicant Address: US CO Broomfield
- Assignee: CodeFutures Corporation
- Current Assignee: CodeFutures Corporation
- Current Assignee Address: US CO Broomfield
- Agency: Dinsmore & Shohl LLP
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F11/14 ; G06F11/16 ; G06F11/20

Abstract:
A relational database replication system includes a client, at least one primary database, a plurality of secondary databases and replication agents which coordinate database transactions. The system provides a high level of performance, reliability, and scalability with an end result of efficient and accurate duplication of transactions between the primary and secondary databases. In one implementation, the client transmits sets of database update statements to the primary database and primary agent in parallel; the primary agent replicates the statements to at least one secondary agent. A transaction prepare and commit process is coordinated between the primary database and the primary agent, which in turn coordinates with the at least one secondary agent. Databases can be partitioned into individual smaller databases, called shards, and the system can operate in a linearly scalable manner, adding clients, databases and replication agents without requiring central coordination or components that cause bottlenecks.
Public/Granted literature
- US20140298077A1 Scalable Relational Database Replication Public/Granted day:2014-10-02
Information query