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

Follow up: This is a follow up my own post.

Since some solutions mentioned above require that I use another
database (Oracle, Postgres, etc.) I decided I needed something that
could integrate with my sqlite database.

One of the authors of the white papers that I mentioned above replied
to an email request for information. He said that
There is a group called Spread Concepts that have developed code based
on the algorithms defined in the white papers. This code is available
for purchase.

http://www.spreadconcepts.com/replicationSuite.html

The "Congruity Engine" and the Spread Toolkit, in theory, should give
me the peer to peer replication needs along with the ability to
integrate with an existing data store.

I'm investigating licensing costs. The Spread toolkit is open source
but it does have some restrictions that our marketing people may not
like.
-dan