Peer to peer database replication

I've spent most of the day pouring over the web looking for
replication solutions for a peer-to-peer database architecture.

I'm writing software for networked embedded linux system that serves
up data using sqlite. Each peer on the network needs to have a copy of
the same db data and each peer is allowed to update the data. The
peers are expected to hop on and drop off routinely.

I've found some interesting data on the subject in the form of
somewhat dated (1999-2002) white papers.

The most promising, considering my development constraints (C++,
linux, sqlite) was a white paper by Yair Amir and Ciprian Tutu called
"From Total Order to Database Replication" and "Practical Wide-Area
Database Replication". This solution involves a description of an
algorithm and a network broadcast communication package called
"Spread".

I'm wondering if there are more recent frameworks or patterns that are
available (preferably open source). Recommendations anyone?

-dan

Here are some of the related data that I've found
* Practical Wide Area Database Replication - whitepaper (http://
www.cnds.jhu.edu/pub/papers/cnds-2002-1.pdf)
** Spead Toolkit (http://www.spread.org/)
* Clarinet - http://www.clarinet.co.uk/ePublishingClearnetCMS.html
* PeerDirect - Does not support sqlite
* Dalet - java based

.

Relevant Pages

  • Re: Replication/Sychronization and security
    ... When put on the network it takes several seconds for those close to ... I am told that our network drives are for data storage (word/excel ... explore the possiblity of replication as a solution. ... >> database to decrease the potential for breach. ...
    (microsoft.public.access.replication)
  • Re: Replication/Sychronization and security
    ... > require security because it contains medical data. ... > network with folder level security and the network has a very slow ... Replication is not for solving application performance issues. ... > database to decrease the potential for breach. ...
    (microsoft.public.access.replication)
  • Database replication
    ... faster setting it up on the local computer and not using the network, ... first time the program is run in a day, it makes a copy on the server ... they will be putting it on a dedicated Database server as SQLserver ... Database replication or something else may help. ...
    (microsoft.public.vb.general.discussion)
  • Re: is changing design master safe?
    ... Replication is certainly one way, but you are hampered if you don't ... You *can* establish a temporary network ... connection via modem connection and RAS, however, I don't have any ... third database that you *do* copy from location to location. ...
    (microsoft.public.access.replication)
  • Re: Errors in Directory Service Event Viewer
    ... >condition persists then please restore the database from a previous backup. ... >following directory partition. ... >Sites and Services for the KCC to create a spanning tree replication ... >- Add a Connection object to a domain controller that contains the directory ...
    (microsoft.public.windows.server.active_directory)
Loading