Subject | Re: [firebird-support] Database for images |
---|---|
Author | Fabiano Bonin |
Post date | 2007-05-07T04:24:07Z |
> Backing up a database of this size would probably be best using a tool likeI think it's the first time i heard about someone using rsync to
> rsync, that only moves changes between files.
>
> http://rsync.samba.org/
>
> Steps would be:
>
> Shutdown the database on the primary server
>
> Rsync your .fdb file to your backup machine (could take several minutes,
> depending on network), which then makes both .fdb files identical
>
> Start your database back up again.
>
> Rsync is available for all platforms, and is completely free.
>
> We use it for all of our firebird synchronizations, even on live databases,
> although we use FreeBSD filesystem snapshots, which Linux and Windows are
> yet to "invent".
synchronize firebird databases. I would like to know more about your
experience.
- Did you measure if rsync is efficient to make its job in this case?
I don't know FB internals, but after some thousands of transactions,
is the database file in a state rsync can track its similarities and
still optimize the transfers?
- Do you really do this on live databases? Never had problems? Maybe
if i lock the database (as if i would make a file copy) i could use
this approach on windows/linux.
- Is there someone doing this?
Regards,
Fabiano.