On 3/26/11 12:56 PM, hans...@gmail.com wrote:
> I may be wrong here, more reading than experience in this particular
> area, but my understanding is that it would still recommend making
> sure nothing's writing to the database while the dump is taken.
>
> For a heavily used transactional systems with complex relational
> structures, IMO it's possible that otherwise there would be data
> inconsistencies - e.g. this table's been updated but that one hasn't
> yet completed.
In theory, sql databases are supposed to enforce this at a transactional level
so if your server crashed you could recover to a consistent state after a
reboot
and an LVM snapshot should be approximation of that. In practice, applications
tend to not use transactions correctly for everything, partly because mysql has
a history of not supporting them, and LVM has a history of not propagating the
needed information anyway - so stopping the app cleanly is still a good idea if
it is at all practical.
--
Les Mikesell
lesmikes...@gmail.com
------------------------------------------------------------------------------
Enable your software for Intel(R) Active Management Technology to meet the
growing manageability and security demands of your customers. Businesses
are taking advantage of Intel(R) vPro (TM) technology - will your software
be a part of the solution? Download the Intel(R) Manageability Checker
today! http://p.sf.net/sfu/intel-dev2devmar
_______________________________________________
BackupPC-users mailing list
BackupPC-users@lists.sourceforge.net
List: https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki: http://backuppc.wiki.sourceforge.net
Project: http://backuppc.sourceforge.net/
