公开(公告)号：US12086041B2

公开(公告)日：2024-09-10

申请号：US18045260

申请日：2022-10-10

Applicant: Salesforce, Inc.

Inventor： Kaushal Mittal ,  James E. Mace ,  Jun Chen ,  Shao-Yuan Ho

IPC: G06F16/24 ,  G06F11/20 ,  G06F16/2455

CPC classification number: G06F11/2092 ,  G06F16/2455 ,  G06F2201/85

Abstract: The disclosed techniques reduce a responsiveness time for a secondary node state of a database in switching from a second computing node to replace a first computing node acting in a primary node state, with both computing nodes performing the same database queries. The second node receives information regarding queries performed by the first node while in the primary state. In some embodiments, the second node retrieves, from a transaction log, log records detailing operations performed for database transactions. In some embodiments, the second node inserts, based on the log records, data records of the transactions into an in-memory cache of the second node that stores chains of database records from different transactions. Upon receiving sufficient information to switch to the primary state, the second node changes a mode of operation during failover making a committed transaction available for reads by subsequent database queries prior to record reordering.

公开(公告)号：US20240118982A1

公开(公告)日：2024-04-11

申请号：US18045260

申请日：2022-10-10

Applicant: Salesforce, Inc.

Inventor： Kaushal Mittal ,  James E. Mace ,  Jun Chen ,  Shao-Yuan Ho

IPC: G06F11/20 ,  G06F16/2455

CPC classification number: G06F11/2092 ,  G06F16/2455 ,  G06F2201/85

Abstract: The disclosed techniques reduce a responsiveness time for a secondary node state of a database in switching from a second computing node to replace a first computing node acting in a primary node state, with both computing nodes performing the same database queries. The second node receives information regarding queries performed by the first node while in the primary state. In some embodiments, the second node retrieves, from a transaction log, log records detailing operations performed for database transactions. In some embodiments, the second node inserts, based on the log records, data records of the transactions into an in-memory cache of the second node that stores chains of database records from different transactions. Upon receiving sufficient information to switch to the primary state, the second node changes a mode of operation during failover making a committed transaction available for reads by subsequent database queries prior to record reordering.