Derek, That's risky. Just read lock the DB, create the lvm snapshot and release the lock. Otherwise you risk a transaction to be interrupted.
Best Regards, Strahil NikolovOn May 13, 2019 16:47, Derek Atkins <[email protected]> wrote: > > Strahil <[email protected]> writes: > > > Another option is to create a snapshot, backup the snapahot and merge > > the disks (delete the snapshot actually). > > Sadly that option doesn't work with Databases, as you might inyerrupt > > a transaction and leave the DB in inconsistent state. > > Yet another reason to do it from inside the VM. > > What I do (on systems that have a running database) is to run a "flush" > operation to sync the database to disk, and then from within the flush > operation I create an LVM snapshot, and then I backup off the snapshot. > If I'm not running a database, then I just create the snapshot directly. > > > Best Regards, > > Strahil Nikolov > > -derek > -- > Derek Atkins 617-623-3745 > [email protected] www.ihtfp.com > Computer and Internet Security Consultant > _______________________________________________ > Users mailing list -- [email protected] > To unsubscribe send an email to [email protected] > Privacy Statement: https://www.ovirt.org/site/privacy-policy/ > oVirt Code of Conduct: > https://www.ovirt.org/community/about/community-guidelines/ > List Archives: > https://lists.ovirt.org/archives/list/[email protected]/message/JS6YVB3S33VYLPEQTUE3UJVZOBBO5W7H/ _______________________________________________ Users mailing list -- [email protected] To unsubscribe send an email to [email protected] Privacy Statement: https://www.ovirt.org/site/privacy-policy/ oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/[email protected]/message/CLQVBZOTZJGRNB72TUVOHP3MVBKPJHD3/
