System and method for maintaining a cluster setup

• US 9,031,910 B2
• Filed: 06/24/2013
• Issued: 05/12/2015
• Est. Priority Date: 06/24/2013
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Driesen, Volker
• Primary Examiner(s): LE, HUNG D
• Application Number:
  US13/925,601
• Publication Number:
  US 20140379656A1
• Time in Patent Office: 687 Days
• Field of Search: None
• US Class Current: 707/638
• CPC Class Codes: G06F 11/14 Error detection or correction of the data by redundancy in operation G06F11/16 takes precedence
• CPC Class Codes: G06F 11/1433 during software upgrading
• CPC Class Codes: G06F 11/2094 Redundant storage or storage space G06F11/2056 takes precedence
• CPC Class Codes: G06F 16/2329 using versioning
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 2201/80 Database-specific techniques

Abstract

Methods and systems are directed to a maintenance procedure in a production environment comprising a primary database and a secondary database. Production data may be stored in the primary database and failover data may be stored in the secondary database. Data from the primary database may be replicated to the secondary database. The maintenance procedure may provide for modification of the primary database and the secondary database to conform to one or more modified requirements of a modified version of the application. During the maintenance procedure, data in the databases may be duplicated, data structures may be modified, and modification of certain data elements may be prohibited.

Claims

1. A method comprising:

configuring a database system to operate in a first mode that processes first requests in a primary database and replicates results of the first requests as first replicated data in a secondary database, the first requests originating from an application, the primary database and the secondary database conforming to an unmodified requirement of an unmodified version of the application;

creating secondary shadow data in the secondary database by copying the first replicated data within the secondary database;

modifying the secondary database to conform to a modified requirement of a modified version of the application;

creating primary shadow data in the primary database that conforms to the modified requirement of the modified version of the application; and

configuring the database system to operate in a second mode that;

processes second requests in the primary database and replicates results of the second requests in the secondary shadow data, the second requests originating from the application, the primary database and the secondary shadow data conforming to the unmodified requirement of the unmodified version of the application; and

processes third requests in the secondary database and replicates results of the third requests in the primary shadow data, the third requests originating from the modified version of the application, the secondary database and the primary shadow data conforming to the modified requirements of the modified version of the application,

the configuring of the database system to operate in the second mode being performed by a processor of a machine.

2. The method of claim 1, wherein:

the configuring of the database system to operate in the first mode includes configuring a dispatcher to dispatch requests from the unmodified version of the application to the primary database; and

the configuring of the database system to operate in the second mode includes configuring the dispatcher to dispatch requests from the modified version of the application to the secondary database.

3. The method of claim 1, wherein:

the primary database uses a first structure for data that conforms to the unmodified requirement of the unmodified version of the application;

the secondary database uses a modified first structure for data that conforms to the modified requirement of the unmodified version of the application;

the primary database uses a second structure for data that conforms to the unmodified requirement of the unmodified version of the application;

the secondary database uses the second structure for data that conforms to the unmodified requirement of the unmodified version of the application;

and the method further comprises;

configuring the database system to operate in a third mode that;

prevents modification of data stored in the first structure for data that conforms to the unmodified requirement of the unmodified version of the application; and

processes fourth requests in the primary database and replicates results of the fourth requests in the secondary shadow data, the fourth requests originating from the application, the primary database and the secondary shadow data conforming to the unmodified requirement of the unmodified version of the application.

4. The method of claim 1, further comprising:

after creating the secondary shadow data, configuring the database system to operate in a fourth mode that processes fifth requests in the primary database and ceases replicating results of the fifth requests in the secondary database, the fifth requests originating from the application.

5. The method of claim 4, further comprising:

with the database system operating in the fourth mode, tracking the results of the fifth requests in tracked data; and

with the database system operating in the second mode, replicating the tracked data in the secondary shadow data.

6. The method of claim 1, further comprising:

modifying the primary database to conform to the modified requirements of the modified version of the application; and

configuring the database system to operate in a fifth mode that;

rejects requests from the application; and

processes sixth requests in the secondary database and replicates results of the sixth requests in the primary database, the sixth requests originating from the modified version of the application, the primary database and the secondary database conforming to the modified requirement of the modified version of the application.

7. The method of claim 1, further comprising:

with the database system in the second mode, restoring the secondary database to conform to the unmodified requirement of the unmodified version of the application; and

after restoring the secondary database;

deleting the secondary shadow data; and

configuring the database system to operate in the first mode that processes seventh requests in the primary database and replicates results of the seventh requests in the secondary database, the seventh requests originating from the application, the primary database and the secondary database conforming to the unmodified requirement of the unmodified version of the application.

8. A system comprising:

a database system including a primary database and a secondary database;

a configuration module configured to configure the database system to operate in a first mode that processes first requests in the primary database and replicates results of the first requests as first replicated data in the secondary database, the first requests originating from an application, the primary database and the secondary database conforming to an unmodified requirement of an unmodified version of the application;

an upgrade module configured to;

create secondary shadow data in the secondary database by copying the first replicated data within the secondary database;

modify the secondary database to conform to a modified requirement of a modified version of the application;

create primary shadow data in the primary database that conforms to the modified requirement of the modified version of the application; and

wherein

the configuration module is further configured to configure the database system to operate in a second mode that;

processes second requests in the primary database and replicates results of the second requests in the secondary shadow data, the second requests originating from the application, the primary database and the secondary shadow data conforming to the unmodified requirement of the unmodified version of the application; and

processes third requests in the secondary database and replicates results of the third requests in the primary shadow data, the third requests originating from the modified version of the application, the secondary database and the primary shadow data conforming to the modified requirement of the modified version of the application,

