Optimized savepoint during database recovery

    公开(公告)号:US10474541B2

    公开(公告)日:2019-11-12

    申请号:US15452439

    申请日:2017-03-07

    Applicant: SAP SE

    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.

    Delayed snapshot isolation for read service at a database

    公开(公告)号:US10452636B2

    公开(公告)日:2019-10-22

    申请号:US15361760

    申请日:2016-11-28

    Applicant: SAP SE

    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.

    Logical Equivalent Replication with Snapshot Based Failback of Database Systems

    公开(公告)号:US20180143881A1

    公开(公告)日:2018-05-24

    申请号:US15357689

    申请日:2016-11-21

    Applicant: SAP SE

    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.

    DATABASE REPLICATION WITH HOST REPLICATION AT ASYNCHRONOUSLY REPLICATED SYSTEM

    公开(公告)号:US20250045297A1

    公开(公告)日:2025-02-06

    申请号:US18228446

    申请日:2023-07-31

    Applicant: SAP SE

    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.

    INCREASED REPLICATION FOR MANAGED VOLUMES

    公开(公告)号:US20250045178A1

    公开(公告)日:2025-02-06

    申请号:US18228395

    申请日:2023-07-31

    Applicant: SAP SE

    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.

    Replication system takeover with handshake

    公开(公告)号:US11301341B2

    公开(公告)日:2022-04-12

    申请号:US16834317

    申请日:2020-03-30

    Applicant: SAP SE

    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.

    Logical equivalent replication with snapshot based fallback of database systems

    公开(公告)号:US10769040B2

    公开(公告)日:2020-09-08

    申请号:US15357689

    申请日:2016-11-21

    Applicant: SAP SE

    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.

    Testing database replication with multi-container system architecture

    公开(公告)号:US10565228B2

    公开(公告)日:2020-02-18

    申请号:US15451322

    申请日:2017-03-06

    Applicant: SAP SE

    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.

    Proxy views for extended monitoring of database systems

    公开(公告)号:US10380142B2

    公开(公告)日:2019-08-13

    申请号:US15362485

    申请日:2016-11-28

    Applicant: SAP SE

    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.

    Optimized Savepoint During Database Recovery
    20.
    发明申请

    公开(公告)号:US20180260286A1

    公开(公告)日:2018-09-13

    申请号:US15452439

    申请日:2017-03-07

    Applicant: SAP SE

    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.

Patent Agency Ranking