Database Replication

From: Daniel <daniel.ruetimann_at_dartecs.com.nospam>
Date: Thu, 9 Oct 2003 09:38:57 +0200
Message-ID: <3f851099$1_3@news.bluewin.ch>

I have to implement product independent database replication and would appreciate any hints on some theories regarding replication.

What I want (have) to do:

several databases on distributed servers
no master database
changes are made to any of the distributed databases
the changes have then to be synchronized on all databases

My customer wants a detailed desription of the used replication mechanisms and the source code that is doing this. So I can not use any commercial product. Furthermore the mechanism should potentially work with any available database without major changes in the replication software. (For the moment the databases will be ORACLE and InterBase).

I currently have two ideas how this could be realized:

Create my own "transaction log" in a database table and use that for replication
But a timestamp on each record of every table in my database

So my questions:

Does anyone know if 1) or 2) would be a good mechanism to use? Can anyone give me any pointers to (detailed) information regarding replication algorithms?

Thanks for any help!
Daniel Received on Thu Oct 09 2003 - 02:38:57 CDT