On 19.06.2015 19:14, Graeme Geldenhuys wrote:
Hi,
[Apologies in advance - I know this is not a Firebird list, but here are
many Firebird DB users that could possibly comment.]
Has anybody here used any Firebird database replication software?
I've been reading up on it a bit, and there seems to be more options
available that I expected. Has anybody tried any of them, and could
possibly give some comment.
FBReplicator - open source
http://www.meta.com.au
I did my replication service application 7 years ago, its still work. I
used firebird 1.5.6. On center store has a server computer, and this db
work on LAN more then clients same time. 8 store in different cities.
All off them has a two way replication. Main store sent data to first
store, maybe same time or any time first store can sent data to main
store too. Connection is 8mb adsl line. 2 store has 4mb adsl line. if
any db(store) has a change record(s) (insert, update, delete) sent to
all others dbs. So each store has a same ALL datas, and see just self data.
I recommend,
-)need good work on developing tables and stores unique keys
-)use http://www.winton.org.uk/zebedee/index.html for compress data
and secure datas
-)if you use joined tables, don't forget replication tables order
-)use commit after minimum records post. example: after 5-10 records,
'cos if has a problem, in 999. record have to rollback all of them, and
restart from 1. this is lost time and make problem.
-)create replication user and make roles
--
_______________________________________________
Lazarus mailing list
Lazarus@lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
