Subject | Byte Level Replication and Firebird |
---|---|
Author | m2data |
Post date | 2006-02-28T10:05:50Z |
Hi all,
Are any of you using byte level replication with Firebird (fx Double
Take)?
I know about IBReplicator (not fully testet), but it adds a lot of
modifications to the database (Triggers) which I don't like. 1) It
makes it difficult to make a copy that can run on my local machine
for debugging. 2) I also need to modify my replication settings
every time the database structure changes (metadata). It can be
done of cause but it is possible to make errors (fx forgetting a
table).
Currently we have 58 databases running on 3 ASP servers (Terminal
Server). I need those to be replicated to 3 other servers. GBak is
OK for backup (takes 4 hours to run), but that will set me back a
hole day in case of disk crash. NBackup will solve part of the
problem by settings it up to run every half hour but it is still not
super.
Each database size ranges from 200Mb to 4Gb. It is primary read and
little write (UPDATE/INSERT) because data is locked for changes when
it is more then 48 hours old.
By the way, my connection between the servers is 100Mbps.
Brian
Are any of you using byte level replication with Firebird (fx Double
Take)?
I know about IBReplicator (not fully testet), but it adds a lot of
modifications to the database (Triggers) which I don't like. 1) It
makes it difficult to make a copy that can run on my local machine
for debugging. 2) I also need to modify my replication settings
every time the database structure changes (metadata). It can be
done of cause but it is possible to make errors (fx forgetting a
table).
Currently we have 58 databases running on 3 ASP servers (Terminal
Server). I need those to be replicated to 3 other servers. GBak is
OK for backup (takes 4 hours to run), but that will set me back a
hole day in case of disk crash. NBackup will solve part of the
problem by settings it up to run every half hour but it is still not
super.
Each database size ranges from 200Mb to 4Gb. It is primary read and
little write (UPDATE/INSERT) because data is locked for changes when
it is more then 48 hours old.
By the way, my connection between the servers is 100Mbps.
Brian