What are your opinions of DRBD/Heartbeat for replication and failover for the Firebird RDBMS?

Question

I am researching the possibility of using Firebird for a project.

However, one potential problem is replication and failover, or rather, lack of a (subjective) "good" solution. There are several potential solutions listed in the Firebird FAQ but they are either 1) Windows-centric; 2) horribly outdated; 3) commerical; or 4) not full-featured.

The only potential option I see is FIBRE and that looks 1) immature; 2) potentially dead; and 3) not full-featured.

I've learned about DRBD and Heartbeat and these solutions look promising. I am looking for your feedback should you already have 1) setup a replicated Firebird configuration; and/or 2) used DRBD with Firebird.

Any "gotchas", recommendations, tips, etc.?

Thanks!

Answer 1

There is one session about replication in Firebird Conference 2009

Holger Klemt

* Firebird Replicated Part 1
* Firebird Replicated Part 2
      o In this two sessions you will see how easy it is to implement

your own replication system in a Firebird database. Based on triggers and simple scripts, your can create a live backup system. The architecture allows master-master, master-slave, multi-master, online and offline replication. The replicated Firebird cluster can be used by any client without interuption, also in the case of partial hardware failures, planned hardware and software maintenance operations, for example the switch to a new Firebird version.