发明名称 Distributed computing system with resource managed database cloning
摘要 In a distributed computing system, cloning operations determine when each of multiple backup database instances most recently experienced an update. If a most recently updated backup database instance was updated within a prescribed time period of one or more other backup database instances, a source instance for cloning is deemed to be one of these database instances satisfying a prescribed proximity criteria relative to a designated database instance. If a difference in update times is greater than the prescribed time period for the two most recent backup database instances, the source instance for cloning is deemed to be the most recently updated backup database instance. The control center conducts cloning to a target instance using the selected backup database instance as a source instance.
申请公布号 US9460181(B2) 申请公布日期 2016.10.04
申请号 US201614993726 申请日期 2016.01.12
申请人 ServiceNow, Inc. 发明人 Wang Paul;Ye Xiaoyi;Lu Xuejia;Chandrashekar Sridhar
分类号 G06F17/30;G06F11/14 主分类号 G06F17/30
代理机构 Young Basile Hanlon & MacFarlane, P.C. 代理人 Young Basile Hanlon & MacFarlane, P.C.
主权项 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; andclones the selected source instance to a target instance.
地址 Santa Clara CA US
您可能感兴趣的专利