UPGRADE OF HETEROGENEOUS MULTI-INSTANCE DATABASE CLUSTERS

摘要

A method, system, and computer program product for management of large multi-database installations. The method form commences by analyzing a multiple database installation to determine a set of candidate upgrade operations to apply to individual instances of heterogeneous databases in the multiple database installation, and then scheduling an order in which order to apply individual operations from among the set of candidate upgrade operations. In exemplary operation, the candidate upgrade operations comprise database version upgrades, database stack upgrades, and/or database listener upgrades. Some embodiments exploit homogeneity and/or groupings in order to parallelize performance of various upgrade operations during mass upgrade of multi-database installations. In addition to performing upgrade operations in the form of database version upgrades, database stack upgrades, and/or database listener upgrades, the installation can be upgraded by receiving application upgrades.

主权项

1. A computer implemented method comprising:
identifying a first set of candidate upgrade operations to be applied to a first set of database system components; identifying a second set of candidate upgrade operations to be applied to a second set of database system components, wherein the first set and the second set of database system components comprise a combination of at least two of, a database component, a middleware component, a listener component, and an application component; analyzing the first set of candidate upgrade operations and the second set of candidate upgrade operations to generate scheduling dependencies; and scheduling an order to apply individual operations from among the set of candidate upgrade operations based at least in part on the scheduling dependencies.