Re: federated tables? synchronization? replication? backup?
Posted by:
fran cisco
Date: February 24, 2015 10:42AM
Peter Brawley Wrote:
-------------------------------------------------------
> > Could I merge information from multiple client
> tables into one?
>
> Federated tables by themselves won't provide a
> fully synchronising solution. There are 3P
> solutions, one is PervaSync, I don't know
> firsthand how good it is. Or you can roll your own
> along the lines you've sketched.
Well, I've been doing some research and it looks like synch'ing tables from local servers into a remote one is more complex than it looks at first view, and it requires to be made either manually or with 3P tools as you suggested (symmertricDS)
Nevertheless, If anyone suggest a better manual approach than the cronjob + sqldump, I'm all ears.
THank you
Subject
Written By
Posted
February 23, 2015 06:31PM
February 23, 2015 07:07PM
Re: federated tables? synchronization? replication? backup?
February 24, 2015 10:42AM
February 24, 2015 06:42PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.