Subject Re: [firebird-support] FB 1.5.x SS Redundancy
Author Alexandre Benson Smith
Daniel R. Jimenez wrote:

>Hi,
>
>I have had a look at Helen's book, but unfortunately I have not found a
>answer, I was not expecting one, as I believe this is probably to far of
>topic for the book.
>
>I would like know if there is a build in facility on FB 1.5.x SS, which
>allows for full live automated DB redundancy to a separate PC (the FDB on
>PC-2 is identical to the FDB on PC-1 at all times, 24/7), so that if PC-1
>was to go up in flames, PC-2 could take over transparently.
>
>That is, the application will see that the connection to PC-1 is down, so it
>would switch to PC-2, so with transparently, what I really mean, is that our
>application(s) does not have to take responsibility for keeping the two FDB
>in perfect sink at all times, etc.
>
>If this is not part of FB 1.5.x SS what tools do the members of this group
>recommend?
>
>
>Thank you
>
>daniel
>
>
I think a shadow could reside on a NFS share.

But what I can think to be a more robust approach will be replication.

You set-up the server 1 to replicate everything to server 2

Then when connection goes down, your app connects to the second server.

A one way replication like this should be easy to implement.

Maybe others could give other ideas.

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.3.2 - Release Date: 31/05/2005