Dynamic migration script management

• US 9,805,070 B2
• Filed: 07/09/2013
• Issued: 10/31/2017
• Est. Priority Date: 07/09/2013
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Buehne, Stephan, Spiegelberg, Elmar
• Primary Examiner(s): Shanmugasundaram, Kannan
• Application Number:
  US13/937,486
• Publication Number:
  US 20150019478A1
• Time in Patent Office: 1,575 Days
• CPC Class Codes: G06F 16/119 Details of migration of file systems migration mechanisms in storage systems G06F3/0647
• CPC Class Codes: G06F 16/214 Database migration support

Abstract

Various embodiments for managing migration between server systems are presented. Indications of a plurality of migration scripts to be executed during a migration of a database system from a source server system to a target server system may be received. An execution order for the plurality of migration scripts may be determined based upon characteristics of a plurality of database objects to be migrated using the plurality of migration scripts and characteristics of the plurality of migration scripts. Execution of a first migration script of the plurality of migration scripts may be initiated according to the determined execution order. The first migration script may cause copying of a database object of the plurality of database objects from the source server system to the target server system.

Claims

1. A method for managing migration between server systems, the method comprising:

receiving, by a scheduler computer system, indications of a plurality of migration scripts to be executed during a migration of a database system from a source server system to a target server system, wherein the source server system is online and processing database requests during the migration of the database system;

determining, by the scheduler computer system, an execution order for the plurality of migration scripts based upon characteristics of a plurality of database objects to be migrated using the plurality of migration scripts and characteristics of the plurality of migration scripts;

initiating, by the scheduler computer system, execution of a first migration script of the plurality of migration scripts according to the determined execution order, wherein the first migration script causes copying of a first database object of the plurality of database objects from the source server system to the target server system;

determining, by the scheduler computer system, an amount of available resources at the source server system based on the database requests processed while the source server system is online;

modifying, by the scheduler computer system, the execution order for the plurality of migration scripts based on the amount of available resources at the source server system, wherein the amount of available resources at the source server system is based on the database requests processed while the source server system is online; and

initiating, by the scheduler computer system, execution of a second migration script of the plurality of migration scripts according to the modified execution order, wherein the second migration script causes copying of a second database object of the plurality of database objects from the source server system to the target server system.

2. The method for managing migration between server systems of claim 1, the method further comprising:

while the first migration script is being executed, receiving, by the scheduler computer system, an indication of a maximum number of migration scripts permitted to be executed in parallel; and

based on the determined execution order and the maximum number of migration scripts permitted to be executed in parallel, initiating, by the scheduler computer system, execution of a second migration script of the plurality of migration scripts while the first migration script is executing.

3. The method for managing migration between server systems of claim 1, the method further comprising:

while a subset of the migration scripts of the plurality of migration scripts are being executed and after the first migration script has completed, determining, by the scheduler computer system, an amount of available resources of the target server system exceeds a first threshold amount; and

in response to determining the amount of available resources of the target server system exceeds the first threshold amount, initiating, by the scheduler computer system, an index creation for the first database object copied to the target server system based on the first migration script, wherein the index creation is performed by the target server system.

4. The method for managing migration between server systems of claim 1, wherein determining the execution order for the plurality of migrations scripts is based on execution dependencies of migration scripts of the plurality of migrations scripts on one or more other migration scripts of the plurality of migrations scripts.

5. The method for managing migration between server systems of claim 1, the method further comprising:

while a subset of the migration scripts of the plurality of migration scripts are being executed and after the first migration script has completed, determining, by the scheduler computer system, an amount of available resources of the target server system exceeds a first threshold amount; and

based upon the determined execution order, execution of the first migration script being complete, and the amount of available resources of the target server system exceeding the first threshold amount, initiating, by the scheduler computer system, execution of a verification script that causes the target server system to count a number of records in the first database object copied to the target server system.

6. The method for managing migration between server systems of claim 1, wherein initiating the execution of the first migration script of the plurality of migration scripts according to the determined execution order comprises:

causing, by the scheduler computer system, modification of a structure of the first database object being copied to the target server system as compared to the structure of the first database object as stored by the source server system.

7. The method for managing migration between server systems of claim 6, wherein the modification of the structure comprises compression of the first database object such that the first database object stored by the source server system is not compressed and the first database object stored by the target server system is compressed.

8. The method for managing migration between server systems of claim 1, wherein determining the execution order for the plurality of migration scripts based upon characteristics of the plurality of database objects to be migrated comprises:

evaluating, by the scheduler computer system, storage sizes of individual database objects of the plurality of database objects; and

based on the evaluated storage sizes of the plurality of database objects, prioritizing, by the scheduler computer system, in the determined execution order the first migration script for the first database object due to the first database object having a larger storage size than one or more other database objects of the plurality of database objects.

9. The method for managing migration between server systems of claim 1, the method further comprising:

while a subset of the migration scripts of the plurality of migration scripts are being executed and after the first migration script has completed, determining, by the scheduler computer system, an amount of available resources of the target server system exceeds a first threshold amount but does not exceed a second threshold amount, wherein the second threshold amount is greater than the first threshold amount; and

in response to determining the amount of available resources of the target server system exceeds the first threshold amount but not the second threshold amount, initiating, by the scheduler computer system, index creation for the first database object copied to the target server system based on the first migration script instead of index creation for a second database object copied to the target server system based on a second migration script, wherein

index generation for the second database object is more resource intensive than index generation for the first database object;

the determined execution order indicates index generation for the second database object is to be performed before index generation for the first database object; and

the index creation is performed by the target server system.

10. The method for managing migration between server systems of claim 1, wherein the scheduler computer system is selected from the group consisting of:

the target server system; and

the source server system.

