Zero downtime maintenance using a mirror approach

• US 8,200,634 B2
• Filed: 10/08/2008
• Issued: 06/12/2012
• Est. Priority Date: 10/08/2008
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Driesen, Volker, Abitbol, Roy, Ben-Zeev, Miki, Herbas, Franklin, Brodkorb, Thomas
• Primary Examiner(s): Pham, Khanh
• Assistant Examiner(s): CHEEMA, AZAM M
• Application Number:
  US12/247,978
• Publication Number:
  US 20100088281A1
• Time in Patent Office: 1,343 Days
• Field of Search: None
• US Class Current: 707/641
• CPC Class Codes: G06F 11/1433 during software upgrading
• CPC Class Codes: G06F 16/213 with details for schema evolution support
• CPC Class Codes: G06F 8/65 Updates security arrangements therefor G06F21/57

Abstract

The subject matter disclosed herein provides methods and apparatus, including computer program products, for providing software updates. In one aspect there is provided a method. The method may include copying an application to a shadow system, the application used to upgrade the shadow system rather than a production system; copying data from the production system to the shadow system; selecting whether to lock changes to data in the production system or record changes to the data in the production system; recording one or more changes to data in the production system, the changes recorded in a container, when record changes has been selected; migrating recorded data in the container to the shadow system, so that the shadow system and production system are in a similar data state; and using the shadow system, upgraded with the application and at least one of data copied from the production system and recorded data from the container, for production rather than the production system. Related systems, apparatus, methods, and/or articles are also described.

Claims

1. A computer-readable storage medium containing instructions to configure a processor to perform operations comprising:

creating a shadow system, the shadow system comprising an upgraded version of a production system comprising an application and data in a database;

copying the at least one of the application and the database from the production system to the shadow system, the copying comprising migrating data of the at least one of the application and the database from the production system to the shadow system;

providing, during the migrating, production system for continued productive use of the at least one of the application and the database, the continued productive use comprising receiving one or more changes to the data being migrated;

recording, during the migrating, the one or more received changes to the data in a persistency container, at the production system;

taking the production system out of productive use after completion of the migrating, the taking of the production system out of productive use comprising at least one of locking the production system to prevent further changes and taking the production system offline;

replaying, after the production system has been taken out of productive use, the recorded one or more received changes from the persistency container to the shadow system, the replaying comprising executing the recorded one or more received changes in a sequential order of how the one or more received changes were received such that the data migrated to the shadow system from the production system are updated to reflect the one or more received changes; and

initiating productive use at the shadow system to replace the production system after the production system is taken out of productive use.

2. The computer-readable storage medium of claim 1, wherein the operations further comprise:

receiving an indication from a user to record the one or more received changes to the data in the production system in the persistency container instead of locking the production system during the migrating.

3. The computer-readable storage medium of claim 1, wherein recording further comprises:

storing, in the persistency container, the one or more changes received to data at the production system, the recorded one or more received changes being configured to enable the one or more received changes to be applied to the data migrated to the shadow system.

4. The computer-readable storage medium of claim 1, wherein the migrating of the data from the production system to the shadow system further comprises:

copying one or more of the following types of data;

a sales order, a master data, account information, a customer invoice, a batch job runtime information, an update task information, an input queue, a print queue, a change log, and user data.

5. The computer-readable storage medium of claim 1, wherein the operations further comprise:

deleting the recorded one or more received changes from the persistency container, when the recorded one or more received changes have been migrated from the persistency container to the shadow system.

6. A computer-readable storage medium as in claim 1, wherein the operations further comprise:

creating, in the persistency container for each of one or more database tables comprising the data at the production system, a corresponding second database table, the second database table comprising a same key as its corresponding database table at the production system, a first key field defining a sequence number of one of the one or more received changes, and a second key field specifying a change kind of the one of the one or more received changes.

7. A computer-readable storage medium as in claim 1, wherein the operations further comprise:

