-
公开(公告)号:US10474541B2
公开(公告)日:2019-11-12
申请号:US15452439
申请日:2017-03-07
Applicant: SAP SE
Inventor: Christoph Roterring , Dirk Thomsen , Reiner Singer
Abstract: Recovery of a database system can be initiated by taking the database system offline. Thereafter, recovery operations specified by a redo log of the database system are replayed. During the replaying, updates to pages implicated by the recovery operations are blocked. In parallel, modified pages are flushed to physical disk storage. The database is later brought online after all of the recovery operations are replayed.
-
公开(公告)号:US10452636B2
公开(公告)日:2019-10-22
申请号:US15361760
申请日:2016-11-28
Applicant: SAP SE
Inventor: Kyu Hwan Kim , Juchang Lee , Beomsoo Kim , Chang Gyoo Park , Reiner Singer , Christoph Rottering , Werner Thesing , Michael Muehle
IPC: G06F16/00 , G06F16/23 , G06F16/245 , G06F16/27
Abstract: A computer implemented method is provided comprising receiving a group of transaction logs from a first database, allocating transaction logs from the group of transaction logs to a first queue and to a second queue, generating an end-of-group transaction log indicative of an end of the group of transaction logs, allocating the end-of-group log to the first queue and the second queue; replaying transaction logs from the first queue including the end-of-group transaction log allocated to the first queue, replaying transaction logs from the second queue including the end-of-group transaction log allocated to the second queue; and changing visibility of one or more transactions in response to replaying the end-of-group transaction log allocated to the first queue and the end-of-group transaction log allocated to the second queue. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号:US20180143881A1
公开(公告)日:2018-05-24
申请号:US15357689
申请日:2016-11-21
Applicant: SAP SE
Inventor: Reiner Singer , Werner Thesing
CPC classification number: G06F11/1658 , G06F11/2094 , G06F11/2097 , G06F2201/80 , G06F2201/855
Abstract: A computer implemented method for replication includes registering a first database system with a second database system and performing a failback operation on the first database system. The failback operation includes opening a snapshot that includes data known to have existed on the first database system and the second database system at a first time. Transaction log information is requested from the second database system. The transaction log information corresponds to transactions performed on the second database system beginning with the first time. The transaction log information is applied to the snapshot data on the first database system. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号:US20250045297A1
公开(公告)日:2025-02-06
申请号:US18228446
申请日:2023-07-31
Applicant: SAP SE
Inventor: Markus Behrens , Reiner Singer , Werner Thesing , Yue Zhu , Omran Saleh
IPC: G06F16/27
Abstract: Various examples are directed to systems and methods for operating a primary database management system and a secondary database management system. The secondary database management system may receive a takeover request indicating that the secondary database management system is to assume a role of the primary database system. The secondary database management system may determine that a last valid commit of a first host of the secondary database system is an oldest last valid commit. The secondary database management system may revert to a first state of the primary database management system corresponding to the last valid commit of the first host. The secondary database management system may be configured to assume the role of the primary database management system.
-
公开(公告)号:US20250045178A1
公开(公告)日:2025-02-06
申请号:US18228395
申请日:2023-07-31
Applicant: SAP SE
Inventor: Markus Behrens , Reiner Singer , Werner Thesing , Yue Zhu , Mitja Kleider , Omran Saleh , Timo Sulg , Marcel Birn , Christoph Roterring
Abstract: A scale-out computing cluster may include a large number of computing servers and storage devices. In order to provide high reliability, the computing cluster must be able to handle failures of individual devices. Reliability of the computing cluster may be improved by providing a standby server for each active server in the computing cluster. If any active server fails, the corresponding standby server is activated. The failed server may be brought back online or replaced, at which time the restored server becomes the standby server for the now-active original standby server. During the restoration period, if any other active server fails, the standby server for that active server is immediately activated. As a result, the recovery ability of the computing cluster is only challenged if both servers of an active/standby pair fail during the restoration period, substantially improving reliability.
-
公开(公告)号:US11301341B2
公开(公告)日:2022-04-12
申请号:US16834317
申请日:2020-03-30
Applicant: SAP SE
Inventor: Christoph Roterring , Reiner Singer , Werner Thesing
Abstract: A method, a system, and a computer program product for executing a takeover process. A takeover process of a primary computing system by a secondary computing system is triggered. The secondary computing system stores transaction data replicated from the primary computing system. Writing of a redo log of transaction data of one or more transactions into storage by the primary computing system is suspended. The redo log is written by the primary computing system prior to the suspending is transmitted to the secondary computing system. The takeover process of the primary computing system by the secondary computing system is executed upon receiving and persisting the redo log at the secondary computing system.
-
公开(公告)号:US10769040B2
公开(公告)日:2020-09-08
申请号:US15357689
申请日:2016-11-21
Applicant: SAP SE
Inventor: Reiner Singer , Werner Thesing
Abstract: A computer implemented method for replication includes registering a first database system with a second database system and performing a failback operation on the first database system. The failback operation includes opening a snapshot that includes data known to have existed on the first database system and the second database system at a first time. Transaction log information is requested from the second database system. The transaction log information corresponds to transactions performed on the second database system beginning with the first time. The transaction log information is applied to the snapshot data on the first database system. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号:US10565228B2
公开(公告)日:2020-02-18
申请号:US15451322
申请日:2017-03-06
Applicant: SAP SE
Inventor: Martin Heidel , Michael Muehle , Reiner Singer , Johannes Haeussler , Timo Hochberger , Mohamed Ali Chriki , Sascha Bastke
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.
-
公开(公告)号:US10380142B2
公开(公告)日:2019-08-13
申请号:US15362485
申请日:2016-11-28
Applicant: SAP SE
Inventor: Edward-Robert Tyercha , Thomas Simenec , Thomas Theodor Koetter , Reiner Singer
Abstract: A computer implemented method for monitoring databases includes providing views for monitoring information associated with a first datacenter and proxy views for monitoring information associated with a second datacenter. The first datacenter receives a query for monitoring information and parses the query to identify filter information that identifies which of the first or second datacenter the requested services are running on. If the filter information indicates the service is running on the first datacenter, the first datacenter queries the views to request the monitoring information from the server on the first datacenter running the requested service. If the filter information indicates the service is running on the second datacenter, the first datacenter queries the proxy views to request the monitoring information from the server on the second datacenter running the requested service, and receives the monitoring information. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号:US20180260286A1
公开(公告)日:2018-09-13
申请号:US15452439
申请日:2017-03-07
Applicant: SAP SE
Inventor: Christoph Roterring , Dirk Thomsen , Reiner Singer
Abstract: Recovery of a database system can be initiated by taking the database system offline. Thereafter, recovery operations specified by a redo log of the database system are replayed. During the replaying, updates to pages implicated by the recovery operations are blocked. In parallel, modified pages are flushed to physical disk storage. The database is later brought online after all of the recovery operations are replayed.
-
-
-
-
-
-
-
-
-