title: Synchronizing table data across databases
body: <p>I have one table that records its row insert/update timestamps on a field.</p>
  
  <p>I want to synchronize data in this table with another table on another db server. Two db servers are not connected and synchronization is one way (master/slave). Using table triggers is not suitable</p>
  
  <p>My workflow:</p>
  
  <ul>
  <li>I use a global last_sync_date parameter and query table Master for
  the changed/inserted records </li>
  <li>Output the resulting rows to xml </li>
  <li>Parse the xml and update table Slave using updates and inserts</li>
  </ul>
  
  <p>The complexity of the problem rises when dealing with deleted records of Master table. To catch the deleted records I think I have to maintain a log table for the previously inserted records and use sql "NOT IN". This becomes a performance problem when dealing with large datasets.</p>
  
  <p>What would be an alternative workflow dealing with this scenario?</p>