Re: DB Merge Replication


Perl: the Markov chain saw
	PerlMonks

Re: DB Merge Replication

by mpeppler (Vicar)

on Jun 30, 2004 at 15:39 UTC ( [id://370788]=note: print w/replies, xml )

Need Help??

in reply to DB Merge Replication

This is something that Sybase ASA combined with SQL Remote is really good at (which of course isn't really an answer that will be of any use to you...).

Building this sort of system in perl, and have it be reliable is likely to be a pretty serious project. I'd start with building a messaging system of some sort to push the data from the spokes to the hub. The main issue that I can see is making sure that updates are applied correctly, and that failures are detected (and retried if necessary.)

Michael

Comment on Re: DB Merge Replication

Replies are listed 'Best First'.

Re^2: DB Merge Replication
by trialmonkey (Hermit) on Jul 01, 2004 at 01:36 UTC

An open source solution would be ideal. The problem with the commercial products I've used is that while they're pretty solid, they all tend to have subtle bugs. With thousands of replicating nodes a few bugs translates into lots of questions regarding the state of the data. Because they're closed source, it's often difficult to understand what's really going on and get a real solution implemented.

Building this sort of system in perl, and have it be reliable is likely to be a pretty serious project.

Hence, I'm a SoPW and looking for some stable shoulders to stand on ;-)

[reply]

In Section Seekers of Perl Wisdom