Database Replication
From: Daniel <daniel.ruetimann_at_dartecs.com.nospam>
Date: Thu, 9 Oct 2003 09:38:57 +0200
Message-ID: <3f851099$1_3_at_news.bluewin.ch>
I have to implement product independent database replication and would appreciate any hints on some theories regarding replication.
Date: Thu, 9 Oct 2003 09:38:57 +0200
Message-ID: <3f851099$1_3_at_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 - 09:38:57 CEST