On 23 Jun 2004 at 19:46, Robert DiFalco wrote:

>I have a need to figure out some failover solutions for a firebird
>database.

It depends... What kind of fails you can expect? Which of them you
must go through without losses?
For HDD failure there are RAIDs.
For power failure there are UPSes and dual power units.
I don't know how to survive in the cases of flood, fire, explosion
or plane crashed into server room.
There is no good self-acting solution for bad users.

> Can anyone point me to any articles/whitepapers or
>suggestions for doing this with Firebird? Given three computers can I
>make two firebird servers and maybe have the third host the actual
>(.fdb) file?

.fdb files must be placed on the computer with FB server. You can't
use database file from network.

> Then maybe I can have a virtual IP address that can
>switch between these servers? Any thoughts or suggestions would be
>greatly appreciated.

If I were you, I'd set up two or more independent (and rather
geographically-distributed) servers and replication between them.
This way you can't reach 100% durability but data losses may be
minimized to minutes or even seconds.
And, of course, good backup schema is absolutely necessary. You
must have daily backups, weekly backups and annual backups splashed
across the building, town, country or even world. ;-)

SY, Dimitry Sibiryakov.