- Patent Title: Transmitting change data capture events during database replication
-
Application No.: US18091313Application Date: 2022-12-29
-
Publication No.: US12079206B2Publication Date: 2024-09-03
- Inventor: Narsimha Reddy Challa , Swaroop Jayanthi , Komalapriya J , Ramalinga Raju Kalidindi
- Applicant: Salesforce, Inc.
- Applicant Address: US CA San Francisco
- Assignee: Salesforce, Inc.
- Current Assignee: Salesforce, Inc.
- Current Assignee Address: US CA San Francisco
- Main IPC: G06F16/23
- IPC: G06F16/23 ; G06F16/27

Abstract:
An online system performs replication of database from one system to another. A source database is replicated to a target database by performing an initial bulk copy followed by repeated change data capture. The system performs batching to group events generated by the change data capture events. The system performs a multi-constrained analysis to determine when a batch is ready for sending. The system uses multiple buffers for transmitting events to decouple the receiving and sending of events. The online system may be a multi-tenant system the source and target databases stores data of tenants. The system determines a tenant score to adjust the resources allocated during event transfer. The system splits an event into partial events, to avoid dependency between the partial events so that tasks can be executed independent of each other. Therefore, the system performs replication with reduced synchronization overhead.
Public/Granted literature
- US20240220484A1 TRANSMITTING CHANGE DATA CAPTURE EVENTS DURING DATABASE REPLICATION Public/Granted day:2024-07-04
Information query