US 12,332,913 B2
Database replication with host replication at asynchronously replicated system
Markus Behrens, Berlin (DE); Reiner Singer, Schriesheim (DE); Werner Thesing, Lautertal (DE); Yue Zhu, Heidelberg (DE); and Omran Saleh, Wiesloch (DE)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Jul. 31, 2023, as Appl. No. 18/228,446.
Prior Publication US 2025/0045297 A1, Feb. 6, 2025
Int. Cl. G06F 16/27 (2019.01)
CPC G06F 16/273 (2019.01) 20 Claims
OG exemplary drawing
 
1. A system comprising:
a secondary database management system configured to asynchronously replicate a primary database management system remote from the secondary database management system, the secondary database management system comprising a first host performing a first source role, a second host performing a first replica role for the first source role, a third host performing a second source role, and a fourth host performing a second replica role for the second source role, the first host, the second host, third host, and fourth host being executable software components of the secondary database management system, the first host and the second host being for managing a first portion of data stored by the secondary database management system the third host and the fourth host being for managing a second portion of the data stored by the secondary database management system, and the secondary database management system being programmed to execute operations comprising:
receiving, by a coordinator component of the secondary database management system, a takeover request, the takeover request indicating that the secondary database management system is to assume a role of the primary database management system;
determining, by the coordinator component, that a last valid commit of the first host is an oldest last valid commit;
reverting the secondary database management system to a first state of the primary database management system corresponding to the last valid commit of the first host; and
after reverting the secondary database management system to the first state of the primary database management system, configuring the secondary database management system to assume the role of the primary database management system.