Utilizing snapshots for access to databases and other applications

• US 9,092,500 B2
• Filed: 03/10/2013
• Issued: 07/28/2015
• Est. Priority Date: 09/03/2009
• Status: Active Grant

• Current Assignee: CommVault Systems Incorporated
• Original Assignee: CommVault Systems Incorporated
• Inventors: Varadharajan, Prakash, Bansod, Ketan, Kumarasamy, Paramasivam, Nallathambi, Vimal Kumar, Vallabhaneni, Brahmaiah
• Primary Examiner(s): TRAN, ANHTAI V
• Application Number:
  US13/792,104
• Publication Number:
  US 20130262387A1
• Time in Patent Office: 870 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 11/3664 Environments for testing or debugging software
• CPC Class Codes: G06F 16/214 Database migration support
• CPC Class Codes: G06F 16/275 Synchronous replication

Abstract

A method and system for utilizing snapshots to provide copies of a database or other application or large data structure to computing devices receives a request for access to a copy of a database, and performs a snapshot of a storage volume containing the requested database. The system then clones the snapshot and mounts the snapshot to a computing device, thus enabling the computing device to access a copy of the database. In some examples, the system automatically updates copies of a database on a scheduled basis (e.g., daily or weekly basis) to refresh a database regularly.

Claims

1. A computing device for providing access to multiple databases within a testing environment, the computing device comprising:

memory having multiple instructions; and

a processor coupled to the memory and configured to, in response to executing the instructions, instruct;

a snapshot component,

wherein the snapshot component is configured to create a clone of a snapshot, and

wherein the snapshot is of a volume of data containing developer build data; and

a management component configured to mount the clone of the snapshot to a virtual machine to provide the virtual machine, within a testing environment, with access to a first and second database,

wherein providing the virtual machine with access to the first database enables the virtual machine to manipulate the clone of the snapshot of the developer build data, without affecting the volume of data containing the developer build data,

wherein providing the virtual machine with access to the second database enables the virtual machine to test the developer build data on production data stored in the second database;

a request component, wherein the request component is configured to provide a user interface to the virtual machine within the test environment that;

lists versions of the developer build data available to be accessed by the virtual machine, and

receives a selection of an available version of the developer build data to be accessed by the virtual machine.

2. The computing device of claim 1, wherein the snapshot component is configured to cause a snapshot mechanism associated with the external array to create the snapshot of the volume of data containing the developer build data.

3. The computing device of claim 1, wherein the management component is configured to implement a prescribed schedule for refreshing the developer build data.

4. The computing device of claim 1, wherein the snapshot component is configured to create a clone of another snapshot, and wherein the other snapshot is of a volume of data containing production data.

5. The computing device of claim 1, wherein the request component is configured to provide a user interface to the virtual machine within the test environment that:

lists version of production data available to be accessed by the virtual machine, and receives a selection of an available version of the production data to be accessed by the virtual machine.

6. At least one non-transitory computer-readable medium whose contents, when executed by a computing device, cause the computing device to perform a method of providing a testing environment, the method comprising:

receiving a request from a testing machine to access a first database within a group of databases,

wherein the first database within the group of databases includes a list of versions of developer build data available to be accessed by the testing machine;

receiving a selection of an available version of the developer build data to be accessed by the testing machine;

performing a snapshot operation of a volume containing the selected version of developer build data to create a snapshot and a clone of the snapshot;

wherein the snapshot enable the testing machine to test the developer build data on production data stored in a second database in the group of databases;

mounting the clone snapshot to the testing machine requesting access to the first database; and

providing the testing machine with access to the first database via the mounted clone snapshot; and

providing the testing machine with access to a second database with production data,

wherein the providing the testing machine with access to the second database enables the testing machine to test developer build data with production data.

7. The computer-readable medium of claim 6, further comprising:

receiving an indication of a database refresh schedule; and

automatically repeating the steps of performing a snapshot operation, cloning a snapshot, mounting a snapshot, and providing access, in accordance with the indicated database refresh schedule.

8. The computer-readable medium of claim 6, further comprising:

capturing and playing back logs to bring the database and the mounted clone snapshot into a synchronized state.

9. The computer-readable medium of claim 6, wherein the volume containing the selected version of developer build data is contained by a storage array in communication with the testing machine over a network;

and

wherein a hardware snapshot mechanism associated with the storage array performs the snapshot operation of the volume containing the requested database.

10. The computer-readable medium of claim 6, wherein the volume containing the selected version of developer build data is contained by a storage array in communication with the computing device over a network;

and

wherein a software snapshot mechanism associated with a data storage system that stores data to the storage array performs the snapshot operation of the volume containing the selected version of developer build data.

11. The computer-readable medium of claim 6, further comprising:

deleting the snapshot after the snapshot is dismounted from the testing machine.

12. The computer-readable medium of claim 6, further comprising:

providing a user interface presenting a list of accessible databases within the group of databases;

wherein receiving the request from the testing machine to access the database within the group of databases includes receiving the request via the provided user interface.

13. The computer-readable medium of claim 6, further comprising:

providing a virtual developer build environment accessible from the testing machine,

wherein mounting the clone snapshot to the testing machine includes;

mounting the clone snapshot to a virtual machine in the virtual developers build environment, and

connecting the virtual machine to the testing machine to enable a user of the testing machine to access the clone snapshot.

14. The computer-readable medium of claim 6, wherein providing the testing machine with access to the database via the mounted clone snapshot enables the testing machine to perform quality assurance operations on the database.

15. A method for providing access to a group of databases within a testing environment, the method comprising:

receiving a request from a testing machine to access a first database within a group of databases;

wherein the first database within the group of databases includes list versions of developer build data available to be accessed by the testing machine;

receiving a selection of an available version of the developer build data to be accessed by the testing machine;

performing a snapshot operation of a volume containing the selected version of developer build data to create a snapshot and a clone of the snapshot;

wherein the snapshot is of a volume of data containing developer build data;

mounting the clone snapshot to the testing machine requesting access to the database;

providing the testing machine with access to the first database via the mounted clone snapshot,

wherein providing the testing machine with access to the first database enables the testing machine to manipulate the clone of the snapshot of the developer build data, without affecting the volume of data containing the developer build data;

providing the testing machine with access to a second database within the group of databases,

wherein the second database includes production data that the testing machine can access to test the developer build data.

16. The method of for providing access to a group of databases within a testing environment of claim 15, wherein performing the snapshot operation of a volume containing associates an external array to create the snapshot of the volume of data containing the developer build data.

17. The method of for providing access to a group of databases within a testing environment of claim 15, wherein the management component is configured to implement a prescribed schedule for refreshing the developer build data.

18. The method of for providing access to a group of databases within a testing environment of claim 15, further comprising:

receiving an indication of a database refresh schedule; and

automatically repeating the steps of performing a snapshot operation, cloning a snapshot, mounting a snapshot, and providing access, in accordance with the indicated database refresh schedule.

19. The method of for providing access to a group of databases within a testing environment of claim 15, further comprising:

capturing and playing back logs to bring the database and the mounted clone snapshot into a synchronized state.