System and method for planned migration of service connections

Patent metadata

Field	Value
Publication number	US-9678995-B2
Application number	US-201414273192-A
Country	US
Kind code	B2
Filing date	May 8, 2014
Priority date	Jun 6, 2013
Publication date	Jun 13, 2017
Grant date	Jun 13, 2017

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.

First claim

What is claimed is:

1. A system for a planned migration of service connections in a clustered database, comprising:
one or more computers with one or more processors;
a clustered database including first and second database instances and a notification service associated therewith, wherein the notification service broadcasts notifications that describe state changes in the clustered database;
an application server that includes a data source and a connection pool associated therewith, wherein the connection pool provides a plurality of connections that an application uses to connect to the first database instance for a service thereon, and wherein the data source is associated with parameters including a delay-for-planned-draining parameter and a planned-draining-period parameter for rebalancing the plurality of connections;
wherein upon receiving a notification event that the service is stopped on the first database instance, the connection pool delays migrating the plurality of connections for up to a period of delay defined by the delay-for-planned-draining parameter, and during the period of delay, the connection pool continues allocating idle connections from the connection pool to the software application; and
wherein upon receiving a notification event indicating the service is up on the second database instance, the connection pool is operable to spread migrating the plurality of connections from the first to the second database instance over a time period defined by the planned-draining-period parameter.

2. The system of claim 1 , wherein the connection pool is a Universal Connection Pool (UCP) that provides access to the clustered database using JDBC.

3. The system of claim 1 , wherein the clustered database is a multi-tenant database that provides a pluggable database (PDB) for a tenant on a single database instance.

4. The system of claim 3 , wherein the service is a singleton service that exposes the PDB for the tenant.

5. The system of claim 1 , wherein the connections in use are migrated after they are returned to the connection pool.

6. The system of claim 1 , wherein if the notification event is not received when the delay-for-planned-draining elapses, the connection pool is operable to close the plurality of connections to the first database instance.

7. The system of claim 1 , wherein the migration of the plurality of connections in the connection pools are equally spread over the time period defined by the planned-draining-period parameter.

8. The system of claim 1 , wherein the connection pool does not receive the notification event indicating the service is up on the second database instance when the time period defined by the delay-for-planned-draining parameter elapses, each of the plurality of connections to the service on the first database instance are closed.

9. The system of claim 1 , wherein the notification event indicating the service is up on the second database instance is received within the period of delay specified by the delay-for-planned-draining parameter, the connection pool immediately starts to migrate the idle connections.

10. A computer-implemented method for a planned migration of service connections in a database cluster, comprising:
providing a clustered database including first and second database instances and a notification service associated therewith, wherein the notification service broadcasts notifications that describe state changes in the clustered database;
providing an application server executing on one or more microprocessors, wherein the application server includes a data source and a connection pool associated therewith,
wherein the connection pool provides a plurality of connections that a software application uses to connect to the first database instance for a service thereon, and
wherein the data source is associated with parameters including a delay-for-planned-draining parameter and a planned-draining-period parameter for rebalancing the plurality of connections;

delaying, by the connection pool, migrating the plurality of connections for up to a period of delay defined by the delay-for-planned draining parameter in response to receiving a notification event that the service is stopped on the first database instance, wherein the connection pool continues allocating idle connections from the connection pool to the software application during the period of delay;
receiving, from the notification service, a notification event indicating the service is up on the second database instance; and
spreading migrating the plurality of connections from the first to the second database instance over a time period defined by the planned-draining-period parameter.

11. The method of claim 10 , wherein the connection pool is a Universal Connection Pool (UCP) that provides access to the clustered database using JDBC.

12. The method of claim 10 , wherein the clustered database is a multi-tenant database that provides a pluggable database (PDB) for a tenant on a single database instance.

13. The method of claim 12 , wherein the service is a singleton service that exposes the PDB for the tenant.

14. The method of claim 10 , wherein the connections in use are migrated after they are returned to the connection pool.

15. The method of claim 10 , wherein if the notification event is not received when the delay-for-planned-draining elapses, the connection pool is operable to close the plurality of connections to the first database instance.

16. The method of claim 10 , wherein the migration of the plurality of connections in the connection pools are equally spread over the time period defined by the planned-draining-period parameter.

17. The method of claim 10 , wherein the connection pool does not receive the notification event indicating the service is up on the second database instance when the time period defined by the delay-for-planned-draining parameter elapses, each of the plurality of connections to the service on the first database instance are closed.

18. A non-transitory computer readable medium, including instructions stored thereon which when read and executed by one or more computers cause the one or more computers to perform the steps comprising:
configuring a clustered database including first and second database instances and a notification service associated therewith, wherein the notification service broadcasts notifications that describe state changes in the clustered database;
configuring an application server executing on one or more microprocessors, wherein the application server includes a data source and a connection pool associated therewith,
wherein the connection pool provides a plurality of connections that a software application uses to connect to the first database instance for a service thereon, and
wherein the data source is associated with parameters including a delay-for-planned-draining parameter and a planned-draining-period parameter for rebalancing the plurality of connections;

delaying, by the connection pool, migrating the plurality of connections for up to a period of delay defined by the delay-for-planned draining parameter in response to receiving a notification event that the service is stopped on the first database instance, wherein the connection pool continues allocating idle connections from the connection pool to the software application during the period of delay;
receiving, from the notification service, a notification event indicating the service is up on the second database instance; and
spreading migrating the plurality of connections from the first

Assignees

• Oracle Int Corp

Inventors

• Michael Nicolas
• De Lavarene Jean
• Zhou Tong

Classifications

• G06F12/0813

  with a network or matrix configuration · CPC title

• G06F2212/465

  Structured object, e.g. database record · CPC title

• G06F12/0868 Primary

  Data transfer between cache memory and other subsystems, e.g. storage devices or host systems · CPC title

• G06F16/214 Primary

  Database migration support · CPC title

• G06F12/0815

  Cache consistency protocols · CPC title