Recovering from interruptions in database replication streams

    公开(公告)号:US12242505B1

    公开(公告)日:2025-03-04

    申请号:US18194568

    申请日:2023-03-31

    Abstract: Interruptions in an ordered replication stream can be received from in a database. A database instance of the ordered replication stream may detect missing log records and then evaluate log records that are subsequently received to determine whether to update a portion of an in-memory data structure for performing database requests using a comparison of sequence numbers of the last update corresponding to the portion of the in-memory data structure indicated in the log record and the last update recorded for the portion of the in-memory data structure. For comparison indicating valid portions, the log record can be used and for comparison indicating invalid portions, the portion of the in-memory data structure can be made unavailable.

    Synchronous database geo-mirroring using delayed visibility write operations

    公开(公告)号:US11144407B1

    公开(公告)日:2021-10-12

    申请号:US16588868

    申请日:2019-09-30

    Abstract: Systems and methods are disclosed to implement a synchronous database mirroring technique using delayed visibility write operations. In embodiments, a durable log of write operations in a primary database is replicated to a secondary database. The two databases do not make corresponding operations durable in a synchronous manner. However, the two databases coordinate to provide a visible view of the two durable logs that is guaranteed be durable in both databases. In embodiments, the primary database may monitor the state of the durable log of the secondary database, and periodically update the visible range of the logs to include operations that have been made durable in both databases. Advantageously, the visible range of the logs is permitted to grow asynchronously from the logs themselves, so that the two databases can provide a synchronized visible view of the log data without placing timing constrains on the data's durability.

    Minimizing connection loss when changing database query engine versions

    公开(公告)号:US12038946B1

    公开(公告)日:2024-07-16

    申请号:US18194579

    申请日:2023-03-31

    CPC classification number: G06F16/27 G06F16/2329

    Abstract: Connection loss may be minimized for performing database query engine changes. A distributed database system may include different instances of the query engine that provide access to a database. When an event to change the version of the query engine is detected, a copy of the database may be created and a new instance of the query engine created. Read-only access to the database may be maintained using the different instances of the query engine while the new instance may be upgraded to the different version of the query engine. Upon successful installation of the different version of the query engine at the new instance, the new instance may be given read-write access to the database using the copy of the database and other database instances may be upgraded to the different version of the query engine.

Patent Agency Ranking