Hi,

I am sorry I was unclear.  Of course the long operation happens with the
DB unlocked.

Once the LVM snapshot is created (from within the locked environment), the
lock is of course released and the backup proceeds from a db-unlocked
environment.

I apologize for my lack of clarity with "and then I backup off the
snapshot" not making that clear.

-derek

On Tue, May 14, 2019 6:20 am, Strahil wrote:
> 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 <derek@ihtfp.com>
> wrote:
>>
>> Strahil <hunter86_bg@yahoo.com> 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
>>        derek@ihtfp.com             www.ihtfp.com
>>        Computer and Internet Security Consultant
>> _______________________________________________
>> Users mailing list -- users@ovirt.org
>> To unsubscribe send an email to users-leave@ovirt.org
>> 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/users@ovirt.org/message/JS6YVB3S33VYLPEQTUE3UJVZOBBO5W7H/