Oracle International Corporation

Rajkumar Arockia Irudayaraj

Carol L Colrain

Michael Zoll

Douglas N Surber

Logan O'Sullivan Bruns

Vladimir Begun

Naresh Revanuru

Tong Zhou

Sunil Kunisetty

Stephen Felts

Alex Somogyi

Frances Zhao-Perez

Stephen Mark Andrew Clark

Richard Ou

A method and apparatus is provided for dynamically generating data to dataset mappings and dataset to logical instance mappings and distributing these mappings to subscribers for the purpose of routing work. An advisory engine updates the mappings of data to data sets based at least in part on changing demands and patterns of access to data, and updates the mappings of datasets to logical instances based at least in part on anticipated capacity and change in conditions of the database servers. The subscribers receive and store the mapping information that maps the data to dataset identifiers, and dataset identifiers to logical database instances. The subscribers may also receive information that describes the current availability conditions of database instances, which are used to override the mapping of logical database instances to physical database instances. Subscribers may use the data to dataset mapping to map data identified from in an incoming database request to a dataset. Subscribers may use the dataset to logical instance mapping to map a dataset to a possible database server, and the logical instance to physical instance mapping to map a possible database server to an available database server. In this manner, the subscribers may route data efficiently even when access patterns and server conditions change.

Adaptively routing transactions to servers

A system and method can support using a data source to connect an application server with a clustered database. The clustered database includes a plurality of database instances and is associated with a notification service. The notification service can be used by the clustered database to broadcast notifications that describe a state change in the plurality of database instances. The data source includes a connection pool, which manages a set of connections to the plurality of database instances in the clustered database. The data source operates to register with the notification service to receive notifications on the change of the clustered database, wherein the application server operates to configure and manage connection to the clustered database, adaptively according to the state change of the clustered database at run time.

System and method for using a gridlink data source to connect an application server with a clustered database

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.

Connection pool use of runtime load balancing service performance advisories

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.

Temporal affinity-based routing of workloads

This disclosure describes, generally, methods and systems for managing connections within a connection pool. The method includes initializing a plurality of connections. The plurality of connections are configured to pierce a firewall. The method further includes placing the plurality of connections in a connection pool, and storing creation times for each of the plurality of connections. The method then determines the firewall's connection teardown time period and, based at least in part on the firewall's connection teardown time period, setting the connection pool's connection teardown time period to be at least less than the firewall's connection teardown time period.

Methods and systems for automatic removal and replacement of connections in a pool rendered stale by a firewall

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.

Fast reorganization of connections in response to an event in a clustered computing system

Techniques for obtaining a closest match connection to a resource (e.g., a database) from a cache are provided. The request specifies desired attribute values for the connection and a closest match connection is identified. The attributes can have associated weights that are utilized in order to determine the closest match connection to satisfy the connection request.

Weighted attributes on connections and closest connection match from a connection cache

Techniques for implicitly caching connections to a resource (e.g., a database) are provided. A request for a connection does not specify that available connections are stored in a cache. If available connections are stored in a cache, the connection to the resource is obtained from the cache. Otherwise, a new connection to the resource is opened directly, without a connection caching mechanism.

Implicit connection caching

Techniques for utilizing a time-to-live timeout on a logical connection to a resource (e.g., a database) from a cache are provided. When a logical connection to the resource is obtained, a timeout is set specifying the amount of time the logical connection can be utilized. If the timeout expires, the logical connection is closed and the underlying physical connection can be returned to the cache.

Growing community of inventors

Mountain View, CA, United States of America

Rajkumar Arockia Irudayaraj