the configuring of the database system to operate in the second mode being performed by a processor of a machine.

9. The system of claim 8, further comprising:

a dispatcher module configured to;

while the database system operates in the first mode, dispatch requests from the unmodified version of the application to the primary database; and

while the database system operates in the second mode, dispatch requests from the modified version of the application to the secondary database.

10. The system of claim 8, wherein:

the primary database uses a first structure for data that conforms to the unmodified requirement of the unmodified version of the application;

the secondary database uses a modified first structure for data that conforms to the modified requirement of the unmodified version of the application;

the primary database uses a second structure for data that conforms to the unmodified requirement of the unmodified version of the application;

the secondary database uses the second structure for data that conforms to the unmodified requirement of the unmodified version of the application; and

the configuration module is further configured to configure the database system to operate in a third mode that;

prevents modification of data stored in the first structure for data that conforms to the unmodified requirement of the unmodified version of the application; and

processes fourth requests in the primary database and replicates results of the fourth requests in the secondary shadow data, the fourth requests originating from the application, the primary database and the secondary shadow data conforming to the unmodified requirement of the unmodified version of the application.

11. The system of claim 8, wherein:

the configuration module is further configured to;

configure the database system to operate in a fourth mode that processes fifth requests in the primary database and avoids replicating results of the fifth requests in the secondary database, the fifth requests originating from the application.

12. The system of claim 11, wherein:

the database system is further configured to;

while operating in the fourth mode, track the results of the first requests in tracked data; and

after beginning operation in the second mode, replicate the tracked data in the secondary shadow data.

13. The system of claim 8, wherein:

the upgrade module is further configured to modify the primary database to conform to the modified requirement of the modified version of the application; and

the configuration module is further configured to configure the database system to operate in a fifth mode that;

rejects requests from the application; and

processes sixth requests in the secondary database and replicates results of the sixth requests in the primary database, the sixth requests originating from the modified version of the application, the primary database and the secondary database conforming to the modified requirement of the modified version of the application.

14. The system of claim 8, further comprising:

a downgrade module configured to;

with the database system operating in the second mode, restore the secondary database to conform to the unmodified requirement of the unmodified version of the application; and

after restoring the secondary database;

delete the secondary shadow data; and

cause the configuration module to configure the database system to operate in the first mode that processes seventh requests in the primary database and replicates results of the seventh requests in the secondary database, the seventh requests originating from the application, the primary database and the secondary database conforming to the unmodified requirement of the unmodified version of the application.

15. A non-transitory machine-readable storage medium comprising instructions that, when executed by one or more processors of a machine, cause the machine to perform operations comprising:

configuring a database system to operate in a first mode that processes first requests in a primary database and replicates results of the first requests as first replicated data in a secondary database, the first requests originating from an application, the primary database and the secondary database conforming to an unmodified requirement of an unmodified version of the application;

creating secondary shadow data in the secondary database by copying the first replicated data within the secondary database;

modifying the secondary database to conform to a modified requirement of a modified version of the application;

creating primary shadow data in the primary database that conforms to the modified requirement of the modified version of the application; and

configuring the database system to operate in a second mode that;

processes second requests in the primary database and replicates results of the second requests in the secondary shadow data, the second requests originating from the application, the primary database and the secondary shadow data conforming to the unmodified requirement of the unmodified version of the application; and

processes third requests in the secondary database and replicates results of the third requests in the primary shadow data, the third requests originating from the modified version of the application, the secondary database and the primary shadow data conforming to the modified requirements of the modified version of the application.

16. The non-transitory machine-readable storage medium of claim 15, wherein:

the configuring of the database system to operate in the first mode includes configuring a dispatcher to dispatch requests from the unmodified version of the application to the primary database; and

the configuring of the database system to operate in the second mode includes configuring the dispatcher to dispatch requests from the modified version of the application to the secondary database.

17. The non-transitory machine-readable storage medium of claim 15, wherein:

the primary database uses a first structure for data that conforms to the unmodified requirement of the unmodified version of the database;

the secondary database uses a modified first structure for data that conforms to the modified requirement of the unmodified version of the database;

the primary database uses a second structure for data that conforms to the unmodified requirement of the unmodified version of the database;

the secondary database uses the second structure for data that conforms to the unmodified requirement of the unmodified version of the database;

and the operations further comprise;

configuring the database system to operate in a third mode that;

prevents modification of data stored in the first structure for data that conforms to the unmodified requirement of the unmodified version of the database; and

processes fourth requests in the primary database and replicates results of the fourth requests in the secondary shadow data, the fourth requests originating from the application, the primary database and the secondary shadow data conforming to the unmodified requirement of the unmodified version of the application.

18. The non-transitory machine-readable storage medium of claim 15, wherein the operations further comprise:

after creating the secondary shadow data, configuring the database system to operate in a fourth mode that processes fifth requests in the primary database and ceases replicating results of the fifth requests in the secondary database, the fifth requests originating from the application.

19. The non-transitory machine-readable storage medium of claim 18, wherein the operations further comprise:

with the database system operating in the fourth mode, tracking the results of the fifth requests in tracked data; and

with the database system operating in the second mode, replicating the tracked data in the secondary shadow data.

20. The non-transitory machine-readable storage medium of claim 15, wherein the operations further comprise:

modifying the primary database to conform to the modified requirements of the modified version of the application; and

configuring the database system to operate in a fifth mode that;

rejects requests from the application; and

processes sixth requests in the secondary database and replicates results of the sixth requests in the primary database, the sixth requests originating from the modified version of the application, the primary database and the secondary database conforming to the modified requirement of the modified version of the application.