Distributed Computing System With Resource Managed Database Cloning

摘要

When multiple backup database instances most recently experienced an update is determined. If a most recently updated backup database instance was updated within a defined time period of one or more other backup database instances, a source instance for cloning is selected as the backup database instance that satisfies at least one of a physical or logical proximity criteria relative to a designated database instance. If a difference in update times is greater than the defined time period, e.g., for the two most recent backup database instances, the source instance for cloning is selected to be the most recently updated backup database instance. Cloning to a target instance is performed using the selected backup database instance as a source instance as long as preparatory operations all pass. If not, the source databases are used for the cloning while still being accessible to clients.

主权项

1. An apparatus for cloning database instances, comprising:
a control device coupled to computerized servers through a network, the computerized servers comprising at least a first computerized server including a primary database and a second computerized server including a secondary database, and at least some of the computerized servers storing backup database instances respectively constructed by copying data from one of the primary database or the secondary database, the control device comprising: a processor; and machine-readable instructions stored in a non-transitory storage medium that cause the processor to perform a cloning operation by:
identifying a most recently updated one of the backup database instances as a first backup database instance;upon a condition that a time difference between an update time of the first backup database instance and an update time of a second backup database instance is below a defined value, selecting, as a source instance for cloning, one of the first backup database instance or the second backup database instance satisfying at least one of a distance criteria or logical criteria with respect to a designated database instance;upon a condition that the time difference is above the defined value, selecting, as the source instance for cloning, the first backup database instance; andcloning the source instance to a target instance.