公开(公告)号：US10191922B2

公开(公告)日：2019-01-29

申请号：US14571008

申请日：2014-12-15

Applicant: Oracle International Corporation

Inventor： Nicolas Michael ,  Yixiao Shen

IPC: G06F17/30

Abstract: A method for a live migration in a multitenant clustered database aimed at providing efficient migration of transactional online databases with no service interruption or failed requests and minimal impact on quality of service. The migration is facilitated by a client connection pool, which migrates connections from the source node to the target node using a self-adapting algorithm to control the migration rate. The algorithm calculates a base migration rate according to the relative number of connections transferred to the target node. Once base migration rate is calculated, the algorithm accelerates or throttles the base migration rate based on workload behavior and system load, attempting to minimize impact on the migrated tenant, while keeping overall migration time low.

公开(公告)号：US10178100B2

公开(公告)日：2019-01-08

申请号：US15013268

申请日：2016-02-02

Applicant: Oracle International Corporation

Inventor： Nicolas Michael ,  Yixiao Shen ,  Glenn Faden

IPC: G06F9/00 ,  G06F21/53 ,  H04L29/06 ,  G06F9/54

Abstract: Implementations of PDB Sandboxing in layers and mapping to different operating systems are described. In exemplary implementations, one or more pluggable databases (PDBs) are encapsulated on common container databases to form one or more PDB sandboxes. Encapsulating PDBs forms an isolation boundary layer configured to dynamically regulate security and isolation of the PDB sandboxes. Access by processes and resources to and from the PDBs inside respective PDB sandboxes through the isolation boundary layer, and access within PDB sandboxes, is regulated using dynamic access processes that dynamically vary access to resources and process disposed within and external to the PDB sandboxes.

公开(公告)号：US20170111365A1

公开(公告)日：2017-04-20

申请号：US15013268

申请日：2016-02-02

Applicant: Oracle International Corporation

Inventor： Nicolas Michael ,  Yixiao Shen ,  Glenn Faden

IPC: H04L29/06 ,  G06F17/30

CPC classification number: H04L63/102 ,  G06F9/468 ,  G06F21/53 ,  H04L63/0209

Abstract: Implementations of PDB Sandboxing in layers and mapping to different operating systems are described. In exemplary implementations, one or more pluggable databases (PDBs) are encapsulated on common container databases to form one or more PDB sandboxes. Encapsulating PDBs forms an isolation boundary layer configured to dynamically regulate security and isolation of the PDB sandboxes. Access by processes and resources to and from the PDBs inside respective PDB sandboxes through the isolation boundary layer, and access within PDB sandboxes, is regulated using dynamic access processes that dynamically vary access to resources and process disposed within and external to the PDB sandboxes.

公开(公告)号：US20170116213A1

公开(公告)日：2017-04-27

申请号：US15093506

申请日：2016-04-07

Applicant: Oracle International Corporation

Inventor： Sanket Jain ,  Kumar Rajamani ,  Jaebock Lee ,  Nicolas Michael ,  Yixiao Shen ,  Giridhar Ravipati

IPC: G06F17/30

CPC classification number: G06F16/24566 ,  G06F16/172 ,  G06F16/214 ,  G06F16/258

Abstract: Embodiments provide a migration instruction that effectuates the migration of a pluggable database from a source database server instance to a destination database server instance. Upon receiving the migration instruction, the migrating pluggable database is opened at the destination instance. Connections are terminated at the source instance at a rate that is determined based on statistics maintained for one or more of: the migrating pluggable database, the source instance, the destination instance, a container database, etc. Furthermore, once the migration instruction is received, a certain amount of time is provided before the source instance flushes the dirty buffers for the migrating pluggable database from the buffer cache of the source instance. The delay in flushing dirty buffers from buffer cache allows the source instance to provide data blocks, of the migrating pluggable database, directly to the destination database server instance from the cache.

公开(公告)号：US20160170978A1

公开(公告)日：2016-06-16

申请号：US14571008

申请日：2014-12-15

Applicant: Oracle International Corporation

Inventor： Nicolas Michael ,  Yixiao Shen

IPC: G06F17/30

CPC classification number: G06F17/303

Abstract: A method for a live migration in a multitenant clustered database aimed at providing efficient migration of transactional online databases with no service interruption or failed requests and minimal impact on quality of service. The migration is facilitated by a client connection pool, which migrates connections from the source node to the target node using a self-adapting algorithm to control the migration rate. The algorithm calculates a base migration rate according to the relative number of connections transferred to the target node. Once base migration rate is calculated, the algorithm accelerates or throttles the base migration rate based on workload behavior and system load, attempting to minimize impact on the migrated tenant, while keeping overall migration time low.

Abstract translation: 一种用于多租户群集数据库中实时迁移的方法，旨在提供无需服务中断或失败请求的事务在线数据库的有效迁移，以及对服务质量的最小影响。 迁移由客户端连接池促成，客户端连接池使用自适应算法将连接从源节点迁移到目标节点，以控制迁移速率。 该算法根据传输到目标节点的连接的相对数量来计算基本迁移速率。 一旦计算了基本迁移率，该算法会根据工作负载行为和系统负载来加速或抑制基本迁移率，从而尽可能减少对迁移租户的影响，同时保持总迁移时间较短。

