Directed backup for massively parallel processing databases

• US 9,792,185 B2
• Filed: 06/24/2014
• Issued: 10/17/2017
• Est. Priority Date: 06/24/2014
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Gaza, Lukasz, Gruszecki, Artur M., Kazalski, Tomasz, Skibski, Konrad K., Stradomski, Tomasz
• Primary Examiner(s): Vu, Bai D.
• Application Number:
  US14/312,723
• Publication Number:
  US 20150370647A1
• Time in Patent Office: 1,211 Days
• Field of Search: None
• CPC Class Codes: G06F 11/1448 Management of the data involved in backup or backup restore
• CPC Class Codes: G06F 11/1458 Management of the backup or restore process
• CPC Class Codes: G06F 11/1464 for networked environments
• CPC Class Codes: G06F 11/1469 Backup restoration techniques
• CPC Class Codes: G06F 16/113 Details of archiving lifecycle management in storage systems G06F3/0649; backup systems G06F11/1446
• CPC Class Codes: G06F 2201/80 Database-specific techniques
• CPC Class Codes: H04L 67/10 in which an application is distributed across nodes in the network software deployment G06F8/60; multiprogramming arrangements G06F9/46
• CPC Class Codes: H04L 67/1095 Replication or mirroring of data, e.g. scheduling or transport for data synchronisation between network nodes

Abstract

Creating a data backup of data on a first computer system to restore to a second computer system, each of the first and second computer system including one or more nodes, each node configured to manage a subset of the data. Receiving, by the first computer system, identification of data to back up and node configuration information for the second computer system. Creating, by the first computer system, a backup of the data from the one or more nodes of the first computer system, configured in accordance with the node configuration information of the second computer system, such that the backed up data is directly manageable by the one or more nodes of the second computer system.

Claims

1. A computer program product for creating a backup of database on a first massively parallel processing (MPP) computer system to restore to a second MPP computer system, the computer program product comprising one or more non-transitory computer readable storage medium and program instructions stored on at least one of the one or more non-transitory computer readable storage medium, the program instructions comprising:

program instructions to receive, by the first MPP computer system, identification of data to back up and node server configuration information for the second MPP computer system, wherein the node server configuration information includes how the data is partitioned among the node servers of the second computer system, and wherein each of the first and second MPP computer systems includes its own database storage media segmented into storage segments, and a plurality of node servers, each node server configured to manage a respective storage segment and a subset of the database stored on its respective storage segment, and wherein partitioning of the database among the node servers of the first MPP computer system is different than the partitioning of the database among the node servers of the second MPP computer system; and

program instructions to create, by the first MPP computer system, a backup of the identified data from the plurality of node servers of the first MPP computer system in accordance with the node server configuration information of the second MPP computer system, such that the backed up data is partitioned in accordance with the partitioning of the data among the node servers of the second MPP computer system and does not require a re-partitioning by the second MPP computer system for a restore of the data to the second MPP computer system.

2. The computer program product according to claim 1, wherein program instructions to receive further comprise:

program instructions to receive, by the first MPP computer system, an identifier for the second MPP computer system;

program instructions to transmit to the second MPP computer system, by the first MPP computer system, a request for the node server configuration information; and

program instructions to receive, by the first MPP computer system, the node server configuration information.

3. The computer program product according to claim 2, further comprises:

program instructions to transmit to the second MPP computer system, by the first MPP computer system, the backup of the data from the plurality of node servers of the first MPP computer system.

4. The computer program product according to claim 1, wherein program instructions to partition the data from each of the plurality of node servers of the first MPP computer system executes in parallel.

5. The computer program product according to claim 1,

wherein the node server configuration information for the second MPP computer system includes one or more of:

an indication of a data storage format for data on the plurality of node servers of the second MPP computer system, and an indication of a data compression algorithm for data on the plurality of node servers of the second MPP computer system; and

wherein program instructions to create further comprises one or more of;

program instructions to format the data from the plurality of node servers of the first MPP computer system, in accordance with the received indication of the data storage format; and

program instructions to compress the data from the plurality of node servers of the first MPP computer system, in accordance with the received indication of the compression algorithm.

6. The computer program product according to claim 5, wherein program instructions to format the data from each of the plurality of node servers of the first MPP computer system executes in parallel, and/or program instructions to compress the data from each of the plurality of node servers of the first MPP computer system executes in parallel.

7. A computer system for creating a backup of a database on a first massively parallel processing (MPP) computer system to restore to a second MPP computer system, the computer system comprising one or more processors, one or more computer readable memories, one or more computer readable tangible storage medium, and program instructions stored on at least one of the one or more storage medium for execution by at least one of the one or more processors via at least one of the one or more memories, the program instructions comprising:

program instructions to receive, by the first MPP computer system, identification of data to back up and node server configuration information for the second MPP computer system, wherein the node server configuration information includes how the data is partitioned among the node servers of the second MPP computer system, and wherein each of the first and second MPP computer systems includes its own database storage media segmented into storage segments, and a plurality of node servers, each node server configured to manage a respective storage segment and a subset of the database stored on its respective storage segment, and wherein partitioning of the database among the node servers of the first MPP computer system is different than the partitioning of the database among the node servers of the second MPP computer system; and

program instructions to create, by the first MPP computer system, a backup of the identified data from the plurality of node servers of the first MPP computer system in accordance with the node server configuration information of the second MPP computer system, such that the backed up data is partitioned in accordance with the partitioning of the data among the node servers of the second MPP computer system and does not require a re-partitioning by the second MPP computer system for a restore of the data to the second MPP computer system.

8. The computer system according to claim 7, wherein program instructions to receive further comprise:

program instructions to receive, by the first MPP computer system, an identifier for the second MPP computer system;

program instructions to transmit to the second MPP computer system, by the first MPP computer system, a request for the node server configuration information; and

program instructions to receive, by the first MPP computer system, the node server configuration information.

9. The computer system according to claim 8, further comprises:

program instructions to transmit to the second MPP computer system, by the first MPP computer system, the backup of the data from the plurality of node servers of the first MPP computer system.

10. The computer system according to claim 7, wherein program instructions to partition the data from each of the plurality of node servers of the first MPP computer system executes in parallel.

11. The computer system according to claim 7,

wherein the node server configuration information for the second MPP computer system includes one or more of:

an indication of a data storage format for data on the plurality of node servers of the second MPP computer system, and an indication of a data compression algorithm for data on the plurality of node servers of the second MPP computer system; and

wherein program instructions to create further comprises one or more of;

program instructions to format the data from the plurality of node servers of the first MPP computer system, in accordance with the received indication of the data storage format; and

program instructions to compress the data from the plurality of node servers of the first MPP computer system, in accordance with the received indication of the compression algorithm.