[ale] MySQL array based snapshot

[Jim Kinney]

Ah. Vm dude. Ask for his "best method for hot db backup with SAN/NAS drive
space of vm". Change san to nas as required. I hear a vm specialist that's
been bit before on performance during backups not wanting that pile of
meetings ever again.

On Nov 22, 2016 11:40 AM, "Chris Fowler" <cfowler at outpostsentinel.com>
wrote:

>
>
> ------------------------------
>
> *From: *"Jim Kinney" <jim.kinney at gmail.com>
> *To: *"Atlanta Linux Enthusiasts - Yes! We run Linux!" <ale at ale.org>
> *Sent: *Tuesday, November 22, 2016 10:09:36 AM
> *Subject: *Re: [ale] MySQL array based snapshot
>
>
>
> 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.
>
>
> I've received even more Greek when I asked if they were planning on doing
> snapshots in their storage
>
> "Snaps through VAAI.  Our storage is VASA aware.  It is the disk STUN I am
> worried about related to running DB."
>
>
> The good news is that the transactions to the DB are not that high.  It
> could be if they grow significantly and start monitoring SNMP.  I store
> traps in the DB.   They could lock the database and that would cause all
> processes to "pause" till it was unlocked.  I know this because I've
> received complaints when I've done mysqldumps.  Those locks are not lock
> enough to cause timeouts in the apps.  They just block until the lock is
> released.
>
> Chris
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ale.org/pipermail/ale/attachments/20161122/20ab6d64/attachment.html>