Ashley, what database engine would you be running? I'm guessing it'll be something Opensource, but we did have a project here a couple of years back that replicated three Oracle databases between three different sites round the World.... AFAIK it worked okay, but the bandwidth becomes an issue if there's a lot of traffic and a high frequency of updates.
Andi
"Ashley T. Howes" ashley@blueskyresearch.net on 10/07/2001 19:12:31 To: alug@stu.uea.ac.uk cc: (bcc: Andrew Chandler/PSD/LONDON/FTI)
Subject: [Alug] Sending information between databases
(This isn't a pure linux question, but I hope you can help)
What is a good system for sending information between databases, with minimal human interaction? Situation is that someone has a database in one location, another person has another copy. The list of tables/fields between the 2 databases is not exactly the same, but have several tables in common.
The two databases could be synched with a lot of human work, but is there a method to do this automatically - perhaps sending XML between the two? Anyone got experience in doing this sort of stuff?
Ashley
_______________________________________________ alug, the Anglian Linux User Group list Send list replies to alug@stu.uea.ac.uk http://www.anglian.lug.org.uk/ http://rabbit.stu.uea.ac.uk/cgi-bin/listinfo/alug See the website for instructions on digest or unsub!
********************************************************************* * Please visit the web site of the Financial Times at: * * http://www.ft.com * * * * For UK personal finance, please visit http://www.ftyourmoney.com * * * * This E-Mail is intended for the use of the addressee only and may * * contain confidential information. If you are not the intended * * recipient, you are hereby notified that any use or dissemination * * of this communication is strictly prohibited. * * If you receive this transmission in error, please notify us * * immediately then delete this E-Mail. * * * * * postmaster@ft.com * *********************************************************************
on 11/7/01 9:22 am, Andrew Chandler at Andrew.Chandler@ft.com wrote:
Ashley, what database engine would you be running?
It's a general question more than anything. Assume the database does not support native replication.
Ashley
On Wed, 11 Jul, 2001 at 9:50 +0100, Ashley T. Howes Ph.D. wrote:
It's a general question more than anything. Assume the database does not support native replication.
Hrm.
All I can say is, perhaps it's time to consider a database that DOES support native replication? Doing it yourself is going to be at best tricky, at worst prone to errors and omissions. When you're talking about customers valuable data, this is a BAD thing.
There's plenty of free databases out there that support it, so there's little cost argument against (aside from time to implement). Heck, even MySQL supports replication now, and you should all know my thoughts on *that* particular RDBMS-wannabe by now.... ;-)
Andrew.
-
Andrew Savory -
Andrew.Chandler＠ft.com -
Ashley T. Howes Ph.D.