公开(公告)号：US20100174802A1

公开(公告)日：2010-07-08

申请号：US12350182

申请日：2009-01-07

申请人： Wilson Chan ,  Angelo Pruscino ,  Michael Zoll

发明人： Wilson Chan ,  Angelo Pruscino ,  Michael Zoll

IPC分类号： G06F15/16

CPC分类号： G06F17/30362

摘要： Described herein are techniques for using super masters to coordinate accesses by nodes in a database server cluster to data stored in a database. In many cases, the number of inter-nodal messages is reduced, thereby saving the overheads attendant to coordinating accesses in such a system.

摘要翻译： 这里描述的是使用超级主人来协调数据库服务器集群中的节点到存储在数据库中的数据的访问的技术。 在许多情况下，减少节点间消息的数量，从而节省了在这种系统中协调访问的开销。

公开(公告)号：US20060288144A1

公开(公告)日：2006-12-21

申请号：US11156318

申请日：2005-06-16

申请人： Wilson Chan ,  Angelo Pruscino ,  Stefan Roesch ,  Michael Zoll ,  Tolga Yurek ,  Eugene Ho

发明人： Wilson Chan ,  Angelo Pruscino ,  Stefan Roesch ,  Michael Zoll ,  Tolga Yurek ,  Eugene Ho

IPC分类号： G06F12/14

CPC分类号： G06F9/526 ,  G06F2209/522 ,  Y10S707/99938

摘要： Techniques are described herein for handling lock-related inconsistencies. As mentioned above, such inconsistencies occur when two or more sets of lock information, relating to the same resource, convey inconsistent information about locks requested and/or granted on that resource. In general, the techniques involve causing the locally-stored lock information about a resource to be sent to the master node of the resource. The master node of the resource compares the lock information thus received against the lock information maintained by the master node. Based on the comparison, the master node determines how to resolve the lock-related inconsistency, and sends messages to those nodes that need to change their local lock information for the resource. Once all of the lock information has been made consistent, the resource made available for access. Because the lock-related inconsistency is resolved without restarting nodes, the availability required to correct the inconsistency.

摘要翻译： 本文描述了处理与锁相关的不一致性的技术。 如上所述，当与相同资源相关的两组或多组锁定信息传达关于在该资源上请求和/或授予的锁定的不一致的信息时，会发生这种不一致。 一般来说，这些技术涉及将关于资源的本地存储的锁定信息发送到资源的主节点。 资源的主节点将由此接收的锁定信息与由主节点维护的锁定信息进行比较。 基于比较，主节点确定如何解决与锁相关的不一致，并向需要更改其资源的本地锁信息的那些节点发送消息。 一旦所有的锁信息一致，该资源就可用于访问。 由于锁定相关的不一致性在不重新启动节点的情况下得到解决，所以需要更改不一致的可用性。

公开(公告)号：US20060143178A1

公开(公告)日：2006-06-29

申请号：US11024347

申请日：2004-12-27

申请人： Wilson Chan ,  Angelo Pruscino ,  Stefan Roesch ,  Michael Zoll

发明人： Wilson Chan ,  Angelo Pruscino ,  Stefan Roesch ,  Michael Zoll

IPC分类号： G06F17/30 ,  G06F7/00

CPC分类号： G06F17/30362 ,  Y10S707/99938 ,  Y10S707/99939

摘要： Techniques are provided for mastering resources by assigning resources to mastery-eligible-sets. The resources that are assigned to a mastery-eligible-set may be mastered only at nodes that belong to the mastery-eligible-set. The membership of a mastery-eligible-set for a given set of related resources may be established based on which nodes have the highest affinity for the given set of related resources. Resource usage may be monitored, and the system may be periodically reconfigured, by changing membership of the mastery-eligible-sets, based on the usage information.

摘要翻译： 提供了通过将资源分配给符合资格的资源来掌握资源的技术。 分配给精通符合资格的资源的资源只能在属于掌握资格的资源集合的节点上掌握。 可以基于哪些节点对给定的一组相关资源具有最高的亲和力来建立针对给定的一组相关资源的精通符合资格的成员资格。 可以监视资源使用情况，并且可以通过基于使用信息来改变掌握资格的集合的成员资格来周期性地重新配置系统。

