Subject IBReplicator performance
Author mark.ruys
Hi,

For redundancy, we need a master/slave configuration for a Firebird database (classic server 2.1.3 running on CentOS 5.5). We already lost a production database once (due to a combination of a stupid typo + a undocumented gbak -Z 'feature') and this should never ever happen again. In this forum, and in firebird-support, IBReplicator gets referred to regularly as the preferred mirroring solution. Which seems to be a reasonable choice to me.

Someone told me that replicating a complete database (15 GB in our case) might take a considerable performance hit. Is this indeed the case? (Probably this depends on the number of transactions which need to be processed per second.)

Could anyone share hands-on experience on Firebird database mirroring? It would be more then welcome :) For example:
- better alternatives for IBReplicator?
- is it difficult to set up (I found MySQL replication straightforward)?
- is it stable (like running for months/years without any intervention)?
- is it unwisely to replicate to a off-site remote server w.r.t. performance/stability?

Thanks,

Mark