creating, in the persistency container, a single second database table, the single second database comprising, a table name of each of a plurality of database tables at the production system, a first key field defining a sequence number of one of the one or more received changes, and a second key field specifying a change kind of the one of the one or more received changes.

8. A computer-readable storage medium as in claim 1, wherein the operations further comprise:

migrating one or more users attached to the production system to the shadow system.

9. A computer-readable storage medium as in claim 1, wherein the operations further comprise:

also writing the received one or more changes to the production system as they are received.

10. A computer-readable storage medium as in claim 1, wherein the operations further comprise:

recreating a previous state of the production system by using the one or more received changes recorded in the persistency container to roll back the one or more changes written to the production system during the migrating, the recreating being performed if a problem occurs during the migrating.

11. A computer-readable storage medium as in claim 1, wherein the upgraded version of a production system comprises a new format not used in a previous version of the production system, and wherein the operations further comprise recording the one or more received changes in the persistency container using the new format.

12. A computer-implemented method comprising:

creating a shadow system, the shadow system comprising an upgraded version of a production system comprising an application and data in a database;

copying the at least one of the application and the database from the production system to the shadow system, the copying comprising migrating data of the at least one of the application and the database from the production system to the shadow system;

providing, during the migrating, the production system for continued productive use of the at least one of the application and the database, the continued productive use comprising receiving one or more changes to the data being migrated;

recording, during the migrating, the one or more received changes to the data in a persistency container at the production system;

taking the production system out of productive use after completion of the migrating, the taking of the production system out of productive use comprising at least one of locking the production system to prevent further changes and taking the production system offline;

replaying, after the production system has been taken out of productive use, the recorded one or more received changes from the persistency container to the shadow system, the replaying comprising executing the recorded one or more received changes in a sequential order of how the one or more received changes were received such that the data migrated to the shadow system from the production system are updated to reflect the one or more received changes; and

initiating productive use at the shadow system to replace the production system after the production system is taken out of productive use.

13. The computer-implemented method of claim 12, further comprising:

receiving an indication from a user to record the one or more received changes to the data in the production system in the persistency container instead of locking the production system during the migrating.

14. The computer-implemented method of claim 12, wherein recording further comprises:

storing, in the persistency container, the one or more changes received to data at the production system, the recorded one or more received changes being configured to enable the one or more received changes to be applied to the data migrated to the shadow system.

15. The computer-implemented method of claim 12, wherein the migrating of the data from the production system to the shadow system further comprises:

copying one or more of the following types of data;

a sales order, a master data, account information, a customer invoice, a batch job runtime information, an update task information, an input queue, a print queue, a change log, and user data.

16. The computer-implemented method of claim 12, wherein the operations further comprise:

deleting the recorded one or more received changes from the persistency container, when the recorded one or more received changes have been migrated from the persistency container to the shadow system.

17. A system comprising:

a processor; and

a memory, wherein the processor and the memory are configured to perform a method comprising;

creating a shadow system, the shadow system comprising an upgraded version of a production system comprising an application and data in a database;

copying the at least one of the application and the database from the production system to the shadow system, the copying comprising migrating data of the at least one of the application and the database from the production system to the shadow system;

providing, during the migrating, the production system for continued productive use of the at least one of the application and the database, the continued productive use comprising receiving one or more changes to the data being migrated;

recording, during the migrating, the one or more received changes to the data in a persistency container at the production system;

taking the production system out of productive use after completion of the migrating, the taking of the production system out of productive use comprising at least one of locking the production system to prevent further changes and taking the production system offline;

replaying, after the production system has been taken out of productive use, the recorded one or more received changes from the persistency container to the shadow system, the replaying comprising executing the recorded one or more received changes in a sequential order of how the one or more received changes were received such that the data migrated to the shadow system from the production system are updated to reflect the one or more received changes; and

initiating productive use at the shadow system to replace the production system after the production system is taken out of productive use.

18. The system of claim 17, wherein the operations further comprise:

receiving an indication from a user to record the one or more received changes to the data in the production system in the persistency container instead of locking the production system during the migrating.