公开(公告)号：US08868492B2

公开(公告)日：2014-10-21

申请号：US13161315

申请日：2011-06-15

申请人： Benedicto E. Garin, Jr. ,  Mahesh B. Girkar ,  Yunrui Li ,  Vsevolod Panteleenko ,  Vinay H. Srihari

发明人： Benedicto E. Garin, Jr. ,  Mahesh B. Girkar ,  Yunrui Li ,  Vsevolod Panteleenko ,  Vinay H. Srihari

IPC分类号： G06F17/00 ,  G06F17/30

CPC分类号： G06F17/30575

摘要： 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.

摘要翻译： 提供了一种方法和系统，用于减少连接到数据库服务器的应用程序的延迟，保证在故障或灾难期间无数据丢失。 将日志记录永久存储在本地主日志中后，日志记录器将返回到与数据库服务器并发运行的应用程序，该应用程序将会话的日志记录发送到备用数据库。 备用数据库使用一个单独的后置通道，将主持续端口的持续存储的最后一个日志记录的位置进行通信。 等待事务提交的应用程序可能会等到事务的提交记录被持久化。 还描述了当用于更新相同块的多节点簇的节点之间存在竞争时减少应用延迟的技术。 该技术提供了异步ping协议，保证在故障或灾难期间零数据丢失。

公开(公告)号：US20120323849A1

公开(公告)日：2012-12-20

申请号：US13161315

申请日：2011-06-15

申请人： Benedicto E. Garin, JR. ,  Mahesh B. Girkar ,  Yunrui Li ,  Vsevolod Panteleenko ,  Vinay H. Srihari

发明人： Benedicto E. Garin, JR. ,  Mahesh B. Girkar ,  Yunrui Li ,  Vsevolod Panteleenko ,  Vinay H. Srihari

IPC分类号： G06F17/30

CPC分类号： G06F17/30575

摘要： 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.

摘要翻译： 提供了一种方法和系统，用于减少连接到数据库服务器的应用程序的延迟，保证在故障或灾难期间无数据丢失。 将日志记录永久存储在本地主日志中后，日志记录器将返回到与数据库服务器并发运行的应用程序，该应用程序将会话的日志记录发送到备用数据库。 备用数据库使用一个单独的后置通道，将主持续端口的持续存储的最后一个日志记录的位置进行通信。 等待事务提交的应用程序可能会等到事务的提交记录被持久化。 还描述了当用于更新相同块的多节点簇的节点之间存在竞争时减少应用延迟的技术。 该技术提供了一种异步ping协议，可以在故障或灾难期间保证零数据丢失。

公开(公告)号：US08838919B2

公开(公告)日：2014-09-16

申请号：US12871805

申请日：2010-08-30

申请人： Jia Shi ,  Wei M. Hu ,  Vinay H. Srihari ,  Yunrui Li ,  Mahesh B. Girkar ,  Benedicto E. Garin, Jr.

发明人： Jia Shi ,  Wei M. Hu ,  Vinay H. Srihari ,  Yunrui Li ,  Mahesh B. Girkar ,  Benedicto E. Garin, Jr.

IPC分类号： G06F12/00 ,  G06F11/20 ,  G06F17/30

CPC分类号： G06F17/30581 ,  G06F11/2094 ,  G06F11/2097 ,  G06F2201/80 ,  Y10S707/99955

摘要： A method and system is provided for measuring, guaranteeing, and reducing replication data lag time between a primary system and one or more standby systems. Each standby system determines the lag time between the generation of a consistent version of data on the primary system and the time that the consistent version is applied on the standby system. Applications can request and be guaranteed to receive data from a standby system that is identical to the state on the primary system at the time of the query, or lag the primary state only by a maximum tolerable amount. A standby system may also publish a service that guarantees a maximum lag time and withdraw the service offer when the actual lag time exceeds the guaranteed lag time.Implications for implementing synchronous and asynchronous replication as well as performance optimizations are also discussed.

摘要翻译： 提供了一种方法和系统，用于测量，保证和减少主系统与一个或多个备用系统之间的复制数据滞后时间。 每个备用系统确定在主系统上生成一致版本的数据与在备用系统上应用一致版本的时间之间的滞后时间。 应用程序可以请求并保证从查询时与主系统上的状态相同的备用系统接收数据，或仅以最大可容忍的数量滞后于主状态。 备用系统还可以发布保证最大延迟时间的服务，并且当实际滞后时间超过保证滞后时间时撤回服务报价。 还讨论了实现同步和异步复制以及性能优化的意义。

公开(公告)号：US20120054533A1

公开(公告)日：2012-03-01

申请号：US12871805

申请日：2010-08-30

申请人： Jia Shi ,  Wei M. Hu ,  Vinay H. Srihari ,  Yunrui Li ,  Mahesh B. Girkar ,  Benedicto E. Garin, JR.

发明人： Jia Shi ,  Wei M. Hu ,  Vinay H. Srihari ,  Yunrui Li ,  Mahesh B. Girkar ,  Benedicto E. Garin, JR.

IPC分类号： G06F17/30 ,  G06F11/20 ,  G06F11/07

CPC分类号： G06F17/30581 ,  G06F11/2094 ,  G06F11/2097 ,  G06F2201/80 ,  Y10S707/99955

摘要： A method and system is provided for measuring, guaranteeing, and reducing replication data lag time between a primary system and one or more standby systems. Each standby system determines the lag time between the generation of a consistent version of data on the primary system and the time that the consistent version is applied on the standby system. Applications can request and be guaranteed to receive data from a standby system that is identical to the state on the primary system at the time of the query, or lag the primary state only by a maximum tolerable amount. A standby system may also publish a service that guarantees a maximum lag time and withdraw the service offer when the actual lag time exceeds the guaranteed lag time.Implications for implementing synchronous and asynchronous replication as well as performance optimizations are also discussed.

摘要翻译： 提供了一种方法和系统，用于测量，保证和减少主系统与一个或多个备用系统之间的复制数据滞后时间。 每个备用系统确定在主系统上生成一致版本的数据与在备用系统上应用一致版本的时间之间的滞后时间。 应用程序可以请求并保证从查询时与主系统上的状态相同的备用系统接收数据，或仅以最大可容忍的数量滞后于主状态。 备用系统还可以发布保证最大延迟时间的服务，并且当实际滞后时间超过保证滞后时间时撤回服务报价。 还讨论了实现同步和异步复制以及性能优化的意义。