Subject Re: firebird replication
Author Adam
--- In, Matteo Cazzador <matteo@e...>
> Alan McDonald wrote:
> >>Alan McDonald wrote:
> >>
> >>
> >>
> >>>>Is it possible to have a realtime copy of firebird database
> >>>>for backup like mysql replication or similar
> >>>>not using commercial software?
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>i 'have seen shadow, it seem's to be what i need,
> >>but what i must to do to use shadow file
> >> Only rename .shd in fdb or something other?
> >>
> >>
> >>
> >
> >just be aware that when using shadow, any corruption in the master is
> >immediately a corruption in the shadow.
> >Avoid developing on a database with a shadow active and users
connected. And
> >make sure the shadow is on another physical disk on the server box.
Not much
> >use (makes no sense) if it's on the same disk.
> >Alan
> >
> >
> >
> >
> thank's a lot
> i'm using firebird from is born and i'm very
> sutisfied from it , only one thing is not useful
> replication in fact. I try with shadow i 've an application
> that must live 24 for hours a day and a fail over is very
problematic for me
> backup restore is not useful shadow maybe.
> I use php+apache2+firebird a corruption by application using is very
> difficult to verify ( latest famous words..................)
> i need to repristinate latest dats as soon as possible shadow maybe
> the solution.
> the top will be a network replication like mysql native replication
> is it a new feautures of firebird 2.0?


Alan was pointing out that a shadow can not replace a backup restore.
The reason is pretty simple. The moment that the "master" gets
corrupted, the shadow will also get corrupted. It is useful for
protecting against hard drive failure if that is an important aspect
of your application.

You can download the Firebird 2 alpha release notes from This contains what is included in Firebird 2.