Re: Remote Sync

On Wed, 2006-03-15 at 17:12 -0500, Daniel Blaisdell wrote:
> I am currently in a situation where I have a distributed application
> between a few remote nodes all connecting to a central database. I
> have been searching for a database replication or synchronization
> system that will allow a disconnected node to operate independently of
> the central database. The ultimate intention of this type of system is
> to have an application operate off of data locally and have those
> changes synced in the background.
>
> >From the research I've done, Slony doesn't support multi-master
> writers. PGCluster and ExtenDB seem to require all nodes be next to
> each other with the ultimate goal of local load balancing.
>
> Are there any solutions that come close to the requirements I'm after?
>
> Thanks for any input,

Is this situation multi-master? If you partition your data at each
distributed node, then each is a single master to different data. You
can then make the central database the slave to multiple distributed
master databases.

Remote table1 -> central table1
Remote table2 -> central table2 etc

You can then link all the central tables together using:
- inheritance partitioning
- UNION ALL views

Best Regards, Simon Riggs