SYSTEMS AND METHODS FOR HIGH SPEED REMOTE CHANGE DATA CAPTURE

摘要

A system and method are described for change data capture wherein a source database is replicated to a remote database. In one embodiment, a data storage device contains source log blocks containing information regarding database transactions processed for a source database, wherein the data storage device and source database are located in a first location, and at least some of the source log blocks include a plurality of database transactions in the same order as processed in the source database. Messages containing source log blocks are sent from the first location to a second location geographically remote from the first location. One or more components at the second location receive source log blocks from the messages, extract the source transaction data from the source log blocks, and use the source transaction data to write database transaction information to a second database based on the extracted source transaction data.

主权项

1. A method, comprising:
writing source database transactions to a circular log file in order of their occurrence, the source database transactions being processed to commit to a source database; spilling log blocks from the circular log file in time order wherein the spilled log blocks comprise the database transactions, and further wherein all of the database transactions in the spilled log blocks are committed; and receiving the spilled log blocks and assembling the spilled log blocks into each of a plurality of messages, and sending the messages, in time order of the spilled log blocks they contain, to a location geographically remote from the source database.