SEAMLESS UPGRADES IN A DISTRIBUTED DATABASE SYSTEM
    1.
    发明申请
    SEAMLESS UPGRADES IN A DISTRIBUTED DATABASE SYSTEM 有权
    分布式数据库系统中的无缝升级

    公开(公告)号:US20120239616A1

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

    申请号:US13051967

    申请日:2011-03-18

    IPC分类号: G06F7/00 G06F11/30 G06F17/30

    CPC分类号: G06F17/30578

    摘要: Embodiments are directed to providing distributed database service upgrades of database server instances in a computer cluster using multiple database server instances and to monitoring and maintaining a distributed database service during upgrade. In an embodiment, each computer system in a computer cluster instantiates at least two different database server instances on each of the nodes in the cluster. The first database server instances are configured to operate using a current distributed database version and the second instances are configured to operate using a new, updated distributed database service version. The computer system receives an indication that the distributed database service is to be upgraded. Then, based on the received indication, the computer system migrates database replicas from the first database server instances to the second database server instances which operate the new, updated service version, substantially without user-visible downtime.

    摘要翻译: 实施例旨在使用多个数据库服务器实例在计算机集群中提供数据库服务器实例的分布式数据库服务升级,并在升级期间监视和维护分布式数据库服务。 在一个实施例中,计算机集群中的每个计算机系统在群集中的每个节点上实例化至少两个不同的数据库服务器实例。 第一个数据库服务器实例被配置为使用当前分布式数据库版本进行操作,第二个实例被配置为使用新的更新的分布式数据库服务版本进行操作。 计算机系统接收到分布式数据库服务将被升级的指示。 然后,基于收到的指示,计算机系统将数据库副本从第一数据库服务器实例迁移到操作新的更新服务版本的第二数据库服务器实例,基本上没有用户可见的停机时间。

    Seamless upgrades in a distributed database system
    2.
    发明授权
    Seamless upgrades in a distributed database system 有权
    在分布式数据库系统中进行无缝升​​级

    公开(公告)号:US08326800B2

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

    申请号:US13051967

    申请日:2011-03-18

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30578

    摘要: Embodiments are directed to providing distributed database service upgrades of database server instances in a computer cluster using multiple database server instances and to monitoring and maintaining a distributed database service during upgrade. In an embodiment, each computer system in a computer cluster instantiates at least two different database server instances on each of the nodes in the cluster. The first database server instances are configured to operate using a current distributed database version and the second instances are configured to operate using a new, updated distributed database service version. The computer system receives an indication that the distributed database service is to be upgraded. Then, based on the received indication, the computer system migrates database replicas from the first database server instances to the second database server instances which operate the new, updated service version, substantially without user-visible downtime.

    摘要翻译: 实施例旨在使用多个数据库服务器实例在计算机集群中提供数据库服务器实例的分布式数据库服务升级,并在升级期间监视和维护分布式数据库服务。 在一个实施例中,计算机集群中的每个计算机系统在群集中的每个节点上实例化至少两个不同的数据库服务器实例。 第一个数据库服务器实例被配置为使用当前分布式数据库版本进行操作,第二个实例被配置为使用新的更新的分布式数据库服务版本进行操作。 计算机系统接收到分布式数据库服务将被升级的指示。 然后,基于收到的指示,计算机系统将数据库副本从第一数据库服务器实例迁移到操作新的更新服务版本的第二数据库服务器实例,基本上没有用户可见的停机时间。

    Distributed transactional deadlock detection
    3.
    发明申请
    Distributed transactional deadlock detection 审中-公开
    分布式事务死锁检测

    公开(公告)号:US20080282244A1

    公开(公告)日:2008-11-13

    申请号:US11800675

    申请日:2007-05-07

    IPC分类号: G06F9/46

    CPC分类号: G06F9/524

    摘要: Aspects of the subject matter described herein relate to deadlock detection in distributed environments. In aspects, nodes that are part of the environment each independently create a local wait-for graph. Each node transforms its local wait-for graph to remove non-global transactions that do not need resources from multiple nodes. Each node then sends its transformed local wait-for graph to a global deadlock monitor. The global deadlock monitor combines the local wait-for graphs into a global wait-for graph. Phantom deadlocks are detected and removed from the global wait-for graph. The global deadlock monitor may then detect and resolve deadlocks that involve global transactions.

    摘要翻译: 本文所述主题的方面涉及分布式环境中的死锁检测。 在方面,作为环境一部分的节点各自独立地创建本地等待图。 每个节点转换其本地等待图,以去除不需要多个节点资源的非全局事务。 然后,每个节点将其转换的本地等待图发送到全局死锁监视器。 全局死锁监视器将本地等待图形合并到全局等待图中。 从全局等待图中检测并删除幻像死锁。 然后,全局死锁监视器可以检测并解决涉及全局事务的死锁。

    Buffer Pool Extension for Database Server
    5.
    发明申请
    Buffer Pool Extension for Database Server 有权
    数据库服务器缓冲池扩展

    公开(公告)号:US20110219169A1

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

    申请号:US12717139

    申请日:2010-03-04

    IPC分类号: G06F12/00 G06F12/02 G06F17/00

    摘要: Aspects of the subject matter described herein relate to a buffer pool for a database system. In aspects, secondary memory such as solid state storage is used to extend the buffer pool of a database system. Thresholds such as hot, warm, and cold for classifying pages based on access history of the pages may be determined via a sampling algorithm. When a database system needs to free space in a buffer pool in main memory, a page may be evicted to the buffer pool in secondary memory or other storage based on how the page is classified and conditions of the secondary memory or other storage.

    摘要翻译: 本文描述的主题的方面涉及数据库系统的缓冲池。 在方面,诸如固态存储的辅助存储器用于扩展数据库系统的缓冲池。 可以通过采样算法来确定基于页面访问历史的用于对页面进行分类的诸如热,暖和冷等的阈值。 当数据库系统需要释放主内存中的缓冲池中的空间时,可能会根据页面的分类和辅助内存或其他存储的条件,将页面逐出驱动到辅助内存或其他存储中的缓冲池。

    Partitioning of contended synchronization objects
    6.
    发明授权
    Partitioning of contended synchronization objects 有权
    竞争同步对象的分区

    公开(公告)号:US08103638B2

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

    申请号:US12436805

    申请日:2009-05-07

    IPC分类号: G06F7/00 G06F17/00

    CPC分类号: G06F17/30486

    摘要: Methods, systems, and computer-readable media are disclosed for partitioning contended synchronization objects. A particular method determines a contention-free value of a performance metric associated with a synchronization object of a data structure. A contended value of the performance metric is measured, and the synchronization object is partitioned when the contended value of the performance metric exceeds a multiple of the contention-free value of the performance metric.

    摘要翻译: 公开了用于划分竞争的同步对象的方法,系统和计算机可读介质。 特定方法确定与数据结构的同步对象相关联的性能度量的无争用值。 测量性能度量的竞争值,并且当性能度量的竞争值超过性能度量的无争用值的倍数时,同步对象被分区。

    Computing device resource scheduling
    7.
    发明授权
    Computing device resource scheduling 有权
    计算设备资源调度

    公开(公告)号:US08087028B2

    公开(公告)日:2011-12-27

    申请号:US11770716

    申请日:2007-06-28

    IPC分类号: G06F9/46

    CPC分类号: G06F9/4881

    摘要: Systems and methods for scheduling computing device resources include a scheduler that maintains multiple queues. Requests are placed in one of the multiple queues depending on how much resource time the requests are to receive and when they are to receive it. The queue that a request is placed into depends on a pool bandwidth defined for a pool that includes the request and a bandwidth request. A request has an importance associated therewith that is taken into account in the scheduling process. The scheduler proceeds through the queues in a sequential and circular fashion, taking a work item from a queue for processing when that queue is accessed.

    摘要翻译: 用于调度计算设备资源的系统和方法包括维护多个队列的调度器。 请求被放置在多个队列中的一个队列中,具体取决于请求的接收资源时间和接收时间。 请求被放置的队列取决于为包含请求和带宽请求的池定义的池带宽。 请求具有与调度过程相关联的重要性。 调度器以顺序和循环的方式进行队列,从队列中获取工作项,以便在访问该队列时进行处理。

    DISTRIBUTED COMMUNICATIONS BETWEEN DATABASE INSTANCES
    8.
    发明申请
    DISTRIBUTED COMMUNICATIONS BETWEEN DATABASE INSTANCES 审中-公开
    数据库实现之间的分布式通信

    公开(公告)号:US20100185714A1

    公开(公告)日:2010-07-22

    申请号:US12353992

    申请日:2009-01-15

    IPC分类号: G06F17/30

    CPC分类号: G06F16/27

    摘要: A database communication system is described herein that structures communications in a way that provides lower overhead tracking, statistics, semantics for closing a communication, and reliability. The system provides communication namespaces that organize communications by component, purpose, and instance, which allow database servers to implicitly create communication-related objects without central coordination. The database communication system enables group-based communications that streamline the development of complex distributed components and protocols by providing creation and management of communications namespaces, centralized cleanup support, and centralized monitoring. These features allow the system to be highly distributed, with no one single coordinator of operations, and still provide reliable communications. Thus, the system allows databases to be spread across multiple servers while keeping the burden on database server developers of managing communications between the servers low.

    摘要翻译: 本文描述了以提供较低开销跟踪,统计,用于关闭通信的语义和可靠性的方式来构造通信的数据库通信系统。 系统提供通过组件,目的和实例组织通信的通信命名空间,这允许数据库服务器隐含地创建与中心协调的通信相关的对象。 数据库通信系统通过提供通信命名空间,集中清理支持和集中监控的创建和管理,实现了基于组的通信,从而简化了复杂分布式组件和协议的开发。 这些功能允许系统高度分布,没有一个单一的操作协调器,并且仍然提供可靠的通信。 因此,该系统允许数据库跨多个服务器分布,同时保持数据库服务器开发人员负责管理服务器之间的通信的负担。

    COMPUTING DEVICE RESOURCE SCHEDULING
    9.
    发明申请
    COMPUTING DEVICE RESOURCE SCHEDULING 有权
    计算设备资源调度

    公开(公告)号:US20080222643A1

    公开(公告)日:2008-09-11

    申请号:US11770716

    申请日:2007-06-28

    IPC分类号: G06F9/46

    CPC分类号: G06F9/4881

    摘要: Systems and methods for scheduling computing device resources include a scheduler that maintains multiple queues. Requests are placed in one of the multiple queues depending on how much resource time the requests are to receive and when they are to receive it. The queue that a request is placed into depends on a pool bandwidth defined for a pool that includes the request and a bandwidth request. A request has an importance associated therewith that is taken into account in the scheduling process. The scheduler proceeds through the queues in a sequential and circular fashion, taking a work item from a queue for processing when that queue is accessed.

    摘要翻译: 用于调度计算设备资源的系统和方法包括维护多个队列的调度器。 请求被放置在多个队列中的一个队列中,具体取决于请求的接收资源时间和接收时间。 请求被放置的队列取决于为包含请求和带宽请求的池定义的池带宽。 请求具有与调度过程相关联的重要性。 调度器以顺序和循环的方式进行队列,从队列中获取工作项,以便在访问该队列时进行处理。

    Buffer pool extension for database server
    10.
    发明授权
    Buffer pool extension for database server 有权
    数据库服务器的缓冲池扩展

    公开(公告)号:US08712984B2

    公开(公告)日:2014-04-29

    申请号:US12717139

    申请日:2010-03-04

    IPC分类号: G06F17/30

    摘要: Aspects of the subject matter described herein relate to a buffer pool for a database system. In aspects, secondary memory such as solid state storage is used to extend the buffer pool of a database system. Thresholds such as hot, warm, and cold for classifying pages based on access history of the pages may be determined via a sampling algorithm. When a database system needs to free space in a buffer pool in main memory, a page may be evicted to the buffer pool in secondary memory or other storage based on how the page is classified and conditions of the secondary memory or other storage.

    摘要翻译: 本文描述的主题的方面涉及数据库系统的缓冲池。 在方面,诸如固态存储的辅助存储器用于扩展数据库系统的缓冲池。 可以通过采样算法来确定基于页面访问历史的用于对页面进行分类的诸如热,暖和冷等的阈值。 当数据库系统需要释放主内存中的缓冲池中的空间时,可能会根据页面的分类和辅助内存或其他存储的条件,将页面逐出驱动到辅助内存或其他存储中的缓冲池。