公开(公告)号：US08370318B2

公开(公告)日：2013-02-05

申请号：US12340569

申请日：2008-12-19

申请人： Wilson Chan ,  Angelo Pruscino ,  Michael Zoll

发明人： Wilson Chan ,  Angelo Pruscino ,  Michael Zoll

IPC分类号： G06F17/00

CPC分类号： G06F9/52 ,  G06F17/30362

摘要： Described herein are techniques for time limited lock ownership. In one embodiment, in response to receiving a request for a lock on a shared resource, the lock is granted and a lock lease period associated with the lock is established. Then, in response to determining that the lock lease period has expired, one or more lock lease expiration procedures are performed. In many cases, the time limited lock ownership may prevent system hanging, timely detect system deadlocks, and/or improve overall performance of the database.

公开(公告)号：US20070043728A1

公开(公告)日：2007-02-22

申请号：US11282327

申请日：2005-11-18

申请人： Wilson Chan ,  Angelo Pruscino ,  Stefan Roesch ,  Michael Zoll ,  Tolga Yurek

发明人： Wilson Chan ,  Angelo Pruscino ,  Stefan Roesch ,  Michael Zoll ,  Tolga Yurek

IPC分类号： G06F17/30 ,  G06F7/00

CPC分类号： G06F11/2046 ,  G06F11/203 ,  G06F11/2033 ,  G06F11/2035 ,  G06F11/30 ,  G06F2201/825 ,  Y10S707/99939 ,  Y10S707/99942 ,  Y10S707/99953

摘要： Techniques are provided for responding to the termination of a node executing one or more transactions by selecting another node to complete the transactions, and assigning to the selected node the affinity relationships that existed between the terminated node and the objects being accessed by said transactions.

摘要翻译： 提供了通过选择另一个节点来完成事务来响应执行一个或多个事务的节点的终止的技术，并且向所选择的节点分配存在于所终止的节点和被所述事务访问的对象之间的亲和度关系。

公开(公告)号：US08429657B2

公开(公告)日：2013-04-23

申请号：US12150393

申请日：2008-04-28

申请人： Michael Zoll ,  Angelo Pruscino ,  Wilson Chan

发明人： Michael Zoll ,  Angelo Pruscino ,  Wilson Chan

IPC分类号： G06F9/46

CPC分类号： G06F9/46 ,  G06F9/4818 ,  G06F9/5038 ,  G06F9/524

摘要： Systems, methods, and other embodiments associated with avoiding resource blockages and hang states are described. One example computer-implemented method for a clustered computing system includes determining that a first process is waiting for a resource and is in a blocked state. The resource that the first process is waiting for is identified. A blocking process that is holding the resource is then identified. A priority of the blocking process is compared with a priority the first process. If the priority of the blocking process is lower than the priority of the first process, the priority of the blocking process is increase. In this manner the blocking process can be scheduled for execution sooner and thus release the resource.

摘要翻译： 描述了与避免资源阻塞和挂起状态相关联的系统，方法和其他实施例。 用于集群计算系统的一个示例性计算机实现的方法包括确定第一进程正在等待资源并且处于阻塞状态。 确定第一个进程正在等待的资源。 然后识别持有资源的阻塞进程。 将阻塞进程的优先级与第一进程的优先级进行比较。 如果阻塞进程的优先级低于第一个进程的优先级，阻塞进程的优先级就会增加。 以这种方式，可以更快地将阻塞进程安排进行执行，从而释放资源。

公开(公告)号：US20090271794A1

公开(公告)日：2009-10-29

申请号：US12150393

申请日：2008-04-28

申请人： Michael Zoll ,  Angelo Pruscino ,  Wilson Chan

发明人： Michael Zoll ,  Angelo Pruscino ,  Wilson Chan

IPC分类号： G06F9/46

CPC分类号： G06F9/46 ,  G06F9/4818 ,  G06F9/5038 ,  G06F9/524

