Testing database replication with multi-container system architecture

• US 10,565,228 B2
• Filed: 03/06/2017
• Issued: 02/18/2020
• Est. Priority Date: 03/06/2017
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Heidel, Martin, Muehle, Michael, Singer, Reiner, Haeussler, Johannes, Hochberger, Timo, Chriki, Mohamed Ali, Bastke, Sascha
• Primary Examiner(s): Pham, Hung Q
• Application Number:
  US15/451,322
• Publication Number:
  US 20180253481A1
• Time in Patent Office: 1,079 Days
• CPC Class Codes: G06F 11/1469 Backup restoration techniques
• CPC Class Codes: G06F 11/3688 for test execution, e.g. scheduling of test suites
• CPC Class Codes: G06F 11/3696 Methods or tools to render software testable
• 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 16/273 Asynchronous replication or reconciliation
• CPC Class Codes: G06F 16/275 Synchronous replication
• CPC Class Codes: G06F 2201/80 Database-specific techniques

Abstract

Testing a database replication system within a multi-container system architecture comprises receiving a first request for creating a database recovery system within a multi-container system architecture. The multi-container system architecture is configured to contain a plurality of tenant databases and a system database, and the database recovery system includes a primary system and a secondary system. The primary system is then identified from the information in the first request. Upon identification, a first tenant database included in the plurality of tenant databases is determined that corresponds to the identified primary system. Upon determining the first tenant database, a second tenant database of the plurality of tenant database is generated that corresponds to the secondary system, and which is enabled to test replicating information that would otherwise be associated with the first tenant database. Related apparatus, systems, techniques and articles are also described.

Claims

1. A computer-implemented method for testing a database replication system within a multi-container system architecture, the method comprising:

receiving a first request for creating a database recovery system within a multi-container system architecture, the multi-container system architecture comprising a computing device having a plurality of tenant databases and a system database;

identifying a primary system of a database system from information included in the first request;

in response to identifying the primary system from the information included in the first request, determining a first tenant database of the plurality of tenant databases, the first tenant database representing the identified primary system;

in response to determining the first tenant database, generating a second tenant database of the plurality of tenant databases, the second tenant database representing a secondary system of the database system and being enabled to test replicating information that would otherwise be associated with the first tenant database, wherein the primary system and the secondary system each comprise a computing device independent of the computing device of the multi-container system architecture;

receiving, by the first tenant database, a request to enter a recovery mode;

upon entering the recovery mode, retrieving log information from the first tenant database for transmission to the second tenant database; and

generating a log catalog comprising transmitted objects from the first tenant database to the second tenant database by replaying the log information at the second tenant database.

2. The method of claim 1, further comprising:

receiving a second request for accessing the secondary system;

in response to receiving a second request for accessing the secondary system, executing the second request; and

outputting results of the executing the second request;

wherein the executing the second request is based at least in part on data included in the second tenant database.

3. The method of claim 2, wherein the executing the second request is based at least in part on information included in the system database.

4. The method of claim 1, further comprising:

receiving a third request for accessing the primary system;

in response to receiving a third request for accessing the primary system, executing the third request; and

outputting results of the executing the third request;

wherein the executing the third request is based at least in part on data included in the first tenant database.

5. The method of claim 4, wherein the executing the third request is based at least in part on information included in the system database.

6. The method of claim 1, wherein the log information comprises a metadata log.

7. The method of claim 6, wherein the log catalog is a metadata catalog and the transmitted objects are transmitted metadata objects.

8. The method of claim 1, wherein the generating the multi-container system architecture comprises generating the system database and the first tenant database.

9. The method of claim 1, wherein the generating the second tenant database of the plurality of tenant databases comprises replicating information associated with the first tenant database, and storing the replicated information in the second tenant database.

10. The method of claim 9, wherein the replicated information comprises data pages, log buffers and metadata or any combination thereof.

11. The method of claim 1, wherein the multi-container system architecture comprises a plurality of index servers including a first index server and a second index server, and wherein the first index server hosts the first tenant database, and the second index server hosts the second tenant database.

12. The method of claim 11, wherein the first index server stores topology information associated with the first tenant database, and the second index server stores topology information associated with the second tenant database.

13. The method of claim 12, wherein the topology information associated with a tenant database of the plurality of tenant databases includes:

information corresponding to tables associated with the tenant database, and information corresponding to table partitions associated with the tenant database.

14. The method of claim 1, wherein the multi-container system architecture comprises a name server, and wherein the name server hosts the system database, stores information associated with the first tenant database, and stores information associated with the second tenant database.

15. The method of claim 14, wherein information stored in the name server includes landscape information associated with the multi-container system architecture.

16. The method of claim 14, wherein the information stored in the name server does not include topology information associated with a tenant database of the plurality of tenant databases.

17. The method of claim 1, wherein the first tenant database is configured to communicate with client applications through a read/write connection.

18. The method of claim 1, wherein the second tenant database is configured to communicate with client applications through a read-only connection.

19. A computer-implemented system for testing a database replication system within a multi-container system architecture, the system comprising:

a data processor of the multi-container system architecture;

a plurality of tenant databases and a system database of the multi-container system architecture, wherein the plurality of tenant databases represent separate, physical databases of a database system comprising a primary system and a secondary system; and

a computer-readable storage medium encoded with instructions for commanding the data processor to perform operations comprising;

receiving a first request for creating a database recovery system within the multi-container system architecture;

identifying the primary system from information included in the first request;

in response to identifying the primary system from the information included in the first request, determining a first tenant database of the plurality of tenant databases, the first tenant database representing the identified primary system;

in response to determining the first tenant database, generating a second tenant database of the plurality of tenant databases, the second tenant database representing the secondary system, wherein the primary system and the secondary system each comprise a computing device independent of the data processor of the multi-container system architecture;

receiving, by the first tenant database, a request to enter a recovery mode;

upon entering the recovery mode, retrieving log information from the first tenant database for transmission to the second tenant database; and

generating a log catalog comprising transmitted objects from the first tenant database to the second tenant database by replaying the log information at the second tenant database.

20. A computer program product for testing a database replication system within a multi-container system architecture, the product comprising:

a non-transitory machine-readable medium storing instructions that, when executed by at least one data processor, cause the at least one data processor to perform operations comprising;

generating a multi-container system architecture, the multi-container system architecture comprising a computing device having a plurality of tenant databases and a system database;

receiving a first request for creating a database recovery system within the multi-container system architecture;

identifying a primary system of a database system from information included in the first request;

in response to identifying the primary system from the information included in the first request, determining a first tenant database of the plurality of tenant databases, the first tenant database replicating the identified primary system;

in response to determining the first tenant database, generating a second tenant database of the plurality of tenant databases, the second tenant database replicating a secondary system of the database system, wherein the primary system and the secondary system each comprise a computing device independent of the computing device of the multi-container system architecture;

receiving, by the first tenant database, a request to enter a recovery mode;

upon entering the recovery mode, retrieving log information from the first tenant database for transmission to the second tenant database; and

generating a log catalog comprising transmitted objects from the first tenant database to the second tenant database by replaying the log information at the second tenant database.