Subject | Re: Live backup firebird database using LVM |
---|---|
Author | Christian |
Post date | 2010-03-22T23:58:55Z |
In this case I'll prefer to do a LVM snapshot inside the OS and copy the database using rsync.
Due rsync differential algorithm and ssh protocol support, this process let me copy the database across a low bandwidth net at a very high speed and get in the target an operational database without needing a restore process.
As I understand from this thread, I must:
- use an OS and a Firebird version that support forced writes on (linux and FB > 2.1.3)
- have forced writes on.
- take the LVM snapshot inside the OS (not outside like virtual machines snapshots).
Thanks everybody
Regards
Christian
Due rsync differential algorithm and ssh protocol support, this process let me copy the database across a low bandwidth net at a very high speed and get in the target an operational database without needing a restore process.
As I understand from this thread, I must:
- use an OS and a Firebird version that support forced writes on (linux and FB > 2.1.3)
- have forced writes on.
- take the LVM snapshot inside the OS (not outside like virtual machines snapshots).
Thanks everybody
Regards
Christian
--- In firebird-support@yahoogroups.com, "Steffen Heil" <lists@...> wrote:
>
> Hi
>
> > A snapshot of a database that's suffering from caching by the operating
> system or disk controller will not be consistent either.
>
> Usually right, but LVM snapshots are software-based snapshots and will
> therefore not suffer from disk controller caching.
> Just make sure, forces writes are ON and WORKING.
>
> Even OS-caches should - from my POV - also not be a problem IF you take the
> LVM snapshots inside the OS that is caching - the OS should be knowing what
> it is doing.
>
> If you have virtualization and caches inside the guest and do LVM snapshots
> in the host, there is a good chance of problems, if forced writes are not
> working, which is much more problematic in virtualized environments.
>
> - LVM snapshots on linux are basically the same as volume shadow copies on
> Windows... Both should work.
>
> Regards,
> Steffen
>
>
>
> [Non-text portions of this message have been removed]
>