Patent ID: 7707181
Filing Date: 2010-04-27
Classification: G06F

Abstract:
1. A system for distributing replication commands from a distributor to a subscriber, the system comprising: a memory; a distributor for execution on a first computer in a network including a plurality of computers, the distributor comprising: a command queue that receives transactional replication commands from a publisher and stores the transactional replication commands in the memory, wherein each replication command corresponds to a change in data in a data row and is associated with a respective hash of a primary key of the data row to which the replication command is associated; a plurality of command buckets, wherein each of the plurality of command buckets is associated with a respective connection to the command queue and only one data row, and wherein at least a portion of a communication and logging overhead associated with a two phase commit operation is avoided by including for each of the plurality of command buckets an executor that executes a coordinated commit operation upon the plurality of command buckets at substantially the same time; a dispatcher, wherein the dispatcher: