Subject Re: [firebird-support] Replication SW experience
Author Alan J Davies
Hi Slavek, there are a number of issues you need to resolve before
making a decision. If network performance is an issue then replication
is not the answer - unless you can send the changes back to head office
'out of hours'. This means the different databases will be out of sync
for some time. Is this acceptable from your customer's point of view?
Are there different production plants making the same item? What happens
if plant 1 and plant 2 make the same item on the same day?

I think you may have to generate your own version because replication is
not what you need (imho) but you could create a series of triggers and
tables to do what you want. e.g. if you have a table called PARTS,
create SYNC_PARTS and each time there is a change to PARTS you add a
record. You could then send your updates to HO via a scheduled update or
even within the same transaction if your network access allows for that.

Alan J Davies

On 25/11/2015 21:35, Slavomir Skopalik skopalik@...
[firebird-support] wrote:
> Hi all,
> we are preparing new project with bidirectional replication.
> Customer idea is to have master database in head quoter
> and slave databases on production plant (to solve network performance
> and availability issues).
> Witch replication SW you can recommend for this bidirectional replication?
> What is typical issues and weakness of this SW.
> Thank you.
> Slavek
> --
> Ing. Slavomir Skopalik
> Executive Head
> Elekt Labs s.r.o.
> Collection and evaluation of data from machines and laboratories
> by means of system MASA (
> ----------------------------------------------------------
> Address:
> Elekt Labs s.r.o.
> Chaloupky 158
> 783 72 Velky Tynec
> Czech Republic
> ----------------------------------------------------------
> Mobile: +420 724 207 851
> icq:199 118 333
> skype:skopaliks
> e-mail:skopalik@...