>> If I were you, I'd set up two or more independent (and rather
>> geographically-distributed) servers and replication between them.

Suggestions for the best way to replicate from one Firebird server to
another? Are there options that don't require Schema/Trigger changes?
GBAK?

________________________________

From: Dimitry Sibiryakov [mailto:SD@...]
Sent: Thursday, June 24, 2004 12:07 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Suggestions for Failover

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.



Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129au0b5i/M=298184.5022502.6152625.3001176/
D=groups/S=1705115386:HM/EXP=1088143870/A=2197946/R=0/SIG=11elgumq7/*htt
p://www.netflix.com/Default?mqso=60183367>

<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=group
s/S=:HM/A=2197946/rand=968621423>

________________________________

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe
>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .