公开(公告)号：US07516221B2

公开(公告)日：2009-04-07

申请号：US10917873

申请日：2004-08-12

申请人： Benny Souder ,  Debashish Chatterjee ,  Lakshminarayanan Chidambaran ,  David Brower ,  Carol Colrain ,  Daniel Semler ,  Christopher A. Kantarjiev ,  James W. Stamos

发明人： Benny Souder ,  Debashish Chatterjee ,  Lakshminarayanan Chidambaran ,  David Brower ,  Carol Colrain ,  Daniel Semler ,  Christopher A. Kantarjiev ,  James W. Stamos

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

CPC分类号： G06F11/3433 ,  G06F9/5027 ,  G06F9/5061 ,  G06F11/3495 ,  G06F2201/80 ,  G06F2201/87 ,  G06F2209/501 ,  H04L29/08279 ,  H04L41/5009 ,  H04L41/5038

摘要： Approaches are used for efficiently and effectively managing the dynamic allocation of resources of multi-node database systems between services provided by the multi-node database server. A service is a category of work that is hosted on the database server. The approaches manage allocation of resources at different levels. For services that use a particular database, the performance realized by the services is monitored. Resources assigned to the database are allocated between these services to ensure performance goals for each are met. Resources assigned to a cluster of nodes are allocated between the databases to ensure that performance goals for all the services that use the databases are met. Resources assigned to a farm of clusters are assigned amongst clusters based on service level agreements and back-end policies. The approach uses a hierarchy of directors to manage resources at the different levels.

摘要翻译： 方法用于在由多节点数据库服务器提供的服务之间有效和有效地管理多节点数据库系统的资源的动态分配。 服务是托管在数据库服务器上的一类工作。 这些方法管理不同层次的资源分配。 对于使用特定数据库的服务，将监视服务实现的性能。 分配给数据库的资源在这些服务之间分配，以确保满足每个服务的性能目标。 分配给节点集群的资源在数据库之间分配，以确保满足使用数据库的所有服务的性能目标。 根据服务级别协议和后端策略，在集群中分配分配给集群场的资源。 该方法使用董事级别来管理不同级别的资源。

公开(公告)号：US20050038834A1

公开(公告)日：2005-02-17

申请号：US10917873

申请日：2004-08-12

申请人： Benny Souder ,  Debashish Chatterjee ,  Lakshminarayanan Chidambaran ,  David Brower ,  Carol Colrain ,  Daniel Semler ,  Christopher Kantarjiev ,  James Stamos

发明人： Benny Souder ,  Debashish Chatterjee ,  Lakshminarayanan Chidambaran ,  David Brower ,  Carol Colrain ,  Daniel Semler ,  Christopher Kantarjiev ,  James Stamos

IPC分类号： G06F17/30

CPC分类号： G06F11/3433 ,  G06F9/5027 ,  G06F9/5061 ,  G06F11/3495 ,  G06F2201/80 ,  G06F2201/87 ,  G06F2209/501 ,  H04L29/08279 ,  H04L41/5009 ,  H04L41/5038

摘要： Approaches are used for efficiently and effectively managing the dynamic allocation of resources of multi-node database systems between services provided by the multi-node database server. A service is a category of work that is hosted on the database server. The approaches manage allocation of resources at different levels. For services that use a particular database, the performance realized by the services is monitored. Resources assigned to the database are allocated between these services to ensure performance goals for each are met. Resources assigned to a cluster of nodes are allocated between the databases to ensure that performance goals for all the services that use the databases are met. Resources assigned to a farm of clusters are assigned amongst clusters based on service level agreements and back-end policies. The approach uses a hierarchy of directors to manage resources at the different levels.

摘要翻译： 方法用于在由多节点数据库服务器提供的服务之间有效和有效地管理多节点数据库系统的资源的动态分配。 服务是托管在数据库服务器上的一类工作。 这些方法管理不同层次的资源分配。 对于使用特定数据库的服务，将监视服务实现的性能。 分配给数据库的资源在这些服务之间分配，以确保满足每个服务的性能目标。 分配给节点集群的资源在数据库之间分配，以确保满足使用数据库的所有服务的性能目标。 根据服务级别协议和后端策略，在集群中分配分配给集群场的资源。 该方法使用董事级别来管理不同级别的资源。

公开(公告)号：US20060064400A1

公开(公告)日：2006-03-23

申请号：US10946749

申请日：2004-09-21

申请人： Alex Tsukerman ,  Carol Colrain ,  Graham Wood ,  Jane Chen ,  Lakshminarayanan Chidambaran ,  Benoit Dageville ,  Gary Ngai ,  Mark Ramacher

发明人： Alex Tsukerman ,  Carol Colrain ,  Graham Wood ,  Jane Chen ,  Lakshminarayanan Chidambaran ,  Benoit Dageville ,  Gary Ngai ,  Mark Ramacher

IPC分类号： G06F17/30

CPC分类号： G06F16/27

摘要： Various embodiments of the invention provide solutions to allow more sophisticated management of the relationship between a database and its clients (which can be, inter alia, end users, business applications, etc.). Merely by way of example, some embodiments can facilitate the management of work requests in a database, as well as the management of the quality-of-service in a database system. In some embodiments, an identification handle may be assigned to a database work request. A database management application can use the identification handle to identify the work request, as well, perhaps, as any related work requests. The identification handle may also identify the database (and/or an instance thereof) and/or a clustered database node, and the identification handle may be transmitted to a mid-tier application, e.g., to notify the mid-tier about the processing of the work request, changes in quality-of service, server availability, etc.

摘要翻译： 本发明的各种实施例提供了解决方案，以允许数据库与其客户端之间的关系（其可以是最终用户，业务应用等）的更为复杂的管理。 仅仅作为示例，一些实施例可以促进对数据库中的工作请求的管理以及数据库系统中的服务质量的管理。 在一些实施例中，可以将识别句柄分配给数据库工作请求。 数据库管理应用程序可以使用识别句柄来识别工作请求，也可以是任何相关的工作请求。 识别句柄还可以识别数据库（和/或其实例）和/或集群数据库节点，并且识别句柄可以被发送到中间层应用，例如，向中层通知关于 工作请求，服务质量的变化，服务器可用性等。

公开(公告)号：US20050038833A1

公开(公告)日：2005-02-17

申请号：US10917715

申请日：2004-08-12

申请人： Carol Colrain ,  Daniel Semler

发明人： Carol Colrain ,  Daniel Semler

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

CPC分类号： G06F11/3495 ,  G06F9/5027 ,  G06F11/3409 ,  G06F11/3433 ,  G06F2201/87 ,  G06F2201/875 ,  G06F2209/501 ,  H04L29/08144 ,  H04L43/0817

摘要： Approaches for manage and measuring workload on computer resources by measuring workload in ways that are independent of physical hardware and that correlate to ways in which it is desirable to measure and manage workload for applications and clients. Specifically, logical abstractions of workload, referred to as services, are defined for a cluster of nodes running a multi-node database server of a database. A service is a category of work hosted on a subset of multi-node database servers, such as work that is performed for an online order entry application. The workload is measured and demarcated by the service no matter which node in a single or multi-node system performs the service, providing a global view of performance realized by the system.

摘要翻译： 通过以独立于物理硬件的方式测量工作负载来管理和衡量计算机资源上的工作负载的方法，并与测量和管理应用程序和客户端的工作负载的方式相关。 具体来说，称为服务的工作负载的逻辑抽象是为运行数据库多节点数据库服务器的节点集群定义的。 服务是托管在多节点数据库服务器子集上的一类工作，例如为在线订单输入应用程序执行的工作。 无论单节点或多节点系统中的哪个节点执行服务，服务都将测量和划分工作负载，从而提供系统实现的性能的全局视图。

公开(公告)号：US07664847B2

公开(公告)日：2010-02-16

申请号：US10917715

申请日：2004-08-12

申请人： Carol Colrain ,  Daniel Semler

发明人： Carol Colrain ,  Daniel Semler

IPC分类号： G06F15/173

CPC分类号： G06F11/3495 ,  G06F9/5027 ,  G06F11/3409 ,  G06F11/3433 ,  G06F2201/87 ,  G06F2201/875 ,  G06F2209/501 ,  H04L29/08144 ,  H04L43/0817

