Disk group based backup

Patent metadata

Field	Value
Publication number	US-10055300-B2
Application number	US-201614993789-A
Country	US
Kind code	B2
Filing date	Jan 12, 2016
Priority date	Jan 12, 2015
Publication date	Aug 21, 2018
Grant date	Aug 21, 2018

Abstract

Systems and methods for backing up clustered databases such that production backups associated with the clustered databases are restorable with near zero downtime. First data indicative of a backup request of a clustered database is transmitted by a first computing device to a second computing device. The first computing device maps the backup staging disks to each of a plurality of nodes. The second computing device adds the mapped staging disks to a backup staging diskgroup on a primary node. The second computing device mounts the backup staging diskgroup to each of the plurality of nodes. The second computing device executes a full backup from at least one of the plurality of nodes to the backup staging diskgroup. The second computing device transmits a catalog of backup information to a database associated with the first computing device. The first computing device creates a snapshot of the first backup staging disk.

First claim

The invention claimed is:

1. A computerized method of backing up clustered databases such that production backups associated with the clustered databases are restorable with near zero downtime, the method comprising:
transmitting, by a first computing device, first data indicative of a first backup request of a clustered database to a second computing device at a first point in time, the clustered database associated with an application, the clustered database including a plurality of nodes, each of the plurality of nodes including database data from a shared storage associated with the clustered database;
mapping, by the first computing device, first backup staging disks to each of the plurality of nodes;
adding, by the second computing device, the mapped first backup staging disks to a first backup staging diskgroup on a primary node of the plurality of nodes;
mounting, by the second computing device, the first backup staging diskgroup to each of the plurality of nodes;
executing, by the second computing device, one of:
a full backup from the primary node to the first backup staging diskgroup when load balancing is not configured, and
a full backup from the primary node and at least one of the other plurality of nodes to the first backup staging diskgroup when load balancing is configured such that the full backup is representative of shared storage data at the first point in time;

transmitting, by the second computing device, a catalog of first backup information to a database associated with the first computing device; and
creating, by the first computing device, a first snapshot of the first backup staging disk,
thereby backing up clustered databases such that production backups associated with the clustered databases are restorable with near zero downtime.

2. The computerized method of claim 1 , further comprising:
transmitting, by the first computing device, second data indicative of a second backup request of the clustered database to a second computing device at a second point in time; and
when a second backup request size of the application is larger than a first backup request size of the application, the second backup request size associated with the second backup request and the first backup request size associated with the first backup request:
adding, by the first computing device, additional staging disks to the first backup staging disks to form second backup staging disks to account for an expansion of size associated with the application,
mapping, by the first computing device, the second backup staging disks to each of the plurality of nodes,
adding, by the second computing device, the additional staging disks to the first backup staging diskgroup to form a second backup staging diskgroup,
mounting, by the second computing device, the second backup staging diskgroup to each of the plurality of nodes,
executing, by the second computing device, incremental backup from each of the other plurality of nodes to the second backup staging diskgroup such that the incremental backup is representative of shared storage data at the second point in time, the incremental backup including backup of difference data, the difference data associated with changes to the application data between the first point in time and the second point in time,
transmitting, by the second computing device, a catalog of second backup information to the database associated with the first computing device, and
creating, by the first computing device, a second snapshot of the second backup staging disk.

3. The computerized method of claim 2 , further comprising restoring the shared storage data when the shared storage is corrupted, wherein restoring the shared storage data comprises:
receiving, by the first computing device, third data associated with a request for restoring the shared storage data associated with at least one of the first snapshot and the second snapshot;
mapping, by the first computing device, the requested snapshots to the plurality of nodes;
mounting, by the second computing device, an associated staging diskgroup to the plurality of nodes;
switching, by the second computing device, the clustered database to run from the associated staging diskgroup; and
migrating, by the second computing device, associated staging diskgroup data to the shared storage using rebalancing after shared storage is repaired, wherein rebalancing includes spreading the staging diskgroup data evenly across all disks in a diskgroup associated with the repaired shared storage.

4. The computerized method of claim 2 , further comprising provisioning the clustered database for test and development, wherein provisioning the clustered database for test and development comprises:
receiving, by the first computing device, fourth data associated with a request for provisioning a portion of the clustered database for test and development, the request including a diskgroup name associated with the portion of the provisioned portion of the clustered database;
receiving, by the first computing device, an IP address associated with a plurality of test and development nodes;
mapping, by the first computing device, at least one snapshot associated with the requested portion of the clustered database to the plurality of test and development nodes;
adding, by a third computing device, the mapped at least one snapshot to a test and development diskgroup associated with the plurality of test and development nodes;
updating, by the third computing device, header information associated with disks in the test and development diskgroup with the diskgroup name;
mounting, by the third computing device, the test and development diskgroup to each of the plurality of test and development nodes; and
executing, by the third computing device, a clone operation from a primary node of the plurality of test and development nodes, wherein executing the clone operation includes creating new parameter files, setting new cluster database names, and communicating with other test and development nodes.

5. The computerized method of claim 4 , further comprising:
enabling, by a database server, a listener associated with the provisioned clustered database such that the provisioned clustered database is active, the listener managing requests from a client to the clustered database.

6. A computing system for backing up clustered databases such that production backups associated with the clustered databases are restorable with near zero downtime, the system comprising:
a first processor associated with a first computing device and a second processor associated with a second computing device; and
a first memory coupled to the first processor and a second memory coupled to the second processor, each of the first memory and the second memory including instructions that, when executed by the first processor and the second processor, cause the first processor and the second processor to:
transmit, by the first computing device, first data indicative of a first backup request of a clustered database to a second computing device at a first point in time, the clustered database associated with an application, the clustered database including a plurality of nodes, each of the plurality of nodes including database data from a shared storage associated with the clustered database,
map, by the first computing device, first backup staging disks to each of the plurality of nodes,
add, by the second computing device, the mapped first backup staging disks to a first backup staging diskgroup on a primary node of the plurality of nodes,
mount, by the second computing device, the first backup staging diskgroup to each of the plurality of nodes,
execute, by the second computing device, one of:
a full backup from the primary node to the fi

Assignees

• Actifio Inc

Inventors

• Zhang Xiangdong
• Mutalik Madhav
• Palaparthi Satya Sri Kanth
• Gottemukkula Yeganjaiah
• Kumar Sachindra
• Tekade Uday

Classifications

• G06F16/22

  Indexing; Data structures therefor; Storage structures · CPC title

• G06F16/217

  Database tuning (G06F16/2282 takes precedence; database performance monitoring G06F11/3409) · CPC title

• G06F11/1469

  Backup restoration techniques · CPC title

• G06F2201/80

  Database-specific techniques · CPC title

• G06F11/1456

  Hardware arrangements for backup · CPC title