Controlling data lag in a replicated computer system
    1.
    发明授权
    Controlling data lag in a replicated computer system 有权
    控制复制计算机系统中的数据滞后

    公开(公告)号:US08838919B2

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

    申请号:US12871805

    申请日:2010-08-30

    IPC分类号: G06F12/00 G06F11/20 G06F17/30

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

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

    Controlling Data Lag in a Replicated Computer System
    2.
    发明申请
    Controlling Data Lag in a Replicated Computer System 有权
    控制复制计算机系统中的数据滞后

    公开(公告)号:US20120054533A1

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

    申请号:US12871805

    申请日:2010-08-30

    IPC分类号: G06F17/30 G06F11/20 G06F11/07

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

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

    Method for maximizing throughput and minimizing transactions response times on the primary system in the presence of a zero data loss standby replica
    3.
    发明授权
    Method for maximizing throughput and minimizing transactions response times on the primary system in the presence of a zero data loss standby replica 有权
    在存在零数据丢失备用副本的情况下,在主系统上最大化吞吐量并最小化事务响应时间的方法

    公开(公告)号:US08868492B2

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

    申请号:US13161315

    申请日:2011-06-15

    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协议,保证在故障或灾难期间零数据丢失。

    Method For Maximizing Throughput And Minimizing Transaction Response Times On The Primary System In The Presence Of A Zero Data Loss Standby Replica
    4.
    发明申请
    Method For Maximizing Throughput And Minimizing Transaction Response Times On The Primary System In The Presence Of A Zero Data Loss Standby Replica 有权
    在零数据丢失备用副本存在的情况下,最大化吞吐量并最大限度地减少主系统上的事务响应时间的方法

    公开(公告)号:US20120323849A1

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

    申请号:US13161315

    申请日:2011-06-15

    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协议,可以在故障或灾难期间保证零数据丢失。

    Reduced Disk Space Standby
    7.
    发明申请
    Reduced Disk Space Standby 有权
    减少磁盘空间待机

    公开(公告)号:US20120054158A1

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

    申请号:US12871795

    申请日:2010-08-30

    IPC分类号: G06F17/30 G06F12/08

    摘要: A method and system for replicating database data is provided. One or more standby database replicas can be used for servicing read-only queries, and the amount of storage required is scalable in the size of the primary database storage. One technique is described for combining physical database replication to multiple physical databases residing within a common storage system that performs de-duplication. Having multiple physical databases allows for many read-only queries to be processed, and the de-duplicating storage system provides scalability in the size of the primary database storage. Another technique uses one or more diskless standby database systems that share a read-only copy of physical standby database files. Notification messages provide consistency between each diskless system's in-memory cache and the state of the shared database files. Use of a transaction sequence number ensures that each database system only accesses versions of data blocks that are consistent with a transaction checkpoint.

    摘要翻译: 提供了一种用于复制数据库数据的方法和系统。 一个或多个备用数据库副本可用于维护只读查询,并且所需的存储量可在主数据库存储的大小上扩展。 描述了一种将物理数据库复制与驻留在执行重复数据删除的公共存储系统中的多个物理数据库进行组合的技术。 拥有多个物理数据库可以处理许多只读查询,并且重复存储系统提供主数据库存储大小的可扩展性。 另一种技术使用一个或多个共享物理备用数据库文件的只读副本的无盘备用数据库系统。 通知消息提供每个无盘系统的内存缓存与共享数据库文件的状态之间的一致性。 使用事务序列号确保每个数据库系统只能访问与事务检查点一致的数据块版本。

    Reduced disk space standby
    8.
    发明授权

    公开(公告)号:US08589361B2

    公开(公告)日:2013-11-19

    申请号:US12871795

    申请日:2010-08-30

    IPC分类号: G06F17/00

    摘要: A method and system for replicating database data is provided. One or more standby database replicas can be used for servicing read-only queries, and the amount of storage required is scalable in the size of the primary database storage. One technique is described for combining physical database replication to multiple physical databases residing within a common storage system that performs de-duplication. Having multiple physical databases allows for many read-only queries to be processed, and the de-duplicating storage system provides scalability in the size of the primary database storage. Another technique uses one or more diskless standby database systems that share a read-only copy of physical standby database files. Notification messages provide consistency between each diskless system's in-memory cache and the state of the shared database files. Use of a transaction sequence number ensures that each database system only accesses versions of data blocks that are consistent with a transaction checkpoint.