[ale] MySQL array based snapshot

[Jim Kinney]

On Nov 22, 2016 9:59 AM, "Chris Fowler" <cfowler at outpostsentinel.com> wrote:
>
>
>
> ________________________________
>>
>> From: "Jim Kinney" <jim.kinney at gmail.com>
>> To: "Atlanta Linux Enthusiasts" <ale at ale.org>
>> Sent: Monday, November 21, 2016 4:38:51 PM
>>
>> Subject: Re: [ale] MySQL array based snapshot
>>
>> This sounds to me like a LVM snapshot of the database file space.
>>
>> http://dev.mysql.com/doc/refman/5.7/en/backup-methods.html
>>
>> Snapshot _IS_ a backup as long as it is copied off the original machine.
Loud google mouths are not always accurate. Dump your Google search cookie
and see what comes up again.
>>
>> There is a STUN event but it's pretty short. The key that I see is to
lock the DB after a flush (see link) , make the LVM snapshot, then release
the lock, copy out the snapshot as a backup. The performance drag happens
during the copy of the snapshot but the copy can be 'nice 20' if things are
on a decent drive subsystem and drive failure is not expected to be eminent.
>
>
> I don't see them doing a LVM snapshot on the guest.  They'll do it on the
host.  Maybe they intend to do it on the guest.  Maybe VMWare does it for
them.
>

That's even easier. From inside vm, sync and lock db, vm snapshot, unlock.
Copy snapshot away. Flatten vm snapshot. Vmware and Ovirt/KVM will do this.

> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://mail.ale.org/mailman/listinfo/ale
> See JOBS, ANNOUNCE and SCHOOLS lists at
> http://mail.ale.org/mailman/listinfo
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ale.org/pipermail/ale/attachments/20161122/0650ca95/attachment.html>