摘要： Approaches for manage and measuring workload on computer resources by measuring workload in ways that are independent of physical hardware and that correlate to ways in which it is desirable to measure and manage workload for applications and clients. Specifically, logical abstractions of workload, referred to as services, are defined for a cluster of nodes running a multi-node database server of a database. A service is a category of work hosted on a subset of multi-node database servers, such as work that is performed for an online order entry application. The workload is measured and demarcated by the service no matter which node in a single or multi-node system performs the service, providing a global view of performance realized by the system.

摘要翻译： 通过以独立于物理硬件的方式测量工作负载来管理和衡量计算机资源上的工作负载的方法，并与测量和管理应用程序和客户端的工作负载的方式相关。 具体来说，称为服务的工作负载的逻辑抽象是为运行数据库多节点数据库服务器的节点集群定义的。 服务是托管在多节点数据库服务器子集上的一类工作，例如为在线订单输入应用程序执行的工作。 无论单节点或多节点系统中的哪个节点执行服务，服务都将测量和划分工作负载，从而提供系统实现的性能的全局视图。

公开(公告)号：US20050256971A1

公开(公告)日：2005-11-17

申请号：US11168967

申请日：2005-06-27

申请人： Carol Colrain ,  Charles Simmons ,  Daniel Semler ,  Stefan Pommerenk ,  Angelo Pruscino

发明人： Carol Colrain ,  Charles Simmons ,  Daniel Semler ,  Stefan Pommerenk ,  Angelo Pruscino

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

CPC分类号： G06F9/5083 ,  G06F9/505 ,  G06F2209/508

摘要： Runtime load balancing of work across a clustered computing system involves servers calculating, and clients utilizing, current service performance grades of each instance in the system. A performance grade for an instance is based on performance metrics for that instance, where the computation used may vary by policy. Examples of possible policies include: (a) using estimated bandwidth as a performance grade, (b) using spare capacity as a performance grade, or (c) using response time as a performance grade. Clients distribute work requests across servers in the system as the requests arrive. Work requests can be distributed according to performance grades, and/or flags associated with the performance grades. Automatically and intelligently directing work requests to the best server instances, based on real-time service performance metrics, minimizes the need to manually relocate work within the clustered system.

摘要翻译： 跨群集计算系统的运行时负载平衡涉及服务器计算，客户端利用系统中每个实例的当前服务性能等级。 实例的性能等级基于该实例的性能指标，其中使用的计算可能因策略而异。 可能的政策示例包括：（a）使用估计带宽作为绩效等级，（b）使用备用容量作为绩效等级，或（c）使用响应时间作为绩效等级。 客户端在请求到达时，通过系统中的服务器分发工作请求。 工作请求可以根据绩效等级和/或与绩效等级相关联的标记进行分发。 基于实时服务性能指标，将工作请求自动和智能地指向最佳服务器实例，最大限度地减少了在群集系统中手动重新定位工作的需要。

公开(公告)号：US20110179173A1

公开(公告)日：2011-07-21

申请号：US12688800

申请日：2010-01-15

申请人： Carol Colrain ,  Andrey Gusev

发明人： Carol Colrain ,  Andrey Gusev

IPC分类号： G06F15/173

CPC分类号： G06F9/5061 ,  G06F2209/505 ,  G06F2209/506

摘要： A method and apparatus is provided for automatically performing an operation for one or more resources of a computing cluster when a conditional dependency is satisfied. The conditional dependency may be based on the operating state, load, performance metric, or performance statistic of one or more other resources. A resource profile for a resource stores a conditional dependency that, when satisfied, causes a centralized policy engine to send a command to the resource or an agent for the resource. The policy engine receives notifications of operating state changes from agents that manage resources in the cluster. The policy engine determines that one or more conditional dependencies is satisfied when one or more resources change state to satisfy conditions specified by the conditional dependencies. The policy engine responds to detecting that a conditional dependency is satisfied by sending a command that causes the dependent resource to change its operating state.

摘要翻译： 提供一种方法和装置，用于当满足条件依赖性时，自动对计算集群的一个或多个资源执行操作。 条件依赖可以基于一个或多个其他资源的操作状态，负载，性能度量或性能统计。 资源的资源配置文件存储条件依赖关系，当满足时，使集中式策略引擎向资源或资源的代理发送命令。 策略引擎从管理群集资源的代理接收操作状态更改的通知。 当一个或多个资源改变状态以满足条件依赖性指定的条件时，策略引擎确定满足一个或多个条件依赖性。 策略引擎响应检测到通过发送使依赖资源改变其操作状态的命令来满足条件依赖性。

