-
公开(公告)号:US20190155705A1
公开(公告)日:2019-05-23
申请号:US15877074
申请日:2018-01-22
Applicant: SAP SE
Inventor: Mahendra Chavan , Reiner Singer , Markus Behrens , John Smirnios , Anant Agarwal
Abstract: Disclosed herein are system, method, and computer program product embodiments for coordinated replication of heterogeneous database stores. An embodiment operates by determining a synchronization point based on a commit log of a primary data center. A current log position of each of a plurality of secondary slave servers associated with a secondary master server of a secondary data center is requested. It is determined that the current log position of at least one of the secondary slave servers does not correspond to the logged position of a corresponding primary slave server relative to the synchronization point. An update indicating that the current log position of each of the secondary slave servers corresponds to the logged position of each of the relative corresponding primary slave servers is received. A replay of each of the secondary slave servers up to the synchronization point is initiated.
-
公开(公告)号:US11042568B2
公开(公告)日:2021-06-22
申请号:US16457170
申请日:2019-06-28
Applicant: SAP SE
Inventor: Edward-Robert Tyercha , Thomas Simenec , Thomas 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.
-
公开(公告)号:US20180150496A1
公开(公告)日:2018-05-31
申请号: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: G06F17/30
CPC classification number: G06F16/2322 , G06F16/2365 , G06F16/2379 , G06F16/2386 , G06F16/245 , G06F16/27 , G06F16/273
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.
-
公开(公告)号:US11200221B2
公开(公告)日:2021-12-14
申请号:US16576498
申请日:2019-09-19
Applicant: SAP SE
Inventor: Kyu Hwan Kim , Juchang Lee , Beomsoo Kim , Chang Gyoo Park , Reiner Singer , Christoph Roterring , 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.
-
公开(公告)号:US20200012633A1
公开(公告)日:2020-01-09
申请号:US16576498
申请日:2019-09-19
Applicant: SAP SE
Inventor: Kyu Hwan Kim , Juchang Lee , Beomsoo Kim , Chang Gyoo Park , Reiner Singer , Christoph Roterring , Werner Thesing , Michael Muehle
IPC: G06F16/23 , G06F16/245
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.
-
公开(公告)号:US20190324974A1
公开(公告)日:2019-10-24
申请号:US16457170
申请日:2019-06-28
Applicant: SAP SE
Inventor: Edward-Robert Tyercha , Thomas Simenec , Thomas 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 associated with services running on the first datacenter and/or the second datacenter. The first datacenter 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.
-
公开(公告)号:US20180150541A1
公开(公告)日:2018-05-31
申请号:US15362485
申请日:2016-11-28
Applicant: SAP SE
Inventor: Edward-Robert Tyercha , Thomas Simenec , Thomas Theodor Koetter , Reiner Singer
CPC classification number: G06F16/275 , H04L43/028 , H04L43/045 , H04L43/0876 , H04L67/1004 , H04L67/1095 , H04L67/1097 , H04L67/2819 , H04L67/32
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 associated with services running on the first datacenter and/or the second datacenter. The first datacenter 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.
-
公开(公告)号:US20250045034A1
公开(公告)日:2025-02-06
申请号:US18228412
申请日:2023-07-31
Applicant: SAP SE
Inventor: Markus Behrens , Reiner Singer , Werner Thesing , Yue Zhu , Mitja Kleider , Omran Saleh , Timo Sulg , Jan Scheperski , Markus Glatz , Steffen Michael Wagner , Ahsan Nasir
Abstract: Various examples are directed to systems and methods for operating a database management system. A first host of a first version may be executed at a first container of a cloud environment. A second host of a second version may be executed at a second container of the cloud environment. The first host may be configured to perform a source role and the second host may be configured to perform a replica role corresponding to the source role. A network layer executing at the cloud environment may receive a request directed to the second host. The network layer may determine that the request is consistent with allowed request data describing allowed requests and may send the request to the second host.
-
公开(公告)号:US11216346B2
公开(公告)日:2022-01-04
申请号:US15877074
申请日:2018-01-22
Applicant: SAP SE
Inventor: Mahendra Chavan , Reiner Singer , Markus Behrens , John Smirnios , Anant Agarwal
Abstract: Disclosed herein are system, method, and computer program product embodiments for coordinated replication of heterogeneous database stores. An embodiment operates by determining a synchronization point based on a commit log of a primary data center. A current log position of each of a plurality of secondary slave servers associated with a secondary master server of a secondary data center is requested. It is determined that the current log position of at least one of the secondary slave servers does not correspond to the logged position of a corresponding primary slave server relative to the synchronization point. An update indicating that the current log position of each of the secondary slave servers corresponds to the logged position of each of the relative corresponding primary slave servers is received. A replay of each of the secondary slave servers up to the synchronization point is initiated.
-
公开(公告)号:US20210303421A1
公开(公告)日:2021-09-30
申请号: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.
-
-
-
-
-
-
-
-
-