Pseudo replication

replicate.rb

# From remote

Connect(home_base, username, password)
last_id_replicated = SELECT highest_replicated_id FROM replication_information WHERE computer = self.name
Connect(local_db, username, password)
to_replicate = local_machine.SELECT * FROM tracked_points WHERE id > last_id_replicated 
to_replicate.every_thousand_records
  start_transaction
    INSERT INTO home_base.big_table (computer_name, x, y, recorded_at) VALUES (self.name, thousand_records.x, thousand_records.y, thousand_records.recorded_at)
    UPDATE replication_information SET last_updated_at = Time.now, highest_replicated_id = thousand_records.last.id WHERE computer_name = self.name
  end_transaction