公开(公告)号：US07809690B2

公开(公告)日：2010-10-05

申请号：US10891433

申请日：2004-07-13

申请人： Stefan Pommerenk ,  Carol Colrain ,  Wilson Chan ,  Angelo Pruscino

发明人： Stefan Pommerenk ,  Carol Colrain ,  Wilson Chan ,  Angelo Pruscino

IPC分类号： G06F17/30

CPC分类号： G06F11/1469 ,  G06F11/1471 ,  G06F2201/80

摘要： A method and apparatus for selecting one or more instances to perform database recovery is provided. According to one aspect, one or more performance metrics are determined for each instance on each node in a cluster. Based on these performance metrics, which may be weighted to give one or more metrics more significance relative to the other metrics, an overall score is determined for each instance on each surviving node when a node in the cluster fails. One or more instances with the highest of these scores are selected. The selected instances are assigned the task of performing the database recovery process. Because instances best able to handle to database recovery process are selected, the database recovery process consumes less time, thereby making data accessible in less time after a node fails.

摘要翻译： 提供了用于选择一个或多个实例以执行数据库恢复的方法和装置。 根据一个方面，针对集群中的每个节点上的每个实例确定一个或多个性能度量。 基于这些性能度量，其可以被加权以给出相对于其他度量更重要的一个或多个指标，当集群中的节点发生故障时，为每个存活节点上的每个实例确定整体得分。 选择这些分数中最高的一个或多个实例。 所选实例被分配执行数据库恢复过程的任务。 因为选择了能够处理数据库恢复过程的实例，所以数据库恢复过程消耗更少的时间，从而使节点在节点出现故障后更少的时间可以访问数据。

公开(公告)号：US07953860B2

公开(公告)日：2011-05-31

申请号：US10917663

申请日：2004-08-12

申请人： Carol Colrain ,  Rajkumar Irudayaraj

发明人： Carol Colrain ,  Rajkumar Irudayaraj

IPC分类号： G06F15/16

CPC分类号： G06F11/1443 ,  G06F17/30289

摘要： Techniques for fast recovery and/or balancing of connections to a clustered computing system provide management of such connections by determining a number of connections to load balance across nodes and by triggering creation of such connections. In one aspect, a notification of an event regarding the clustered computing system is received by a connection pool manager, a pool of connections to the system is identified based on the notification, and one or more connections from the pool are processed in response to the event. According to an embodiment, the notification comprises the identities of the service, database, server instance and machine that correspond to the event.

摘要翻译： 用于快速恢复和/或平衡与集群计算系统的连接的技术通过确定跨节点之间的负载平衡的连接的数量以及通过触发这种连接的创建来提供对这种连接的管理。 在一个方面，连接池管理器接收到关于群集计算系统的事件的通知，基于该通知来识别到系统的连接池，并且响应于来自池的一个或多个连接进行处理 事件。 根据实施例，通知包括与事件相对应的服务，数据库，服务器实例和机器的身份。

公开(公告)号：US20050262183A1

公开(公告)日：2005-11-24

申请号：US11168968

申请日：2005-06-27

申请人： Carol Colrain ,  Rajkumar Irudayaraj ,  Douglas Surber

发明人： Carol Colrain ,  Rajkumar Irudayaraj ,  Douglas Surber

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

CPC分类号： G06F9/5083 ,  G06F9/505 ,  G06F2209/508

摘要： Runtime connection load balancing of work across connections to a clustered computing system involves the routing of requests for a service, based on the current operational performance of each of the instances that offer the service. A connection is selected from an identified connection pool, to connect to an instance that provides the service for routing a work request. The operational performance of the instances may be represented by performance information that characterizes the response time and/or the throughput of the service that is provided by a particular instance on a respective node of the system, and is relative to other instances that offer the same service.

摘要翻译： 基于提供服务的每个实例的当前操作性能，对群集计算系统的连接进行工作的运行时连接负载平衡包括对服务的请求的路由。 从标识的连接池中选择连接，以连接到提供服务以路由工作请求的实例。 实例的操作性能可以由表征由系统的相应节点上的特定实例提供的服务的响应时间和/或吞吐量的性能信息来表示，并且相对于提供相同的其他实例 服务。