Back up and recovery in virtual machine environments

• US 9,619,342 B2
• Filed: 06/24/2014
• Issued: 04/11/2017
• Est. Priority Date: 06/24/2014
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: He, Zhengwen, Jandir, Mandeep K., Smith, James P., Yakushev, Mark L., Zaremba, Christopher
• Primary Examiner(s): Rones, Charles
• Assistant Examiner(s): WONG, NANCI N
• Application Number:
  US14/312,738
• Publication Number:
  US 20150370639A1
• Time in Patent Office: 1,022 Days
• CPC Class Codes: G06F 11/1451 by selection of backup contents
• CPC Class Codes: G06F 11/1469 Backup restoration techniques
• CPC Class Codes: G06F 11/1471 involving logging of persistent data for recovery
• CPC Class Codes: G06F 2201/80 Database-specific techniques
• CPC Class Codes: G06F 2201/815 Virtual
• CPC Class Codes: G06F 2201/84 Using snapshots, i.e. a logical point-in-time copy of the data

Abstract

Embodiments of the present invention provide efficient and cost-effective systems and methods for backing up and recovering a virtual machine and application data therein. Embodiments of the present invention can be used to satisfy near-zero RPOs by providing more recovery points for backups in virtual machine environments, while also providing increased granularity for recovery (i.e., single virtual disk, single file, etc.) and maintaining central management capabilities and back up efficiencies offered by virtual machine-level backups.

Claims

1. A computer program product comprising:

one or more computer readable storage media and program instructions stored on the one or more computer readable storage media, the program instructions comprising;

program instructions to identify an application executing in a guest operating system in a virtual machine and log data associated with the application, wherein the log data represents changes to data of SQL database transaction logs that have occurred since a point in time;

program instructions to query a relational data structure to determine when a full backup of the virtual machine has been generated and stored;

program instructions, responsive to generation of the full backup of the virtual machine, to create an incremental backup of the virtual machine;

program instructions to store the incremental backup of the virtual machine;

program instructions to confirm that the full and incremental backups of the virtual machine have been stored in the one or more storage devices, and that the full and incremental backups of the virtual machine are in a data format that is compatible with a data format used to back up the log data, via the relational data structure;

program instructions to create a backup of the log data;

program instructions to store the backup of the log data; and

program instructions to relate in the relational data structure the full and incremental backups of the virtual machine and the backup of the log data.

2. The computer program product of claim 1, wherein the application is a database management program and the log data comprises a transaction log describing modifications made to an SQL database.

3. The computer program product of claim 1, wherein the program instructions to create a backup of the log data associated with the application comprise:

program instructions to execute in the guest operating system, one or more programs to access a file system of the guest operating system; and

program instructions to execute in the guest operating system, one or more programs to copy one or more log files containing the log data.

4. The computer program product of claim 1, wherein the program instructions to create a backup of the log data associated with the application comprise:

program instructions to execute outside of the guest operating system, one or more programs to inject code into the virtual machine to create a backup of the log data associated with the application.

5. The computer program product of claim 1, wherein the program instructions to create a backup of the log data associated with the application comprise:

program instructions to execute outside of the guest operating system, one or more programs to inject code into the virtual machine to invoke a snapshot of the virtual machine; and

program instructions to execute outside of the guest operating system, one or more programs to inject code into the virtual machine to copy the log data from the snapshot of the virtual machine, wherein the log data is associated with the application.

6. The computer program product of claim 1, wherein the program instructions to create a backup of the log data associated with the application comprise:

program instructions to execute outside of the guest operating system, one or more programs to inject code into the virtual machine to invoke a snapshot of one or more virtual disks of the virtual machine on which the log data reside;

program instructions to execute outside of the guest operating system, one or more programs to inject code into the virtual machine to mount the snapshot of the one or more virtual disks of the virtual machine on which the log data reside; and