11. A system for managing migration between server systems, the system comprising:

a source server system;

a target server system; and

a scheduler computer system, comprising;

one or more processors; and

a memory communicatively coupled with and readable by the one or more processors and having stored therein processor-readable instructions which, when executed by the one or more processors, cause the one or more processors to;

receive indications of a plurality of migration scripts to be executed during a migration of a database system from the source server system to the target server system, wherein the source server system is online and processing database requests during the migration of the database system;

determine an execution order for the plurality of migration scripts based upon characteristics of a plurality of database objects to be migrated using the plurality of migration scripts and characteristics of the plurality of migration scripts;

initiate execution of a first migration script of the plurality of migration scripts according to the determined execution order, wherein the first migration script causes copying of a first database object of the plurality of database objects from the source server system to the target server system;

determine an amount of available resources at the source server system based on the database requests processed while the source server system is online;

modify the execution order for the plurality of migration scripts based on the amount of available resources at the source server system, wherein the amount of available resources at the source server system is based on the database requests processed while the source server system is online; and

initiate execution of a second migration script of the plurality of migration scripts according to the modified execution order, wherein the second migration script causes copying of a second database object of the plurality of database objects from the source server system to the target server system.

12. The system for managing migration between server systems of claim 11, wherein the processor-readable instructions, when executed, further cause the one or more processors of the scheduler computer system to:

while the first migration script is being executed, receive an indication of a maximum number of migration scripts permitted to be executed in parallel; and

based on the determined execution order and the maximum number of migration scripts permitted to be executed in parallel, initiate execution of a second migration script of the plurality of migration scripts while the first migration script is executing.

13. The system for managing migration between server systems of claim 11, wherein the processor-readable instructions, when executed, further cause the one or more processors of the scheduler computer system to:

while a subset of the migration scripts of the plurality of migration scripts are being executed and after the first migration script has completed, determine an amount of available resources of the target server system exceeds a first threshold amount; and

in response to determining the amount of available resources of the target server system exceeds the first threshold amount, initiate an index creation for the first database object copied to the target server system based on the first migration script, wherein

the index creation is performed by the target server system.

14. The system for managing migration between server systems of claim 11, wherein the processor-readable instructions for determining the execution order for the plurality of migrations scripts are based on execution dependencies of migration scripts of the plurality of migrations scripts on one or more other migration scripts of the plurality of migrations scripts.

15. The system for managing migration between server systems of claim 11, wherein the processor-readable instructions, when executed, further cause the one or more processors of the scheduler computer system to:

while a subset of the migration scripts of the plurality of migration scripts are being executed and after the first migration script has completed, determine an amount of available resources of the target server system exceeds a first threshold amount; and

based upon the determined execution order, execution of the first migration script being complete, and the amount of available resources of the target server system exceeding the first threshold amount, initiate execution of a verification script that causes the target server system to count a number of records in the first database object copied to the target server system.

16. The system for managing migration between server systems of claim 11, wherein the processor-readable instructions for initiating the execution of the first migration script of the plurality of migration scripts according to the determined execution order comprises processor-readable instructions, when executed, cause the one or more processors of the scheduler computer system to:

cause modification of a structure of the first database object being copied to the target server system as compared to the structure of the first database object as stored by the source server system.

17. The system for managing migration between server systems of claim 11, wherein the processor-readable instructions for determining the execution order for the plurality of migration scripts based upon characteristics of the plurality of database objects to be migrated comprises processor-readable instructions, when executed, cause the one or more processors of the scheduler computer system to:

evaluate storage sizes of individual database objects of the plurality of database objects; and

based on the evaluated storage sizes of the plurality of database objects, prioritize in the determined execution order the first migration script for the first database object due to the first database object having a larger storage size than one or more other database objects of the plurality of database objects.

18. The system for managing migration between server systems of claim 11, wherein the processor-readable instructions, when executed, further cause the one or more processors of the scheduler computer system to:

while a subset of the migration scripts of the plurality of migration scripts are being executed and after the first migration script has completed, determine an amount of available resources of the target server system exceeds a first threshold amount but does not exceed a second threshold amount, wherein the second threshold amount is greater than the first threshold amount; and

in response to determining the amount of available resources of the target server system exceeds the first threshold amount but not the second threshold amount, initiate index creation for the first database object copied to the target server system based on the first migration script instead of index creation for a second database object copied to the target server system based on a second migration script, wherein

index generation for the second database object is more resource intensive than index generation for the first database object;

the determined execution order indicates index generation for the second database object is to be performed before index generation for the first database object; and

the index creation is performed by the target server system.

19. The system for managing migration between server systems of claim 11, wherein the scheduler computer system is selected from the group consisting of:

the target server system; and

the source server system.

20. A non-transitory processor-readable medium for managing migration between server systems, comprising processor-readable instructions configured to cause one or more processors to:

receive indications of a plurality of migration scripts to be executed during a migration of a database system from a source server system to a target server system, wherein the source server system is online and processing database requests during the migration of the database system;

determine an execution order for the plurality of migration scripts based upon characteristics of a plurality of database objects to be migrated using the plurality of migration scripts and characteristics of the plurality of migration scripts;

initiate execution of a first migration script of the plurality of migration scripts according to the determined execution order, wherein the first migration script causes copying of a first database object of the plurality of database objects from the source server system to the target server system;

determine an amount of available resources at the source server system based on the database requests processed while the source server system is online;

modify the execution order for the plurality of migration scripts based on the amount of available resources at the source server system, wherein the amount of available resources at the source server system is based on the database requests processed while the source server system is online; and

initiate execution of a second migration script of the plurality of migration scripts according to the modified execution order, wherein the second migration script causes copying of a second database object of the plurality of database objects from the source server system to the target server system.