Method and database system for duplicating transactions between remote sites
    1.
    发明授权
    Method and database system for duplicating transactions between remote sites 有权
    用于复制远程站点之间的事务的方法和数据库系统

    公开(公告)号:US07593974B2

    公开(公告)日:2009-09-22

    申请号:US11647201

    申请日:2006-12-29

    IPC分类号: G06F17/30

    摘要: A method for duplicating transactions in a disaster recover system is disclosed. In this method, transactions and queries input to a primary database system are copied to a secondary database system and both database systems execute the queries and save the results permanently to each database, thereby maintaining duplicated data. When executing a query on the primary database system, if the query is a commit, the primary system simultaneously copies uncopied queries placed in a queue to the secondary database system and then executes the query. By using this processing procedure, the invention realizes a disaster recovery system which carries out copying transactions from one site to another site without losing the transactions, while reducing the influence of copy operation on the transaction processing performance.

    摘要翻译: 公开了一种在灾难恢复系统中复制事务的方法。 在这种方法中,将输入到主数据库系统的事务和查询复制到辅助数据库系统,并且两个数据库系统都执行查询并将结果永久保存到每个数据库,从而保留重复的数据。 当在主数据库系统上执行查询时,如果查询是提交,则主系统会同时将放入队列中的未查找的查询复制到辅助数据库系统,然后执行查询。 通过使用该处理过程,本发明实现了在不丢失事务的情况下执行从一个站点到另一站点的复制事务的灾难恢复系统,同时减少了复制操作对事务处理性能的影响。

    Failover method in a redundant computer system with storage devices
    2.
    发明申请
    Failover method in a redundant computer system with storage devices 有权
    具有存储设备的冗余计算机系统中的故障切换方法

    公开(公告)号:US20050050392A1

    公开(公告)日:2005-03-03

    申请号:US10834979

    申请日:2004-04-30

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

    摘要: A high availability database system, subject to a failure causing data corruption in the active server system, may recover valid data prior to the corruption, and use the protected and recovered data to effect a failover. At the time T1 when a stand-by computer system detects the occurrence of a failure, a pair split is done to the data area to protect the data area time T0, just before the occurrence of the failure, and another pair split is done to the log area at the time, where the log area is corrupted or a time T3, where the failover is to take effect without corrupting data, to protect the log area containing data at a given time between time TO and time T3. By using the data and log areas thus protected, the stand-by computer system may take over valid data and log areas of the given time to perform a failover.

    摘要翻译: 高可用性数据库系统受到在活动服务器系统中导致数据损坏的故障的影响,可能会在损坏之前恢复有效数据,并使用受保护和恢复的数据实现故障切换。 在备用计算机系统检测到故障发生的时刻T1,在数据区域进行对分割,以在故障发生之前保护数据区域时间T0,并且另一对分割完成 日志区域损坏的日志区域,或时间T3,故障转移将在不破坏数据的情况下生效,以保护在时间T0到时间T3之间的给定时间内包含数据的日志区域。 通过使用受保护的数据和日志区域,备用计算机系统可以接管给定时间的有效数据和日志区域以执行故障切换。

    Method and database system for duplicating transactions between remote sites
    3.
    发明申请
    Method and database system for duplicating transactions between remote sites 有权
    用于复制远程站点之间的事务的方法和数据库系统

    公开(公告)号:US20070226276A1

    公开(公告)日:2007-09-27

    申请号:US11647201

    申请日:2006-12-29

    IPC分类号: G06F17/30

    摘要: A method for duplicating transactions in a disaster recover system is disclosed. In this method, transactions and queries input to a primary database system are copied to a secondary database system and both database systems execute the queries and save the results permanently to each database, thereby maintaining duplicated data. When executing a query on the primary database system, if the query is a commit, the primary system simultaneously copies uncopied queries placed in a queue to the secondary database system and then executes the query. By using this processing procedure, the invention realizes a disaster recovery system which carries out copying transactions from one site to another site without losing the transactions, while reducing the influence of copy operation on the transaction processing performance.

    摘要翻译: 公开了一种在灾难恢复系统中复制事务的方法。 在这种方法中,将输入到主数据库系统的事务和查询复制到辅助数据库系统,并且两个数据库系统都执行查询并将结果永久保存到每个数据库,从而保留重复的数据。 当在主数据库系统上执行查询时,如果查询是提交,则主系统会同时将放入队列中的未查找的查询复制到辅助数据库系统,然后执行查询。 通过使用该处理过程,本发明实现了在不丢失事务的情况下执行从一个站点到另一站点的复制事务的灾难恢复系统,同时减少了复制操作对事务处理性能的影响。

    Failover method in a redundant computer system with storage devices
    5.
    发明授权
    Failover method in a redundant computer system with storage devices 有权
    具有存储设备的冗余计算机系统中的故障切换方法

    公开(公告)号:US07117393B2

    公开(公告)日:2006-10-03

    申请号:US10834979

    申请日:2004-04-30

    IPC分类号: G06F11/00

    摘要: A high availability database system, subject to a failure causing data corruption in the active server system, may recover valid data prior to the corruption, and use the protected and recovered data to effect a failover. At the time when a stand-by computer system detects occurrence of a failure, a pair split is done to the data area to protect the data area data of time T0, just before the occurrence of the failure, and another pair split is done to the log area at the time, where the log area is corrupted or a time T3, where the failover is to take effect without corrupting data, to protect the log area containing data at a given time between time T0 and time T3. By using the data and log areas thus protected, the stand-by computer system may take over valid data and log areas to perform a failover.

    摘要翻译: 高可用性数据库系统受到在活动服务器系统中导致数据损坏的故障的影响,可能会在损坏之前恢复有效数据,并使用受保护和恢复的数据实现故障切换。 当备用计算机系统检测到故障发生时,对数据区域进行对分割,以在发生故障之前保护时间T 0的数据区域数据,并且另一对分裂完成 到日志区域被破坏的日志区域或时间T 3,其中故障转移将在不破坏数据的情况下生效,以在时间T 0和时间T 3之间的给定时间保护包含数据的日志区域 。 通过使用受保护的数据和日志区域,备用计算机系统可以接管有效的数据和日志区域以执行故障转移。

    Failover method in a clustered computer system
    6.
    发明授权
    Failover method in a clustered computer system 有权
    集群计算机系统中的故障切换方法

    公开(公告)号:US07305578B2

    公开(公告)日:2007-12-04

    申请号:US10942873

    申请日:2004-09-17

    IPC分类号: G06F11/00

    摘要: In a high available clustered computer system, a standby computer starts up takeover preparation procedures at a time when occurrence of a failure is watched in an active computer and failover procedures will be started up from the takeover preparation completion status when the failure is detected in the active computer. Thus, speeding up of failover preparation procedures is realized.With such arrangement, it is possible to realize failover procedures by the hot-standby procedures when a failure occurs in an active computer.

    摘要翻译: 在高可用的集群计算机系统中,备用计算机在活动计算机中观察到发生故障时启动接管准备程序,并且当检测到故障时,将从接管准备完成状态启动故障转移过程 活动电脑 因此,实现了故障切换准备过程的加速。

    Failover method in a clustered computer system
    7.
    发明申请
    Failover method in a clustered computer system 有权
    集群计算机系统中的故障切换方法

    公开(公告)号:US20050198552A1

    公开(公告)日:2005-09-08

    申请号:US10942873

    申请日:2004-09-17

    摘要: In a high available clustered computer system, a standby computer starts up takeover preparation procedures at a time when occurrence of a failure is watched in an active computer and failover procedures will be started up from the takeover preparation completion status when the failure is detected in the active computer. Thus, speeding up of failover preparation procedures is realized. With such arrangement, it is possible to realize failover procedures by the hot-standby procedures when a failure occurs in an active computer.

    摘要翻译: 在高可用的集群计算机系统中,备用计算机在活动计算机中观察到发生故障时启动接管准备程序,并且当检测到故障时,将从接管准备完成状态启动故障转移过程 活动电脑 因此,实现了故障切换准备过程的加速。 通过这样的安排,当在活动计算机中发生故障时,可以通过热备用程序来实现故障切换过程。

    Backup system, program and backup method
    8.
    发明授权
    Backup system, program and backup method 失效
    备份系统,程序和备份方法

    公开(公告)号:US07640276B2

    公开(公告)日:2009-12-29

    申请号:US11132175

    申请日:2005-05-19

    IPC分类号: G06F17/30

    CPC分类号: G06F11/2097 Y10S707/99953

    摘要: Provided is a backup method including a step (S1) of reading a log which is a data update difference, and identifying a data storage area (page) of backup data, a step (S2) of determining high/low reusability of the identified data storage area, a step (S3) of storing a log corresponding to a data storage area determined to be low in reusability in a log storage area preset on a memory, and a step (S4) of applying a log corresponding to a data storage area determined to be high in reusability to the identified data storage area in a cache area set on the memory, and updating the data storage area. Thus, by further reducing the number of I/O times in an external storage system of a standby system which backs up data by log transfer, it is possible to reduce introduction costs of a backup system and its normal-time operation's costs at normal times.

    摘要翻译: 提供了一种备份方法,包括:读取作为数据更新差异的日志的步骤(S1),以及识别备份数据的数据存储区域(页面);确定所识别的数据的高/低可重用性的步骤(S2) 存储与预定在存储器上的日志存储区域中存储对应于确定为可重用性低的数据存储区域的日志的步骤(S3);以及步骤(S4),对应于数据存储区域 被确定为对存储器中设置的高速缓存区域中的识别数据存储区域的可重用性高,并且更新数据存储区域。 因此,通过进一步减少通过日志传送备份数据的备用系统的外部存储系统中的I / O次数,可以降低备用系统的引入成本和正常时间操作的成本 。

    Setup method for disaster recovery system
    9.
    发明授权
    Setup method for disaster recovery system 有权
    灾难恢复系统的安装方法

    公开(公告)号:US07539703B2

    公开(公告)日:2009-05-26

    申请号:US11455751

    申请日:2006-06-20

    IPC分类号: G06F17/30

    摘要: Provided is a technique of setting up a disaster recovery system. In a log-based disaster recovery system including a first site for processing data and a second site for storing a backup of the first site, the first site has a volume where data is stored and a volume that is made quiescent. The disaster recovery system accepts data updates while sequentially copying initial data from the quiescent volume to the second site. A copy of a log of the first site is kept in the second site and is synchronized with the original log. When data of the first site is updated and corresponding initial data has not been copied to the second site, the data to be updated is preferentially copied to the second site. A log is applied to the copied data, thereby matching data of the second site with data of the first site.

    摘要翻译: 提供了一种设置灾难恢复系统的技术。 在基于日志的灾难恢复系统中,包括用于处理数据的第一站点和用于存储第一站点的备份的第二站点,第一站点具有存储数据的卷和静止的卷。 灾难恢复系统接受数据更新,同时将初始数据从静态卷逐次复制到第二个站点。 第一个站点的日志的副本保存在第二个站点中,并与原始日志同步。 当第一站点的数据被更新并且对应的初始数据没有被复制到第二站点时,要更新的数据被优先地复制到第二站点。 将日志应用于复制的数据,从而将第二站点的数据与第一站点的数据进行匹配。

    Data duplication method in a disaster recovery system
    10.
    发明授权
    Data duplication method in a disaster recovery system 有权
    灾难恢复系统中的数据复制方法

    公开(公告)号:US07529964B2

    公开(公告)日:2009-05-05

    申请号:US10930832

    申请日:2004-09-01

    IPC分类号: G06F11/00

    CPC分类号: G06F11/2097 G06F11/1471

    摘要: A recovery of a secondary DB is executed by a log including a update difference of a primary DB, and a command is executed by adding the command to the log and analyzing the log by a secondary site. An operation command execution in the secondary site is applied to the DB having the consistency in the transaction at the same timing as a primary site or an intended timing, by transferring and executing the operation command via the log. In the case that the command is constituted by a snap shot generating instruction, a plurality of volumes of a mirror set forming a secondary storage apparatus are set to a pair state and the secondary DB is written in each of the volumes and synchronized, and the mirror set is set to a split state after the synchronization is finished, whereby a secondary DB is stored.

    摘要翻译: 辅助DB的恢复由包括主DB的更新差异的日志执行,并且通过将命令添加到日志并通过辅助站点分析日志来执行命令。 通过经由日志传送和执行操作命令,在辅助站点中的操作命令执行以与主站点相同的定时或预期定时被应用于事务中具有一致性的DB。 在命令由快照生成指令构成的情况下,形成副存储装置的多个镜像组的集合被设置为成对状态,并且辅助DB被写入每个卷并同步,并且 镜像集在同步完成后设置为分割状态,从而存储辅助数据块。