TESTING DATABASE REPLICATION WITH MULTI-CONTAINER SYSTEM ARCHITECTURE

• US 20180253481A1
• Filed: 03/06/2017
• Published: 09/06/2018
• 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
• Granted Patent: US 10,565,228 B2
• Time in Patent Office: 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 being configured to contain a plurality of tenant databases and a system database, and the database replication system including a primary system and a secondary system;

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 included in the plurality of tenant databases, the first tenant database corresponding to the identified primary system; and

in response to determining the first tenant database, generating a second tenant database of the plurality of tenant databases, the second tenant database corresponding to the secondary system and being enabled to test replicating information that would otherwise be associated with the first 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, further comprising:

sending log information from the first tenant database to the second tenant database, and replaying the log information at the second tenant database.

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

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:

one or more data processors; and

a computer-readable storage medium encoded with instructions for commanding the one or more data processors to perform operations comprising;

generating a multi-container system architecture, the multi-container system architecture being configured to contain 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, the database replication system including a primary system and a secondary system;

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 included in the plurality of tenant databases, the first tenant database corresponding to the identified primary system; and

in response to determining the first tenant database, generating a second tenant database of the plurality of tenant databases, the second tenant database corresponding to the secondary system.

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 being configured to contain 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, the database replication system including a primary system and a secondary system;

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 included in the plurality of tenant databases, the first tenant database corresponding to the identified primary system; and

in response to determining the first tenant database, generating a second tenant database of the plurality of tenant databases, the second tenant database corresponding to the secondary system.