Failover and resume when using ordered sequences in a multi-instance database environment

    公开(公告)号:US09910893B2

    公开(公告)日:2018-03-06

    申请号:US13309300

    申请日:2011-12-01

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F17/3048

    摘要: An approach is disclosed for implementing failover and resume when using ordered sequences in a multi-instance database environment. The approach commences by instantiating a first database instance initially to serve as an active instance, then instantiating a second database instance to serve as an instance of one or more passive instances. The active database establishes mastership over a sequence and then processes requests for the ‘next’ symbol by accessing a shared sequence cache only after accessing a first instance semaphore. The active instance and the passive instance perform a protocol such that upon passive database detection of a failure of the active database, one of the passive database instances takes over mastership of the sequence cache, and then proceeds to satisfy sequence value requests. The particular order is observed in spite of the failure.

    TEMPORAL AFFINITY-BASED ROUTING OF WORKLOADS
    32.
    发明申请
    TEMPORAL AFFINITY-BASED ROUTING OF WORKLOADS 有权
    基于临时性的工作流程路由

    公开(公告)号:US20090034537A1

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

    申请号:US11868317

    申请日:2007-10-05

    IPC分类号: H04L12/56

    摘要: Techniques for routing client requests among a group of nodes offering a service are described. A coordinator determines that performance could be improved by using affinity-based routing. In one embodiment, the coordinator calculates a Time-to-Live (TTL) metric whereby clients benefit by returning to the same cache and posts this hint to subscribers. Client's start preserving locality data in an affinity context, such that later requests for a connection can be routed to the location last visited. The coordinator measures the system over subsequent intervals. If the gradient of the goodness (viz service quality and capacity) is stable or improving, then the coordinator continues to advise subscribers to use the affinity-based technique. Alternatively, if the gradient of the goodness is deteriorating, then the coordinator posts advice to the subscribers to stop using the affinity-based technique for any instance during the next intervals.

    摘要翻译: 描述了在提供服务的一组节点之间路由客户端请求的技术。 协调者决定通过使用基于亲和性的路由可以提高性能。 在一个实施例中,协调器计算生存时间(TTL)度量,由此客户端通过返回到相同的高速缓存并且向用户发布该提示而受益。 客户端启动在亲和性上下文中保留位置数据,以便稍后的连接请求可以路由到上次访问的位置。 协调员在随后的时间间隔内测量系统。 如果善意的梯度(服务质量和容量)稳定或改善,协调员将继续建议用户使用基于亲和力的技术。 或者,如果善意的渐变正在恶化,则协调器向订阅者发布建议以在下一间隔期间停止对任何实例使用基于亲和力的技术。