Invention Grant
US08868492B2 Method for maximizing throughput and minimizing transactions response times on the primary system in the presence of a zero data loss standby replica
有权
在存在零数据丢失备用副本的情况下,在主系统上最大化吞吐量并最小化事务响应时间的方法
- Patent Title: Method for maximizing throughput and minimizing transactions response times on the primary system in the presence of a zero data loss standby replica
- Patent Title (中): 在存在零数据丢失备用副本的情况下,在主系统上最大化吞吐量并最小化事务响应时间的方法
-
Application No.: US13161315Application Date: 2011-06-15
-
Publication No.: US08868492B2Publication Date: 2014-10-21
- Inventor: Benedicto E. Garin, Jr. , Mahesh B. Girkar , Yunrui Li , Vsevolod Panteleenko , Vinay H. Srihari
- Applicant: Benedicto E. Garin, Jr. , Mahesh B. Girkar , Yunrui Li , Vsevolod Panteleenko , Vinay H. Srihari
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Truong Becker Bingham Wong LLP
- Main IPC: G06F17/00
- IPC: G06F17/00 ; G06F17/30

Abstract:
A method and system is provided for reducing delay to applications connected to a database server that guarantees no data loss during failure or disaster. After storing a log record persistently in a local primary log, the log writer returns control to the application which continues running concurrently with the database server sending the session's log records to a standby database. A separate back channel is used by the standby to communicate, out-of-band to the primary, the location of the last log record stored persistently to the standby log. An application waiting for a transaction to commit may wait until the transaction's commit record has been persisted. Also described is a technique for reducing application delay when there is contention between nodes of a multi-node cluster for updating the same block. The technique provides for an asynchronous ping protocol that guarantees zero data loss during failure or disaster.
Public/Granted literature
Information query