INSTANCE RECOVERY USING BLOOM FILTERS
    1.
    发明申请

    公开(公告)号:US20180300204A1

    公开(公告)日:2018-10-18

    申请号:US15489482

    申请日:2017-04-17

    Abstract: Techniques related to instance recovery using Bloom filters are disclosed. A multi-node node database management system (DBMS) includes a first database server instance and a second database server instance. A recovery set includes a set of data blocks that have been modified by a first database server instance and not persisted. A Bloom filter is generated to indicate whether data blocks are excluded from the recovery set. The Bloom filter is sent to the second database server instance, which determines whether the Bloom filter indicates that a particular data block is excluded from the recovery set. Based on determining that the Bloom filter indicates that the particular data block is excluded from the recovery set, access to the particular data block is granted.

    Instance recovery using bloom filters

    公开(公告)号:US10809916B2

    公开(公告)日:2020-10-20

    申请号:US15489482

    申请日:2017-04-17

    Abstract: Techniques related to instance recovery using Bloom filters are disclosed. A multi-node node database management system (DBMS) includes a first database server instance and a second database server instance. A recovery set includes a set of data blocks that have been modified by a first database server instance and not persisted. A Bloom filter is generated to indicate whether data blocks are excluded from the recovery set. The Bloom filter is sent to the second database server instance, which determines whether the Bloom filter indicates that a particular data block is excluded from the recovery set. Based on determining that the Bloom filter indicates that the particular data block is excluded from the recovery set, access to the particular data block is granted.

    Planned cluster node maintenance with low impact on application throughput

    公开(公告)号:US09679004B2

    公开(公告)日:2017-06-13

    申请号:US14337067

    申请日:2014-07-21

    CPC classification number: G06F17/30362

    Abstract: Techniques for taking one or more nodes of a multi-node database system offline are provided. Initially, the multi-node database system uses a first data access management system (e.g., a distributed lock management system) to manage access to data stored in a database. In response to determining that one or more nodes need to be taken offline or otherwise become unavailable, the remaining nodes implement a second data access management system (e.g., an affinity-based access system) to manage access to data stored in the database. After the offline nodes are brought back online, all the nodes in the multi-node database system implement the first data access management system again. The transitions between the two data access management system may involve multiple phases that involve communicating different types of information between nodes that are taken offline and nodes that are not taken offline.

    Automatic recovery of a failed standby database in a cluster
    5.
    发明授权
    Automatic recovery of a failed standby database in a cluster 有权
    自动恢复群集中的故障备用数据库

    公开(公告)号:US09514160B2

    公开(公告)日:2016-12-06

    申请号:US13794112

    申请日:2013-03-11

    CPC classification number: G06F17/30289 G06F17/30575 G06F17/30581

    Abstract: A method, system, and computer program product. The method for non-intrusive redeployment of a standby database facility comprises configuring a database system having a shared lock manager process to synchronize two or more concurrent access instances, then granting lock requests for access to a cache of database blocks. At some moment in time, the shared lock manager process may fail, and a monitor process detects the failure or other stoppage of the shared lock manager process. A new shared lock manager process and other processes are started, at least one of which serves for identifying the database blocks in the cache that have not yet been written to the database. The identified blocks are formed into a recovery set of redo operations. During this time, incoming requests for access to the cache of database blocks are briefly blocked, at least until the recovery set of redo operations has been formed.

    Abstract translation: 一种方法,系统和计算机程序产品。 用于非侵入式重新部署备用数据库设施的方法包括配置具有共享锁管理器进程的数据库系统以同步两个或多个并发访问实例,然后授予对数据库块的高速缓存的锁定请求。 在某个时刻,共享锁管理器进程可能会失败,并且监视进程检测到共享锁管理器进程的故障或其他停止。 启动新的共享锁管理器进程和其他进程,其中至少一个用于识别高速缓存中尚未写入数据库的数据库块。 所识别的块被形成恢复一组重做操作。 在此期间,暂时阻止访问数据库块的缓存的传入请求,至少在恢复组重做操作已经形成之前。

    PLANNED CLUSTER NODE MAINTENANCE WITH LOW IMPACT ON APPLICATION THROUGHPUT
    6.
    发明申请
    PLANNED CLUSTER NODE MAINTENANCE WITH LOW IMPACT ON APPLICATION THROUGHPUT 有权
    计划中的群集节点维护对应用程序的影响很小

    公开(公告)号:US20160019253A1

    公开(公告)日:2016-01-21

    申请号:US14337067

    申请日:2014-07-21

    CPC classification number: G06F17/30362

    Abstract: Techniques for taking one or more nodes of a multi-node database system offline are provided. Initially, the multi-node database system uses a first data access management system (e.g., a distributed lock management system) to manage access to data stored in a database. In response to determining that one or more nodes need to be taken offline or otherwise become unavailable, the remaining nodes implement a second data access management system (e.g., an affinity-based access system) to manage access to data stored in the database. After the offline nodes are brought back online, all the nodes in the multi-node database system implement the first data access management system again. The transitions between the two data access management system may involve multiple phases that involve communicating different types of information between nodes that are taken offline and nodes that are not taken offline.

    Abstract translation: 提供了多节点数据库系统离线的一个或多个节点的技术。 最初,多节点数据库系统使用第一数据访问管理系统(例如,分布式锁管理系统)来管理对存储在数据库中的数据的访问。 响应于确定一个或多个节点需要脱机或以其他方式变得不可用,其余节点实现第二数据访问管理系统(例如,基于关联的接入系统)以管理对存储在数据库中的数据的访问。 离线节点恢复联机后,多节点数据库系统中的所有节点再次实现第一个数据访问管理系统。 两个数据访问管理系统之间的转换可能涉及多个阶段,这些阶段涉及在脱机的节点和未脱机的节点之间传递不同类型的信息。

    Coordinated hash table indexes to facilitate reducing database reconfiguration time

    公开(公告)号:US10296498B2

    公开(公告)日:2019-05-21

    申请号:US15245005

    申请日:2016-08-23

    Abstract: According to embodiments, reconfiguration of lock masters for a cluster of nodes is optimized using coordinated hash indexes to index into the master hash table and into local hash tables stored on the nodes of the cluster. A DBMS uses a hybrid hash index, a portion of which represents a corresponding master hash index, to index into both the master hash table and into a local hash table for a given lock. The hash index used to store lock metadata in a particular local hash table bucket, on a particular node, encodes the lock master index, for a master hash table, to which the locks in the local hash table bucket correspond. Only the portions of the local hash table on the lock master that correspond to the index of the master hash table bucket need to be scanned in order to perform needed tasks for lock master reconfiguration.

Patent Agency Ranking