×

Distributed computing system with resource managed database cloning

  • US 9,460,181 B2
  • Filed: 01/12/2016
  • Issued: 10/04/2016
  • Est. Priority Date: 01/23/2015
  • Status: Active Grant
First Claim
Patent Images

1. A computer-driven distributed data storage and management system for cloning database instances, comprising:

  • multiple datacenters comprising first and second datacenters;

    wherein;

    each of the datacenters comprises a plurality of computerized servers and digital data storage;

    each of the servers comprises a digital data processor coupled to the digital data storage;

    the digital data storage of the first datacenter comprises a primary database;

    the digital data storage of the second datacenter comprises a standby database;

    the system further comprising;

    backup database instances constructed by copying data from a corresponding data source comprising the primary or the standby database; and

    a control center coupled to the datacenters comprising a processor, a memory, a store and retrieve module, a cloning module, and other modules, wherein the modules comprise instructions stored in the control center memory that execute on the control center processor to execute operations;

    wherein;

    the store and retrieve module directs the datacenters, including operation of the primary database to store and retrieve data on behalf of remote clients, and operation of the standby database to mirror the primary database for use upon a failover event;

    the cloning module, responsive to receiving or detecting a prescribed command, event trigger, or other occurrence;

    identifies a plurality of the backup database instances and retrieves machine-readable records listing update times when each of the identified backup database instances most recently experienced an update from the backup database instance'"'"'s data source;

    responsive to a first identified backup database instance having an update time within a prescribed period of a second identified backup database instance, where the first identified backup database instance is a most recently updated of the identified backup database instances, selects, as a source instance for cloning, the first or the second identified backup database instances satisfying a prescribed proximity criteria relative to a designated database instance;

    responsive to a difference in update times being greater than the prescribed period for two identified backup databases experiencing most recent updates, selects, as a source instance for cloning, one of the identified backup database instances whose update time is most recent; and

    clones the selected source instance to a target instance.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×