program instructions to execute outside of the guest operating system, one or more programs to inject code into the virtual machine to copy the log data from the mounted snapshot.

7. The computer program product of claim 1, wherein the program instructions stored on the one or more computer readable storage media further comprise:

program instructions to identify one or more available recovery points for recovering data based on time points associated with backups of the virtual machine stored in the one or more storage devices and backups of the log data stored in the one or more storage devices;

program instructions to receive a selection of an available recovery point from the one or more available recovery points;

program instructions to identify a backup of the virtual machine and a backup of the log data that are needed to satisfy the selected recovery point;

program instructions to receive from the one or more storage devices, the identified backup of the virtual machine and the identified backup of the log data that are needed to satisfy the selected recovery point;

program instructions to mount the identified backup of the virtual machine and initiating recovery of the application; and

program instructions to provide to the application the log data from the identified backup of the log data.

8. A computer system comprising:

one or more computer processors;

one or more computer readable storage media;

program instructions stored on the computer readable storage media for execution by at least one of the one or more processors, the program instructions comprising;

program instructions to identify an application executing in a guest operating system in a virtual machine and log data associated with the application, wherein the log data represents changes to data of SQL database transaction logs that have occurred since a point in time;

program instructions to query a relational data structure to determine when a full backup of the virtual machine has been generated and stored;

program instructions, responsive to generation of the full backup of the virtual machine, to create an incremental backup of the virtual machine;

program instructions to store the incremental backup of the virtual machine;

program instructions to confirm that the full and incremental backups of the virtual machine have been stored in the one or more storage devices and that the full and incremental backups of the virtual machine are in a data format that is compatible with a data format used to back up the log data, via the relational data structure;

program instructions to create a backup of the log data;

program instructions to store the backup of the log data; and

program instructions to relate in the relational data structure the full and incremental backups of the virtual machine and the backup of the log data.

9. The system of claim 8, wherein the application is a database management program and the log data comprises a transaction log describing modifications made to an SQL database.

10. The system of claim 8, wherein the program instructions to create a backup of the log data associated with the application comprise:

program instructions to execute outside of the guest operating system, one or more programs to inject code into the virtual machine to create a backup of the log data associated with the application.

11. The system of claim 8, wherein the program instructions to create a backup of the log data associated with the application comprise:

program instructions to execute outside of the guest operating system, one or more programs to inject code into the virtual machine to invoke a snapshot of the virtual machine; and

program instructions to execute outside of the guest operating system, one or more programs to inject code into the virtual machine to copy the log data from the snapshot of the virtual machine, wherein the log data is associated with the application.

12. The system of claim 8, wherein the program instructions to create a backup of the log data associated with the application comprise:

program instructions to execute outside of the guest operating system, one or more programs to inject code into the virtual machine to invoke a snapshot of one or more virtual disks of the virtual machine on which the log data reside;

program instructions to execute outside of the guest operating system, one or more programs to inject code into the virtual machine to mount the snapshot of the one or more virtual disks of the virtual machine on which the log data reside; and

program instructions to execute outside of the guest operating system, one or more programs to inject code into the virtual machine to copy the log data from the mounted snapshot.

13. The system of claim 8, wherein the program instructions stored on the computer readable storage media for execution by at least one of the one or more processors further comprise:

program instructions to identify one or more available recovery points for recovering data based on time points associated with backups of the virtual machine stored in the one or more storage devices and backups of the log data stored in the one or more storage devices;

program instructions to receive a selection of an available recovery point from the one or more available recovery points;

program instructions to identify a backup of the virtual machine and a backup of the log data that are needed to satisfy the selected recovery point;

program instructions to receive from the one or more storage devices, the identified backup of the virtual machine and the identified backup of the log data that are needed to satisfy the selected recovery point;

program instructions to mount the identified backup of the virtual machine and initiating recovery of the application; and

program instructions to provide to the application the log data from the identified backup of the log data.