June 19, 2008 at 2:46 pm
I appreciate few ideas on how to synchronize data from multiple database servers (the database servers can be MySQL, SQL Server, Oralce, etc.,). Hence, using features such as stored procedures, function, tables, view, etc., which are available across most of the database systems are better.
My requirements are there would be multiple database servers running data in-sync in all these databases i.e. if a record in one server1.table1 is updated it must be synchronized across all other server2.table1, server3.table1, etc., (there is no central server at all) Also, there would be cases where Server4.table1 could be offline & that record is updated by the user offline but when the Server4.table1 comes online it must be synchronized across all other databases. So I would need some ideas about what kind of algorithms can be used & how to achieve this?
~Thanks in advance.
June 20, 2008 at 12:24 pm
The only thing I can think of is relatively complex upserts from each server to each other server. There might be a product somewhere out there that can synchronize data across multiple storage engines, but I haven't used one.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply