Note: "permalinks" may not be as permanent as we would like,
direct links of old sources may well be a few messages off.
H.D. <devnull at deleted.on.request.example> writes:
> What confuses me is that page:
>
> http://mike.kruckenberg.com/archives/2006/05/mysql_backups_u.html
>
> It states `LVM doesn't do a true online backup, although it gets
> close.'.
>
> To me that reads `LVM is only capable of creating an "almost
> consistent" snapshot'.
>
> Is that true?
A genuine online backup requires that your file system and application
participate to some degree; XFS can participate -- automatically, as I
understand, for recent kernels -- in an LVM snapshot.
Then you require only that your application is either notified to sync
state appropriately or it is "always consistent" in the way that
PostgreSQL is.
MySQL ... may or may not play nicely in this regard. My experience has
been pretty uniformly poor but I do believe it theoretically supports
this sort of snapshot.
Regards,
Daniel
--
Digital Infrastructure Solutions -- making IT simple, stable and secure
Phone: 0401 155 707 email: contact at digital-infrastructure.com.au
http://digital-infrastructure.com.au/