公开(公告)号：US20150324354A1

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

申请号：US14273192

申请日：2014-05-08

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Nicolas Michael ,  Jean De Lavarene ,  Tong Zhou

IPC: G06F17/30

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.

Abstract translation: 一种用于计划将服务连接从第一数据库实例迁移到群集数据库中的第二数据库实例的系统和方法。 根据实施例，数据源和连接池使软件应用程序能够访问第一数据库实例上的服务。 数据源与指定计划排水延迟的参数相关联，以及指定计划排水期的参数，用于在重新定位服务时重新平衡连接。 当在第一数据库实例上停止服务时，连接池从通知服务接收到“服务关闭”事件，并将连接维持到与计划排水延迟相对应的时间。 当接收到“服务启动”事件时，连接池将连接从第一个数据库实例迁移到第二个数据库实例在计划排放期间。