公开(公告)号：US10152354B2

公开(公告)日：2018-12-11

申请号：US15445907

申请日：2017-02-28

Applicant: Oracle International Corporation

Inventor： Jonathan Chew ,  Nicolas Michael ,  Junsang Cho

IPC: G06F9/50 ,  G06F9/48

Abstract: To schedule a software thread for execution on a CPU in a multiprocessor system, a scheduler uses both software and hardware utilization information. For a thread, resource demands (including software and hardware resource demands) are determined based on measuring resource usage while the thread executes on the multiprocessor system without being isolated from any other threads that may run concurrently. For at least two processor cores, resource usage is calculated based on any threads already running on it. The software thread is assigned to a strand in the processor core with optimum available resources given the thread's resource demands.

公开(公告)号：US09678995B2

公开(公告)日：2017-06-13

申请号：US14273192

申请日：2014-05-08

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Nicolas Michael ,  Jean De Lavarene ,  Tong Zhou

IPC: G06F7/00 ,  G06F17/00 ,  G06F17/30 ,  G06F12/0815 ,  G06F12/0813 ,  G06F12/0868

CPC classification number: G06F17/303 ,  G06F12/0813 ,  G06F12/0815 ,  G06F12/0868 ,  G06F17/30345 ,  G06F17/30902 ,  G06F2212/465

Abstract: A system and method for a planned migration of service connections from a first database instance to a second database instance in a clustered database. In accordance with an embodiment, a data source and connection pool enable access by a software application to a service on the first database instance. The data source is associated with a parameter specifying a delay-for-planned-draining, and a parameter specifying a planned-draining-period, which are used to rebalance connections when relocating a service. When a service is stopped on the first database instance, the connection pool receives a “service down” event from a notification service, and maintains the connections up to a time corresponding to the delay-for-planned-draining. When a “service up” event is received, the connection pool spreads migration of the connections from the first to second database instance over the planned-draining-period.

公开(公告)号：US20180246767A1

公开(公告)日：2018-08-30

申请号：US15445907

申请日：2017-02-28

Applicant: Oracle International Corporation

Inventor： Jonathan Chew ,  Nicolas Michael ,  Junsang Cho

IPC: G06F9/50 ,  G06F9/48

CPC classification number: G06F9/5044 ,  G06F9/4843 ,  G06F2209/483 ,  G06F2209/501

Abstract: To schedule a software thread for execution on a CPU in a multiprocessor system, a scheduler uses both software and hardware utilization information. For a thread, resource demands (including software and hardware resource demands) are determined based on measuring resource usage while the thread executes on the multiprocessor system without being isolated from any other threads that may run concurrently. For at least two processor cores, resource usage is calculated based on any threads already running on it. The software thread is assigned to a strand in the processor core with optimum available resources given the thread's resource demands.

公开(公告)号：US09921880B2

公开(公告)日：2018-03-20

申请号：US15009395

申请日：2016-01-28

Applicant: Oracle International Corporation

Inventor： Nicolas Michael ,  Chen Wang ,  Jonathan Chew

IPC: G06F9/50 ,  H04L29/08

CPC classification number: G06F9/5027 ,  G06F9/5033 ,  H04L67/10

Abstract: A system and method for facilitating allocating computing resources to workloads, facilitating workload performance isolation. An example method includes determining one or more workloads to be allocated a set of computing resources in the computing environment, the one or more workloads characterized by metadata describing one or more workload properties; and using the one or more workload properties to calculate a binding between each of the one or more workloads and one or more corresponding portions of the computing resources. Plural competing workloads may be isolated by binding each workload to a disjunct set of Central Processing Units (CPUs) that share as few common hardware resources as possible given a topology the computing resources. Resource allocation adjustments need not require any reconfiguration of the system or adjustment to already provisioned workloads.

公开(公告)号：US20170220389A1

公开(公告)日：2017-08-03

申请号：US15009395

申请日：2016-01-28

Applicant: Oracle International Corporation

Inventor： Nicolas Michael ,  Chen Wang ,  Jonathan Chew

IPC: G06F9/50 ,  H04L29/08

CPC classification number: G06F9/5027 ,  G06F9/5033 ,  H04L67/10

Abstract: A system and method for facilitating allocating computing resources to workloads, facilitating workload performance isolation. An example method includes determining one or more workloads to be allocated a set of computing resources in the computing environment, the one or more workloads characterized by metadata describing one or more workload properties; and using the one or more workload properties to calculate a binding between each of the one or more workloads and one or more corresponding portions of the computing resources. Plural competing workloads may be isolated by binding each workload to a disjunct set of Central Processing Units (CPUs) that share as few common hardware resources as possible given a topology the computing resources. Resource allocation adjustments need not require any reconfiguration of the system or adjustment to already provisioned workloads.