| Subject | Re: Live backup firebird database using LVM |
|---|---|
| Author | Christian |
| Post date | 2010-04-01T15:44:23Z |
Yes, the bug is documented here:
https://bugzilla.kernel.org/show_bug.cgi?id=9554
The solution is to use kernel 2.6.31 with EXT3 (enabling barriers) or EXT4 (which have barriers enabled by default).
This problem should be documented in Firebird documentation, because using LVM2 (which most Linux server configure by default) with prior kernels is not safe for database integrity.
Regards
https://bugzilla.kernel.org/show_bug.cgi?id=9554
The solution is to use kernel 2.6.31 with EXT3 (enabling barriers) or EXT4 (which have barriers enabled by default).
This problem should be documented in Firebird documentation, because using LVM2 (which most Linux server configure by default) with prior kernels is not safe for database integrity.
Regards
--- In firebird-support@yahoogroups.com, "Rick Debay" <rdebay@...> wrote:
>
> Write barriers are not supported in LVM until kernel 2.6.29. There is a
> claim of a bug in the implementation, I don't know if it got fixed in
> the next release.
> So don't depend on your data forced to disk if you're using LVM and
> kernel 2.6.29 or earlier.
>
> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Christian
> Sent: Friday, March 19, 2010 9:00 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Live backup firebird database using LVM
>
> I need to hot backup large Firebird databases to other physical
> locations.
> This databases are in LVM partitions.
> It's safe to snapshot the filesystem and copy the file database (from
> the snapshot of course) to the other location using rsync?
> There are any risk to get a corrupted database?
>
> Regards
> Christian
>
> Disclaimer: This message (including attachments) is confidential and may be privileged. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. RxStrategies, Inc. shall not be liable for the improper or incomplete transmission of the information contained in this communication or for any delay in its receipt or damage to your system. RxStrategies, Inc. does not guarantee that the integrity of this communication has been maintained nor that this communication is free from viruses, interceptions or interference.
>