Patent ID: 9678995
Date: 2017-06-13
CPC Classifications: G06F

Claim:
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.