Patent ID: 7363332

Claim:
A computer-readable medium having stored thereon instructions, which, when executed by a computer, cause the computer to perform a method of synchronizing a table, wherein the method comprises: streaming, to a destination node, a data stream for a table of a source node, wherein the data stream comprises: static data for the table; a first end-of-stream message; snapshot data for the table comprising uncommitted changes associated with active transactions which are currently in progress on the source node, wherein active transactions involve the table; an end-of-snapshot message; and a second end-of stream message; creating, on the destination node, a copy of the table from the static data; before streaming snapshot data, pausing, on the source node, the active transactions; after streaming snapshot data, resuming, on the source node, the active transactions corresponding to the associated uncommitted changes that have been sent to the destination node; and initiating, on the destination node, active transactions that correspond to initialize-remote-transaction messages sent from the source node.