摘要： Systems, methods, and other embodiments associated with avoiding resource blockages and hang states are described. One example computer-implemented method for a clustered computing system includes determining that a first process is waiting for a resource and is in a blocked state. The resource that the first process is waiting for is identified. A blocking process that is holding the resource is then identified. A priority of the blocking process is compared with a priority the first process. If the priority of the blocking process is lower than the priority of the first process, the priority of the blocking process is increase. In this manner the blocking process can be scheduled for execution sooner and thus release the resource.

摘要翻译： 描述了与避免资源阻塞和挂起状态相关联的系统，方法和其他实施例。 用于集群计算系统的一个示例性计算机实现的方法包括确定第一进程正在等待资源并且处于阻塞状态。 确定第一个进程正在等待的资源。 然后识别持有资源的阻塞进程。 将阻塞进程的优先级与第一进程的优先级进行比较。 如果阻塞进程的优先级低于第一个进程的优先级，阻塞进程的优先级就会增加。 以这种方式，可以更快地将阻塞进程安排进行执行，从而释放资源。

公开(公告)号：US20100161573A1

公开(公告)日：2010-06-24

申请号：US12340569

申请日：2008-12-19

申请人： Wilson Chan ,  Angelo Pruscino ,  Michael Zoll

发明人： Wilson Chan ,  Angelo Pruscino ,  Michael Zoll

IPC分类号： G06F17/30

CPC分类号： G06F9/52 ,  G06F17/30362

摘要： Described herein are techniques for time limited lock ownership. In one embodiment, in response to receiving a request for a lock on a shared resource, the lock is granted and a lock lease period associated with the lock is established. Then, in response to determining that the lock lease period has expired, one or more lock lease expiration procedures are performed. In many cases, the time limited lock ownership may prevent system hanging, timely detect system deadlocks, and/or improve overall performance of the database.

摘要翻译： 这里描述的是用于限时锁定所有权的技术。 在一个实施例中，响应于接收到对共享资源的锁定的请求，该锁被授予并且与该锁相关联的锁租约期间被建立。 然后，响应于确定锁租约期已经过期，执行一个或多个锁租约期过程。 在许多情况下，限时锁定所有权可能会阻止系统挂起，及时检测系统死锁，和/或提高数据库的整体性能。

公开(公告)号：US07917596B2

公开(公告)日：2011-03-29

申请号：US12350182

申请日：2009-01-07

申请人： Wilson Chan ,  Angelo Pruscino ,  Michael Zoll

发明人： Wilson Chan ,  Angelo Pruscino ,  Michael Zoll

IPC分类号： G06F15/16 ,  G06F12/00

CPC分类号： G06F17/30362

摘要： Described herein are techniques for using super masters to coordinate accesses by nodes in a database server cluster to data stored in a database. In many cases, the number of inter-nodal messages is reduced, thereby saving the overheads attendant to coordinating accesses in such a system.

摘要翻译： 这里描述的是使用超级主人来协调数据库服务器集群中的节点到存储在数据库中的数据的访问的技术。 在许多情况下，减少节点间消息的数量，从而节省了在这种系统中协调访问的开销。

公开(公告)号：US07209990B2

公开(公告)日：2007-04-24

申请号：US11099771

申请日：2005-04-05

申请人： Angelo Pruscino ,  Michael Zoll ,  Wilson Chan

发明人： Angelo Pruscino ,  Michael Zoll ,  Wilson Chan

IPC分类号： G06F13/36 ,  G06F13/362 ,  G06F9/46 ,  G06F12/00

CPC分类号： G06F9/526 ,  Y10S707/99938

摘要： Locks are placed in a convert queue in a way that compensates for queue bias. Rather than always placing a remote lock in a queue at the tail, a remote lock can be placed further up in the queue, and possibly be interleaved with local locks. As a result, remote processes are granted locks more frequently and swiftly. Locks are placed in a convert queue according based on queue placement factors, which are factors accounted for when placing a lock in a queue.

摘要翻译： 锁定以一种补偿队列偏差的方式放置在转换队列中。 而不是总是将远程锁放置在尾部的队列中，远程锁可以进一步放置在队列中，并且可能与本地锁交错。 因此，远程进程被更频繁和迅速地被授予锁定。 根据队列放置因子将锁放置在转换队列中，这些因素是将锁放置在队列中时考虑的因素。