Subject | IBReplicator performance |
---|---|
Author | mark.ruys |
Post date | 2011-04-05T18:21:28Z |
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
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